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

Re: [PHP] Postal / Zip Code Proximity Search

2002-07-09 Thread Ray Hunter
intersection of these and reference a table that has the zip codes B i g D o g - Original Message - From: "Brandon Pearcy" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, July 04, 2002 9:33 AM Subject: [PHP] Postal / Zip Code Proximity Search > Hello

[PHP] Postal / Zip Code Proximity Search

2002-07-09 Thread Brandon Pearcy
Hello, I have a couple of questions with respect to creating a postal / zip code proximity search that is remotely accurate. The system I am using now is OK for small distances, but is terrible at calculating large distances. What I have is a database of establishments and their correspo