<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "Sorting geocoded place name results in own server?"]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/4.page</link>
		<description><![CDATA[Latest messages posted in the topic "Sorting geocoded place name results in own server?"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>Sorting geocoded place name results in own server?</title>
				<description><![CDATA[ Hi!

I would like to run a local install of a server to geocode close 47 million items. I am very grateful for the data provided (allCountries) and it looks like a great starting point.

Are there any resources on how to write queries against the data to get results similar to the geonames.org APIs? 

E.g. my data has "San Francisco, CA". In the webservice I get the correct geocoded place (San Francisco, USA) as the first item. In the raw data there are 98 places called "San Francisco". How would an SQL query look that returns a result sorted similar to the geonames.org API?

Regards,

Peter]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/2046.page#8300</guid>
				<link>http://forum.geonames.org/gforum/posts/list/2046.page#8300</link>
				<pubDate><![CDATA[Wed, 25 Aug 2010 12:08:25]]> GMT</pubDate>
				<author><![CDATA[ peterkz]]></author>
			</item>
			<item>
				<title>Re:Sorting geocoded place name results in own server?</title>
				<description><![CDATA[ At the most basic level, I think it just sorts by population descending. 

Ie at the lack of any other distinguishing features returns the biggest one first. 

But can also combine in sort by the featurecode. ]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/2046.page#8302</guid>
				<link>http://forum.geonames.org/gforum/posts/list/2046.page#8302</link>
				<pubDate><![CDATA[Wed, 25 Aug 2010 13:38:55]]> GMT</pubDate>
				<author><![CDATA[ barryhunter]]></author>
			</item>
	</channel>
</rss>