Geography Relationships
Snowflake table name : CYBERSYN.GEOGRAPHY_RELATIONSHIPS
Last updated
Snowflake table name : CYBERSYN.GEOGRAPHY_RELATIONSHIPS
Last updated
Copyright © 2024 Cybersyn
Name | Description | Type | Example |
---|---|---|---|
GEO_NAME
Full name of the place
VARCHAR
Fort Lauderdale
GEO_ID
A unique identifier for a place joinable to the GEOGRAPHY_INDEX table
VARCHAR
geoId/4830464
LEVEL
Geographic level or hierarchy (e.g., Country, State, County, City, Continent, CountrySubRegion, etc.)
VARCHAR
CensusZipCodeTabulationArea
RELATED_GEO_NAME
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
Charlottesville
RELATED_GEO_ID
A unique identifier for the related place joinable to the GEOGRAPHY_INDEX table
VARCHAR
zip/90078
RELATED_LEVEL
Geographic level or hierarchy of the related place (e.g., Country, State, County, City, Continent, CountrySubRegion, etc.)
VARCHAR
City
RELATIONSHIP_TYPE
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
Overlaps