2025-02-24     2025-02-25     2025-02-26

international feature does not have an adm1 code

number of errors=0
number of warnings=0

select geonameid,name,featurecode,countrycode,admincode1 from geoname where (admincode1 is not null and admincode1<>'00') and length(cc2)>8

geonameid	name	featurecode	countrycode	admincode1