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

the lat/lng for adm should be within geoname-shape for same adm.

number of errors=0
number of warnings=0
country=AU
Group=chkGrpLocation
Group=chkGrpShp

select countrycode,geonameid,name,admincode1 from geoname 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 exists (select 1 from geoname_bbox where geoname.geonameid=geoname_bbox.geonameid) and countrycode='AU' and featurecode='ADM1'

countrycode	geonameid	name	admincode1