ADM features with geoshape have ADMx correspond to the shape level

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

select geoname.countrycode,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') order by 1

countrycode	featurecode	level	geonameid	geoshapeid