Global City-Country dimension

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

搜集汇总

背景与挑战

背景概述

该数据集提供全球大洲、国家和城市的三级层次结构信息，涵盖所有地理实体，用于分析位置关系、获取人口和时区等附加数据，并支持从全球到城市的多层级分析，数据来源于Geonames。