Geography Characteristics
Snowflake table name : CYBERSYN.GEOGRAPHY_CHARACTERISTICS
| Name | Description | Type | Example |
|---|---|---|---|
| A unique identifier for a place (a nation, state, zip-code, etc.) joinable to the geography index table for adding geospatial information. | VARCHAR |
|
| Full name of the place | VARCHAR |
|
| 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 |
|
| Value of the characteristic specified in RELATIONSHIP_TYPE. | VARCHAR |
|
| 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 |
|
| 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 |
|
Last updated