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

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

number of errors=0
number of warnings=0
country=EE
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='EE' and featurecode='ADM2'

countrycode	geonameid	name	admincode1