Global City-Country dimension
收藏Snowflake2023-08-18 更新2024-05-01 收录
下载链接：
https://app.snowflake.com/marketplace/listing/GZSVZSYYPBR
下载链接
链接失效反馈官方服务：
资源简介：
ABOUT
=====
Global list of continents, countries, and cities
Dimension hierarchy: Continent > Country > City (city, town, settlement)
All the planet's countries, cities, towns and settlements are included.
USE CASES
=========
Understand relationships, such as cities within countries within continents
Gain additional information about a location, such as population, currency, language, or timezone.
Allows for multi-level analysis, from a global or continental view down to individual countries and cities or towns
DOCUMENTATION
===============
We have put together a comprehensive documentation which includes a description of all of the tables and columns in the data set,and sample queries,
You can view the documentation here:
TABLES
=======
CORE TABLES
--------------------
V_CITY
V_COUNTRY
ATTRIBUTION
==========
Geographical data by Geonames
https://www.geonames.org/ is licensed under Creative Commons Attribution 4.0 License
提供机构：
Sonra
创建时间：
2023-08-18
