Re: [nyphp-talk] Radial Zip Code Search

2007-01-24 Thread Paul
I have used this and got it working with some help from members of this list. Works fine for me. Also has the database of all the zip codes. Paul Guba On Jan 23, 2007, at 9:19 PM, Ken Robinson wrote: At 03:44 PM 1/19/2007, Donna Marie Vincent wrote: Hi, all. I am looking for a script, o

Re: [nyphp-talk] Radial Zip Code Search

2007-01-23 Thread Ken Robinson
At 03:44 PM 1/19/2007, Donna Marie Vincent wrote: Hi, all. I am looking for a script, or a tutorial on how to create a script, that will perform a radial zip code search. I Googled this "radial zip code" and "radial postcode" and have found nothing about how to do this. Can anyone point me i

RE: [nyphp-talk] Radial Zip Code Search

2007-01-23 Thread Steve Solomon
In the real world most of these applications involve finding locations (i.e., "stores") closest to a given zip code (or city and state which is then translated to a zip code). The standard solutions are not very efficient here because they are redoing calculations that only have to be done once.

Re: [nyphp-talk] Radial Zip Code Search

2007-01-22 Thread Joseph Crawford
That's a nice setup but something is wrong there There are 8 Zip codes withing a 5 miles radius of 05701 They are: 05251 Dorset, VT 0.85 miles 05701 Rutland, VT 0.00 miles 05702 Rutland, VT 0.00 miles 05736 Center Rutland, VT 2.59 miles 05744 Florence, VT 3.57 miles 05759 North Clarendon, VT 2.13

Re: [nyphp-talk] Radial Zip Code Search

2007-01-21 Thread Urb LeJeune
Can anyone point me in the right direction? Thanks in advance! ` Is this what you're looking to do? http://phpphanatic.com/zipcodes Urb ___ New York PHP Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk NYPHPCon 200

Re: [nyphp-talk] Radial Zip Code Search

2007-01-20 Thread Paul Houle
The following query, from Donald J Organ IV, is an elegant answer, but it involves a full table scan: SELECT distinct zipcode, ROUND((ACOS((SIN($lat/57.2958) * SIN(latitude/57.2958)) + (COS($lat/57.2958) * COS(latitude/57.2958) * COS(longitude/57.2958 - $long/57.2958 * 3963, 3) AS dist

Re: [nyphp-talk] Radial Zip Code Search

2007-01-20 Thread Urb LeJeune
Hi, all. I am looking for a script, or a tutorial on how to create a script, that will perform a radial zip code search. I Googled this "radial zip code" and "radial postcode" and have found nothing about how to do this. Can anyone point me in the right direction? Thanks in advance!

Re: [nyphp-talk] Radial Zip Code Search

2007-01-20 Thread Donna Marie Vincent
Wow, thanks for all the great info! I had tried searching Hotscripts but apparently used the wrong keywords. I used "radial ..." ___ New York PHP Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk NYPHPCon 2006 Presentations

RE: [nyphp-talk] Radial Zip Code Search

2007-01-19 Thread Mark Armendariz
Good Luck, and have a great weekend, all. Mark > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Joseph Crawford > Sent: Friday, January 19, 2007 4:15 PM > To: NYPHP Talk > Subject: Re: [nyphp-talk] Radial Zip Code Search

Re: [nyphp-talk] Radial Zip Code Search

2007-01-19 Thread Joseph Crawford
PROTECTED] > On Behalf Of Donna Marie Vincent > Sent: Friday, January 19, 2007 3:45 PM > To: talk@lists.nyphp.org > Subject: [nyphp-talk] Radial Zip Code Search > > Hi, all. I am looking for a script, or a tutorial on how to create a > script, that will perform a radial zip code

Re: [nyphp-talk] Radial Zip Code Search

2007-01-19 Thread Donald J Organ IV
php - - Jon - -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Donna Marie Vincent Sent: Friday, January 19, 2007 3:45 PM To: talk@lists.nyphp.org Subject: [nyphp-talk] Radial Zip Code Search Hi, all. I am looking for a script, or a tutorial on how to create a

RE: [nyphp-talk] Radial Zip Code Search

2007-01-19 Thread Baer, Jon
: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Donna Marie Vincent Sent: Friday, January 19, 2007 3:45 PM To: talk@lists.nyphp.org Subject: [nyphp-talk] Radial Zip Code Search Hi, all. I am looking for a script, or a tutorial on how to create a script, that will perform a radial zip

Re: [nyphp-talk] Radial Zip Code Search

2007-01-19 Thread Stephen Musgrave
http://www.myzipdb.com/zipcode_locator.php On Jan 19, 2007, at 3:44 PM, Donna Marie Vincent wrote: Hi, all. I am looking for a script, or a tutorial on how to create a script, that will perform a radial zip code search. I Googled this "radial zip code" and "radial postcode" and have found

[nyphp-talk] Radial Zip Code Search

2007-01-19 Thread Donna Marie Vincent
Hi, all. I am looking for a script, or a tutorial on how to create a script, that will perform a radial zip code search. I Googled this "radial zip code" and "radial postcode" and have found nothing about how to do this. Can anyone point me in the right direction? Thanks in advance!