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 |