| From: | PaulD <pauldacus(at)gmail(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Geographic DB |
| Date: | 2005-11-17 17:37:15 |
| Message-ID: | 888b7c4d0511170937j2db0d61fo8ffe830e2a50df76@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi,
I actually implemented something in PHP/mySQL that is a DB of latitudes
& longitudes and zipcodes. The formula computes distance 'as the crow
flies' using the radius of the Earth between 2 zipcodes, etc. It's
here:
http://www.deschuteshay.com/distance/ziptest1.php
I wish I could remember where I got this data... maybe
hotscripts.com <http://hotscripts.com/>?
If needed, I can gzip a mysql dump... I'll leave the PG conversion to
you :-) Very simple though... only 3 fields!
Tell me if you'd like... maybe I'll post a download link to a page.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PaulD | 2005-11-17 18:40:17 | Geographic DB |
| Previous Message | Achilleus Mantzios | 2005-11-17 17:36:17 | Re: idea for a geographically distributed database: how best |