2025-08-15     2025-08-16     2025-08-17

duplicates for cities15000

number of errors=8
number of warnings=0

select a.countrycode,a.geonameid,b.geonameid,a.name,a.admincode1,b.admincode1 from geoname a, geoname b where a.geonameid <> b.geonameid and a.featureclass='P' and b.featureclass='P' and lower(a.name)=lower(b.name) and a.longlat<->b.longlat<0.25 and a.iscities15000 and b.iscities15000 and a.admincode1=b.admincode1

countrycode	geonameid	geonameid	name	admincode1	admincode1	
GH	2301245	13275281	Ahwiaa	02	02	
GH	13275281	2301245	Ahwiaa	02	02	
CN	8417604	1815878	Longxing	33	33	
CN	1815878	8417604	Longxing	33	33	
IN	1258315	11903147	Rourkela	21	21	
IN	11903147	1258315	Rourkela	21	21	
CN	8054117	2034312	Ulanhot	20	20	
CN	2034312	8054117	Ulanhot	20	20