all country codes used have a single entry in the DB (exlcudes three territories in australia)

number of errors=0
number of warnings=0

select count(*),countrycode from geoname where featurecode in ('PCLI','PCLF','PCLD','PCL','PCLIX','PCLS','TERR') and geonameid not in (2170371,2077507,8335033) group by countrycode having count(*)>1

excludes Jervis Bay Territory, Coral Sea Islands Territory and Territory of Ashmore and Cartier Islands which are Australian territories, they have a fips country code but no iso country code.

count	countrycode