RE: [PHP] Postal / Zip Code Proximity Search

2002-07-09 Thread Matt Schroebel
> 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, vis

Re: [PHP] Postal / Zip Code Proximity Search

2002-07-09 Thread Miguel Cruz
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 "t

RE: [PHP] Postal / Zip Code Proximity Search

2002-07-09 Thread Matt Schroebel
> -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 a

Re: [PHP] Postal / Zip Code Proximity Search

2002-07-09 Thread Peter J. Schoenster
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]> > >

RE: [PHP] Postal / Zip Code Proximity Search

2002-07-09 Thread Brian McGarvie
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 S

Re: [PHP] Postal / Zip Code Proximity Search

2002-07-09 Thread Ray Hunter
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 intersectio