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 |