On 4/16/05, Scott Gifford <[EMAIL PROTECTED]> wrote: > Jeff Kolber <[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? > > The ones I'm familiar with use this: > > http://www.census.gov/geo/www/tiger/zip1999.html > > [...] > > > I would be interested, anyone have insights into doing with Canadian > > Zip Codes or otherwise optimizing a database of Canadian Zip Codes? > > I looked into this a few months back (for a very similar project, > actually) and found many places offering Canadian postal code > databases, but none for free. If you already have the database, I > don't see why optimizing it would be any different than for American > postal codes. > > ----ScottG. >
Just that there are supposedly 650,000+ canadian codes. Makes you want to do whatever your doing in an optimal way. Jeff Kolber -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]