<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "Get Country Code By Lon / Lat - Without Web Service"]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/4.page</link>
		<description><![CDATA[Latest messages posted in the topic "Get Country Code By Lon / Lat - Without Web Service"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>Get Country Code By Lon / Lat - Without Web Service</title>
				<description><![CDATA[ Is there a dump available from Geonames where I can calculate the country code of a lon/lat?

I want it to work exactly the same as the geonames method, but dont want to waste time by calling out to Geonames.

I would like to be able to calculate it in SQL using a lookup table.

Can someone offer any advice on this?

Thanks  :) 
Stu]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1123.page#4896</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1123.page#4896</link>
				<pubDate><![CDATA[Wed, 5 Nov 2008 12:45:47]]> GMT</pubDate>
				<author><![CDATA[ stuartdavenport]]></author>
			</item>
			<item>
				<title>Re:Get Country Code By Lon / Lat - Without Web Service</title>
				<description><![CDATA[ I think this would be a great way of saving calls (and time) to the FindNearestAddress web service, such that if Lat+Long is outside the US, for example, where FindNearestAddress is not available (yet ?), then don't do the call to the WS because no data will be returned.


]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1123.page#4897</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1123.page#4897</link>
				<pubDate><![CDATA[Wed, 5 Nov 2008 16:49:49]]> GMT</pubDate>
				<author><![CDATA[ ealessio]]></author>
			</item>
			<item>
				<title>Re:Get Country Code By Lon / Lat - Without Web Service</title>
				<description><![CDATA[ Hi ealessio,

My actual issue is where I have a large number of places geoencoded - some may be geoencoded badly and a UK place appear in the US for instance, so when searching in the US, I may also see a place in the results from the UK.

Next to each of my "places" in the database I do have a country code field.

I wanted to find the country code of the lon/lat values I am searching for to filter out any erroneous data from my results set. Of course one resolution is to fix all the bad data, but in the short term this isnt feasible.  :?: 

Any further advice would be greatful!  :) 

Thanks
Stu]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1123.page#4905</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1123.page#4905</link>
				<pubDate><![CDATA[Thu, 6 Nov 2008 12:16:47]]> GMT</pubDate>
				<author><![CDATA[ stuartdavenport]]></author>
			</item>
	</channel>
</rss>