US Addresses
Snowflake table name : CYBERSYN.US_ADDRESSES
Name | Description | Type | Example |
---|---|---|---|
| A unique identifier of an address based on street address that is joinable to the point_of_interest_addresses_relationships table. | VARCHAR |
|
| A unique identifier for a zip code joinable to the geography_index/relationships tables | VARCHAR |
|
| A unique identifier for a city joinable to the geography_index/relationships tables | VARCHAR |
|
| A unique identifier for a state, Washington, D.C. or Puerto Rico joinable to the geography_index/relationships tables | VARCHAR |
|
| A unique identifier for a country joinable to the geography_index/relationships tables | VARCHAR |
|
| longitude coordinate in degrees | FLOAT |
|
| latitude coordinate in degrees | FLOAT |
|
| number of the address identifying location on a street | VARCHAR |
|
| a directional modifier preceding the street name, such as N or SW | VARCHAR |
|
| name of the street | VARCHAR |
|
| string type of the street, such as ROAD | VARCHAR |
|
| a directional modifier following the street name, such as S or NE | VARCHAR |
|
| number or label for a unit used to distinguish multiple tenants at a single address | VARCHAR |
|
| name of the city | VARCHAR |
|
| name of the state | VARCHAR |
|
| 5-digit code identifying the location of an address | VARCHAR |
|
Last updated