number of errors=13
number of warnings=0
country=NG
Group=chkGrpShp
select geonameid,name,countrycode,admincode1,admincode2 from geoname where countrycode='NG' and featurecode='ADM2' and not exists (select 1 from geoname_shape where level=3 and geoname_shape.countrycode=geoname.countrycode and geoname_shape.admincode1=geoname.admincode1 and geoname_shape.admincode2=geoname.admincode2)
geonameid name countrycode admincode1 admincode2 9485480 Isiala Ngwa North Local Government Area NG 45 9485480 9485481 Isiala Ngwa South Local Government Area NG 45 9485481 9485482 Makurdi Local Government Area NG 26 9485482 9492098 Yauri Local Government Area NG 40 9492098 9485474 Lagos Mainland Local Government Area NG 05 9485474 9485472 Koko/Besse Local Government Area NG 40 9485472 9485476 Lagos Island Local Government Area NG 05 9485476 9485483 Buruku Local Government Area NG 26 9485483 9485473 Oshodi-Isolo Local Government Area NG 05 9485473 9485484 Bursari Local Government Area NG 44 9485484 9485477 Ogu/Bolo Local Government Area NG 50 9485477 9485478 Mbaitoli Local Government Area NG 28 9485478 9485475 Ifako-Ijaiye Local Government Area NG 05 9485475