<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "Importing data - multiple tables or all one?"]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/4.page</link>
		<description><![CDATA[Latest messages posted in the topic "Importing data - multiple tables or all one?"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>Importing data - multiple tables or all one?</title>
				<description><![CDATA[ I was going to import the data from the AllCountries file, but then I thought, won't that add a ton of extra data?

Wouldn't it be more efficient to load all the data into separate tables and create relationships ebtween them?  If the US has 50 administrative districts - in the allcountries file, wouldn't that add 50 entries for the US?]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/2050.page#8310</guid>
				<link>http://forum.geonames.org/gforum/posts/list/2050.page#8310</link>
				<pubDate><![CDATA[Thu, 26 Aug 2010 12:31:12]]> GMT</pubDate>
				<author><![CDATA[ john_es]]></author>
			</item>
			<item>
				<title>Re:Importing data - multiple tables or all one?</title>
				<description><![CDATA[ The good question is : what do you want to do with GeoNames data ?

If you need only US data, just download US file.
http://download.geonames.org/export/dump/]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/2050.page#8313</guid>
				<link>http://forum.geonames.org/gforum/posts/list/2050.page#8313</link>
				<pubDate><![CDATA[Thu, 26 Aug 2010 13:17:04]]> GMT</pubDate>
				<author><![CDATA[ geotree]]></author>
			</item>
			<item>
				<title>Re:Importing data - multiple tables or all one?</title>
				<description><![CDATA[ At the moment I am experimenting :)

Eventually what I am looking for really is the ability to have a user enter a country, or more likely a postal code, and be able to return the city, state/province/admin1 area, and country.]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/2050.page#8316</guid>
				<link>http://forum.geonames.org/gforum/posts/list/2050.page#8316</link>
				<pubDate><![CDATA[Thu, 26 Aug 2010 14:04:18]]> GMT</pubDate>
				<author><![CDATA[ john_es]]></author>
			</item>
			<item>
				<title>Re:Importing data - multiple tables or all one?</title>
				<description><![CDATA[ Have a look here :
http://www.geonames.org/export/web-services.html#postalCodeLookupJSON

There is a demo link :
http://www.geonames.org/export/ajax-postalcode-autocomplete.html]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/2050.page#8318</guid>
				<link>http://forum.geonames.org/gforum/posts/list/2050.page#8318</link>
				<pubDate><![CDATA[Thu, 26 Aug 2010 14:18:24]]> GMT</pubDate>
				<author><![CDATA[ geotree]]></author>
			</item>
			<item>
				<title>Re:Importing data - multiple tables or all one?</title>
				<description><![CDATA[ See also :
http://forum.geonames.org/gforum/posts/list/1791.page#7521]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/2050.page#8319</guid>
				<link>http://forum.geonames.org/gforum/posts/list/2050.page#8319</link>
				<pubDate><![CDATA[Thu, 26 Aug 2010 14:21:19]]> GMT</pubDate>
				<author><![CDATA[ geotree]]></author>
			</item>
	</channel>
</rss>