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