|
ZIP Code Boundary Sample & Demo
Questions? 1-800-425-1169
ZIP Code Boundaries Sample
Download Sample
Includes these data formats:
- ESRI - Shapefile (.shp)
- Google Display - KML (.kml)
- DB Loadable - WKT (.txt)
- DB Loadable - MySQL™ (.sql)
- DB Loadable - SQL Server(.sql)
- DB Loadable - Post GIS (.sql)
- Comma Separated Values (.csv)
ZIP Code Boundaries Specifications
| 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 |
*WKT field only in WKT format file
**geom field only in MySQL™ and PostGIS formats
Note #1: For database loadable formats all field names will be lowercase
Note #2: In rare instances, ZIP Code boundaries can cross state borders, in which case the state recorded is where the ZIP Code centroid falls.
|
Postal Code Database
