Webmaster Forum / ColdFusion / Advanced Techniques / June 2007

Are you only interested in Taco Bell? What about Burger King?

There are three setups you need to do:
- Get the zip codes for every Taco Bell in the country and put them in a
database.  
- Then download the latitude and longitude zip code directory from
http://www.zipcoderesearch.com/geo.html ($49.99).

I presume the user would enter an address, including a zip code, and the
number of miles, correct?  Use the zip code directory to obtain the latitude
and longitude of the user's address.

Do some trigonometry on the user's lat/long and use the directory to create a
list of acceptable zip codes within the desired radius.  Tlhen query the
database using the list of acceptable zips.

(There's a lot of assuming goin' on here. :-)  )

Here is one that works pretty well for me. Just make sure you have all the
longs and lats to the corresponding zip.

SELECT a.zipcode, b.zipcode, 3963.0 * acos(sin(a.latitude/57.2958) *
sin(b.latitude/57.2958) + cos(a.latitude/57.2958) * cos(b.latitude/57.2958) *
cos(b.longitude/57.2958 - a.longitude/57.2958)) AS distance
FROM zipcode a, zipcode b
WHERE a.zipcode = '90210'  <==Enter zip here
AND 3963.0 * acos(sin(a.latitude/57.2958) * sin(b.latitude/57.2958) +
cos(a.latitude/57.2958) * cos(b.latitude/57.2958) * cos(b.longitude/57.2958 -
a.longitude/57.2958)) <=  20 <==Enter miles here
GROUP BY distance;

could you please let me know what do you have in you db.

I copy one zip db. It looks like that.

"00501","+40.922326","-072.637078","HOLTSVILLE","NY","SUFFOLK","UNIQUE"

I have my db. I have zip code column in it. So I have to match my query to zip
file. Is that right.? Thanx

so you have two  different  zipcode table right?
OR just you joining one table two times.