2025-07-04     2025-07-05     2025-07-06

feature <>'A' had the admincode2 same as the geonameid, probably it was a ADM2 before

number of errors=1
number of warnings=0

select geonameid,ansiname,featurecode,countrycode,admincode1,admincode2 from geoname where featureclass<>'A' and admincode2=geonameid::text and admincode2 is not null

geonameid	ansiname	featurecode	countrycode	admincode1	admincode2	
97825	Batifa	PPLA2	IQ	08	97825