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.
urbanization	text	No	Yes	An area, sector, or residential development within a geographic area. Usually only used in Puerto Rico.
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.
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.
predirectional	text	No	Yes	A geographic direction that precedes the street name such as West in West Lincoln Street.
postdirectional	text	No	Yes	A geographic direction that follows the street name such as South in Washington Road South.
street_suffix	text	No	Yes	A word that follows the name of the street describing its type (e.g. Street, Avenue, Road).
secondary_number	text	No	Yes	The number of the secondary line of the address, such as 2 in Apartment 2.
secondary_designator	text	No	Yes	Usually seen as address line two, the type of secondary address, such as unit, apartment, floor, etc.
extra_number	text	No	Yes	The number for any additional address designator after the secondary designator, such 2 in Floor 2
extra_designator	text	No	Yes	Any additional address designator after the secondary designator, such as apartment, floor, etc.
pmb_number	text	No	Yes	The Private Mailbox Number. The PMB is for when private companies offering mailbox rental services to individuals and businesses.
pmb_designator	text	No	Yes	The code PMB to indicate if it is a private mailbox number.
city	text	No	Yes	City name
state_code	text	No	Yes	Two-digit state code such as PA for Pennsylvania or TX for Texas.
country_code	text	No	Yes	Two-digit country code such as US for United States or UK for United Kingdom.
postal_code	text	No	Yes	Postal code, the 5 digit zip code in the United States.
plus4	text	No	Yes	The extra 4 digits after a zip code.
county	text	No	No	County name in an address.
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.
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.
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.
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
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.
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.