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
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 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?
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?
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?
> 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?
thats pretty impressive for a janitor ;) From: Matt Robertson <[EMAIL PROTECTED]> Sent: Friday, February 18, 2005 4:38 PM To: CF-Talk 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 +. 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?
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?
> 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?
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: 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