2025-03-02     2025-03-03     2025-03-04

ppla2 child of populated place

number of errors=0
number of warnings=0
Group=chkGrpHierarchy

select p.countrycode,p.name,parentid,p.featurecode,p.admincode2,p.population,c.name as childname,childid, c.population as cpop from geoname p, geoname_hierarchy h, geoname c where p.geonameid=parentid and c.geonameid=childid and c.featurecode='PPLA2' and p.featureclass='P' and p.featurecode not in ('PPLA','PPLC') and parentid not in(5128581,7289169) order by 1,2

countrycode	name	parentid	featurecode	admincode2	population	childname	childid	cpop