Yeah, there are a few free ones out there, but I found almost all of them to be incomplete. How do I know? Well, not very scientifically really. First, my client found two zip codes that didn't work with their then current database. I then checked every free zip code table I could find for those two zip codes. Some had one of the two, and some had none of them. Not until I bought one did I find both of the zip codes.
Then after spending thirty bucks on one (not a very big expenditure in my book), I checked out the number of records against the other free ones. From memory, I think my commercial zip code table has about 65,000 records in it... I'm not 100% sure on that, but when compared to the other tables I found for free (one of them even from sourceforge ... i *think*) the free tables weren't even close to that many records. I'm not terribly disappointed that I paid thirty bucks instead of five, especially since my zip table is working just fine for me. The only think I don't particularly like is that my specific commercial zip table comes with a license that says basically that I can't use it for a whole slew of clients. In other words each of my clients would have to purchase their own copy. If that five-dollar table doesn't have that restriction, and proved to be as complete (which if it's working for some folks it probably is), then I'd go with it personally. Even if it did have a similar restriction, I'd still go with it. C'mon it's five bucks! :o) Chris Tyler Clendenin wrote: > I get most of my postal code information from here for free. It is not the > most recent (which you can pay other services for that info) but it is > useful. > > http://www.census.gov/geo/www/gazetteer/places2k.html > > I also have a MS-SQL UDF I use. It's really fast. (Although I couldn't tell > you where I found it) > > > CREATE FUNCTION [dbo].[calcLatLongDist] > ( > @lat_A decimal(28, 16) > , @long_A decimal(28, 16) > , @lat_B decimal(28, 16) > , @long_B decimal(28, 16) > ) > RETURNS decimal(28, 16) > AS > BEGIN > DECLARE > @Distance decimal(28, 16) > > SET @Distance = (Sin(Radians(@lat_A)) * > Sin(Radians(@lat_B)) + > Cos(Radians(@lat_A)) * > Cos(Radians(@lat_B)) * > Cos(Radians(@long_A - @long_B))) > > SET @Distance = (Degrees(ACos(@Distance))) * 69.09 > > RETURN @Distance > END > > > > -----Original Message----- > From: Rick Root [mailto:[EMAIL PROTECTED] > Sent: Monday, February 05, 2007 3:43 PM > To: CF-Talk > Subject: Postal Code database and proximity > > Is anyone out there using "within 25 miles of <zipcode>" for searching > address database? > > I've gotten a request where someone is visiting a certain zip code and > they want to know all the prospects within a 25 mile radius of the zip > code they're visiting. > > I know there are ways to do this.. just wondered what people out there > are using. > > Thanks! > > Rick > > This email message may contain privileged and/or confidential information. > If you are not the intended recipient(s), you are hereby notified that any > dissemination, distribution, or copying of this email message is strictly > prohibited. If you have received this message in error, please immediately > notify the sender and delete this email message from your computer. > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268745 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
