One suggestion is to use the geo functionality of Postgres
We use postgres to calculate city, state, and/or country by using the geo
functions in postgresql.
I would really suggest using postgres for your calculations.
You can pass the lat and long and have postgres give you the
http://www.totalscripts.com/pages/Perl_Scripts/Calculator/
GeoZip... only for US postcodes tho.. but is ur US fine ;)
-Original Message-
From: Brandon Pearcy [mailto:[EMAIL PROTECTED]]
Sent: 04 July 2002 4:34 PM
To: [EMAIL PROTECTED]
Subject: [PHP] Postal / Zip Code Proximity
On 9 Jul 2002 at 10:39, Ray Hunter wrote:
One suggestion is to use the geo functionality of Postgres
We use postgres to calculate city, state, and/or country by using the
geo functions in postgresql.
- Original Message -
From: Brandon Pearcy [EMAIL PROTECTED]
I have a
-Original Message-
From: Peter J. Schoenster [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 09, 2002 1:26 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP] Postal / Zip Code Proximity Search
I don't know what you mean by straight line. AFAIK all of
this will be as the crow flies
On Tue, 9 Jul 2002, Peter J. Schoenster wrote:
From: Brandon Pearcy [EMAIL PROTECTED]
Not only does it need to find the establishments, it needs to
calculate the distances (straight line, of course).
I don't know what you mean by straight line. AFAIK all of this will be
as the crow flies.
I found the points file here:
ftp://ftp.census.gov/pub/tiger/pts/geoex.zip
Sorry, I was wrong here. Those aren't the right files, and it's hard to find the
correct ones. Should I ever do that, I'll post a correct link.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe,
6 matches
Mail list logo
