number of errors=16
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 Riverside 961148 06 DC33 LIM333 S AIRF 1 ZA Arundel 1022202 06 DC33 LIM334 S AIRQ 1 ZA Gravelotte 1000160 06 DC33 LIM334 S AIRQ 1 ZA Gravelotte South 1000158 06 DC33 LIM334 S AIRF 1 ZA Hoedspruit 996200 06 DC33 LIM335 S AIRF 1 ZA Musina 976884 06 DC34 LIM341 S AIRF 2 ZA Punda Miria 963875 06 DC34 LIM342 S AIRF 1 ZA Swartwater 950809 06 DC35 LIM351 S AIRF 1 ZA Dendron 1010968 06 DC35 LIM353 S AIRF 1 ZA Ranch Motel 963245 06 DC35 LIM354 S AIRF 1 ZA Inmalkaar North 994675 06 DC36 LIM361 S AIRF 1 ZA Thabazimbi 949684 06 DC36 LIM361 S AIRF 4 ZA Oost Indie 967689 06 DC36 LIM361 S AIRF 1 ZA Nylstroom 968666 06 DC36 LIM365 S AIRQ 4 ZA Vaalwater 945158 06 DC36 LIM365 S AIRF 1 ZA Potgietersrus 964316 06 DC36 LIM367 S AIRQ 4