I have a copy of the Zip Code db for MySql. Its a few years old but should be 99% accurate compared to new ones.
Thanks Donny Lairson President 29 GunMuse Lane P.O. box 166 Lakewood NM 88254 http://www.gunmuse.com 469 228 2183 -----Original Message----- From: Scott Gifford [mailto:[EMAIL PROTECTED] Sent: Friday, April 15, 2005 6:01 PM To: Scott Haneda Cc: MySql Subject: Re: zip code search within x miles Scott Haneda <[EMAIL PROTECTED]> writes: > How are sites doing the search by zip and coming up with results within x > miles? Is there some OSS zip code download that has been created for this? Zipdy does most of what you want; it needs to be modified to support MySQL instead of PostgreSQL, but that shouldn't be too hard. It also has the great circle function you need to calculate the distances correctly. You can get it from: http://www.cryptnet.net/fsp/zipdy/ If you're using Perl, Geo::PostalCode works very well, though it doesn't use an SQL database at all: http://search.cpan.org/~tjmather/Geo-PostalCode-0.06/lib/Geo/PostalCode. pm ---ScottG. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
