Обсуждение: Geographic DB

<pre><font><font><font><font size="-0">Hi,<br /><br />I actually implemented something in PHP/mySQL that is a DB of
latitudes<br/>& longitudes and zipcodes.  The formula computes distance 'as the crow<br />flies' using the radius
ofthe Earth between 2 zipcodes, etc.  It's 
<br /><br />here:<br /><br /><a href="http://www.deschuteshay.com/distance/ziptest1.php"
target="_blank">http://www.deschuteshay.com/distance/ziptest1.php</a><br/><br />I wish I could remember where I got
thisdata... maybe  
<a href="http://hotscripts.com/" target="_blank"><br />hotscripts.com</a>?<br />If needed, I can gzip a mysql dump...
I'llleave the PG conversion to<br />you :-)  Very simple though... only 3 fields! 
<br /><br />Tell me if you'd like... maybe I'll post a download link to a page.</font></font></font></font></pre>