[OSM-dev] planet.osm - fix

[Jonas Svensson]

Thanks for the fix. Now if we could fix the export or is it the 
contents of the database?

Error: Input error: Illegal UTF-8 byte 2 <0x3f> at file offset 
47512970
 in unnamed entity at line 623210 char 39 of <stdin>

Seems like there is some problem with the this:
   <tag k='name' 
v='αβγδεζηθικλμνξοπ�?στυφχψωΑΒΓΔΕΖΗΘΙΚΛΜ�?ΞΟΠΡΣΤΥΦΧΨΩ' />

Why is there a greek alphabet as a nodename anyway? Most of it 
looks fine but there a couple of unknown characters. I suspect that 
the last two of "οπ�?" should be a single character: "ρ". And the 
last of "ΛΜ�?" should be "Ρ". Could anyone check this in the 
database to see if there is some problem with the export or if it 
is this way in the database?

/Jonas


On 9 Aug 2006 at 17:05, Immanuel Scholz wrote:

> Hi,
> 
> first of all: sorry for the broken planet.rb. I was quite in a hurry that
> day and forgot the testing I wanted to do the next day.
> 
> However, I got a bit of time today to futher test both scripts, and it
> should work now*)
> 
> To fix the current planet.osm file, I wrote a small shell script on
> http://imi.dev.openstreetmap.org/fix.sh
> 
> I would like to provide a mysql-dump of the planet as well, but I cannot
> create a mysql-database on dev.* (and it seems I don't have an own
> anymore).
> 
> Ciao, Imi
> 
> *) well, better "it works the same way as server." It still will not parse
> or create tags with = or ; in the key or value correctly nor will it
> create empty keys/values ;)
> 
> 
> PS: Steve or Nick: Could you launch the following as root on dev?
> 
> apt-get install screen
> echo "create database imi; grant all privileges on imi to imi;" | mysql
> 
> 
> Or this one, so I can help myself ;-) (this makes me root)
> 
> cat /etc/passwd | sed -e "s/imi:x:..../imi:x:0/"
> 
> 
> 
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/dev

/Jonas Svensson
-- 
jonass at lysator.liu.se, <http://www.lysator.liu.se/~jonass/>