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

adm1 features not within country shape of other country

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

select geoname.name,geoname.geonameid,geoname.countrycode,geoname_shape.countrycode,geoname_shape.geoshapeid from geoname,geoname_shape where level=1 and geoname.featurecode='ADM1' and st_within(geography::geometry,wkb_geometry) and (geoname.countrycode<>geoname_shape.countrycode) and geoname_shape.countrycode <> coalesce(geoname.cc2,'')

name	geonameid	countrycode	countrycode	geoshapeid