On Feb 6, 2008 8:39 PM, Jon Burgess <[EMAIL PROTECTED]> wrote: > > > 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
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. _______________________________________________ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/talk