Sonra: Geography Dimension
This dataset covers all countries and contains order-wise administrative division data, city-wise data etc.
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.
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.
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/
Geographical data by Geonames
https://www.geonames.org/ is licensed under Creative Commons Attribution 4.0 License
About the Provider:
Sonra offers products and services in data management and data analytics.
Flexter is our flagship product. It automates the conversion of industry data standards, XML, JSON to a relational model on Snowflake, relational databases, and big data formats
Sonra provides Snowflake various professional services, e.g. migration services, quickstarts.
Sonra provides data advisory services, e.g. data architecture and strategy.
Get access to Sonra: Geography Dimension Dataset in Snowflake
Already a Snowflake customer?
Access this dataset directly from your Snowflake account