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

Dave Stubbs osm.list at randomjunk.co.uk
Wed Feb 6 20:54:01 GMT 2008


On Feb 6, 2008 8:39 PM, Jon Burgess <jburgess777 at googlemail.com> wrote:
>
>
> 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

I went for the slightly easier (from me typing point of view) method
of deleting all ways over about 15,000km in length :-)
The counts for that were 22, and 7, so it's catching a few more, but
probably nothing I'm interested in.




More information about the talk mailing list