2025-03-05     2025-03-06     2025-03-07

linked ADM1 subdivs have level 1

number of errors=0
number of warnings=0
Group=chkGrpSubdivision

select countrysubdivision.countrycode,featurecode,geoname.geonameid,geoname.ansiname, geonameslevel,admlevel from geoname,countrysubdivision where geonameid = subdivisionid and featurecode='ADM1' and (geonameslevel<>1 or geonameslevel is null) order by 1

[]

countrycode	featurecode	geonameid	ansiname	geonameslevel	admlevel