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.
Column name | Type | Null | Default | Description |
---|---|---|---|---|
FIPS | char(2) | YES | ?? | |
zip | varchar(5) | ZIP Code | ||
State | char(2) | State | ||
Name | varchar(30) | Name of city | ||
alloc | float(9,7) | 0.0000000 | ?? | |
pop1990 | int | 0 | Population in 1990. | |
lon | float(10,7) | 0.0000000 | Longitude | |
lat | float(10,7) | 0.0000000 | Latitude |
Key name | Type | Column(s) |
---|---|---|
PRIMARY | PRIMARY |