Geography Relationships
Snowflake table name : CYBERSYN.GEOGRAPHY_RELATIONSHIPS
| Name | Description | Type | Example |
|---|---|---|---|
| Full name of the place | VARCHAR |
|
| A unique identifier for a place joinable to the GEOGRAPHY_INDEX table | VARCHAR |
|
| Geographic level or hierarchy (e.g., Country, State, County, City, Continent, CountrySubRegion, etc.) | VARCHAR |
|
| Name of the place related to GEO_NAME. This is a place that overlaps or is contained within the primary geo (e.g., city within a state) | VARCHAR |
|
| A unique identifier for the related place joinable to the GEOGRAPHY_INDEX table | VARCHAR |
|
| Geographic level or hierarchy of the related place (e.g., Country, State, County, City, Continent, CountrySubRegion, etc.) | VARCHAR |
|
| Relationship between the two places. Contains means the RELATED_GEO_ID is fully contained within the GEO_ID (e.g., relationship of state to a city) while Overlaps indicates the GEO_ID is a subpart of the RELATED_GEO_ID (e.g., relationship of city to a state) | VARCHAR |
|
Last updated