Re: Zip Code & Distance

2006-08-29 Thread barney
Jesse, Back around 1995-1996 I built a VB app with an Access database that would do much of what you want - it was for shipping and terminal locations - then ported it over to ASP & SQL Server a year or two later. I found several raw data files, either CSV or TSV, which were pretty easily impo

RE: Zip Code & Distance

2006-08-29 Thread Jerry Schwartz
That (using the zip code digits) won't work. Zip codes are assigned by population density, not by distance. A big city might have several zip codes, although they'd all likely have the same first three digits, but check Manhattan for an example. In our area, the core city (Hartford) and some of it

Re: Zip Code & Distance

2006-08-29 Thread Gmail User
On Tue, 2006-08-29 at 16:30 -0400, Jesse wrote: > Does anyone have any ideas? One technique is to calculate set distances (5,10,25,50) between the zip codes in advance and stick the results in a table. Enjoy, Ed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql T

Re: Zip Code & Distance

2006-08-29 Thread Chris W
Jesse wrote: 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

Re: Zip Code & Distance

2006-08-29 Thread Greg Donald
On 8/29/06, Jesse <[EMAIL PROTECTED]> wrote: 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 3388

Re: Zip Code & Distance

2006-08-29 Thread Philip Hallstrom
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 cod