2025-03-01     2025-03-02     2025-03-03

no adm1,adm2,adm3,adm4 has an admincode5

number of errors=0
number of warnings=0

select geonameid,name,featurecode,countrycode,admincode1,admincode2,admincode3,admincode4,admincode5 from geoname where featurecode in ('PCLI','PCLF','PCLD','PCL','PCLIX','PCLS','TERR','ADM1','ADM2','ADM3','ADM4') and admincode5 is not null order by featurecode,countryCode,admincode1,admincode2,admincode3

geonameid	name	featurecode	countrycode	admincode1	admincode2	admincode3	admincode4	admincode5