[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