Create an Animated Choropleth Map
3. Prepare Data Tables
We're going to use open data from Our World in Data. Their goal is to make the knowledge on the big problems accessible and understandable. Have a look at the website and search for water related themes.
For this tutorial we're going to download a data table with trends in access to improved water sources. Improved water resources are defined as “piped water on premises (piped household water connection located inside the user’s dwelling, plot or yard), and other improved drinking water sources (public taps or standpipes, tube wells or boreholes, protected dug wells, protected springs, and rainwater collection).”
2. Explore the data om the page and make sure you understand what you're going to download.
3. Click the Download tab and download the Full data (CSV) to the folder where you store the data for this tutorial.
4. Open the file with Notepad. It is good practice to check the data and the column separator in a text editor, before using the data in a GIS.
5. Go to the QGIS Browser panel and drag the CSV file to the accesstowater.gpkg to import it.
6. Drag the number-without-improved-water layer from the GeoPackage in the Browser panel to the map canvas.
The (non-spatial) layer is now added to the the Layers panel.
7. Open the attribute table and check the contents.
Because the table only has the number of people without access to improved water sources we need to download population data to normalize and calculate the percentage of the population per country without access to improved water sources. Only then we can compare countries.
8. Download the population data from here: https://ourworldindata.org/grapher/population
9. Repeat steps 4 - 7 and import the data to the accesstowater.gpkg.
10. Save your project in the accesstowater.gpkg
In the next section we're going to join the population data with the data on the number of people without access to improved water sources.