<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "How to setup timezone database"]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/4.page</link>
		<description><![CDATA[Latest messages posted in the topic "How to setup timezone database"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>How to setup timezone database</title>
				<description><![CDATA[ I searched the forums, and posted a similiar question previously; it seems there's never been a clear answer to the following question:

How could one go about creating a timezone database similar to the one that geonames uses? one that can be queried by lat&lon and retrieve the appropriate timezone.

Im *guessing* this will involve importing some form of shapefile(s) into a SQL database that can handle spatial data, and then running point queries to see within what polygon (timezone) the points lay. Is this correct? More advice/recommendations on how to set this up would be greatly appreciated...

Or, better yet, are there any plans to publicly release the geonames timezone database software/data?

Please help....]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1371.page#5748</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1371.page#5748</link>
				<pubDate><![CDATA[Wed, 22 Apr 2009 19:35:34]]> GMT</pubDate>
				<author><![CDATA[ romero619]]></author>
			</item>
			<item>
				<title>Re:How to setup timezone database</title>
				<description><![CDATA[ 
I simply took the geoname database and do a nearest neighbor search on it to find the closest record by lat/lon. The record contains the timezone ID.
]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1371.page#5754</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1371.page#5754</link>
				<pubDate><![CDATA[Thu, 23 Apr 2009 05:10:28]]> GMT</pubDate>
				<author><![CDATA[ stasiana]]></author>
			</item>
			<item>
				<title>How to setup timezone database</title>
				<description><![CDATA[ thanks for the reply.
What I need to do is create my own timezone database for use with our intranet application. So, unfortunately, I cannot use the public geonames webservice.

Geonames administrators, can you please provide some feedback?]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1371.page#5771</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1371.page#5771</link>
				<pubDate><![CDATA[Fri, 24 Apr 2009 19:48:42]]> GMT</pubDate>
				<author><![CDATA[ romero619]]></author>
			</item>
			<item>
				<title>How to setup timezone database</title>
				<description><![CDATA[ I still havent received a reply from the geonames admins.
so, I guess I'll keep bumping this message until I do...
Please help,
Thanks,]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1371.page#5833</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1371.page#5833</link>
				<pubDate><![CDATA[Thu, 7 May 2009 21:30:22]]> GMT</pubDate>
				<author><![CDATA[ romero619]]></author>
			</item>
			<item>
				<title>Re:How to setup timezone database</title>
				<description><![CDATA[ It is not planed for the foreseable future to release anything that is not in the focus of the project. I hardly manage to find enough time for the important stuff related to the focus of the project (a gazetteer) and definitely don't have the time for other things.

Best

Marc]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1371.page#5844</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1371.page#5844</link>
				<pubDate><![CDATA[Sun, 10 May 2009 10:03:43]]> GMT</pubDate>
				<author><![CDATA[ marc]]></author>
			</item>
			<item>
				<title>How to setup timezone database</title>
				<description><![CDATA[ I understand that you presently do not have the time to prepare the timezone database sourcecode for public release.

I am willing to create the database myself.
I just need some more info on the method(s) used to create the timezone database, so that I can build it myself.

Were shapefiles with timezone data imported into a database? How could I go about creating such a database?

Please help.....]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1371.page#5870</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1371.page#5870</link>
				<pubDate><![CDATA[Sat, 16 May 2009 19:23:20]]> GMT</pubDate>
				<author><![CDATA[ romero619]]></author>
			</item>
			<item>
				<title>How to setup timezone database</title>
				<description><![CDATA[ never received a response to my last question:
again, I would appreciate some simple help & guidance on how to to setup my own timezone database, using publicly-accessible data in shapefile format, or some other format.

I just need some basic, productive tips to get me started; I can generate the code myself, so Im not asking geonames to 'reveal its secrets'...]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1371.page#5928</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1371.page#5928</link>
				<pubDate><![CDATA[Sun, 31 May 2009 18:18:29]]> GMT</pubDate>
				<author><![CDATA[ romero619]]></author>
			</item>
			<item>
				<title>How to setup timezone database</title>
				<description><![CDATA[ Hi
I need to setup such a timezone database too, for personal use, and would appreciate any help.
Thanks]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1371.page#5984</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1371.page#5984</link>
				<pubDate><![CDATA[Sun, 14 Jun 2009 08:08:22]]> GMT</pubDate>
				<author><![CDATA[ gentle_man]]></author>
			</item>
	</channel>
</rss>