Zip Code Help

treeleaf20

On resturants websites and stuff like that they have find nearest location. On my site I would like something similar to that as well. When someone selects a city that zip code is stored in a database. I would like to find the nearest zip codes within 50 miles or 25 miles and so forth. I would like to display them in checkboxes then so users can select them as search criteria. Can anyone help me out with this or know of a place to find information on this?

Thanks in advance.

Weedpacket

You can find out here. Just search for "zip code" and/or "distance".

treeleaf20

Weedpacket thanks for your reply. I was wondering if you had any specific threads you were referring to . I did the search and it didn't yeild much of anything. I do appreciate yours and anyone else's help on this issue.

Thank you

Weedpacket

Really? I try searching for "distance zip code" and I find plenty:

http://www.phpbuilder.com/board/showthread.php?t=10283742&highlight=distance+zip+code
http://www.phpbuilder.com/board/showthread.php?t=10281098&highlight=distance+zip+code
http://www.phpbuilder.com/board/showthread.php?t=10301949&highlight=distance+zip+code

among many others. There was one no more than a day ago:

http://www.phpbuilder.com/board/showthread.php?t=10313417

treeleaf20

I really like the AstroTeg solution found here: http://www.rsbauer.com/zip/index.php I have a couple questions. One is that I would like to view the queries he uses for all of them so I can understand how he did it. The second thing is what datasource did he use to obtain all that information. Is the running on mySql? Thanks for the continued help this will help me so much.

dalecosp

I assume since we say "ZIP", we mean U.S. "Zoning Improvement Plan" codes? Why not go to the source?

treeleaf20

THanks for the reply. I looked an was still unsure of what he downloaded.

AstroTeg

I used US census data since the USPS charges for their zip code info. To figure out distances, you'll want lattitude and longitude coordinates which can then be used to calculate the distance between two points (be it zip codes or whatever). I've got code to do the calculations up on my site and as others have pointed out here, there's all sorts of threads here on the topic.

treeleaf20

Do you have a link to that file that you used. It looked like the only census data that I could find was from 1999. Thanks for your continued help.

AstroTeg

I don't have the link to the files. I know the data I found was for 2000. I'd go look up the link, but I'm knee-deep in a Java data structures and algorithms programming assignment.

treeleaf20

Ok I downloaded some date. The form is lilke: Zipcode, Latitude, logitude, city, state, abbr. I' not sure what goes where with your query:

SELECT zipponame, zipclass, zipcode, ziplong, ziplat, stateabrev, statename, countyname, zip2000.zipcounty, geodist(40.653037, -75.726896, ziplat, ziplong) AS distance, zippop, ziphousing, zipland, zipwater FROM zip2000 INNER JOIN state ON state.fipsstate = zip2000.zipstate INNER JOIN county ON county.fipsstate = zip2000.zipstate and county.fipscounty = zip2000.zipcounty WHERE geodist(40.653037, -75.726896, ziplat, ziplong) <= 5 ORDER BY distance

Did you do a query before that to pick the actual latitude and longitude of the zip code that was entered? Would you be able to rewrite the query for me to just use the fields that I had.

By the way a real cheap zip code database that is up to date is: http://www.teamredline.com/zc/ it is only $5.

Thanks for the continued help.