2025-03-03     2025-03-04     2025-03-05

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