Geographic DB
| От | PaulD |
|---|---|
| Тема | Geographic DB |
| Дата | |
| Msg-id | 888b7c4d0511170937j2db0d61fo8ffe830e2a50df76@mail.gmail.com обсуждение исходный текст |
| Список | pgsql-sql |
<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>
В списке pgsql-sql по дате отправления: