<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "cities5000 schema or column names"]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/4.page</link>
		<description><![CDATA[Latest messages posted in the topic "cities5000 schema or column names"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>cities5000 schema or column names</title>
				<description><![CDATA[ Hello.


I'd like to start by thanking GeoNames for this wonderful resource.


Sorry if this is a redundant question, but I seem to be unable to find an in-order listing of the columns in the cities5000 file.


The page here ( http://download.geonames.org/export/dump/ ) contains schema information regarding the geoname and alternate names table.  Is there similar information for the cities5000 file somewhere?


I've looked through the forum and there are some extremely helpful posts regarding importing all of the geonames tables into SQL ( http://forum.geonames.org/gforum/posts/list/732.page for example).
From such posts I can determine the schema of these tables, but unfortunately the cities5000 file doesn't seem to be included there either!


Cheers,
yascha

]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/924.page#4113</guid>
				<link>http://forum.geonames.org/gforum/posts/list/924.page#4113</link>
				<pubDate><![CDATA[Wed, 4 Jun 2008 18:47:09]]> GMT</pubDate>
				<author><![CDATA[ yascha]]></author>
			</item>
			<item>
				<title>Re:cities5000 schema or column names</title>
				<description><![CDATA[ Hi Yascha

The cities5000 table is an extract from the geonames table. The columns are exactly the same.

Cheers

Marc

Edited : corrected a meaningless sentence.]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/924.page#4116</guid>
				<link>http://forum.geonames.org/gforum/posts/list/924.page#4116</link>
				<pubDate><![CDATA[Wed, 4 Jun 2008 19:05:55]]> GMT</pubDate>
				<author><![CDATA[ marc]]></author>
			</item>
			<item>
				<title>Re:cities5000 schema or column names</title>
				<description><![CDATA[ Oh wonderful!
Thanks for the prompt response.

(I imagine you meant to say that the cities5000 table is an extract from the geonames table)

Cheers,
Yascha]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/924.page#4117</guid>
				<link>http://forum.geonames.org/gforum/posts/list/924.page#4117</link>
				<pubDate><![CDATA[Wed, 4 Jun 2008 19:09:35]]> GMT</pubDate>
				<author><![CDATA[ yascha]]></author>
			</item>
	</channel>
</rss>