GeoNames Forum

Hi,

Earlier (about a year ago) I imported some of the countries I found here at geonames into my database. That time I was able to import the geo data into 4 tables for a 4 level hierarchic system of it, which was sorted into what "county" and "state" each area belongs to.

The following tables was created:

Country
.CountryID
.CountryName

State
.StateID
.CountryID
.Statename

County
.CountyID
.StateID
.Countyname

Area
.AreaID
.CountyID
.Areaname

I wanted to do the same for Japan today, and downloaded the JP.zip file from here: http://download.geonames.org/export/dump/

This dump seems like it has data with all the areas, but the areas are not sorted into what county > state the area belongs to. Am I right?

Where can I find the data I need to sort out what area belong to what "county" and what "county" belongs to which "state"?

Thanks for a Great service Marc, you rock the world!

Kind regards
Joe

We don't have this information.
Someone once sent me the following link:
http://www.mlit.go.jp/kokudokeikaku/gis/index.html
I don't speak Japanese so I don't know whether the information is still there...

Best

Marc

You don't have it for Japan or you don't have it for any country?

I`m pretty sure that it was from you we got the data with states and counties on the other countries we inserted.

We have it for other countries. Look at the fields 'adminCode1-4'. If the fields are filled then the information is available.

Marc

Hi

The Gisgraphy framework has an importer that can import the Country and the ADM in a tree structure (ADM4->ADM3->ADM2->ADM1). For a given ADM, you can ask for his parent and childs

www.gisgraphy.com is the project site
services.gisgraphy.com is a site where the gisgraphy framework is installed (so you can test it before install it)

Hope it helps (if i understand the need)

David

Can anyone show me how to get the states or provinces for any given country?

I can get all the countries but seem to be unable to get the states (ie. states in the USA)

Help