Geography Dimension

Share on facebook
Share on twitter
Share on linkedin

Snowflake Cost Saving

We Automate SnowflakeDB Data Cloud Cost Saving. Sign Our Free 7 Days No Risk Trail Now

Data Share Description:

Geography Dimension

Data Share Frequency: Monthly
Data Share Category: Local
Data Share Type: Personalized
Data Share Date Added: March 1, 2021
Data Share Status: ACTIVE
Data Share Email Contact: datamarket@sonra.io
Data Share Usage Example Q1: Fetch the first order administrative divisions of a country SELECT ADMIN1_CD, NAME, LATITUDE, LONGITUDE, POPULATION, DEM FROM V_GEONM_ADMIN_1 WHERE COUNTRY_CD = ‘IE’ ;
Data Share Usage Example SQL1 Last Tested: January 1, 1970

Data Share Overview:

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

Join The Club

Every week, we'll be sending you curated materials handpicked by professionals. Plus, you'll be the first to know about our latest data!