[OSM-talk] User umehlig and some really nasty edits

Jon Burgess jburgess777 at googlemail.com
Wed Feb 6 20:39:48 GMT 2008


On Wed, 2008-02-06 at 20:23 +0000, Dave Stubbs wrote:
> On Feb 6, 2008 7:06 PM, Dave Stubbs <osm.list at randomjunk.co.uk> wrote:
> > On Feb 6, 2008 5:57 PM, Dave Stubbs <osm.list at randomjunk.co.uk> 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






More information about the talk mailing list