number of errors=0
number of warnings=0
Group=chkGrpShp
select geoname.countrycode,geoname.admincode5,geoname_shape.admincode5,featurecode,level,geoname.geonameid,geoshapeid from geoname,geoname_shape where geoname.geonameid=geoname_shape.geonameid and level=1+ replace(featurecode,'ADM','')::int and featurecode like 'ADM_' and featurecode not in ('ADMD','ADMF','ADMS') and coalesce(geoname.admincode5,'xx')<>geoname_shape.admincode5 order by 1
countrycode admincode5 admincode5 featurecode level geonameid geoshapeid