Geography Relationships

Snowflake table name : CYBERSYN.GEOGRAPHY_RELATIONSHIPS

View data sources, attributes, and sample queries here.

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