Data Layout

Introduction

A Carrier Route is a designated geographic representation of a group of addresses that are served by each postal carrier to facilitate an efficient mail delivery within specific regions, whereby address delivery points are converted to polygonal areas for each route. For effective mail delivery, the U.S. Postal Service (USPS) provides a unique 9-digit code to a specific group of mailing addresses known as a “carrier route.” This route is a means to divide a geographic region into smaller sections to speed up the delivery process. The routes are defined by a address locations, a specified set of zip code boundaries and census block information. Using carrier routes with the combined use of route planning and optimization can make the delivery process faster, easier, and more efficient.

Sample File

Click here to download the sample file.

Layout and Definitions

Grouping	Column Name	Type	Definition
Address	ZIPCode	nvarchar(5)	ZIP Code
	CarrierRoute	nvarchar(4)	The carrier route for the location address assigned by the USPS.
	ZIPCarrierRoute	nvarchar(9)	ZIP Code plus carrier route
Geo	Shape	geography	Internal shape information used to generate shape
	CenterLatitude	decimal(18,6)	The latitude in decimal degrees using the WGS84 datum for the centroid of the parcel
	CenterLongitude	decimal(18,6)	The longitude in decimal degrees using the WGS84 datum for the centroid of the parcel