Geography Index
Snowflake table name : CYBERSYN.GEOGRAPHY_INDEX
Last updated
Snowflake table name : CYBERSYN.GEOGRAPHY_INDEX
Last updated
Copyright © 2024 Cybersyn
| Name | Description | Type | Example |
|---|---|---|---|
GEO_ID
A unique identifier for a place (a nation, state, zip-code, etc.)
VARCHAR
CoC/NY-600
GEO_NAME
Full name of the place
VARCHAR
New York City CoC
LEVEL
Geographic level or hierarchy (e.g., Country, State, County, City, Continent, CountrySubRegion, etc.)
VARCHAR
LocalAuthorityDistrict
ISO_NAME
Country name from International Organization for Standardization
VARCHAR
Aruba
ISO_ALPHA2
2 letter country code from International Organization for Standardization
VARCHAR
AW
ISO_ALPHA3
3 letter country code from International Organization for Standardization
VARCHAR
ABW
ISO_NUMERIC_CODE
Numeric code from International Organization for Standardization
VARCHAR
533
ISO_3166_2_CODE
Full ISO-3166 code
VARCHAR
ISO 3166-2:AW