<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "Finding nearby geonameid's"]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/4.page</link>
		<description><![CDATA[Latest messages posted in the topic "Finding nearby geonameid's"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>Finding nearby geonameid's</title>
				<description><![CDATA[ So I have GeonameId and Lat & Long for any given position. I want to be able to find out nearby products to this position, my products tabel looks like:

ProductId     ProductName     GeonameId
-----------------------------------------------
1                 Product 1          875124
2                 Product 2          987412
etc

So my question is whats the best way to find which products are close by a given location? I am using the dump on a locale MySQL database.]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1500.page#6256</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1500.page#6256</link>
				<pubDate><![CDATA[Mon, 24 Aug 2009 16:11:52]]> GMT</pubDate>
				<author><![CDATA[ johnnytoobad]]></author>
			</item>
			<item>
				<title>Re:Finding nearby geonameid's</title>
				<description><![CDATA[ There are several approaches and which is best for your depends on your requirements, skills and environment.

You could add the lat/lng to the product table, that you don't have to join with all geonames records.

For the distance query you could use a spatial extension: http://dev.mysql.com/doc/refman/5.0/en/spatial-extensions.html
(geonames is using postgres with postgis)
or you could use a bounding box restriction on the coordinates and sort by your own distance implementation:
http://forum.geonames.org/gforum/posts/list/1081.page

Other threads:
http://forum.geonames.org/gforum/posts/list/692.page
http://forum.geonames.org/gforum/posts/list/727.page

Best

Marc]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1500.page#6265</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1500.page#6265</link>
				<pubDate><![CDATA[Wed, 26 Aug 2009 08:15:44]]> GMT</pubDate>
				<author><![CDATA[ marc]]></author>
			</item>
	</channel>
</rss>