Last modified by Aurelie Bertrand on 2025/07/21 11:40
Show last authors
1 {{ddtoc/}}
2
3 ----
4
5 = Introduction =
6
7 In this tutorial, we're going to find out how to create an Open Street Map and navigate on different map backgrounds.
8
9 The dataset used in the tutorial corresponds to fictitious data on the French départements. This data is contained in the Excel file "[[departements_regionsfr>>attach:departements_regionsfr.xlsx]]".
10
11 This entire tutorial takes place in the Studio.
12 We will first create a data model in which we will define a hierarchy based on regions and departments.
13 We will then create a background map with 2 levels corresponding to the regions and departments.
14 Finally, we will create an Open Street Map and configure it using the elements previously created.
15
16 = Prerequisites =
17
18 In order to complete this tutorial, you will need to :
19
20 * have installed DigDash Enterprise version 2025R1 or higher;
21 * be a user with the **"Data Model Designer**" authorization group;
22 * download the Excel file "departements_regionsfr_en" and the Geosjson maps contained in [[Cartes_geojson.zip>>attach:Cartes_geojson.zip]].
23
24 (% class="box" %)
25 (((
26 ℹ The screenshots in this tutorial were produced using the Chrome browser. There may be slight differences depending on the browser.
27 )))
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49 = Step 1: Create and configure the data model =
50
51 (% class="box infomessage" %)
52 (((
53 This tutorial assumes that you are going to import your data sources and create your charts in your personal role.
54 )))
55
56 == Import the data ==
57
58 Here we're going to import the data from the Excel file "departements_regionsfr_en" (retrieved earlier).
59
60 To do this
61
62 1. Launch the **Studio**.
63 1. Open the **Templates** tab.
64 1. Click on the **New template** button.
65 1. In the **Create a new data model** box, select **All types** in the **Files** section.
66 ➡ The **Search remote files **box appears.
67 1. In the **Server** drop-down list, select "**Common Datasources**."
68 1. Click the **Add file** button.
69 **~ [[image:Search_remote_files_dialog_EN.png||alt="Search file" height="405" width="749"]] **
70 1. When the **Select a local file or URL **box appears, keep the default selection** From your computer**.
71 1. Click **Browse **to select the **"departements_regionsfr_en" **file retrieved earlier.
72 1. Click **OK**.
73 ➡ The file is now saved on the DigDash server **"Common Datasources"** and accessible to all users.
74
75 (% class="box infomessage" %)
76 (((
77 ℹ If the document server //**UserDocs**// is selected the documents are only accessible to the user who uploaded them.
78 )))
79
80 (% start="10" %)
81 1. In the **Search remote files** dialog, select **"departements_regionsfr_en"**.
82 1. Click **OK.**
83
84 The **Excel File **box appears. It offers data selection options and a preview of the data.
85
86 [[image:Preview_EN.png||height="612" width="1097"]]
87
88 The data includes a column **DEP** containing the department code, a column **REG** for the region code and a column **Measure**.
89
90 The elements in the first row of the table correspond to the data types in each column. We will therefore use them as column headers. For example, DEP for column 1. To do this:
91
92 * In the **Data selection** section, select the **First row as header** checkbox **.
93 [[image:Data_selection_EN.png||alt="Data selection"]]**
94
95 We can now move on to configuring the data model: click the **Next **button at the bottom right to open the data model configuration window.
96
97 == Create the hierarchy ==
98
99 The data model configuration window opens on the **Columns** tab. We are going to create the Region-Departement hierarchy. To do this:
100
101 1. Select the dimension **DEP**//, which //corresponds to the department codes. Grouping is done from the most detailed to the least detailed level.
102 1. In the **Hierarchies** section, click the **+** button and select [[**Automatic grouping**>>doc:Digdash.user_guide.studio.Create_datamodel.configure_data_model.Configure_columns.Create_hierarchy.Create_group_discrete_dimension.WebHome||anchor="Groupement_automatique"]].
103 ➡ The **Group editor** dialog box is displayed.
104 1. In the **Group** field, enter the name of the hierarchy:** Region-Department//.//**
105 1. In the **Complete path** field, select **REG** from the drop-down list after **DEP /**.
106 [[image:Auomatic_grouping_EN.png||alt="Automatic grouping"]]
107 1. Click **OK** and then **Finish**.
108 1. Enter a name for the data model : **Departments**, and click** OK**.
109
110 = Step 2: Create a multi-level map =
111
112 We are now going to create the map with the different levels of layers corresponding to the different levels of the hierarchy.
113
114 == Add the map layer for regions ==
115
116 We start by adding the map layer containing regions:
117
118 1. From the Studio, open the **Map Manager:** click the **Managers** button in the left-hand sidebar and then select **Maps**.
119 [[image:Map_manager_EN.png||alt="Map manager"]]
120 1. Click the **Add map** button.
121 ➡ The **New map **dialog** **box appears.
122 1. Select the format of the map file. In this example, we use a JSON type file.
123 1. Enter the name of the map. In this example, **//reg-dep//**.
124 1. In the **Role** field, select **None** to share the map with all roles.
125 1. In the **File** section, add the file corresponding to the map: **//regions.geojson//**
126 1. Enter the name of the **Level **: here **//reg//**.
127 [[image:New_map_reg_EN.png||alt="New map" height="571" width="640"]]
128 1. Click **OK**.
129 ➡ The map is then added to the list of available maps.
130
131 == Add the map layer for departments ==
132
133 Now, we add the departments map level:
134
135 1. Select the newly added regions map and click the **Add a level** button.
136 1. In the **New map** dialog box, add the **//departments.geojson//** file as before and enter the name of the level, here **//dep //**for department.
137 [[image:Add_level_EN.png||height="315" width="409"]]
138 1. Click **OK**.
139 ➡ The //**dep** //level is// //added below the **//reg//** level.
140 [[image:Map_added_EN.png]]
141 1. Click **OK** to save the map and close the **Map Manager**.
142
143 = Step 3: Create and configure the Open Street Map =
144
145 (% start="1" %)
146 1. From the **Studio** **{{glossaryReference glossaryId="Glossary" entryId="Flux"}}Flow{{/glossaryReference}} **tab **,** click the** New flow** button**.**
147 1. Select the {{glossaryReference glossaryId="Glossary" entryId="Flux"}}Flow{{/glossaryReference}} type **[[OSM map>>doc:Digdash.user_guide.studio.Create_flow.Flow_types_and_configuration.Flow_type_map.Carte de type Open Street Map.WebHome]]**.
148 ➡ The **{{glossaryReference glossaryId="Glossary" entryId="Flux"}}Flow{{/glossaryReference}} Properties** window appears.
149 1. Select the data model created earlier: **Departments**.
150 1. Add the **DEP** dimension **.**
151 ➡ The automatic level selection box is displayed.
152 1. Select the **Add the action "Navigate hierarchies"** checkbox and click **OK.**
153 **[[image:Add_DEP_EN.png]]**
154 1. Add the **Measure**.
155 1. In the **Specific parameters** tab,
156 1*. select the **Color depending to value **checkbox: to define the colour of the zone depending to the value of the associated measurement (according to the chosen colour palette)
157 1*. select the map previously added and validate.
158 **[[image:Map_settings_EN.png]]**
159 ➡ In the chart preview area, a yellow warning sign flashes
160
161 [[image:Warning_sign_EN.png]]
162
163 (% start="8" %)
164 1. Click it and validate the WFS layer association for each level by clicking **OK**.
165 [[image:Layer_association_EN.png||alt="Layer association"]]
166 \\➡ The regions are displayed using the current colour palette:
167 [[image:Regions_initial_palette_FR.png]]
168 \\You can click the [[image:1738591809872-214.png]] button to view the WFS layer settings.
169 [[image:Associate_WFS_layer_parameters_FR.png]]
170
171 We are now going to choose a more suitable colour palette:
172
173 1. Click on the **Colors** button on the toolbar and then the **Edit **button to the right of the selected palette.
174 ➡ The **Colour palette setup window **appears.
175 1. Select the //Flat Design 10// blue gradients palette.
176 (% style="box-sizing:border-box; display:block" %)[[image:Color_options_EN.png||alt="Color options" height="253" width="351"]]
177
178 We're going to add a red border to make it easier to see the boundaries of the regions:
179
180 1. Click the [[image:Bouton_calques.png]] button at the top right of the map and then the cogwheel next to **regions.geojson**.
181 [[image:1738591062528-158.png||alt="Attributs"]]
182 1. [[image:1717167361648-114.gif]]Click in the **Stroke** field and select the dark red colour.
183 [[image:Attributes_EN.png||alt="Border"]]
184 ➡ We obtain the following rendering:
185 (% style="box-sizing:border-box; display:block" %)[[image:Regions_blue_palette_red_border_FR.png||alt="Bordure ajoutée"]]
186
187 (% start="3" %)
188 1. To see details of the departments, click a region.
189 1. Add a border for **departements.geojson **in the same way as above.
190 [[image:Select_departement_FR.png||alt="Sélection département"]]
191 1. Change the name of the {{glossaryReference glossaryId="Glossary" entryId="Flux"}}Flow{{/glossaryReference}} as desired and click **OK**.
192
193 The Open Street Map is now ready to be used in a dashboard.
194
195 = Congratulations! =
196
197 You've managed to create an Open Street Map and navigate on different levels.
198 Now all you have to do is apply it to your data!