Geography Characteristics
Snowflake table name : CYBERSYN.GEOGRAPHY_CHARACTERISTICS
Last updated
Snowflake table name : CYBERSYN.GEOGRAPHY_CHARACTERISTICS
Last updated
Copyright © 2024 Cybersyn
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