Data dimensions are prepared projects that contain specific data (e.g. administrative units or demography). They can be imported into other projects and combined with their data.
...
Administrative units hierarchy of the Czech Republic.
- Project ID: q1zdp9d0ao78rdv5
- Link: https://secure.clevermaps.io/ui/#/q1zdp9d0ao78rdv5/project
Every hierarchy unit has its own table:
zsj_d_dwh - Neighborhoods (Základní sídelní jednotky)
cast_obec_dwh - Aministrative districts (Části obcí)
obec_momc_dwh - Municipality and City districts (Obce a městské části)
obec_dwh - Municipalities (Obce)
orp_dwh - Municipalities with extended competences (Obce s rozšířenou působností)
okres_dwh - Districts (Okresy)
kraj_dwh - Counties (Kraje)
Data model:
can-dim-adm-units-sk
...
Administrative units hierarchy of the Slovak Republic.
- Project ID: h3aytnzloh7tzpko
- Link: https://secure.clevermaps.io/ui/#/h3aytnzloh7tzpko/project
Every hierarchy unit has its own table:
zsj_dwh - Neighborhood (Základné sídelné jednotky)
zuj_dwh - Municipalities (Základné územné jednotky)
okres_dwh - Districts (Okresy)
kraj_dwh - Counties (Kraje)
Data model:
can-dim-dates
Dates dimension
Dimension contains all dates from 2010-01-01 to 2025-12-31.
- Project ID: tbagvahj2yvva9cx
- Link: https://secure.clevermaps.io/ui/#/tbagvahj2yvva9cx/project
- Dates are divided to Days of week, Weeks, Months, Quarters and Years.
- Project has no views.
Data model:
Import guide
There are few things to note when importing a can-dim-dates dimension into your project:
...
Note |
---|
Please note that when you have 2 distinct fact tables containing 2 properties you would like to filter using can-dim-dates (e.g. order date & shop opening date), you have to import the dimension twice. Due to the nature of
|
can-dim-demography-cz-en
Demography of the Czech Republic
- Basic demographic attributes of Czech Republic - citizens, households, houses, flats.
- Project ID: wxgt3a0p3jlnihmtcn0fv61t751c6elt
- Link: https://secure.clevermaps.io/ui/#/wxgt3a0p3jlnihmtcn0fv61t751c6elt/project
- Demography project contains own Demography tables and imported tables from Administrative units of the Czech Republic
- Demography project is divided into two language branches:
- Czech - "Demografie ČR"
- English - "Demography of Czech republic"
- Every branch has 4 indicators.
- Residents and age categories 0-14, 15-64, 65 +
- Residents and age categories - step by 5 years: 0-4, 5-9, 10-14, 15-19, 20-24, 25-29,... 85+
- Residents and age categories 0-14, 15-24, 25-49, 50-74, 75+
- Households
- Education with educational structure of citizens
- Each indicator has its own table.
- Data model:
can-dim-demography-sk
...
- Basic demographic attributes of the Slovak Republic - citizens, households, houses, flats.
- Project ID: vommuqm52187ysyb
- Link: https://secure.clevermaps.io/ui/#/vommuqm52187ysyb/project
- Demography project contains own Demography tables and imported tables from Administrative units of Slovakia
- Demography project contains 6 indicators and indicator drills:
- Residents and categories by age
- Residents and categories by sex
- Economically active population and categories by sector
- Households
- Houses
- Flats and categories by house type
- Data of those 6 indicators comes from 5 tables (you can see in data model)
- Data model:
can-dim-grid-cz
...
Project divides the area of Czech Republic to polygons or hexapolygons.
- Project ID: k51ytmasn2u6hpyt
- Link: https://secure.clevermaps.io/ui/#/k51ytmasn2u6hpyt/project
- There are 4 resolution types of grid by size.
Data model: