Re: Zip Codes, Long/Lat and LAMP?

2006-02-27 Thread Alec Brecher
Have you looked at PostGIS? It's an open component which is built on top of PostgreSQL for performing geographic queries such as distances between two points. You can perform the queries through DBD:Pg. http://www.postgis.org/ I believe there is also a subgroup working on a geocoder which wil

RE: Zip Codes, Long/Lat and LAMP?

2006-02-27 Thread Rutherdale, Will
Formulas for great circle distances aren't hard to derive using just basic trig. No calculus required! That being said, the Math::Trig package comes standard with Perl distributions and has a function called great_circle_distance(). Try 'man Math::Trig'. If you search PDL::Index on CPAN, I beli

Re: Zip Codes, Long/Lat and LAMP?

2006-02-26 Thread Ben Tilly
On 2/26/06, Scott Webster Wood <[EMAIL PROTECTED]> wrote: > OK, I think I asked something along these lines before, but I am actually > starting to code so I wanted to revise the question(s) a bit. I am looking > for > a good way to keep an up-to-date database (or perhaps use an XML-RPC/SOAP > b