<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "Sorting areas into "county" and "county" into "states""]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/4.page</link>
		<description><![CDATA[Latest messages posted in the topic "Sorting areas into "county" and "county" into "states""]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>Sorting areas into "county" and "county" into "states"</title>
				<description><![CDATA[ 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]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1339.page#5611</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1339.page#5611</link>
				<pubDate><![CDATA[Sun, 22 Mar 2009 21:31:06]]> GMT</pubDate>
				<author><![CDATA[ uflidd]]></author>
			</item>
			<item>
				<title>Re:Sorting areas into "county" and "county" into "states"</title>
				<description><![CDATA[ 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]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1339.page#5612</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1339.page#5612</link>
				<pubDate><![CDATA[Sun, 22 Mar 2009 23:02:40]]> GMT</pubDate>
				<author><![CDATA[ marc]]></author>
			</item>
			<item>
				<title>Re:Sorting areas into "county" and "county" into "states"</title>
				<description><![CDATA[ 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.



]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1339.page#5614</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1339.page#5614</link>
				<pubDate><![CDATA[Sun, 22 Mar 2009 23:59:54]]> GMT</pubDate>
				<author><![CDATA[ uflidd]]></author>
			</item>
			<item>
				<title>Re:Sorting areas into "county" and "county" into "states"</title>
				<description><![CDATA[ We have it for other countries. Look at the fields 'adminCode1-4'. If the fields are filled then the information is available.

Marc]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1339.page#5615</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1339.page#5615</link>
				<pubDate><![CDATA[Mon, 23 Mar 2009 06:29:35]]> GMT</pubDate>
				<author><![CDATA[ marc]]></author>
			</item>
			<item>
				<title>Re:Sorting areas into "county" and "county" into "states"</title>
				<description><![CDATA[ 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 ]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1339.page#5617</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1339.page#5617</link>
				<pubDate><![CDATA[Mon, 23 Mar 2009 09:45:22]]> GMT</pubDate>
				<author><![CDATA[ david masclet]]></author>
			</item>
			<item>
				<title>Getting States In A Country</title>
				<description><![CDATA[ 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  :roll: ]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1339.page#6086</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1339.page#6086</link>
				<pubDate><![CDATA[Fri, 10 Jul 2009 19:28:21]]> GMT</pubDate>
				<author><![CDATA[ dbaerwaldt]]></author>
			</item>
	</channel>
</rss>