US ZIP Code Database

I've seen this database for sale by unscrupulous individuals who do nothing more than try to con you out of your hard earned cash.

Did you know this data is free?

This archive even includes a simple ASP/VBSCript demo, with CSS goodness.

This free Access database of ZIP codes provides database designers with a valuable tool to assist in mapping ZIP codes to a city/state pair and even provides the latitude and longitude of that location. The database contains three tables: the ZIP Code table, the Class table and the State table.

The ZIP Code table contains six fields:

ZIP Code is the five digit ZIP code and is the primary key of this table.
Latitude is the latitude of the location, to five decimal places.
Longitude is the longitude of the location, to five decimal places.
Class is the class of the ZIP code. This field is a foreign key to the Class table.
City is the name of the post office serving this ZIP code.
State Code is the two-digit state code, as defined by the Federal Information Processing Standards. It is a foreign key to the States table

The States table contains three fields:

State Code is the two-digit state code, as defined by the Federal Information Processing Standards.
State Abbreviation is the commonly accepted postal abbreviation for the state.
State Name is the full name of the state.

The Class table contains two fields:

Class is the one character class code.
Descripton is a text field describing the class in further detail.

About this post

Posted: 2009-06-13
By: FortyPoundHead
Viewed: 3,171 times

Comments

No comments have been added for this post.

You must be logged in to make a comment.