[OSM-talk] Multiple nodes for one country

[Jon Burgess]

On Mon, 2009-08-03 at 20:49 +0200, Peter Körner wrote:
> Peter Körner schrieb:
> > andrzej zaborowski schrieb:
> >> Hi Peter,
> >> I don't think anybody has a reason to object to merging them.  At
> >> least me and User:Mala have been merging some of these nodes last
> week
> >> and we got no blackmail so far :)  I believe we went through all
> the
> >> country nodes which didn't have a name:pl= or name:it= assigned yet
> so
> >> out of your list at most 15 or so countries should still remain
> >> duplicated.
> >>
> >> Cheers
> > 
> > The main problem is that I'm unable to produce an up-to-date list
> from 
> > database since I don't have the resources to import an up-to-date
> dump.
> > 
> > I'll try to process an up-to-date planet.osm tomorrow to generate
> an 
> > up-to-date list from it. It's a pity that cassini is not updated via
> the 
> > diffs right now.
> > 
> > At the next step I'll generate a list for each wikimedia-language 
> > containing all countries and their names in this language, so people
> can 
> > correct the locale names more easy. It seems you've already done
> this 
> > for pl and it -- I'm about to do it for de.
> > 
> > Peter
> > 
> 
> I threw an nearly up-to-date planet.osm against a simple 
> sax-parser-script in php and after it ran about 10 hours (such a 
> planet.osm is a really big thing) it produced this table:
> 
> http://toolserver.org/~mazder/duplicate-countries/from-planet.osm/
> 
> Looks much better! Still 26 countries are duplicated, but this could
> be 
> fixed manually, so I'll do that now.
> 
> On some time in the near future, when cassini holds an regularly
> updated 
> gis-database we'll be able to track such duplications at 
> http://toolserver.org/~mazder/duplicate-countries/

I obtained a list of the duplicate country nodes IDs from the Mapnik
rendering DB[1] and have downloaded & fixed all the duplicates[2].


	Jon


1: SQL: gis=> select name,osm_id from planet_osm_point where
place='country' and name in (select name from planet_osm_point where
place='country' group by name having count(*) > 1) order by name,osm_id;

2: Two changesets. The first removes those automatically fixed by the
JOSM validator. The second picks up the few remaining ones which needed
merging.
http://www.openstreetmap.org/browse/changeset/2028815
http://www.openstreetmap.org/browse/changeset/2029180