number of errors=61
number of warnings=0
country=ZA
select countrycode,name,geonameid,admincode1,admincode2,admincode3,featureclass,featurecode,relevance from geoname where countrycode in ('ZA') and not featureCode in ('ADM1H','ADM2H','ADM3H','ADM4H','ADM5H','ADMD') and admincode1 is not null and admincode1<>'00' and admincode2 is not null and admincode3 is not null and not exists (select 1 from geoname b where b.countrycode=geoname.countrycode and b.admincode1=geoname.admincode1 and b.admincode2=geoname.admincode2 and b.admincode3=geoname.admincode3 and b.featurecode='ADM3' and b.countrycode in ('ZA')) order by countrycode,admincode1,admincode2,admincode3
countrycode name geonameid admincode1 admincode2 admincode3 featureclass featurecode relevance ZA Shingwidzi Ruskamp 13372347 06 DC33 LIM331 S AIRF 0 ZA Tarantaalrand 13372295 06 DC33 LIM333 S AIRF 0 ZA Kruger 13372289 06 DC33 LIM334 S AIRF 0 ZA Phalaborwa Nw 13372340 06 DC33 LIM334 S AIRF 0 ZA Hippo Pools Southeast 13372305 06 DC33 LIM335 S AIRF 0 ZA Mica East 13372276 06 DC33 LIM335 S AIRF 0 ZA Mica 13372350 06 DC33 LIM335 S AIRQ 0 ZA Uhi Forest 13372351 06 DC33 LIM335 S AIRF 0 ZA Umbabat Aerocamp North 13372233 06 DC33 LIM335 S AIRF 0 ZA Blyde River Northwest 13372389 06 DC33 LIM335 S AIRQ 0 ZA Sandringham 13372410 06 DC33 LIM335 S AIRF 0 ZA Olifantstenk 13372423 06 DC33 LIM335 S AIRQ 0 ZA Umbabat Aerocamp 13372372 06 DC33 LIM335 S AIRF 0 ZA Thornbush Southeast 13372252 06 DC33 LIM335 S AIRF 0 ZA Hippo Pools 13372251 06 DC33 LIM335 S AIRQ 0 ZA Blyde River Northeast 13372370 06 DC33 LIM335 S AIRQ 0 ZA Klaserie 13372213 06 DC33 LIM335 S AIRQ 0 ZA Cambridge Southwest 13372298 06 DC33 LIM335 S AIRF 0 ZA Schoonoord 13372292 06 DC34 LIM341 S AIRF 0 ZA Breslaw 13372397 06 DC34 LIM341 S AIRF 0 ZA Skietwater 13372234 06 DC34 LIM341 S AIRF 0 ZA Club Ranch 13372321 06 DC34 LIM341 S AIRF 0 ZA Skietwater East 13372239 06 DC34 LIM341 S AIRF 0 ZA Dovedale 13372432 06 DC34 LIM341 S AIRQ 0 ZA Breslaw East 13372375 06 DC34 LIM341 S AIRQ 0 ZA Linton 13372356 06 DC34 LIM341 S AIRF 0 ZA Skietwater Southeast 13372335 06 DC34 LIM341 S AIRF 0 ZA Little Muck North 13372421 06 DC34 LIM341 S AIRF 0 ZA Venetia 13372313 06 DC34 LIM341 S AIRF 0 ZA Fontainebleau 13372230 06 DC34 LIM341 S AIRF 0 ZA Makuleka 13372226 06 DC34 LIM342 S AIRF 0 ZA Madimbo 13372285 06 DC34 LIM342 S AIRF 0 ZA Blouhak 13372294 06 DC34 LIM344 S AIRQ 0 ZA Rewlatch 13372357 06 DC34 LIM344 S AIRF 0 ZA Davidslust 13372427 06 DC35 LIM351 S AIRF 0 ZA Baltimore 13372422 06 DC35 LIM351 S AIRF 0 ZA Bristol 13372188 06 DC35 LIM351 S AIRF 0 ZA Dardenellen 13372405 06 DC35 LIM351 S AIRF 0 ZA Usutu 13372284 06 DC35 LIM351 S AIRQ 0 ZA Meanderthal East 13372224 06 DC35 LIM353 S AIRF 0 ZA Olifants River Bridge 13372373 06 DC35 LIM355 S AIRF 0 ZA Rooibokkraal 13372412 06 DC36 LIM361 S AIRF 0 ZA Thabazimbi Northeast 13372377 06 DC36 LIM361 S AIRF 0 ZA Dwaalboom 13372219 06 DC36 LIM361 S AIRF 0 ZA Kareeport 13372254 06 DC36 LIM361 S AIRF 0 ZA Duikerspan 13372296 06 DC36 LIM361 S AIRF 0 ZA Thaba Tholo 13372371 06 DC36 LIM361 S AIRF 0 ZA Batavia 13372424 06 DC36 LIM361 S AIRF 0 ZA Honing Valey South 13372270 06 DC36 LIM361 S AIRF 0 ZA Diepspruit 13372360 06 DC36 LIM362 S AIRF 0 ZA Matlabas 13372317 06 DC36 LIM362 S AIRF 0 ZA Rietgat 13372391 06 DC36 LIM362 S AIRF 0 ZA Doornleegte 13372382 06 DC36 LIM362 S AIRF 0 ZA Rietbokfontein 13372211 06 DC36 LIM362 S AIRF 0 ZA Bold 13372419 06 DC36 LIM362 S AIRQ 0 ZA Seekoeivlei 13372291 06 DC36 LIM362 S AIRQ 0 ZA Illawara 13372366 06 DC36 LIM366 S AIRF 0 ZA Zebula 13372258 06 DC36 LIM366 S AIRF 0 ZA Marble Hall 13372279 06 DC47 LIM471 S AIRF 0 ZA Marble Hall Southeast 13372243 06 DC47 LIM471 S AIRF 0 ZA Onverwacht 13372303 06 DC47 LIM475 S AIRF 0