Geography Dimension

ABOUT
=====

The geography dimension can be used to lookup transactional data across administrative divisions and cities. It can be used to drill down from the country to the city level or from the city to country level.

It covers all major countries in the world. Administrative levels 1-5 are covered. The major towns and cities with a population > 500 are included.

USE CASES
=========

Drill down / roll up on location data

Order-wise administrative divisions of a country.
Administrative division hierarchies for a selected location.
All the Administrative division hierarchies for a selected country.
Population within different order of administrative divisions.
All important features of a country.
Alternate names of a geographical location.

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: https://sonra.io/2021/02/03/geography-dimension-documentation/

TABLES
=======

CORE TABLES
--------------------

V_GEONM_ADMIN_1
V_GEONM_ADMIN_2
V_GEONM_ADMIN_3
V_GEONM_ADMIN_4
V_GEONM_ADMIN_5
V_GEONM_ALT_NM
V_GEONM_CITY_500
V_GEONM_COUNTRY
V_GEONM_FEATURE

ATTRIBUTION
==========

Geographical data by Geonames
https://www.geonames.org/ is licensed under Creative Commons Attribution 4.0 License

搜集汇总

背景与挑战

背景概述

该数据集涵盖全球主要国家的1-5级行政区划及人口超500的城市信息，支持多级地理位置钻取分析，并包含地理特征和别名数据。数据源自Geonames，采用CC BY 4.0许可协议。