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]
