From: Robert Dunlop
Date: April 15 2005 10:51pm
Subject: Re: zip code search within x miles
List-Archive: http://lists.mysql.com/mysql/182714
Message-Id: <000901c5420d$a7b433a0$c101a8c0@legolas>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

I haven't looked into this recently, but as long as 15  years ago there were
zip -> mile libraries available; I assume similar libraries still exist.
The ones I worked with all used only the first 3 digits.  Full five digit
and nine digit zips get to pretty specific geographic locations, a level of
accuracy not needed when telling people what resource exist within "x"
miles.   You might try google something like: (zipcode OR zip)  distance
software library
HTH

Bob
----- Original Message ----- 
From: "Scott Haneda" <lists@stripped>
To: "MySql" <mysql@stripped>
Sent: Friday, April 15, 2005 3:37 PM
Subject: zip code search within x miles


> 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?
> -- 
> -------------------------------------------------------------
> Scott Haneda                                Tel: 415.898.2602
> <http://www.newgeo.com>                     Novato, CA U.S.A.
>
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/mysql?unsub=rdunlopconsult@stripped
>
>