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

each ADM4 should be within shape

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

select countrycode,geoname.geonameid,name from geoname,geoname_bbox where not exists (select 1 from geoname_bbox where geoname.geonameid=geoname_bbox.geonameid and (st_within(geography::geometry,wkb_geometry) or wkb_geometry is null)) and geoname.geonameid=geoname_bbox.geonameid and geoname.featurecode='ADM4'

[]
fix with st_centroid or ST_PointOnSurface

countrycode	geonameid	name