Geography Characteristics

Snowflake table name : CYBERSYN.GEOGRAPHY_CHARACTERISTICS

View data sources, attributes, and sample queries here.

Name	Description	Type	Example
GEO_ID	A unique identifier for a place (a nation, state, zip-code, etc.) joinable to the geography index table for adding geospatial information.	VARCHAR	statcanId/S051235390659
GEO_NAME	Full name of the place	VARCHAR	35260188
RELATIONSHIP_TYPE	Description of the provided characteristic. For example, 'coordinates_wkt' means that VALUE contains the GEO_ID's coordinates in WKT format, while 'coordinates_geojson' means that VALUE contains the GEO_ID's coordinates in GeoJSON format.	VARCHAR	coordinates_geojson
VALUE	Value of the characteristic specified in RELATIONSHIP_TYPE.	VARCHAR	{"coordinates":[[[-68.315692985,47.373685008],[-68.316266763,47....
RELATIONSHIP_START_DATE	The date from which a given characteristic is valid. For example, if the coordinates for ZIP code 12345 changed on 2023-04-01 (i.e., on 2023-04-01 the Census Bureau released shapefiles with updated coordinates for ZIP code 12345), then relationship_start_date of 2023-04-01 is assigned. However, currently, all the values in this column are NULL since it only contains most recent characteristics with no historical changes.	DATE	N/A
RELATIONSHIP_END_DATE	The date through which a given characteristic is valid. For example, if the coordinates for ZIP code 12345 changed on 2023-04-01 (i.e., on 2023-04-01 the Census Bureau released shapefiles with updated coordinates for ZIP code 12345), then relationship_end_date of 2023-03-31 is assigned to the previous coordinates for ZIP code 12345. However, currently, all the values in this column are NULL since it only contains most recent characteristics with no historical changes.	DATE	N/A