2025-06-11     2025-06-12     2025-06-13

duplicates for cities1000

number of errors=12
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.015 and a.iscities1000 and b.iscities1000 and a.admincode1=b.admincode1

countrycode	geonameid	geonameid	name	admincode1	admincode1	
BR	6316690	3404464	Cachoeira Grande	13	13	
BR	3404464	6316690	Cachoeira Grande	13	13	
BR	6316884	3465934	Colinas do Sul	29	29	
BR	3465934	6316884	Colinas do Sul	29	29	
BR	3401833	6316907	Condado	17	17	
BR	6316907	3401833	Condado	17	17	
BR	3395091	6317567	Mato Grosso	17	17	
BR	6317567	3395091	Mato Grosso	17	17	
BR	12958550	6318032	Porto Rico do Maranhão	13	13	
BR	6318032	12958550	Porto Rico do Maranhão	13	13	
BR	6318338	3389186	Santo Amaro do Maranhão	13	13	
BR	3389186	6318338	Santo Amaro do Maranhão	13	13