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

duplicates for cities5000

number of errors=4
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.15 and a.iscities5000 and b.iscities5000 and a.admincode1=b.admincode1 and a.geonameid not in (12157065,12157098)

countrycode	geonameid	geonameid	name	admincode1	admincode1	
IN	1258315	11903147	Rourkela	21	21	
IN	11903147	1258315	Rourkela	21	21	
CN	8054117	2034312	Ulanhot	20	20	
CN	2034312	8054117	Ulanhot	20	20