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
X: 860.674.8341 -Original Message- From: Jesse [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 29, 2006 4:31 PM To: MySQL List Subject: Zip Code & Distance This is not necessarily SQL Specific, but it will impact my MySQL application. Using the zip code, how can you determine what&#

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

Zip Code & Distance

2006-08-29 Thread Jesse
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