This is not necessarily SQL Specific, but it will impact my MySQL
application.
Using the zip code, how can you determine what's in a (say) 50 mile radius.
In other words, if I'm looking for schools within a 50 mile radius of my
location (Zip Code 33881), How can I determine this by the zip code? I have
seen lots of search engines that do this, but don't know how they determine
the distance. I figured that I can use the first 4 digits as a match, then
the first 3 digits which will be a little further away, but I don't know how
accurate that would be. Does anyone have any ideas?
Don't use the zip code itself. It might work for some areas, but
certainly doesn't work in the western washington. It's just cut uptoo
weird.
We bought a zip code database from um... www.zipcodedownload.com which has
a big list of cities, zips, and lat/long coordinates.
Once you have the lat/long you can do the math easily...
Not sure if they have a zip code only version... but the one we bought was
like $30 and works just fine...
-philip
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
