Geonames - Admin3 and Admin4 data

Question

I've downloaded the geonames data dump

The main table has admin3 and admin4 columns but there is no data dump which corresponds to the data in these columns.

Does any one know how to map the admin3 and admin4 codes with their respective place names?

Answer 1

The data is self-referencing, i.e., it contains admin1, admin2, admin3, and admin4 data. It is described in the feature code column:

feature code : see http://www.geonames.org/export/codes.html, varchar(10)

Example admin3 data is referred as PPLA3 (Poland, admin3):

• 3080473
• Zbójno
• Zbojno
• Comuna Zbojno,Comuna Zbójno,Comuna de Zbojno,Comuna de Zbójno,Gmina Zbojno,Gmina Zbujno,Gmina Zbójno,Zbojno,Zbujno,Zbójno,Збуйно,Ґміна Збуйно
• 53.00848
• 19.1575
• P
• PPLA3
• [...]