2025-02-28     2025-03-01     2025-03-02

each ADM4H is within current ADM4 shape

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

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

countrycode	featurecode	geonameid