{"id":1992,"date":"2022-01-21T17:34:31","date_gmt":"2022-01-21T17:34:31","guid":{"rendered":"https:\/\/dreid.nl\/?p=1992"},"modified":"2022-01-22T08:38:03","modified_gmt":"2022-01-22T08:38:03","slug":"creating-a-map-of-covid-cases-per-municipality-in-qgis","status":"publish","type":"post","link":"https:\/\/dreid.nl\/?p=1992","title":{"rendered":"Creating a map of Covid cases per municipality in QGIS"},"content":{"rendered":"

Since the beginning of Covid-19, I’ve from time to time downloaded the official Dutch Covid-19 statistics (available here<\/a>) and created my own plots, using a Jupyter Python notebook that you can find over on Github<\/a>. But it’s also interesting to view maps instead of only timeline plots. Unfortunately, the official map shown on the Coronadashboard<\/a> colors dark blue beyond 30 cases, leaving no possibility to see regional differences. QGIS to the rescue!<\/p>\n

I first downloaded the daily counts per municipality, the file called COVID-19_aantallen_gemeente_per_dag.csv<\/em>. From this I pasted the header line and lines of the last day into a new text file, and imported this into QGIS using the\u00a0Add Delimited Text Layer<\/em> function:<\/p>\n

\"\"<\/p>\n

I then downloaded the current municipality borders, available on PDOK<\/a> in GeoPackage format, and loaded these in QGIS. The next step is to join the two datasets together. Open the processing toolbox, and use the Join attributes by field value<\/em> command that is located under Vector general<\/em>. I joined the datasets using the Municipality name, but you could also use the code instead.<\/p>\n

\"\"<\/p>\n

Now we’ve got absolute numbers, but it makes much more sense to use the number of cases per 100,000 inhabitants. For this we need the population numbers, which can be obtained from the CBS Open Data portal. The dataset is called\u00a0Regionale kerncijfers Nederland<\/em>. You can select only the most recent year, municipalities only, and only population numbers. The resulting dataset can then, after import, also be joined with the geographic data. I had to use the option “Discard records which could not be joined” to get this to work, and lost three municipalities in the process – I think that these were formed at the beginning of 2022 and hence do no exist in the 2021 CBS data.<\/p>\n

We can then use the field calculator to compute the number of cases per 100,000 inhabitants:<\/p>\n

\"\"<\/p>\n

This can then be visualized as desired:<\/p>\n

\"\"<\/p>\n

The RIVM has a map with a readable color scale, based on the weekly numbers, on its website<\/a>. ESRI have a dashboard<\/a> with a map based on the 7-day trend.<\/p>\n","protected":false},"excerpt":{"rendered":"

Since the beginning of Covid-19, I’ve from time to time downloaded the official Dutch Covid-19 statistics (available here) and created my own plots, using a Jupyter Python notebook that you can find over on Github. But it’s also interesting to view maps instead of only timeline plots. Unfortunately, the official map shown on the Coronadashboard […]<\/p>\n","protected":false},"author":1,"featured_media":1996,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[100],"tags":[102],"class_list":["post-1992","post","type-post","status-publish","format-standard","has-post-thumbnail","category-blog","tag-qgis","czr-hentry"],"yoast_head":"\nCreating a map of Covid cases per municipality in QGIS - DreiD BV<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dreid.nl\/?p=1992\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Creating a map of Covid cases per municipality in QGIS - DreiD BV\" \/>\n<meta property=\"og:description\" content=\"Since the beginning of Covid-19, I’ve from time to time downloaded the official Dutch Covid-19 statistics (available here) and created my own plots, using a Jupyter Python notebook that you can find over on Github. But it’s also interesting to view maps instead of only timeline plots. Unfortunately, the official map shown on the Coronadashboard […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dreid.nl\/?p=1992\" \/>\n<meta property=\"og:site_name\" content=\"DreiD BV\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DreiDBV\" \/>\n<meta property=\"article:published_time\" content=\"2022-01-21T17:34:31+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-01-22T08:38:03+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/dreid.nl\/wp-content\/uploads\/2022\/01\/covidmap.png\" \/>\n\t<meta property=\"og:image:width\" content=\"831\" \/>\n\t<meta property=\"og:image:height\" content=\"835\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Tobias\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Geschreven door\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tobias\" \/>\n\t<meta name=\"twitter:label2\" content=\"Verwachte leestijd\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/dreid.nl\\\/?p=1992#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dreid.nl\\\/?p=1992\"},\"author\":{\"name\":\"Tobias\",\"@id\":\"https:\\\/\\\/dreid.nl\\\/#\\\/schema\\\/person\\\/724765ca445bdd176b5dfa6f0f432741\"},\"headline\":\"Creating a map of Covid cases per municipality in QGIS\",\"datePublished\":\"2022-01-21T17:34:31+00:00\",\"dateModified\":\"2022-01-22T08:38:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/dreid.nl\\\/?p=1992\"},\"wordCount\":362,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/dreid.nl\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/dreid.nl\\\/?p=1992#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dreid.nl\\\/wp-content\\\/uploads\\\/2022\\\/01\\\/covidmap.png\",\"keywords\":[\"QGIS\"],\"articleSection\":[\"Blog\"],\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/dreid.nl\\\/?p=1992#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/dreid.nl\\\/?p=1992\",\"url\":\"https:\\\/\\\/dreid.nl\\\/?p=1992\",\"name\":\"Creating a map of Covid cases per municipality in QGIS - DreiD BV\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dreid.nl\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/dreid.nl\\\/?p=1992#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/dreid.nl\\\/?p=1992#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dreid.nl\\\/wp-content\\\/uploads\\\/2022\\\/01\\\/covidmap.png\",\"datePublished\":\"2022-01-21T17:34:31+00:00\",\"dateModified\":\"2022-01-22T08:38:03+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/dreid.nl\\\/?p=1992#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/dreid.nl\\\/?p=1992\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\\\/\\\/dreid.nl\\\/?p=1992#primaryimage\",\"url\":\"https:\\\/\\\/dreid.nl\\\/wp-content\\\/uploads\\\/2022\\\/01\\\/covidmap.png\",\"contentUrl\":\"https:\\\/\\\/dreid.nl\\\/wp-content\\\/uploads\\\/2022\\\/01\\\/covidmap.png\",\"width\":831,\"height\":835},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/dreid.nl\\\/?p=1992#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/dreid.nl\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Creating a map of Covid cases per municipality in QGIS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/dreid.nl\\\/#website\",\"url\":\"https:\\\/\\\/dreid.nl\\\/\",\"name\":\"DreiD BV\",\"description\":\"3D printen en meer\",\"publisher\":{\"@id\":\"https:\\\/\\\/dreid.nl\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/dreid.nl\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-NL\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/dreid.nl\\\/#organization\",\"name\":\"DreiD B.V.\",\"url\":\"https:\\\/\\\/dreid.nl\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\\\/\\\/dreid.nl\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"http:\\\/\\\/dreid.nl\\\/wp-content\\\/uploads\\\/2017\\\/11\\\/cropped-logo-vierkant.png\",\"contentUrl\":\"http:\\\/\\\/dreid.nl\\\/wp-content\\\/uploads\\\/2017\\\/11\\\/cropped-logo-vierkant.png\",\"width\":512,\"height\":512,\"caption\":\"DreiD B.V.\"},\"image\":{\"@id\":\"https:\\\/\\\/dreid.nl\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/DreiDBV\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/dreid.nl\\\/#\\\/schema\\\/person\\\/724765ca445bdd176b5dfa6f0f432741\",\"name\":\"Tobias\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/da384b41c29915cbc57151669bfd69215048a0d4cebed631ab35a6f893826870?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/da384b41c29915cbc57151669bfd69215048a0d4cebed631ab35a6f893826870?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/da384b41c29915cbc57151669bfd69215048a0d4cebed631ab35a6f893826870?s=96&d=mm&r=g\",\"caption\":\"Tobias\"},\"url\":\"https:\\\/\\\/dreid.nl\\\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Creating a map of Covid cases per municipality in QGIS - DreiD BV","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dreid.nl\/?p=1992","og_locale":"nl_NL","og_type":"article","og_title":"Creating a map of Covid cases per municipality in QGIS - DreiD BV","og_description":"Since the beginning of Covid-19, I’ve from time to time downloaded the official Dutch Covid-19 statistics (available here) and created my own plots, using a Jupyter Python notebook that you can find over on Github. But it’s also interesting to view maps instead of only timeline plots. Unfortunately, the official map shown on the Coronadashboard […]","og_url":"https:\/\/dreid.nl\/?p=1992","og_site_name":"DreiD BV","article_publisher":"https:\/\/www.facebook.com\/DreiDBV","article_published_time":"2022-01-21T17:34:31+00:00","article_modified_time":"2022-01-22T08:38:03+00:00","og_image":[{"width":831,"height":835,"url":"http:\/\/dreid.nl\/wp-content\/uploads\/2022\/01\/covidmap.png","type":"image\/png"}],"author":"Tobias","twitter_card":"summary_large_image","twitter_misc":{"Geschreven door":"Tobias","Verwachte leestijd":"2 minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dreid.nl\/?p=1992#article","isPartOf":{"@id":"https:\/\/dreid.nl\/?p=1992"},"author":{"name":"Tobias","@id":"https:\/\/dreid.nl\/#\/schema\/person\/724765ca445bdd176b5dfa6f0f432741"},"headline":"Creating a map of Covid cases per municipality in QGIS","datePublished":"2022-01-21T17:34:31+00:00","dateModified":"2022-01-22T08:38:03+00:00","mainEntityOfPage":{"@id":"https:\/\/dreid.nl\/?p=1992"},"wordCount":362,"commentCount":0,"publisher":{"@id":"https:\/\/dreid.nl\/#organization"},"image":{"@id":"https:\/\/dreid.nl\/?p=1992#primaryimage"},"thumbnailUrl":"https:\/\/dreid.nl\/wp-content\/uploads\/2022\/01\/covidmap.png","keywords":["QGIS"],"articleSection":["Blog"],"inLanguage":"nl-NL","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dreid.nl\/?p=1992#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dreid.nl\/?p=1992","url":"https:\/\/dreid.nl\/?p=1992","name":"Creating a map of Covid cases per municipality in QGIS - DreiD BV","isPartOf":{"@id":"https:\/\/dreid.nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dreid.nl\/?p=1992#primaryimage"},"image":{"@id":"https:\/\/dreid.nl\/?p=1992#primaryimage"},"thumbnailUrl":"https:\/\/dreid.nl\/wp-content\/uploads\/2022\/01\/covidmap.png","datePublished":"2022-01-21T17:34:31+00:00","dateModified":"2022-01-22T08:38:03+00:00","breadcrumb":{"@id":"https:\/\/dreid.nl\/?p=1992#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dreid.nl\/?p=1992"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/dreid.nl\/?p=1992#primaryimage","url":"https:\/\/dreid.nl\/wp-content\/uploads\/2022\/01\/covidmap.png","contentUrl":"https:\/\/dreid.nl\/wp-content\/uploads\/2022\/01\/covidmap.png","width":831,"height":835},{"@type":"BreadcrumbList","@id":"https:\/\/dreid.nl\/?p=1992#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dreid.nl\/"},{"@type":"ListItem","position":2,"name":"Creating a map of Covid cases per municipality in QGIS"}]},{"@type":"WebSite","@id":"https:\/\/dreid.nl\/#website","url":"https:\/\/dreid.nl\/","name":"DreiD BV","description":"3D printen en meer","publisher":{"@id":"https:\/\/dreid.nl\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dreid.nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-NL"},{"@type":"Organization","@id":"https:\/\/dreid.nl\/#organization","name":"DreiD B.V.","url":"https:\/\/dreid.nl\/","logo":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/dreid.nl\/#\/schema\/logo\/image\/","url":"http:\/\/dreid.nl\/wp-content\/uploads\/2017\/11\/cropped-logo-vierkant.png","contentUrl":"http:\/\/dreid.nl\/wp-content\/uploads\/2017\/11\/cropped-logo-vierkant.png","width":512,"height":512,"caption":"DreiD B.V."},"image":{"@id":"https:\/\/dreid.nl\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DreiDBV"]},{"@type":"Person","@id":"https:\/\/dreid.nl\/#\/schema\/person\/724765ca445bdd176b5dfa6f0f432741","name":"Tobias","image":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/secure.gravatar.com\/avatar\/da384b41c29915cbc57151669bfd69215048a0d4cebed631ab35a6f893826870?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/da384b41c29915cbc57151669bfd69215048a0d4cebed631ab35a6f893826870?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/da384b41c29915cbc57151669bfd69215048a0d4cebed631ab35a6f893826870?s=96&d=mm&r=g","caption":"Tobias"},"url":"https:\/\/dreid.nl\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/dreid.nl\/index.php?rest_route=\/wp\/v2\/posts\/1992","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dreid.nl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dreid.nl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dreid.nl\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dreid.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1992"}],"version-history":[{"count":2,"href":"https:\/\/dreid.nl\/index.php?rest_route=\/wp\/v2\/posts\/1992\/revisions"}],"predecessor-version":[{"id":1998,"href":"https:\/\/dreid.nl\/index.php?rest_route=\/wp\/v2\/posts\/1992\/revisions\/1998"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dreid.nl\/index.php?rest_route=\/wp\/v2\/media\/1996"}],"wp:attachment":[{"href":"https:\/\/dreid.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1992"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dreid.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1992"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dreid.nl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1992"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}