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

linked ADM2 subdivs have level 2

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='ADM2' and (geonameslevel<>2 or geonameslevel is null) order by 1

[]

countrycode	featurecode	geonameid	ansiname	geonameslevel	admlevel