<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "help with Zillow data and mySQL"]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/4.page</link>
		<description><![CDATA[Latest messages posted in the topic "help with Zillow data and mySQL"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>help with Zillow data and mySQL</title>
				<description><![CDATA[ I'm working on a web app with a local search component. I am trying to accomplish two bits of neighborhood geocoding (on the cheap, of course). 

1. What neighborhood is a lat/long point inside? (I could do this with the webservice if it wasn't for the next point).

2. Given a lat long point, a list of nearby neighborhoods.

I think I need to import the raw Zillow shapefiles into the mySQL database but I have no idea what mathematical calculations to do for the boundary checking for a lat/long pair (for 1). For 2, I was thinking about calculating the center of each neighborhood and then some trigonometry to find nearby neighborhoods.

This is a bit intimidating for a novice and I'm not quite sure where to start. Any guidance would be appreciated. Thanks!]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/947.page#4221</guid>
				<link>http://forum.geonames.org/gforum/posts/list/947.page#4221</link>
				<pubDate><![CDATA[Mon, 23 Jun 2008 17:15:37]]> GMT</pubDate>
				<author><![CDATA[ jodansmif]]></author>
			</item>
			<item>
				<title>Re:help with Zillow data and mySQL</title>
				<description><![CDATA[ I suggest you use postgres/postgis instead of mysql.

Marc]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/947.page#4230</guid>
				<link>http://forum.geonames.org/gforum/posts/list/947.page#4230</link>
				<pubDate><![CDATA[Wed, 25 Jun 2008 21:31:48]]> GMT</pubDate>
				<author><![CDATA[ marc]]></author>
			</item>
			<item>
				<title>Re:help with Zillow data and mySQL</title>
				<description><![CDATA[ It's a Rails app and I'm the intern, so I don't think switching the database is a great plan... I found that the urbanmapping neighborhood API offers centroids so I think I'll just use that instead. Thanks for the advice, though.]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/947.page#4231</guid>
				<link>http://forum.geonames.org/gforum/posts/list/947.page#4231</link>
				<pubDate><![CDATA[Wed, 25 Jun 2008 21:48:29]]> GMT</pubDate>
				<author><![CDATA[ jodansmif]]></author>
			</item>
	</channel>
</rss>