GeoNames Forum

i know that you can use the web API to look up the hierarchy (eg europe, sweden, skåne) for a city with its geoname_id.

but isnt there a way to look up this information locally? cause i have downloaded the whole database and imported it to mysql.

do i really have to use wep API for each city and then put the information in the mysql database myself?

The information is available in the dump included in the admin1-4 codes. The relation ppl-pplx is available as a csv file in this forum.

Marc

could you please be more specific, cause im a beginner at this.

i dont get the admin1-4 codes in the table geonames. there is no such code for sweden and norway. do those codes only apply for the US? and there are only admin1 and admin2 tables. where are the admin3 and admin4 table? if a geoname got a admin4 code...how should i associate that with a place?

what do you mean in the dump? you mean the full database i downloaded?

and which csv file? why dont they just have that information in the native database?

please help...its kinda messy (why a lot of users are asking the same questions over and over).

HowTo for Sweden :

1/ download SE.zip from :
http://download.geonames.org/export/dump/

2/ according to :
http://download.geonames.org/export/dump/readme.txt
select all records with "feature code" = ADM1

One of them is :
http://www.geonames.org/2721357/blekinge-laen.html
with "admin1 code" = 02

3/ select records with "feature code" = ADM2 and "admin1 code" = 02
Now you have all children of Blekinge.

etc