Bulk Validation Tool: US Address List Output Fields
||several varchar(50)||All fields from the corresponding input line.|
||varchar(0)||This field intentionally left blank. No, really, it's just blank.|
||int||Incrementing sequence number which refers to the input record number.|
||varchar(50)||Indicates whether the input address matched a valid USPS address.|
||varchar(50)||The name of the person or company at this address. This value is taken directly from the
Contains the first delivery line (usually the street address). This can
include any of the following:
||varchar(50)||The second delivery line (if needed); it is common for this field to remain empty, but it may contain a private mailbox number.|
||varchar(64)||The USPS-preferred city name for this particular address, or an acceptable alternate if provided by the user|
||char(2)||The two-letter state abbreviation|
||char(10)||The nine-digit ZIP Code|
||varchar(250)||Describes steps taken to verify and standardize the address and other information about it.|
||varchar(64)||The name of the county in which the address is located|
Residential Delivery Indicator (residential or commercial)
residential — The address is a residential address.
commercial — The address is a commercial address.
unknown — The RDI of the address is currently unknown.
||decimal(9,6)||The horizontal component used for geographic positioning; it is the angle between 0° (the equator) and ±90° (north or south) at the poles. It is the first value in an ordered pair of (latitude, longitude). A negative number denotes a location below the equator; a positive number is above the equator. Combining lat/long values enables you to pinpoint addresses on a map.|
||decimal(9,6)||The vertical component used for geographic positioning; it is the angle between 0° (the Prime Meridian) and ±180° (westward or eastward). It is the second number in an ordered pair of (latitude, longitude). A negative number indicates a location west of Greenwich, England; a positive number, east. Combining lat/long values enables you to pinpoint addresses on a map.|
Indicates the precision of the latitude and longitude values.
Unknown — Coordinates not known, possibly because address is invalid
None — Coordinates are not provided for this address. Military addresses such as APO, FPO, and DPO do not provide coordinates.
Zip5 — Accurate to a 5-digit ZIP Code level (least precise)
Zip6 — Accurate to a 6-digit ZIP Code level
Zip7 — Accurate to a 7-digit ZIP Code level
Zip8 — Accurate to an 8-digit ZIP Code level
Zip9 — Accurate to a 9-digit ZIP Code level (most precise with the basic subscription)
Parcel — Accurate to the centroid of a property parcel. Requires the US Rooftop Geocoding subscription.
Rooftop — Accurate to the rooftop of a structure for this address. Requires the US Rooftop Geocoding subscription.
Note: Concerning addresses for which the ZIP9 precision is not available, the ZIP# precision is interpolated based on neighboring addresses. Thus, ZIP7 is an average of all the lat/long coordinates of nearby ZIP Codes that share those first 7 digits.
Status of the Delivery Point Validation (DPV). This lets you know if the USPS delivers mail to the
Y — Confirmed; entire address is present in the USPS data. To be certain the address is actually deliverable, verify that the
(e.g., 1600 Amphitheatre Pkwy Mountain View, CA)
N — Not confirmed; address is not present in the USPS data.
S — Confirmed by ignoring secondary info; the main address is present in the USPS data, but the submitted secondary information (apartment, suite, etc.) was not recognized.
(e.g., 62 Ea Darden Dr Apt 298 Anniston, AL)
D — Confirmed but missing secondary info; the main address is present in the USPS data, but it is missing secondary information (apartment, suite, etc.).
(e.g., 122 Mast Rd Lee, NH)
[blank] — The address is not present in the USPS data.
Information related to the delivery point validation of this address. All these footnotes have a length of 2 characters, and there may be up to 14 footnotes.
AA — Street address, city, state, and ZIP are all valid.
(e.g., 2335 S State St Ste 300 Provo UT)
A1 — Address is invalid.
(e.g., 3214 N University Ave New York NY)
BB — Entire address is valid.
(e.g., 2335 S State St Ste 300 Provo UT)
CC — The submitted secondary information (apartment, suite, etc.) was not recognized.
(e.g., 2335 S State St Ste 500 Provo UT)
F1 — Military or diplomatic address
(e.g., Unit 2050 Box 4190 APO AP 96278)
G1 — General delivery address
(e.g., General Delivery Provo UT 84601)
M1 — Primary number (e.g., house number) is missing.
(e.g., N University Ave Provo UT)
M3 — Primary number (e.g., house number) is invalid.
(e.g., 16 N University Ave Provo UT)
N1 — Address is missing secondary information (apartment, suite, etc.).
(e.g., 2335 S State St Provo UT)
PB — PO Box street style address.
(e.g., 555 S B B King Blvd Unit 1 Memphis TN 38103)
P1 — PO, RR, or HC box number is missing.
(e.g., Dept 126 Denver CO 802910126)
P3 — PO, RR, or HC box number is invalid.
(e.g., PO BOX 60780 FAIRBANKS AK 99706)
RR — Confirmed address with private mailbox (PMB) info.
(e.g., 3214 N University Ave #409 Provo UT)
R1 — Confirmed address without private mailbox (PMB) info.
(e.g., 3214 N University Ave Provo UT)
R7 — Confirmed as a valid address that doesn't currently receive US Postal Service street delivery.
(e.g., 6D Cruz Bay St John VI 00830)
U1 — Address has a "unique" ZIP Code.
(e.g., 100 North Happy Street 12345)
Here are some common combinations:
Indicates which changes were made to the input address. Footnotes are delimited by a
||char(5)||The 5-digit county FIPS (Federal Information Processing Standards) code. It is a combination of a 2-digit state FIPS code and a 3-digit county code assigned by the NIST (National Institute of Standards and Technology).|
Indicates the type of record that was matched. Only given if a DPV match is made.
F — Firm; the finest level of match available for an address.
(e.g., Julie Julia 11300 Center Ave Gilroy CA 95020-9257)
G — General Delivery; for mail to be held at local post offices.
(e.g., General Delivery Provo UT 84601)
H — High-rise; address contains apartment or building sub-units.
(e.g., 1600 Pennsylvania Ave SE Washington DC 20003-3228)
P — Post Office box
(e.g., PO Box 4735 Tulsa OK 74159-0735)
R — Rural Route or Highway Contract; may have box number ranges.
(e.g., RR 2 Box 4560 Anasco PR 00610-9393)
S — Street; address contains a valid primary number range.
(e.g., 16990 Monterey Rd Lake Elsinore CA 92530-7529)
[blank] — No record type because address did not make a valid DPV match
Indicates the type of the ZIP Code for the address that was matched. Only given if a 5-digit match
Unique — The ZIP Code consists of a single delivery point, pertaining to a US Postal Service customer (like a large business or government agency) that routes all of its own mail internally.
Military — The ZIP Code pertains to military units and diplomatic organizations, often in foreign locations.
POBox — The ZIP Code is a PO Box ZIP Code and is assigned to a collection of Post Office Boxes.
Standard — The ZIP Code does not pertain to any of the above categories.
The postal carrier route for the address. Consists of a one-letter prefix followed by a three-digit route designator.
(e.g., C007, R123)
C — Carrier Route (commonly termed "City Route")
R — Rural Route
H — Highway Contract Route
B — Post Office Box Section
G — General Delivery Unit
Routes C770 through C779 pertain to PO Box Street Addresses.
||char(2)||The congressional district to which the address belongs. Output will be two digits from 01 - 53 or "AL." "AL" means that the entire state (or territory) is covered by a single congressional district. These include: Alaska, Delaware, Montana, North Dakota, South Dakota, Vermont, Wyoming, Washington DC, Virgin Islands, and other territories.|
Indicates whether the address is the "default" address for a building; for example, the main lobby.
Y — Yes
N — No
||varchar(4)||eLOT (Enhanced Line of Travel) 4-digit sequence number|
eLOT (Enhanced Line of Travel) product was developed to give mailers the ability to sort their
mailings by line of travel sequence.
A — Ascending
D — Descending
[blank] — Address was not submitted for eLOT.
Indicates the common name of the time zone associated with the address.
Alaska, Atlantic, Central, Eastern, Hawaii, Mountain, None, Pacific, Samoa, UTC+9, UTC+10, UTC+11, UTC+12
Indicates the number of hours the time zone is offset from Universal Time Coordinated (UTC), the
international time standard, also known as Greenwich Meridian Time (GMT).
-11, -10, -9, -8, -7, -6, -5, -4, 0, 9, 10, 11, 12
Indicates if the time zone "obeys," or, in other words, adjusts their clocks forward and back with
the seasons. This information is particularly useful to determine time in other time zones with
areas that may or may not use daylight saving time - for example, Arizona, Hawaii, and, of all
true — Time zone observes daylight saving time.
If dst is absent from the response, then time zone does not observe daylight saving time.
Indicates whether the address is associated with a Commercial Mail Receiving Agency (CMRA), also
known as a private mailbox (PMB) operator. A CMRA is a business through which USPS mail may be sent
or received, for example the UPS Store and Mailboxes Etc.
Y — Address is associated with a valid CMRA.
N — Address is not associated with a valid CMRA.
[blank] — Address was not submitted for CMRA verification.
Early warning system flag; a positive result indicates the street of the address is not yet ready
for mail delivery and that the address will soon be added to the master ZIP+4 file in the coming
weeks or months. This commonly occurs for new streets or streets undergoing a name change.
true — The address was flagged by EWS, preventing a ZIP+4 match.
[blank] — Address was not flagged by EWS.
Indicates whether there is an address match in the LACSLink database.
Y — LACS record match; a new address could be furnished because the input record matched a record in the master file.
S — LACS record - secondary number dropped; the record is a ZIP+4 street level or high-rise match. The input record matched a master file record, but the input address has a secondary number and the master file record did not.
N — No match; a new address could not be furnished; the input record could not be matched to a record in the master file.
F — False positive; a false positive record was detected.
[blank] — No LACSLink lookup attempted.
The reason for the LACSLink indication that was given (below)
A — Match: Address provided. LACSLink record match was found, and a converted address was provided.
00 — No Match. No converted address. No soup for you!
09 — Match: No new address. LACSLink matched an input address to an old address, which is a "high-rise default" address; no new address was provided.
14 — Match: No conversion. Found a LACSLink record, but couldn't convert the data to a deliverable address.
92 — Match: Dropped secondary number. LACSLink record was matched after dropping the secondary number from input.
[blank] — No LACSLink lookup attempted.
Indicates a match (or not) to the USPS SuiteLink data. SuiteLink attempts to provide secondary information such as "suite" or "apartment" whenever there is a match based on address and company name.
true — There was a SuiteLink match and the result is provided.
false — There was no SuiteLink match.
Indicates that a delivery point was active in the past, but is currently vacant (in most cases,
unoccupied over 90 days) and is not receiving deliveries. This status is often obtained when mail
receptacles aren't being emptied and are filling up, so mail is held at the post office for a
certain number of days before the delivery point is marked vacant.
Y — Address is vacant.
N — Address is not vacant.
[blank] — Address was not submitted for vacancy verification.
Indicates whether the address is active, or "in-service" according to the USPS. Examples: New
developments may have addresses but will be "inactive" until somebody moves in. Or, after Hurricane
Katrina, addresses in the affected area were marked as inactive for a time. Residents may also mark
their own mailboxes as inactive for privacy and other reasons.
Y — Address is active.
N — Address is inactive.
[blank] — Activity status is not known by the USPS.
||varchar(64)||The neighborhood, or city subdivision; used with Puerto Rican addresses.|
||varchar(30)||The house, PO Box, or building number|
||varchar(64)||The name of the street|
||char(16)||Directional information before a street name (N, SW, etc.)|
||char(16)||Directional information after a street name (N, SW, etc.)|
||char(16)||Abbreviated value describing the street (St, Ave, Blvd, etc.)|
||varchar(32)||Apartment or suite number, if any|
||varchar(16)||Describes location within a complex/building (Ste, Apt, etc.)|
Descriptive information about the location of a building within a campus
(e.g., E-5 in "5619 Loop 1604, Bldg E-5, Ste 101 San Antonio TX")
Description of the location type within a campus
(e.g., Bldg, Unit, Lot, etc.)
||varchar(16)||Private mailbox unit designator, assigned by a CMRA|
||varchar(16)||The private mailbox number, assigned by a CMRA|
||varchar(64)||The default city name for this 5-digit ZIP Code|
||char(5)||The 5-digit ZIP Code|
||varchar(4)||The 4-digit add-on code (more specific than 5-digit ZIP)|
||char(2)||The last two digits of the house/box number, unless an "H" record is matched, in which case this is the secondary unit number representing the delivery point information to form the delivery point barcode (DPBC).|
||char(1)||Correction character, or check digit, for the 11-digit barcode|
||varchar(50)||City, state, and ZIP Code combined|
||varchar(12)||12-digit POSTNET™ barcode; consists of 5-digit ZIP Code, 4-digit add-on code, 2-digit delivery point, and 1-digit check digit.|
This table describes possible values in the
(Example addresses may be changed at any time due to the nature of the data.)
|A#||Corrected ZIP Code||
The address was found to have a different 5-digit ZIP Code than the one submitted. The correct ZIP Code is shown in the
(e.g., 4800 Fairmount Ave Kansas City MO 64111)
|B#||Corrected city/state spelling||
The spelling of the city name and/or state abbreviation in the submitted address was found to be different than the standard spelling. The standard spellings are shown in the
(e.g., 34 Main St Roeblong NJ 08554)
The ZIP Code in the submitted address could not be found because neither a valid city and state, nor valid 5-digit ZIP Code was present. SmartyStreets recommends that the customer check the accuracy of the submitted address.
(e.g., 200 Camp Drive 25816)
|D#||No ZIP+4 assigned||
This address is not present in the USPS data. SmartyStreets recommends that the customer check the accuracy of the submitted address.
(e.g., 39 Main Street Roeblong NJ 08554)
|E#||Same ZIP for multiple||
Multiple records were returned, with the same 5-digit ZIP Code.
(e.g., 1 Rosedale Baltimore MD)
|F#||Address not found||
The address, exactly as submitted, could not be found in the city, state, or ZIP Code provided. Either the primary number is missing, the street is missing, or the street is too badly misspelled to understand.
(e.g., 2600 Rafe Lane Jackson MS 39201)
|G#||Used addressee data||
Information in the
(e.g., 97 Taylor St apt 3F Taylor Manchester NH)
|H#||Missing secondary number||
The address as submitted is missing a secondary number (apartment, suite, etc.). SmartyStreets recommends that the customer check the accuracy of the submitted address and add the missing secondary number to ensure the correct Delivery Point Barcode (DPBC).
(e.g., 109 Wimbledon Sq Chesapeake VA 23320)
|I#||Insufficient/ incorrect address data||
More than one ZIP+4 Code was found to satisfy the address as submitted. The submitted address did not contain sufficiently complete or correct data to determine a single ZIP+4 Code. SmartyStreets recommends that the customer check the accuracy and completeness of the submitted address. For example, a street may have a similar address at both the north and south ends of the street.
(e.g., 1 Rosedale Baltimore MD 21229)
The input contained two addresses. For example: 123 MAIN ST PO BOX 99.
(e.g., PO Box 38606 30th Street Train Station Philadelphia PA 19104)
|K#||Cardinal rule match||
Although the address as submitted is not valid, we were able to find a match by changing the cardinal direction (North, South, East, West). The cardinal direction we used to find a match is found in the components.
(e.g., 315 W Cesar Chavez St Austin TX)
|L#||Changed address component||
An address component (i.e., directional or suffix only) was added, changed, or deleted in order to achieve a match.
(e.g., 213 S QUANAH RUSSELLVILLE AR 72801)
|Flagged address for LACSLink||The input address matched a record that was LACS-indicated, that was submitted to LACSLink for processing. This does not mean that the address was converted; it only means that the address was submitted to LACSLink because the input address had the LACS indicator set.|
|M#||Corrected street spelling||
The spelling of the street name was changed in order to achieve a match.
(e.g., 3308 Fountainviuw Monsey NY)
The delivery address was standardized. For example, if STREET was in the delivery address, SmartyStreets will return ST as its standard spelling.
(e.g., 2438 Brown Avenue Knoxville TN 37917)
|O#||Multiple ZIP+4; lowest used||
More than one ZIP+4 Code was found to satisfy the address as submitted. The lowest ZIP+4 add-on may be used to break the tie between the records.
(e.g., RR 2 Box 132 Wolf Summit WV 26426)
|P#||Better address exists||
The delivery address is matchable, but it is known by another (preferred) name. For example, in New York, NY, AVENUE OF THE AMERICAS is also known as 6TH AVE. An inquiry using a delivery address of 39 6th Avenue would be flagged with Footnote P.
(e.g., 131 Stone Farm Lebanon NH 03766)
|Q#||Unique ZIP match||
The address has a "unique" ZIP Code
(e.g., 645 Swick Hill Street Charlotte NC 28263)
|R#||No match; EWS: Match soon||The delivery address is not yet matchable, but the US Postal Service Early Warning System file indicates that a match will be available soon.|
|S#||Unrecognized secondary address||
The secondary information (apartment, suite, etc.) was not recognized as part of the USPS data.
(e.g., 1409 Hueytown Rd Apt 1781 Bessemer AL 35023)
|T#||Multiple response due to magnet street syndrome||
The search resulted in a single response; however, the record matched was flagged as having magnet street syndrome, and the input street name components (pre-directional, primary street name, post-directional, and suffix) did not exactly match those of the record. A "magnet street" is one having a primary street name that is also a suffix or directional word, having either a post-directional or a suffix (i.e., 2220 PARK MEMPHIS TN logically matches to a ZIP+4 record 2200-2258 PARK AVE MEMPHIS TN 38114-6610), but the input address lacks the suffix "AVE" which is present on the ZIP+4 record. The primary street name "PARK" is a suffix word. The record has either a suffix or a post-directional present. Therefore, in accordance with CASS requirements, a ZIP+4 Code must not be returned. The multiple response return code is given since a "no match" would prevent the best candidate.
(e.g., 84 Green St Northampton MA)
|U#||Unofficial city name||
The city name in the submitted address is an alternate city name that is not accepted by the US Postal Service. The preferred city name is output in the
(e.g., 9894 Bissonnet St #723 Sharpstown TX 77036)
The city and state in the submitted address could not be verified as corresponding to the given 5-digit ZIP Code. This comment does not necessarily denote an error; however, SmartyStreets recommends that the customer check the accuracy of the city and state in the submitted address.
(e.g., 107 Kerwood St Kildeer IL 60067)
|W#||Invalid delivery address||The USPS does not provide street delivery service for this ZIP Code. The USPS requires the use of a PO Box, General Delivery, or Postmaster for delivery within this ZIP Code.|
|X#||Unique ZIP Code||
The address has a "unique" ZIP Code
(e.g., 609 Pheasant Ridge Road Wayne PA 19088)
The address has a military or diplomatic ZIP Code.
(e.g., PSC 10 Box 1324 APO AE 09142)
|Z#||Matched with ZIPMOVE||
The ZIPMOVE product shows which ZIP+4 records have moved from one ZIP Code to another. If an input address matches a ZIP+4 record which the ZIPMOVE product indicates has moved, the search is performed again in the new ZIP Code.
(e.g., 10300 Fm 920, Weatherford TX)