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

each ADM5H is within current ADM5 shape

number of errors=0
number of warnings=0
Group=chkGrpShp

select countrycode,featurecode,geonameid from geoname where featurecode='ADM5H' and not exists (select 1 from geoname_shape where geoname.countrycode=geoname_shape.countrycode and level=6 and st_within(geography::geometry,wkb_geometry)) and exists (select 1 from geoname_shape where level=6 and geoname_shape.countrycode=geoname.countrycode) order by 1

countrycode	featurecode	geonameid