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

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

countrycode	geonameid	name	admincode1