Data Layout

Attention

🚧🛠️ Pardon Our Dust! 🛠️🚧

We’re in the process of enhancing our website to provide you with a better experience. While we work diligently, you might notice a few things out of place. Please excuse the temporary mess as we strive to improve our site.

👇 For now the links below will guide you to our previous documentation. 👇

Layout and Definitions

Grouping	Column Name	Type	Definition
Address	RBDI	char(1)	Business/Residential indication
	Title	varchar(14)	Delivery address title
	ADDRESS	varchar(64)	Address line
	City	varchar(28)	City name as it should appear as part of the address. Renamed from Post Office name.
	State	char(2)	The abbreviation used for a state
	Zip	char(5)	ZIP Code for this address
	Plus4	char(4)	ZIP+4 for this address, For Simplified addresses the Zip+4 values are Empty/Blank
	Walkseq	varchar(9)	Walk Sequence number
	Crrt	char(4)	Carrier Route for this address
	Endorse	varchar(30)	Optional Endorsement Line
	City_rural	varchar(1)	Identifies the address as City Style (C) or Simplified (S). City style (C) addressing requires that there is a specific street address including street numbers or specific post office box number. Simplified addressing (S) is an address method used for rural deliveries. Simplified addresses are those which do not contain a specific street address. Renamed from city rural flag.
	dpb	char(2)	Delivery point barcode. You will have to left zero fill this field.
	dpbc	char(1)	Delivery point barcode check digit
People	PreName	varchar(10)	Primary salutation of person living at the residential address. For example: Mr. Mrs. Rev. Dr.
	FirstName	varchar(20)	Primary first name of person living at the residential address
	Initial	varchar(1)	Primary middle initial of person living at the residential address
	LastName	varchar(20)	Primary last name of person living at the residential address
	PostName	varchar(5)	Primary first name suffix. For example: Sr, Jr, III
Address	NameSlug	varchar(25)	Indicating Current resident or box holder
Date	updateD	char(10)	Date that addresses were last updated on file via CDS.
Geo	Latitude	decimal(18,6)	The latitude in decimal degrees using the WGS84 datum for the address
	Longitude	decimal(18,6)	The longitude in decimal degrees using the WGS84 datum for the address

Code and Definitions

Column Name	Code	Definition
RBDI	R	Residential
	B	Business
City_rural	C	Identifies the address as City Style
	S	Simplified addressing (S) is an address method used for rural deliveries