[SQL] Geographic DB
Hi,I actually implemented something in PHP/mySQL that is a DB of latitudes& longitudes and zipcodes. The formula computes distance 'as the crowflies' using the radius of the Earth between 2 zipcodes, etc. It's here:http://www.deschuteshay.com/distance/ziptest1.phpI wish I could remember where I got this data... maybe hotscripts.com?If needed, I can gzip a mysql dump... I'll leave the PG conversion toyou :-) Very simple though... only 3 fields! Tell me if you'd like... maybe I'll post a download link to a page.
[SQL] Geographic DB
Having been asked, I posted a mySQL dump of latitude, longitude and zip codes for the US. I've also included a PHP zipcode computational piece of code, a DB manager, and the page itself all in GZIP format. Instructions are on the page. P.S. I can't possibly help you if you're having problems! Unzip it all, put the dump into mySQL, edit the db.inc file (username/pwd/host/db_name), run the ziptest1.php script, and if it works GREAT! If it doesn't... you'll have a new opportunity to learn! I would never want to take that away from you :-) It works for me, so if it doesn't work for you, I probably can't fix it. Paul Dacus
[SQL] Geographic Distance Calc website
I found the original website: http://www.sanisoft.com/ziploc/
