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.
You can find any of the projects on the following link, just replace the project ID at the end of the link with a real project ID from the table below: https://secure.clevermaps.io/#/projectList/project/{project-id}
In case you need access to any of the projects, don't hesitate to contact the maintainer of the project or our sales team.
List of data dimensions projects:
Project title | Project ID | Project name | Category | Coverage | Maintainer | Maintainer Email |
|---|---|---|---|---|---|---|
Address points in the Czech Republic | d3rf25iv95lt26k4 | can-dim-address-points-cz | Administrative Units | Czech Republic | František Pavlíček | frantisek.pavlicek@clevermaps.io |
Administrative divisions of the United States | i3p181knkde0s6we | can-dim-adm-units-us | Administrative Units | USA | Jan Kantor | jan.kantor@clevermaps.io |
Administrative units of Australia | r384fe5akm5g25h5 | can-dim-adm-units-aus | Administrative Units | Australia | Kateřina Tomášková | katerina.tomaskova@clevermaps.io |
Administrative units of Austria | t5ocpt6krb5jbh0h | can-dim-adm-units-aut | Administrative Units | Austria | Kateřina Tomášková | katerina.tomaskova@clevermaps.io |
Administrative units of Belgium | g4uevm4fi7jh99fa | can-dim-adm-units-bel | Administrative Units | Belgium | František Pavlíček | frantisek.pavlicek@clevermaps.io |
Administrative units of Bulgaria | hnekbl680e2ev440 | can-dim-adm-units-bg | Administrative Units | Bulgaria | Karel Psota | karel.psota@clevermaps.io |
Administrative units of Croatia | se8e97n9t458df7j | can-dim-adm-units-hr | Administrative Units | Croatia | Kateřina Tomášková | katerina.tomaskova@clevermaps.io |
Administrative units of European countries | je1vf8nle83abhqo | can-dim-adm-units-nuts-eu | Administrative Units | Europe | Karel Psota | karel.psota@clevermaps.io |
Administrative units of France | add4g4uklt5q87sn | can-dim-adm-units-nuts-fr | Administrative Units | France | Karel Psota | karel.psota@clevermaps.io |
Administrative units of Germany | gn3523n3rjif0sa5 | can-dim-adm-units-de | Administrative Units | Germany | Kateřina Tomášková | katerina.tomaskova@clevermaps.io |
Administrative units of Hungary | iu6ob8j5g5hbmbag | can-dim-adm-units-hu | Administrative Units | Hungary | Karel Psota | karel.psota@clevermaps.io |
Administrative Units of Italy | n6g1k0f73f68v7at | can-dim-adm-units-ita | Administrative Units | Italy | František Pavlíček | frantisek.pavlicek@clevermaps.io |
Administrative units of Lebanon | tl13dkotaejj3efg | can-dim-adm-units-lbn | Administrative Units | Lebanon | František Pavlíček | frantisek.pavlicek@clevermaps.io |
Administrative units of Moldova | ee8ep1tpssjme35j | can-dim-adm-units-md | Administrative Units | Moldova | František Pavlíček | frantisek.pavlicek@clevermaps.io |
Administrative units of Poland | h1o0u4v8tv4bp94v | can-dim-adm-units-pl | Administrative Units | Poland | Kateřina Tomášková | katerina.tomaskova@clevermaps.io |
Administrative units of Romania | nt1kcnm13ecp17bj | can-dim-adm-units-ro | Administrative Units | Romania | František Pavlíček | frantisek.pavlicek@clevermaps.io |
Administrative units of Singapore | luchuiaml9aboe8p | can-dim-adm-units-sg | Administrative Units | Singapore | Jan Kantor | jan.kantor@clevermaps.io |
Administrative units of Slovakia | h3aytnzloh7tzpko | can-dim-adm-units-sk | Administrative Units | Slovakia | Jan Kantor | jan.kantor@clevermaps.io |
Administrative units of Spain | t3j88apc3iht7tah | can-dim-adm-units-esp | Administrative Units | Spain | František Pavlíček | frantisek.pavlicek@clevermaps.io |
Administrative units of Switzerland | jpgfurb89ang99du | can-dim-adm-units-sui | Administrative Units | Switzerland | František Pavlíček | frantisek.pavlicek@clevermaps.io |
Administrative units of the Czech republic | q1zdp9d0ao78rdv5 | can-dim-adm-units-cz-en | Administrative Units | Czech Republic | Jan Kantor | jan.kantor@clevermaps.io |
Administrative units of UK | vs7ksq4dl9boecbc | can-dim-adm-units-nuts-uk | Administrative Units | United Kingdom | Petr Suk | petr.suk@clevermaps.io |
Administrativní jednotky České republiky | vyhs2oc86viyipe7 | can-dim-adm-units-cz-cz | Administrative Units | Czech Republic | Jan Kantor | jan.kantor@clevermaps.io |
Completed apartments and houses and population in the Czech Republic | hvfg86jk8c74e8jl | Can-dim-cz-demography-level-ruian-from-zsj | Demography | Czech Republic | Kateřina Tomášková | katerina.tomaskova@clevermaps.io |
Completed Apartments and houses in the Czech Republic | lq14mmv3ks8o21m0 | can-dim-cz-dokoncene-byty-v-obcich | Buildings | Czech Republic | Kateřina Tomášková | katerina.tomaskova@clevermaps.io |
Construction objects in the Czech Republic | ccp8jmoxqwnac03a | can-dim-rn-so | Geotypes/Consumer Segments | Czech Republic | Jan Kantor | jan.kantor@clevermaps.io |
Countries of the World | lpvlhtou6rtm0nf8 | can-dim-adm-units-world | Administrative Units | World | Jan Kantor | jan.kantor@clevermaps.io |
Countries of the World | qn6k0164aofh7jgm | can-dim-adm-units-world2 | Administrative Units | World | Jan Kantor | jan.kantor@clevermaps.io |
Cycling paths in the Czech Republic | q93dr01ahd6trc1o | can-dim-cz-cyklostezky | Car Mobility | Czech Republic | František Pavlíček | frantisek.pavlicek@clevermaps.io |
Demografie České republiky | wxgt3a0p3jlnihmt | can-dim-demography-cz-cz | Demography | Czech Republic | František Pavlíček | frantisek.pavlicek@clevermaps.io |
Demography of Australia | sbfmifanpb9a1k34 | can-dim-demography-aus | Demography | Australia | Kateřina Tomášková | katerina.tomaskova@clevermaps.io |
Demography of Austria | v5riq7p8ik5nm6pj | can-dim-demography-aut | Demography | Austria | Kateřina Tomášková | katerina.tomaskova@clevermaps.io |
Demography of Austria - Worldpop | krsc1odbss0iv9t3 | Can-dim-aut-worldpop | Demography | Austria | František Pavlíček | frantisek.pavlicek@clevermaps.io |
Demography of Benelux | dmabaj9oafo57nd7 | can-dim-demography-benelux | Demography | Belgium, Netherlands | František Pavlíček | frantisek.pavlicek@clevermaps.io |
Demography of Bulgaria | oh5fmj1e4rqoufmm | can-dim-demography-bg | Demography | Bulgaria | Karel Psota | karel.psota@clevermaps.io |
Demography of Croatia | ta2vj762c09k4n9t | can-dim-demography-hr | Demography | Croatia | Kateřina Tomášková | katerina.tomaskova@clevermaps.io |
Demography of Czech Republic | cn0fv61t751c6elt | can-dim-demography-cz-en | Demography | Czech Republic | František Pavlíček | frantisek.pavlicek@clevermaps.io |
Demography of Czech Republic 2021 | u94f20uqq418f2bg | can-dim-demography-cz-2021 | Demography | Czech Republic | Jan Kantor | jan.kantor@clevermaps.io |
Demography of Germany | gg4gcoma0el9mtis | can-dim-demography-de | Demography | Germany | Kateřina Tomášková | katerina.tomaskova@clevermaps.io |
Demography of Germany | e0gb2ptsfqmjchnd | can-dim-grid-de-demo-byty-kupni-sila-neverejna-dimenze | Demography | Germany | Kateřina Tomášková | katerina.tomaskova@clevermaps.io |
Demography of Hungary | sgafhk7cii0lr3nj | can-dim-demography-hu | Demography | Hungary | Jan Kantor | jan.kantor@clevermaps.io |
Demography of Italy | a26adumkbc35sk9m | can-dim-demography-ita | Demography | Italy | František Pavlíček | frantisek.pavlicek@clevermaps.io |
Demography of Italy - Worldpop | r4g5g924h2n76e0h | can-dim-worldpop-ita | Demography | Italy | František Pavlíček | frantisek.pavlicek@clevermaps.io |
Demography of Poland | jt2o7nco0mub2dr2 | can-dim-demography-pl | Demography | Poland | Kateřina Tomášková | katerina.tomaskova@clevermaps.io |
Demography of Romania | kk669eq96hjg5l46 | can-dim-demography-ro | Demography | Romania | Jan Kantor | jan.kantor@clevermaps.io |
Demography of Serbia | d5s8q14jseol47kt | can-dim-demography-srb | Demography | Serbia | Jan Kantor | jan.kantor@clevermaps.io |
Demography of Singapore | nn94s9eprcm7e4v6 | can-dim-demography-sg | Demography | Singapore | Jan Kantor | jan.kantor@clevermaps.io |
Demography of Slovakia | vommuqm52187ysyb | can-dim-demography-sk | Demography | Slovakia | Jan Kantor | jan.kantor@clevermaps.io |
Demography of Texas | nc0rtvq6jpr2fi2q | can-dim-demography-us-texas | Demography | USA | Jan Kantor | jan.kantor@clevermaps.io |
Demography of the United States of America | ujq69htpc9na6l0o | can-dim-demography-us | Demography | USA | Jan Kantor | jan.kantor@clevermaps.io |
Density of population in the Czech Republic | rbce0b17tsr0a219 | can-dim-density | Demography | Czech Republic | František Pavlíček | frantisek.pavlicek@clevermaps.io |
Departures/Arrivals in Austria | sf25uttv35dgtlik | can-dim-commuting-at | Car Mobility | Austria | Jan Kantor | jan.kantor@clevermaps.io |
Departures/Arrivals in the Czech Republic | a16v1erm1bmbo1bb | can-dim-vyjizdka-dojizdka | Car Mobility | Czech Republic | Jan Kantor | jan.kantor@clevermaps.io |
Dimension of dates | tbagvahj2yvva9cx | can-dim-dates | Dates | World | Kateřina Tomášková | katerina.tomaskova@clevermaps.io |
Dimension of times | p53boou4162877lm | can-dim-times | Dates | World | František Pavlíček | frantisek.pavlicek@clevermaps.io |
Eurostat grid of Austria | fglb58kavomlj9u1 | can-dim-eurostat-grid-at | Grid | Austria | Jan Kantor | jan.kantor@clevermaps.io |
Eurostat grid of Bulgaria | vg0t0k702jjs41hj | can-dim-eurostat-grid-bg | Grid | Bulgaria | Jan Kantor | jan.kantor@clevermaps.io |
Eurostat grid of Croatia | iien19r76mplsdjl | can-dim-eurostat-grid-hr | Grid | Croatia | Jan Kantor | jan.kantor@clevermaps.io |
Eurostat grid of Hungary | mmilir0buqs0dpeh | can-dim-eurostat-grid-hu | Grid | Hungary | Jan Kantor | jan.kantor@clevermaps.io |
Eurostat grid of Romania | d7ho1luk0irh0dh3 | can-dim-eurostat-grid-ro | Grid | Romania | Jan Kantor | jan.kantor@clevermaps.io |
Eurostat grid of Slovakia | kv5gok8fsim4hvr0 | can-dim-eurostat-grid-sk | Grid | Slovakia | Jan Kantor | jan.kantor@clevermaps.io |
Eurostat grid of the Czech Republic | a74hh3bfbrr1dmkf | can-dim-eurostat-grid | Grid | Czech Republic | Jan Kantor | jan.kantor@clevermaps.io |
Exposure index of Hungary | djq4e5gc0896brfk | can-dim-exposure-index-osm-hu | Exposure Index | Hungary | Jan Kantor | jan.kantor@clevermaps.io |
Exposure index of Slovakia | ohl7oldtfodvfsfd | can-dim-exposure-index-osm-sk | Exposure Index | Slovakia | Jan Kantor | jan.kantor@clevermaps.io |
Exposure index of the Czech Republic (OSM) | djflqntshvfj8efm | can-dim-exposure-index-osm-cz | Exposure Index | Czech Republic | Karel Psota | karel.psota@clevermaps.io |
Exposure index of the Czech Republic (RUIAN) | qqed22vn86qgnck7 | can-dim-exposure-index-cz | Exposure Index | Czech Republic | Jan Kantor | jan.kantor@clevermaps.io |
Grid of Austria | lq8mok09cg8jvfbe | can-dim-grid-at | Grid | Austria | Jan Kantor | jan.kantor@clevermaps.io |
Grid of Austria | i0er79nejivfuu6a | can-dim-grid-bg-uber | Grid | Bulgaria | Jan Kantor | jan.kantor@clevermaps.io |
Grid of Croatia | d3nbl79v0ucrbqhi | can-dim-grid-hr | Grid | Croatia | Jan Kantor | jan.kantor@clevermaps.io |
Grid of Germany | uapq3q90mgmu1le4 | can-dim-grid-de | Grid | Germany | Jan Kantor | jan.kantor@clevermaps.io |
Grid of Poland | nvp4b9meoni05j6a | can-dim-grid-pl | Grid | Poland | František Pavlíček | frantisek.pavlicek@clevermaps.io |
Grid of Romania | t3kn0ef0hqtdb9hr | can-dim-grid-ro | Grid | Romania | Jan Kantor | jan.kantor@clevermaps.io |
Grid of Slovakia | pjfgode9ri4vq4di | can-dim-grid-sk | Grid | Slovakia | Jan Kantor | jan.kantor@clevermaps.io |
Grid of the Czech Republic | k51ytmasn2u6hpyt | can-dim-grid-cz | Grid | Czech Republic | Jan Kantor | jan.kantor@clevermaps.io |
H3 Uber Grid of Austria | aimlkct7ht0mnv20 | can-dim-grid-at-uber | Grid | Austria | Jan Kantor | jan.kantor@clevermaps.io |
H3 Uber Grid of Benelux | jmd2964hmisn9cev | can-dim-grid-benelux-uber | Grid | Belgium, Netherlands, Luxembourg | Jan Kantor | jan.kantor@clevermaps.io |
H3 Uber Grid of Bulgaria | jalumqbbrlf4me0j | can-dim-grid-bg-uber | Grid | Bulgaria | Jan Kantor | jan.kantor@clevermaps.io |
H3 Uber Grid of Croatia | nghf4eol7a6bpfr3 | can-dim-grid-hr-uber | Grid | Croatia | Jan Kantor | jan.kantor@clevermaps.io |
H3 Uber Grid of Hungary | msr2tqrk13dhje4m | can-dim-grid-hu-uber | Grid | Hungary | Jan Kantor | jan.kantor@clevermaps.io |
H3 Uber Grid of Poland | j98sicau75sfu54n | can-dim-grid-pl-uber | Grid | Poland | Jan Kantor | jan.kantor@clevermaps.io |
H3 Uber Grid of Romania | rn7rkbtqlh964t71 | can-dim-grid-ro-uber | Grid | Romania | Jan Kantor | jan.kantor@clevermaps.io |
H3 Uber Grid of Serbia | j2ahpi5v3l9m47tu | can-dim-grid-srb-uber | Grid | Serbia | Jan Kantor | jan.kantor@clevermaps.io |
H3 Uber Grid of Slovakia | i5i1ab2k23qbtqsk | can-dim-grid-sk-uber | Grid | Slovakia | Jan Kantor | jan.kantor@clevermaps.io |
H3 Uber Grid of the Czech Republic | nbutdscdghhg25v4 | can-dim-grid-cz-uber | Grid | Czech Republic | Kateřina Tomášková | katerina.tomaskova@clevermaps.io |
Price sensitivity in the Czech Republic | h444gjwngbwyawra | can-dim-price-sensitivity-cz | Purchasing Power | Czech Republic | František Pavlíček | frantisek.pavlicek@clevermaps.io |
Purchasing power in the Czech Republic | rze116z5u3ilsz9i | can-dim-purchase-strength | Purchasing Power | Czech Republic | Jan Kantor | jan.kantor@clevermaps.io |
Purchasing power of Hungary | s1lj1gma65qg307j | can-dim-purchase-strength-hu | Purchasing Power | Hungary | Jan Kantor | jan.kantor@clevermaps.io |
Purchasing power of Slovakia | toql8gi185das8ed | can-dim-purchase-strength-sk | Purchasing Power | Slovakia | Jan Kantor | jan.kantor@clevermaps.io |
Structure of education in the Czech Republic | esr64w0nvr0o430l | can-dim-education-cz | Demography | Czech Republic | František Pavlíček | frantisek.pavlicek@clevermaps.io |
Traffic intensity in the Czech Republic | n4c07m128521bi6c | can-dim-traffic-intensity-cz | Car Mobility | Czech Republic | Karel Psota | karel.psota@clevermaps.io |
Turism in the Czech Republic | eg0f7qit5e4b93en | can-dim-tur-ruch-cz | Human Mobility | Czech Republic | Jan Kantor | jan.kantor@clevermaps.io |
can-dim-adm-units-cz-en
Administrative units of the Czech Republic
Administrative units hierarchy of the Czech Republic
- Project ID: q1zdp9d0ao78rdv5
- Link: https://secure.clevermaps.io/#/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 of Slovakia
Administrative units hierarchy of the Slovak Republic.
- Project ID: h3aytnzloh7tzpko
- Link: https://secure.clevermaps.io/#/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/#/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:
To match the property of your fact dataset (orders in this case) with the primaryKey of dim_dates, you have to use the date type and set the foreignKey to point to the dim_dates table.
...
{
"filterable": true,
"name": "order_date",
"title": "Order date",
"column": "order_date",
"type": "date",
"foreignKey": "dim_dates"
},
...
The primaryKey of dim_dates table is in the ISO 8601 (YYYY-MM-DD) format.
We accept 4 possible date formats. These recognized formats are automatically converted to the YYYY-MM-DD format during the import, to match the dim_dates.date_iso property.
| Example | Format | Note |
|---|---|---|
| 2013-10-31 | YYYY-MM-DD | ISO 8601, preferred |
| 10/31/2013 | MM/DD/YYYY | |
| 31-Oct-13 | DD-MON-YY | case insensitive |
| 31/Oct/2013 | DD/MON/YYYY | case insensitive |
And to enable the date picker, you have to add the globalDate filter to your view. Here is an excerpt from the view, showing the correct settings of filterGroup.
...
"filterGroup": [
{
"type": "globalDate",
"property": "orders.order_date"
}
]
...
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 import command, you have to specify a prefix for the second import like this:
import --project tbagvahj2yvva9cx --prefix "shops_"
can-dim-demography-cz-en
Demography of the Czech Republic
- Basic demographic attributes of Czech Republic - citizens, households, houses, flats.
- Project ID: cn0fv61t751c6elt
- Link: https://secure.clevermaps.io/#/cn0fv61t751c6elt/project
- Demography project contains own Demography tables and imported tables from Administrative units of the Czech Republic
- Data model:
can-dim-demography-sk
Demography of Slovakia
- Basic demographic attributes of the Slovak Republic - citizens, households, houses, flats.
- Project ID: vommuqm52187ysyb
- Link: https://secure.clevermaps.io/#/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
Grid of Czech Republic
Project divides the area of Czech Republic to polygons or hexapolygons.
- Project ID: k51ytmasn2u6hpyt
- Link: https://secure.clevermaps.io/#/k51ytmasn2u6hpyt/project
- There are 4 resolution types of grid by size.
Data model:
