address_canonical

Canonical address information retrieved from smarty.com API. See address_seen for field details. (https://www.smarty.com/products/us-address-verification)

Primary Key:

• canonical_address_id

Checks:

• address_canonical_check - ((primary_number <> ''::text) OR (street_name <> ''::text) OR (street_suffix <> ''::text))

Indexes:

• address_canonical_urbanization_primary_number_street_name_p_idx (Unique) - urbanization, primary_number, street_name, predirectional, postdirectional, street_suffix, secondary_number, secondary_designator, extra_number, extra_designator, pmb_number, pmb_designator, city, state_code, country_code, postal_code, plus4

Column	Data Type	Nullable	Indexed	Description
canonical_address_id	bigint	No	Yes	Snowflake ID for the canonical address. Generated through expression:
urbanization	text	No	Yes	An area, sector, or residential development within a geographic area. Usually only used in Puerto Rico. Generated through expression:
primary_number	text	No	Yes	A house, rural route, contract box, or Post Office box number. The numeric or alphanumeric component of an address preceding the street name. Generated through expression:
street_name	text	No	Yes	The name of a street. The Street Name contains only the street name and does not include directionals (EAST, WEST, etc.) or suffixes (ST, DR, BLVD, etc.). This element may also contain literals, such as PO BOX, GENERAL DELIVERY, USS, PSC, or UNIT. Generated through expression:
predirectional	text	No	Yes	A geographic direction that precedes the street name such as West in West Lincoln Street. Generated through expression:
postdirectional	text	No	Yes	A geographic direction that follows the street name such as South in Washington Road South. Generated through expression:
street_suffix	text	No	Yes	A word that follows the name of the street describing its type (e.g. Street, Avenue, Road). Generated through expression:
secondary_number	text	No	Yes	The number of the secondary line of the address, such as 2 in Apartment 2. Generated through expression:
secondary_designator	text	No	Yes	Usually seen as address line two, the type of secondary address, such as unit, apartment, floor, etc. Generated through expression:
extra_number	text	No	Yes	The number for any additional address designator after the secondary designator, such 2 in Floor 2 Generated through expression:
extra_designator	text	No	Yes	Any additional address designator after the secondary designator, such as apartment, floor, etc. Generated through expression:
pmb_number	text	No	Yes	The Private Mailbox Number. The PMB is for when private companies offering mailbox rental services to individuals and businesses. Generated through expression:
pmb_designator	text	No	Yes	The code PMB to indicate if it is a private mailbox number. Generated through expression:
city	text	No	Yes	City name Generated through expression:
state_code	text	No	Yes	Two-digit state code such as PA for Pennsylvania or TX for Texas. Generated through expression:
country_code	text	No	Yes	Two-digit country code such as US for United States or UK for United Kingdom. Generated through expression:
postal_code	text	No	Yes	Postal code, the 5 digit zip code in the United States. Generated through expression:
plus4	text	No	Yes	The extra 4 digits after a zip code. Generated through expression:
county	text	No	No	County name in an address. Generated through expression:
county_fips	text	No	No	County FIPS Codes are unique 5-digit codes that represent specific US counties. The first two digits represent the county's state and the last three digits represent the county. Generated through expression:
latitude	numeric	No	No	Latitude is a geographic coordinate that specifies the north-south position of a point on the Earth's surface. It is one of the two coordinates (along with longitude) used to pinpoint an exact location. Generated through expression:
longitude	numeric	No	No	Longitude is a geographic coordinate that specifies the east-west position of a point on the Earth's surface. It is one of the two primary coordinates (along with latitude) used to pinpoint an exact location. Generated through expression:
geo_precision	geo_precision_type	No	No	Geo precision is the descrption of how specific the latitude and longitude are in relationship to the address. For example: Zip9, Parcel, etc. See enum.geo_precision_type Generated through expression:
congressional_district	text	No	No	Congressional district. 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. Generated through expression:
residential_delivery_indicator	residential_delivery_indicator_type	No	No	Indicator of Whether an address is classified as residential or business in the USPS. Yes for business, no for residential. Generated through expression: