Zip code radius database?
I need to be able to find all zip codes within x miles of a given zip code. What' the best (perhaps free) way to do this? Gracias! Jon Block ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195390 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Zip code radius database?
From: Jon Block [mailto:[EMAIL PROTECTED] I need to be able to find all zip codes within x miles of a given zip code. What' the best (perhaps free) way to do this? You need to obtain a database of zip codes including lat/long coordinates. Then the formula for calculating distance is out on the net (google). Pengoworks.com has a zipcodes DB in the JS Gateway examples area that has all the zip code / lat / long information... I don't know how current the data is though. Mike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195395 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Zip code radius database?
If you can get a zip code db that contains latitudes and longitudes you can
use:
The great circle distance d between two points with coordinates {lat1,lon1}
and {lat2,lon2} is given by:
d=acos(sin(lat1)*sin(lat2)+cos(lat1)*cos(lat2)*cos(lon1-lon2))
Props go to Novak Banda.
He used to have a free zip code db at http://www.cfdynamics.com/zipbase but
I'm not sure if its still there, updated, or whatever...
HTH,
Max
-Original Message-
From: Jon Block [mailto:[EMAIL PROTECTED]
Sent: Friday, February 18, 2005 11:32 AM
To: CF-Talk
Subject: Zip code radius database?
I need to be able to find all zip codes within x miles of a given zip code.
What' the best (perhaps free) way to do this?
Gracias!
Jon Block
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195399
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Zip code radius database?
From: Max Hamby [mailto:[EMAIL PROTECTED]
If you can get a zip code db that contains latitudes and
longitudes you can
use:
The great circle distance d between two points with
coordinates {lat1,lon1} and {lat2,lon2} is given by:
d=acos(sin(lat1)*sin(lat2)+cos(lat1)*cos(lat2)*cos(lon1-lon2))
Remember to convert to radians first or include the conversion to radians
from degrees in the formula.
Michael T. Tangorre
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195402
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Zip code radius database?
I think you can get the DB from the US Postal Service. I have a DB that is about a year old. If you're interested, e-mail me off-list. On Fri, 18 Feb 2005 11:32:07 -0500, Jon Block [EMAIL PROTECTED] wrote: I need to be able to find all zip codes within x miles of a given zip code. What' the best (perhaps free) way to do this? Gracias! Jon Block ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195427 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Zip code radius database?
Most of the zip code tags I came across were made with a particular db in mind. I whipped up ZipMonger to work with anything, and then I optimized it to the point where it was returning responses in a couple of seconds where other tags where at 30 seconds +. It'll work with any zip code db you can come up with, but I don't think you will find a free current one unless someone has updated their stuff. (one of the free tags in the devex has a db in it, I think) I use the zipcodeworld.com db. A one-month subscription to the premium version is $39.95. Can't beat that as the db is usable for a heck of a lot longer than a month :-). ZipMonger is free for the taking. http://mysecretbase.com/zipmonger_home.cfm -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195483 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Zip code radius database?
thats pretty impressive for a janitor ;) From: Matt Robertson [EMAIL PROTECTED] Sent: Friday, February 18, 2005 4:38 PM To: CF-Talk cf-talk@houseoffusion.com Subject: Re: Zip code radius database? Most of the zip code tags I came across were made with a particular db in mind. I whipped up ZipMonger to work with anything, and then I optimized it to the point where it was returning responses in a couple of seconds where other tags where at 30 seconds +. It'll work with any zip code db you can come up with, but I don't think you will find a free current one unless someone has updated their stuff. (one of the free tags in the devex has a db in it, I think) I use the zipcodeworld.com db. A one-month subscription to the premium version is $39.95. Can't beat that as the db is usable for a heck of a lot longer than a month :-). ZipMonger is free for the taking. http://mysecretbase.com/zipmonger_home.cfm -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195485 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Zip code radius database?
Most of the zip code tags I came across were made with a particular db in mind. I whipped up ZipMonger to work with anything, and then I optimized it to the point where it was returning responses in a couple of seconds where other tags where at 30 seconds +. Try moving the logic into the database. When you're done, it should return in milliseconds. It won't be as portable, but it will be much faster. Ben Rogers http://www.c4.net v.508.240.0051 f.508.240.0057 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195490 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Zip code radius database?
OT but fun, check this out: http://acg.media.mit.edu/people/fry/zipdecode/ V cool On Fri, 18 Feb 2005 13:35:39 -0800, Matt Robertson [EMAIL PROTECTED] wrote: Most of the zip code tags I came across were made with a particular db in mind. I whipped up ZipMonger to work with anything, and then I optimized it to the point where it was returning responses in a couple of seconds where other tags where at 30 seconds +. It'll work with any zip code db you can come up with, but I don't think you will find a free current one unless someone has updated their stuff. (one of the free tags in the devex has a db in it, I think) I use the zipcodeworld.com db. A one-month subscription to the premium version is $39.95. Can't beat that as the db is usable for a heck of a lot longer than a month :-). ZipMonger is free for the taking. http://mysecretbase.com/zipmonger_home.cfm -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195492 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Zip code radius database?
I got all this workin right here! It's pretty brainless if you ask me! http://www.singinginfo.com/singinginfo/search.cfm THE GAAAME! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195519 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Zip code radius database?
dang it must be then HAHA jk willy check this out, one of the girls u like (sorry its kinda big outside of a page) http://www.icandfashion.com/chandissmusic/chandissmp3.swf From: Will Tomlinson [EMAIL PROTECTED] Sent: Friday, February 18, 2005 6:58 PM To: CF-Talk cf-talk@houseoffusion.com Subject: Re: Zip code radius database? I got all this workin right here! It's pretty brainless if you ask me! http://www.singinginfo.com/singinginfo/search.cfm THE GAAAME! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195526 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Zip code radius database?
dang it must be then HAHA jk willy check this out, one of the girls u like (sorry its kinda big outside of a page) http://www.icandfashion.com/chandissmusic/chandissmp3.swf That is NICE dudE! VERY NICE!! I like that! ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195530 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
