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
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
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
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
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
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