[thelist] zip code sql inserts to download
Michael Mell
mike at nthwave.net
Thu Apr 11 23:58:01 CDT 2002
Here:
http://www.nthwave.net/buildDB07-sql.zip
is a sql file containing all the zips in the U.S. with their longitude
and latitude set as sql statements in the form:
insert into zipCodeCoords set
zipCode="35004",longitude="86.51557",latitude="33.584132";
I didn't think till later today that this might be helpful. This, along
with my earlier link to http://www.cryptnet.net/fsp/zipdy/ is all you
need to calculate distances between zip codes in the U.S.
I believe the coordinates came from the U.S.Postal Service but I can't
find the link on the www.usps.com site.
--
mike[at]nthwave.net
llemekim YahooIM
415.455.8812 voice
419.735.1167 fax
More information about the thelist
mailing list