number of errors=0
number of warnings=0
country=GB
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='GB' and featurecode='ADM2'
countrycode geonameid name admincode1