zips

zips — ZIP Code data for the United States that includes geographic coordinates. Only used with a ljmaint script that generates marker files for use in making xplanet maps. Most the LJ code uses the zip table instead.

zips

Column nameTypeNullDefaultDescription
FIPSchar(2)YES??
zipvarchar(5)ZIP Code
Statechar(2)State
Namevarchar(30)Name of city
allocfloat(9,7)0.0000000??
pop1990int0Population in 1990.
lonfloat(10,7)0.0000000Longitude
latfloat(10,7)0.0000000Latitude
Key nameTypeColumn(s)
PRIMARYPRIMARY