[thelist] zip code sql inserts to download

[Michael Mell]

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