2025-03-03     2025-03-04     2025-03-05

PPLA without population

number of errors=0
number of warnings=0
Group=ckgGrpPopulation

select countrycode,name,geonameid from geoname where featurecode='PPLA' and not population >0 and countrycode in ('AT','CH','DE','DK','ES','FI','FR','GB','IT','NL','NO','SE','US','CA','AU','NZ','JP') order by countrycode

countrycode	name	geonameid