 Hello, in this video, we're going to create a coroplete map of household size in the Netherlands in 2021. We'll use data from statistics Netherlands and download it through the PDOC services plugin. This video is part of the summer course for IHG Delft on creating data visualizations with graphs, maps and animations. You can also find the tutorial for free at gisopencoursware.org. The link will be provided in the description of this video. Open data for the Netherlands can easily be downloaded with the PDOC services plugin. In the plugins manager, look for PDOC services. Install the plugin and it will add a toolbar. Click on the icon and you will see a list of layers that you can choose including the different services that are available. We're looking for municipalities. In Dutch, municipality is gemeente. And we want it as factor data that we can manipulate, so we want WFS. Here in the metadata, you can find the description and it says that this is data for 2021 and that's the most recent one that is currently available from statistics Netherlands, CBS. Click on standard to add the layer to your map canvas. It's a big layer which will download from the internet. And when it shows up, zoom to the extent of the layer. Because the layer is quite large, it's difficult to open the attribute table to take time. So we can also check the attributes and the layer properties. Scroll down in the information tab. You will find all the attributes that are in this layer and you'll find their Antel inwoners, which means number of inhabitants and Antel households, which means number of households. And those are the layers that we need for our calculation. Now this layer also has municipality boundaries that cover water bodies included in the municipalities. And we need to filter them out because we're not interested in showing those parts of the map. Without opening the attribute table, we can do it by choosing select by expression from the toolbar. And there is a field in the layer, which is called water. And if we load all unique values, then we see that it has its attributes b, ja, ne, and ne means no. So that's what we need to filter out, water equals ne. Click select features and now we see in yellow highlighted the polygons that don't contain water. Let's export the selected features and save them in the geopackage. We create a new folder for this project on the hard drive. We call it Coruplift and save the database as municipalities and as a layer name. I'll choose municipalities without water. Click OK and now remove the original layer. Let's also save the project in the geopackage. Choose project save to browse to the geopackage and give the project a name. For example Coruplift and click OK. The next step is to calculate the amount of people per household. And we would normally use the field calculator from the attribute table, but we can also use this button. Then we don't have to open the attribute table and the output field name will be people per household. And the output field type is decimal. Then under field and values choose until inwoners, the number of inhabitants, and divide it by until households, number of households. In the preview we see that the number makes sense. So we click OK, the calculation is applied, but we still need to save it, so we need to toggle the editing and save the results. The next step is to style our Coruplift map. Go to the layer styling panel and for Coruplift maps we will always use the graduated renderer. And for value choose here our calculated field with people per household. Click classify to see the result with the default color ramp. The color ramp goes from white to red and red is associated with something that's bad. And here we need more neutral color ramp because we don't want to give any judgment on the number of people per household. So choose something neutral like purples and we'll use seven classes. And by default it uses the equal count or quantile mode which makes sure that all colors are equally represented. If we look at the histogram then we see that there are also a few outliers and you can use this histogram to adjust the mode and the class boundaries. And here I think that natural breaks gives a nice impression of distribution in the country. In the tutorial there's a link included with a blog post about how to choose these modes, which I think is very important. Now the reader needs some orientation and therefore it's useful to add labels. So we change to single labels and we need to use the name of the municipalities. In Dutch that will be the field gemeentenaan, but it looks already very crowded so showing them all doesn't make much sense and we need to tweak a bit the visualization. Let's first go to the rendering tab and there check the box to show all labels for this layer including colliding labels. It makes it worse, but then we're going to change the data defined overwrite using an expression to only select municipalities with more than 100,000 inhabitants. So a number of inhabitants should be larger than 100,000 and click OK. Now this looks less crowded but it's not very clear to read so let's also tweak a few other settings of the labels. It would help to make a text buffer so check the box to draw the text buffer. Make it a bit smaller 0.5 should be enough. Now this looks quite readable you can tune it more but I'll leave it like this for this tutorial and save the project. So now we can finalize the map in a print layout. Go to project, new print layout and give it a name, for example household size. The first thing we need to do is to change the orientation of the sheet. The map of the Netherlands looks better when the sheet is portrait. Then we can add the map frame. I'll make it as big as the map sheet. Now use the move item content button to scale the map in the frame. You can use control scroll to make little steps with the mouse and make sure it fits nicely on the sheet. Now let's add a title, drag a rectangle and type there the text of the title household size 2021. And let's adjust the font and use Calibri for example or any other sensory font. And I use bold and make it big, maybe even bigger will be better. Let's use 36 and horizontal alignment should be center vertical alignment middle. Now let's add the legend and check the box for auto update so we can edit the legend. Let's add the title, people per household. We place the text at municipalities with a space so it will not be shown. Let's change the fonts a bit. The item fonts make them 10 points. I want square symbols so I change it to 4 by 4 and I want to better align the numbers. So I give them all the same decimals we need to change 2.5 to 2.50. Now I want to add some text with the data source and the author. And the data source here is statistics Netherlands or CBS. And I add there that that was via PDOC. And at cartographer you can insert your name and you can also use dynamic text for that. If there's a variable with your name you can use project author. And there you see on the map sheet that it fills in my complete name. Adjust the font. I'll just use Calibri light italic 8 points. And I drag it so it's aligned with the southern province of Limburg. For background change it to gray so that's the fill color of the map frame. Light gray. And then we also need to make the background of the legend transparent by unchecking the box there. I'm going to change the spacing a bit to get the title closer to the legend. So this space below the title set it to 0. You can still further improve it by moving the labels a bit. But for this tutorial I'll leave it like this. You can export to PDF or to PNG. Here I will export it to PNG. I'll use the default and let's have a look at the result. That looks nice and you can still crop it of course in a program like this. And overwrite it to have here the final result. If I scale it to a window that looks nice. As said you can further improve it by editing but now we can already start interpreting what we see in the map. So in this video you've learned how to create a corrupt lead map.