|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)||Will usually contain a firm name; intended recipient at an address|
|varchar(50)||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|
|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 the address is in|
|varchar(12)||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.|
|varchar(18)||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.
State — Reserved for future use
SolutionArea — Reserved for future use
City — Reserved for future use
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 but NOT rooftop level)
Structure — Reserved for future use
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.
|varchar(1)||Status of the Delivery Point Validation (DPV). This lets you know if the USPS delivers mail to the address.|
Y — Confirmed; entire address was DPV confirmed deliverable.
(e.g., 1600 Amphitheatre Pkwy Mountain View, CA)
N — Not Confirmed; address could not be DPV confirmed as deliverable.
S — Confirmed By Dropping Secondary; address was DPV confirmed by dropping some or all of the secondary info (apartment, suite, etc.).
(e.g., 62 Ea Darden Dr Apt 298 Anniston, AL)
D — Confirmed - Missing Secondary Info; the address was DPV confirmed, but it is missing secondary information (apartment, suite, etc.).
(e.g., 122 Mast Rd Lee, NH)
[blank] — The address was not submitted for DPV. This is usually because the address does not have a ZIP Code and a +4 add-on code, or the address has already been determined to be not deliverable.
|varchar(32)||Indicates why the address was given its DPV value and potentially the type of ZIP Code that was matched. All these footnotes have a length of 2 characters, and there may be up to 14 footnotes.|
AA — City/state/ZIP + street are all valid.
(e.g., 2335 S State St Ste 300 Provo UT)
A1 — ZIP+4 not matched; address is invalid. (City/state/ZIP + street don't match.)
(e.g., 3214 N University Ave New York NY)
BB — ZIP+4 matched; confirmed entire address; address is valid.
(e.g., 2335 S State St Ste 300 Provo UT)
CC — Confirmed address by dropping secondary (apartment, suite, etc.) information.
(e.g., 2335 S State St Ste 500 Provo UT)
F1 — Matched to military or diplomatic address.
(e.g., Unit 2050 Box 4190 APO AP 96278)
G1 — Matched to 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 — Confirmed with missing secondary information; address is valid but it also needs a secondary number (apartment, suite, etc.).
(e.g., 2335 S State St Provo UT)
PB — Confirmed as a 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 — Matched a unique ZIP Code.
(e.g., 100 North Happy Street 12345)
Here are some common combinations:
|varchar(24)||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).|
|char(1)||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
G — General Delivery; for mail to be held at local post offices
H — High-rise; address contains apartment or building sub-units.
P — Post Office Box; address is a PO Box record type.
R — Rural Route or Highway Contract; address may have box number ranges.
S — Street; address contains a valid primary number range.
[blank] — No record type because address did not make a valid DPV match.
|varchar(32)||Indicates the type of ZIP Code for the address that was matched. Only given if a 5-digit match was made.|
Unique — The ZIP Code is assigned to an address that receives a high volume of mail. All delivery lines are routed internally by the assigned organization.
Military — The ZIP Code pertains to military units, often deployed to foreign locations.
POBox — The ZIP Code is assigned to a collection of Post Office Boxes.
Standard — The ZIP Code does not pertain to any of the above categories.
|char(4)||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
|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.|
|char(1)||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|
|varchar(4)||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.
|varchar(48)||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
|decimal(4,2)||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
|char(5)||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 places, Indiana.|
true — Time zone observes daylight saving time.
If dst is absent from the response, then time zone does not observe daylight saving time.
|varchar(1)||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.
|char(5)||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.
|varchar(1)||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.
|varchar(2)||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.
|varchar(5)||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 Firm Name (Company) input.|
true — There was a SuiteLink match and the result is provided.
false — There was no SuiteLink match.
|varchar(1)||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.
|varchar(1)||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)||Primarily for Puerto Rican addresses; a very important component which contains area, sector, or development within a geographic area; should be included after the name of the recipient.|
|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.)|
|varchar(32)||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")
|varchar(16)||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. This field will not be present if the default city name is equal to the value of the city name field.|
|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
footnotes field from 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 given in the submitted list. The correct ZIP Code is shown in the ZIP Code field.|
(e.g., 4800 Fairmount Ave Kansas City MO 64111)
|B#||Fixed 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 spelling of the city name and state abbreviation is shown in the City and State fields.|
(e.g., 34 Main St Roeblong NJ 08554)
|C#||Invalid city/state/ZIP||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 is a record listed by the United States Postal Service as a non-deliverable location. 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, but each shares 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. Many factors contribute to this; either the primary number is missing, the street is missing, or the street is too horribly misspelled to understand.|
(e.g., 2600 Rafe Lane Jackson MS 39201)
|G#||Used firm data||Information in the firm line was determined to be a part of the address. It was moved out of the firm line and incorporated into the address line.|
(e.g., 97 Taylor St apt 3F Taylor Manchester NH)
|H#||Missing secondary number||ZIP+4 information indicates that this address is a building. The address as submitted does not contain a secondary (apartment, suite, etc.) number. 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)
|J#||Dual address||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#||Fixed street spelling||The spelling of the street name was changed in order to achieve a match.|
(e.g., 3308 Fountainviuw Monsey NY)
|N#||Fixed abbreviations||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||Match to an address with 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 Early Warning System file indicates that an exact match will be available soon.|
(e.g., 1644 CR 1800E PMB 17420 Arthur IL 61911)
|S#||Bad secondary address||The secondary information (apartment, suite, etc.) does not match that on the national ZIP+4 file. The secondary information, although present on the input address, was not valid in the range found on the national ZIP+4 file.|
(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 post office name||The city or post office name in the submitted address is not recognized by the United States Postal Service as an official last line name (preferred city name), and is not acceptable as an alternate name. The preferred city name is included in the City field.|
(e.g., 9894 Bissonnet St #723 Sharpstown TX 77036)
|V#||Unverifiable city / state||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 input address record contains a delivery address other than a PO Box, General Delivery, or Postmaster 5-digit ZIP Code that is identified as a "small town default." 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||Default match inside a unique ZIP Code|
(e.g., 609 Pheasant Ridge Road Wayne PA 19088)
|Y#||Military match||Match made to a record with 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)