Geography Characteristics

Snowflake table name : CYBERSYN.GEOGRAPHY_CHARACTERISTICS

View data source documentation here.

NameDescriptionTypeExample

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

geoId/06113010204

GEO_NAME

Full name of the place

VARCHAR

Census Tract 102.04, Yolo County, California

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_wkt

VALUE

Value of the characteristic specified in RELATIONSHIP_TYPE.

VARCHAR

{"coordinates":[[[-74.143004595,45.459191618],[-74.142717679,45....

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

2023-01-01

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

2023-12-31

Last updated

Copyright © 2024 Cybersyn