On Wed, 2008-02-06 at 20:23 +0000, Dave Stubbs wrote:
> On Feb 6, 2008 7:06 PM, Dave Stubbs <[EMAIL PROTECTED]> wrote:
> > On Feb 6, 2008 5:57 PM, Dave Stubbs <[EMAIL PROTECTED]> wrote:
> > > I don't know who/what they are, but there are a large number of low
> > > number nodes that have been utterly destroyed. Basically 522-603 and a
> > > few others in the 1000's have been moved halfway round the planet.
>
> And now I've got a response from the user who is very apologetic.
> Apparently he created a custom .osm file from a script and tried to
> upload it using JOSM without realising he needed to use -ve IDs. I've
> let him know, and asked him to send me the .osm file so I can check if
> it clobbered anything else.
>
> Dave
If you've already imported the data into a Mapnik Postgres DB then the
following should remove them. This is based on deleting all ways which
cross over a sea tile just off the coast of South America:
gis=> delete from planet_osm_line where way &&
GeomFromText('POLYGON((-3757032.81427298 2504683.91830469,-3757032.81427298
3763310.62714417,-2504688.54284866 3763310.62714417,-2504688.54284866
2504683.91830469,-3757032.81427298 2504683.91830469))',900913);
DELETE 17
gis=> delete from planet_osm_roads where way &&
GeomFromText('POLYGON((-3757032.81427298 2504683.91830469,-3757032.81427298
3763310.62714417,-2504688.54284866 3763310.62714417,-2504688.54284866
2504683.91830469,-3757032.81427298 2504683.91830469))',900913);
DELETE 1
Jon
_______________________________________________
talk mailing list
talk@openstreetmap.org
http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/talk
