| Field Name |
Data Type |
Description |
| geom** |
GEOMETRY |
Binary internal representation of geometry |
| WKT* |
TEXT |
“MULTIPOLYGON” label, followed by coordinate pairs to define polygon(s) (longitude, latitude) |
| ZIP |
Char(5) |
5-digit ZIP Code |
| NAME |
VarChar(40) |
Postal town name, Primary |
| ZIPTYPE |
VarChar(20) |
The type of ZIP Code, per one of three types:
NON_UNIQUE, PO_BOX, or UNIQUE |
| STATE |
Char(2) |
State abbreviation (see note #2 below) |
| STATEFIPS |
Char(2) |
State FIPS Code |
| COUNTYFIPS |
Char(3) |
County FIPS code |
| COUNTYNAME |
VarChar(60) |
County name |
| S3DZIP |
Char(3) |
3-digit ZIP Code (the first 3 digits of the 5-digit ZIP Code) |
| LAT |
Decimal(12, 6) |
Latitude of ZIP Code Centroid |
| LON |
Decimal(12, 6) |
Longitude of ZIP Code Centroid |
| EMPTYCOL |
VarChar(5) |
Empty record |
| TOTRESCNT |
Integer |
Total count of residential deliveries in this route |
| MFDU |
Integer |
Total count of multifamily deliveries in this route; generally analogous to apartments |
| SFDU |
Integer |
Total count of single family deliveries in this route;
generally analogous to homes |
| BOXCNT |
Integer |
Total count of PO Box deliveries in this route |
| BIZCNT |
Integer |
Total count of business deliveries in this route |
| RELVER |
VarChar(8) |
Release version (e.g. 1.11.1) |
| COLOR |
Integer |
Numeric value for colorization in a map, so that no two adjacent ZIP Codes have the same color |
Postal Code Database
