address_canonical
Canonical address information retrieved from smarty.com API. See address_seen for field details.
Primary Key:Checks:address_canonical_check-(((primary_number IS NOT NULL) AND (primary_number <> ''::text)) OR ((street_name IS NOT NULL) AND (street_name <> ''::text)) OR ((street_suffix IS NOT NULL) AND (street_suffix <> ''::text)))
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 | - |
urbanization | text | No | Yes | - |
primary_number | text | No | Yes | - |
street_name | text | No | Yes | - |
predirectional | text | No | Yes | - |
postdirectional | text | No | Yes | - |
street_suffix | text | No | Yes | - |
secondary_number | text | No | Yes | - |
secondary_designator | text | No | Yes | - |
extra_number | text | No | Yes | - |
extra_designator | text | No | Yes | - |
pmb_number | text | No | Yes | - |
pmb_designator | text | No | Yes | - |
city | text | No | Yes | - |
state_code | text | No | Yes | - |
country_code | text | No | Yes | - |
postal_code | text | No | Yes | - |
plus4 | text | No | Yes | - |
county | text | No | No | - |
county_fips | text | No | No | - |
latitude | numeric | No | No | - |
longitude | numeric | No | No | - |
geo_precision | geo_precision_type | No | No | - |
congressional_district | text | No | No | - |
residential_delivery_indicator | residential_delivery_indicator_type | No | No | - |