zips

zips — Global. ZIP Code data for the United States that includes geographic co-ordinates. Only used with an ljcom maintenance script that generates marker files for use in making Xplanet maps. Most of the LJ code uses the zip table instead.

zips

Column name Type Null Default Description
FIPS char(2) YES U.S. Census Bureau assigned two-digit FIPS (Federal Information Processing Standards) code for geographic sequence of each State within each census division.
zip varchar(5)   ZIP Code.
State char(2)   State.
Name varchar(30)   Name of city.
alloc float(9,7)   0.0000000 Allocation Factor (decimal portion of state within zipcode).
pop1990 int   0 Population in 1990. (Table uses 1990 Census Bureau 'Gazetteer' data).
lon float(10,7)   0.0000000 Longitude (West is assumed, no minus sign).
lat float(10,7)   0.0000000 Latitude (North is assumed, no plus sign).
Key name Type Column(s)
PRIMARY PRIMARY