Thank goodness for the US Census! The 1999 Census contained public domain info on zip codes (info the businesses usually pay a pretty penny for for the postal service).
I was able to use this data to create a SQL table with some useful zip code info in it like:
City
State
ZipCode class (tells you if it is a unique zip code or po box only)
Lat/Lon (for mapping applications)
I used SQL 2008's great Generate Scripts Wizard to export the table structure, index definitions, and all the data to a single script file. You can find the zip file here (I just know there is a pun in there somewhere).
I will keep an eye out for a newer census report, but zip codes don;t change all that often, so this list should be pretty accurate.
Did this help you? If so, please leave a comment!
No comments:
Post a Comment