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
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
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
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
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
-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's in a (say) 50 mile
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