Data dimension projects

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 name

Category

Coverage

Project link

Address points in the Czech Republic

can-dim-address-points-cz

Administrative Units

Czech Republic

https:/secure.clevermaps.io/#/projectList/project/d3rf25iv95lt26k4

Administrative divisions of the United States

can-dim-adm-units-us

Administrative Units

USA

https:/secure.clevermaps.io/#/projectList/project/i3p181knkde0s6we

Administrative units of Australia

can-dim-adm-units-aus

Administrative Units

Australia

https:/secure.clevermaps.io/#/projectList/project/r384fe5akm5g25h5

Administrative units of Austria

can-dim-adm-units-aut

Administrative Units

Austria

https:/secure.clevermaps.io/#/projectList/project/t5ocpt6krb5jbh0h

Administrative units of Belgium

can-dim-adm-units-bel

Administrative Units

Belgium

https:/secure.clevermaps.io/#/projectList/project/g4uevm4fi7jh99fa

Administrative units of Bulgaria

can-dim-adm-units-bg

Administrative Units

Bulgaria

https:/secure.clevermaps.io/#/projectList/project/hnekbl680e2ev440

Administrative units of European countries

can-dim-adm-units-nuts-eu

Administrative Units

Europe

https:/secure.clevermaps.io/#/projectList/project/je1vf8nle83abhqo

Administrative units of France

can-dim-adm-units-nuts-fr

Administrative Units

France

https:/secure.clevermaps.io/#/projectList/project/add4g4uklt5q87sn

Administrative units of Germany

can-dim-adm-units-de

Administrative Units

Germany

https:/secure.clevermaps.io/#/projectList/project/gn3523n3rjif0sa5

Administrative units of Hungary

can-dim-adm-units-hu

Administrative Units

Hungary

https:/secure.clevermaps.io/#/projectList/project/iu6ob8j5g5hbmbag

Administrative Units of Italy

can-dim-adm-units-ita

Administrative Units

Italy

https:/secure.clevermaps.io/#/projectList/project/n6g1k0f73f68v7at

Administrative units of Lebanon

can-dim-adm-units-lbn

Administrative Units

Lebanon

https:/secure.clevermaps.io/#/projectList/project/tl13dkotaejj3efg

Administrative units of Moldova

can-dim-adm-units-md

Administrative Units

Moldova

https:/secure.clevermaps.io/#/projectList/project/ee8ep1tpssjme35j

Administrative units of Poland

can-dim-adm-units-pl

Administrative Units

Poland

https:/secure.clevermaps.io/#/projectList/project/h1o0u4v8tv4bp94v

Administrative units of Romania

can-dim-adm-units-ro

Administrative Units

Romania

https:/secure.clevermaps.io/#/projectList/project/nt1kcnm13ecp17bj

Administrative units of Singapore

can-dim-adm-units-sg

Administrative Units

Singapore

https:/secure.clevermaps.io/#/projectList/project/luchuiaml9aboe8p

Administrative units of Slovakia

can-dim-adm-units-sk

Administrative Units

Slovakia

https:/secure.clevermaps.io/#/projectList/project/h3aytnzloh7tzpko

Administrative units of Spain

can-dim-adm-units-esp

Administrative Units

Spain

https:/secure.clevermaps.io/#/projectList/project/t3j88apc3iht7tah

Administrative units of Switzerland

can-dim-adm-units-sui

Administrative Units

Switzerland

https:/secure.clevermaps.io/#/projectList/project/jpgfurb89ang99du

Administrative units of the Czech republic

can-dim-adm-units-cz-en

Administrative Units

Czech Republic

https:/secure.clevermaps.io/#/projectList/project/q1zdp9d0ao78rdv5

Administrative units of UK

can-dim-adm-units-nuts-uk

Administrative Units

United Kingdom

https:/secure.clevermaps.io/#/projectList/project/vs7ksq4dl9boecbc

Administrativní jednotky České republiky

can-dim-adm-units-cz-cz

Administrative Units

Czech Republic

https:/secure.clevermaps.io/#/projectList/project/vyhs2oc86viyipe7

Completed apartments and houses and population in the Czech Republic

Can-dim-cz-demography-level-ruian-from-zsj

Demography

Czech Republic

https:/secure.clevermaps.io/#/projectList/project/hvfg86jk8c74e8jl

Completed Apartments and houses in the Czech Republic

can-dim-cz-dokoncene-byty-v-obcich

Buildings

Czech Republic

https:/secure.clevermaps.io/#/projectList/project/lq14mmv3ks8o21m0

Construction objects in the Czech Republic

can-dim-rn-so

Geotypes/Consumer Segments

Czech Republic

https:/secure.clevermaps.io/#/projectList/project/ccp8jmoxqwnac03a

Countries of the World

can-dim-adm-units-world

Administrative Units

World

https:/secure.clevermaps.io/#/projectList/project/lpvlhtou6rtm0nf8

Countries of the World

can-dim-adm-units-world2

Administrative Units

World

https:/secure.clevermaps.io/#/projectList/project/qn6k0164aofh7jgm

Cycling paths in the Czech Republic

can-dim-cz-cyklostezky

Car Mobility

Czech Republic

https:/secure.clevermaps.io/#/projectList/project/q93dr01ahd6trc1o

Density of population in the Czech Republic

can-dim-density

Demography

Czech Republic

https:/secure.clevermaps.io/#/projectList/project/rbce0b17tsr0a219

Departures/Arrivals in Austria

can-dim-commuting-at

Car Mobility

Austria

https:/secure.clevermaps.io/#/projectList/project/sf25uttv35dgtlik

Departures/Arrivals in the Czech Republic

can-dim-vyjizdka-dojizdka

Car Mobility

Czech Republic

https:/secure.clevermaps.io/#/projectList/project/a16v1erm1bmbo1bb

Dimension of dates

can-dim-dates

Dates

World

https:/secure.clevermaps.io/#/projectList/project/tbagvahj2yvva9cx

Dimension of times

can-dim-times

Dates

World

https:/secure.clevermaps.io/#/projectList/project/p53boou4162877lm

Exposure index of Hungary

can-dim-exposure-index-osm-hu

Exposure Index

Hungary

https:/secure.clevermaps.io/#/projectList/project/djq4e5gc0896brfk

Exposure index of Slovakia

can-dim-exposure-index-osm-sk

Exposure Index

Slovakia

https:/secure.clevermaps.io/#/projectList/project/ohl7oldtfodvfsfd

Exposure index of the Czech Republic (OSM)

can-dim-exposure-index-osm-cz

Exposure Index

Czech Republic

https:/secure.clevermaps.io/#/projectList/project/djflqntshvfj8efm

Exposure index of the Czech Republic (RUIAN)

can-dim-exposure-index-cz

Exposure Index

Czech Republic

https:/secure.clevermaps.io/#/projectList/project/qqed22vn86qgnck7

Grid of Austria

can-dim-grid-at

Grid

Austria

https:/secure.clevermaps.io/#/projectList/project/lq8mok09cg8jvfbe

Grid of Austria

can-dim-grid-bg-uber

Grid

Bulgaria

https:/secure.clevermaps.io/#/projectList/project/i0er79nejivfuu6a

Grid of Croatia

can-dim-grid-hr

Grid

Croatia

https:/secure.clevermaps.io/#/projectList/project/d3nbl79v0ucrbqhi

Grid of Germany

can-dim-grid-de

Grid

Germany

https:/secure.clevermaps.io/#/projectList/project/uapq3q90mgmu1le4

Grid of Poland

can-dim-grid-pl

Grid

Poland

https:/secure.clevermaps.io/#/projectList/project/nvp4b9meoni05j6a

Grid of Romania

can-dim-grid-ro

Grid

Romania

https:/secure.clevermaps.io/#/projectList/project/t3kn0ef0hqtdb9hr

Grid of Slovakia

can-dim-grid-sk

Grid

Slovakia

https:/secure.clevermaps.io/#/projectList/project/pjfgode9ri4vq4di

Grid of the Czech Republic

can-dim-grid-cz

Grid

Czech Republic

https:/secure.clevermaps.io/#/projectList/project/k51ytmasn2u6hpyt

H3 Uber Grid of Austria

can-dim-grid-at-uber

Grid

Austria

https:/secure.clevermaps.io/#/projectList/project/aimlkct7ht0mnv20

H3 Uber Grid of Benelux

can-dim-grid-benelux-uber

Grid

Belgium

https:/secure.clevermaps.io/#/projectList/project/jmd2964hmisn9cev

H3 Uber Grid of Bulgaria

can-dim-grid-bg-uber

Grid

Bulgaria

https:/secure.clevermaps.io/#/projectList/project/jalumqbbrlf4me0j

H3 Uber Grid of Croatia

can-dim-grid-hr-uber

Grid

Croatia

https:/secure.clevermaps.io/#/projectList/project/nghf4eol7a6bpfr3

H3 Uber Grid of Hungary

can-dim-grid-hu-uber

Grid

Hungary

https:/secure.clevermaps.io/#/projectList/project/msr2tqrk13dhje4m

H3 Uber Grid of Poland

can-dim-grid-pl-uber

Grid

Poland

https:/secure.clevermaps.io/#/projectList/project/j98sicau75sfu54n

H3 Uber Grid of Romania

can-dim-grid-ro-uber

Grid

Romania

https:/secure.clevermaps.io/#/projectList/project/rn7rkbtqlh964t71

H3 Uber Grid of Serbia

can-dim-grid-srb-uber

Grid

Serbia

https:/secure.clevermaps.io/#/projectList/project/j2ahpi5v3l9m47tu

H3 Uber Grid of Slovakia

can-dim-grid-sk-uber

Grid

Slovakia

https:/secure.clevermaps.io/#/projectList/project/i5i1ab2k23qbtqsk

H3 Uber Grid of the Czech Republic

can-dim-grid-cz-uber

Grid

Czech Republic

https:/secure.clevermaps.io/#/projectList/project/nbutdscdghhg25v4

Price sensitivity in the Czech Republic

can-dim-price-sensitivity-cz

Purchasing Power

Czech Republic

https:/secure.clevermaps.io/#/projectList/project/h444gjwngbwyawra

Purchasing power in the Czech Republic

can-dim-purchase-strength

Purchasing Power

Czech Republic

https:/secure.clevermaps.io/#/projectList/project/rze116z5u3ilsz9i

Purchasing power of Hungary

can-dim-purchase-strength-hu

Purchasing Power

Hungary

https:/secure.clevermaps.io/#/projectList/project/s1lj1gma65qg307j

Purchasing power of Slovakia

can-dim-purchase-strength-sk

Purchasing Power

Slovakia

https:/secure.clevermaps.io/#/projectList/project/toql8gi185das8ed

Structure of education in the Czech Republic

can-dim-education-cz

Demography

Czech Republic

https:/secure.clevermaps.io/#/projectList/project/esr64w0nvr0o430l

Tourism in the Czech Republic

can-dim-tur-ruch-cz

Human Mobility

Czech Republic

https:/secure.clevermaps.io/#/projectList/project/eg0f7qit5e4b93en

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

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.

Orders dataset order_date property
    ...
{
    "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.

ExampleFormatNote
2013-10-31YYYY-MM-DDISO 8601, preferred
10/31/2013MM/DD/YYYY
31-Oct-13DD-MON-YYcase insensitive
31/Oct/2013DD/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.

Orders view excerpt
   ...
"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

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