[OSM-dev] planet.osm - fix

Jonas Svensson jonass at lysator.liu.se
Wed Aug 9 17:58:41 BST 2006


A lot easier to check if I told you wich node it is, isn't it?

<node id='543407' lat='51.2706' lon='7.13737' timestamp='2006-02-
16T16:13:15+00:00'>

Also node 543408.


On 9 Aug 2006 at 18:35, Jonas Svensson wrote:

> 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/>
> 
> 
> _______________________________________________
> 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/>





More information about the dev mailing list