number of errors=64
number of warnings=0
Group=chkGrpShp
select countrycode,featurecode,geonameid from geoname where featurecode='ADM4H' and not exists (select 1 from geoname_shape where geoname.countrycode=geoname_shape.countrycode and level=5 and st_within(geography::geometry,wkb_geometry)) and exists (select 1 from geoname_shape where level=5 and geoname_shape.countrycode=geoname.countrycode) order by 1
countrycode featurecode geonameid FR ADM4H 6615806 FR ADM4H 6439632 FR ADM4H 6439191 FR ADM4H 6433786 FR ADM4H 6439702 FR ADM4H 6427467 FR ADM4H 6427720 FR ADM4H 6427773 FR ADM4H 6427779 FR ADM4H 6615072 FR ADM4H 6615028 FR ADM4H 6447694 FR ADM4H 6456897 FR ADM4H 6430052 FR ADM4H 6444175 FR ADM4H 6616765 FR ADM4H 6447994 FR ADM4H 6445204 FR ADM4H 6429143 FR ADM4H 6442162 FR ADM4H 6452002 FR ADM4H 6447645 FR ADM4H 6455720 FR ADM4H 6429822 FR ADM4H 6429894 FR ADM4H 6450064 FR ADM4H 6456761 FR ADM4H 6424647 FR ADM4H 6426317 FR ADM4H 6427241 FR ADM4H 6428068 FR ADM4H 6428446 FR ADM4H 6441960 FR ADM4H 6613409 FR ADM4H 6428451 FR ADM4H 6429059 FR ADM4H 6429987 FR ADM4H 6430268 FR ADM4H 6430824 FR ADM4H 6432010 FR ADM4H 6432123 FR ADM4H 6432397 FR ADM4H 6433734 FR ADM4H 6434287 FR ADM4H 6434854 FR ADM4H 6435785 FR ADM4H 6439107 FR ADM4H 6439855 FR ADM4H 6440168 FR ADM4H 6442143 FR ADM4H 6442200 FR ADM4H 6442697 FR ADM4H 6442707 FR ADM4H 6444172 FR ADM4H 6444825 FR ADM4H 6445711 FR ADM4H 6448504 FR ADM4H 6451248 FR ADM4H 6453521 FR ADM4H 6453855 FR ADM4H 6456452 FR ADM4H 6456994 FR ADM4H 6612815 FR ADM4H 6613477