Water, sanitation and climate data resources
This list of resources has been updated for #WRCHack2019 https://wrchack.github.io/ and #WRCHack4Water 2020
National Integrated Water Information System (NIWIS) provides access to many of the DWS datasets. The various dashboards allow you to download a CSV or EXCEL file, some have historical data. Examples include:
- Use the "Filter Options" button to select data from 2016 to 2020
- Click on the Province + to expand provincial data to municipal level
- Download the CSV file
- Note that the data is presented as a %: the total number of samples taken over the period/ number of failed samples (hover your mouse over the cell to see values). So to analyse trends over time, you will need to select smaller time periods (e.g. month or year) then download these individually. (Let us know if you see a better way to do this!)
Spatial data on water resources: can be accessed from RQIS. Includes the location and boundaries for drainage regions, water management areas, rivers, dams, lakes and lagoons. Most data is available as KMZ file type which can be converted to GeoJSON or similar using an online tool like Geoconverter. Then you can visualise them in an online tool like Kepler or download and install QGIS.
Water Resources of South Africa, 2012 Study (WR2012) data: Extensive source of data on "GIS maps, WRSM2000 (Pitman) rainfall-runoff model, WR2005 database, Reports, Quaternary data spreadsheets, Patched observed streamflow data, Catchment rainfall groups, Catchment based rainfall, Point rainfall, Naturalised streamflow, Water quality, Monitoring, Land/water use, Present day streamflow and Reservoir records." Free registration to download the data.
The previous Department of Rural Development and Land Reform (DRDLR) - now Department of Agriculture, Land Reform and Rural Development (DALRRD) - hosts the SASDI portal which provides various water-related datasets. As many of these are spatial datasets in SHP file format, you will need to convert and use them as noted above.
miniSASS: "The most important feature of the new website is the miniSASS Map, which allows you to explore your catchment, find your river, look at any existing miniSASS results and then upload your own miniSASS results! The map also lets you explore your catchment to see the land uses and activities that might be improving or worsening water quality."
Statistics South Africa collects data on the availability of sanitation at household level in different municipalities. This is done through:
- Municipal reporting on the provision of services in the Non-financial Census of Municipalities. See Table 8 for water supply and Table 9 for toilet facilities. You can download the summary PDF report as well as the XLSX ‘unit data’ from 2005 to 2018.
However, there is a pilot access to their data API which you can try - and decide if you would like to purchase a commercial subscription.
AfriGIS Weather API: "exposes the South African Weather Service (SAWS) data feeds as an Application Programming Interface (API). The API includes measurements, forecasts, thunderstorms, lightning and weather alerts"
The pilot access to API includes "fifty (50) credits per day, for a maximum of sixty (60) days"). Try this demo API GET to see what type of data is available:
The previous Department of Agriculture, Forestry and Fisheries (DAFF) - with the agriculture component now part of the Department of Agriculture, Land Reform and Rural Development (DALRRD) - operates a portal with various maps and datasets.
Some examples from the DAFF portal include:
The Global Terrestrial Network - Hydrology provides a useful list of major water-related data sources. This is useful for comparing South Africa to other countries, and over multiple years. Two examples:
The FAO AQUASTAT "core database provides the platform for organizing and presenting over 180 variables and indicators on water resources and their use which include water withdrawal, wastewater, pressure on water resources, irrigation and drainage, and few components on environment and health. They can be searched and extracted, along with their metadata, for 200+ countries and for different regions over an extensive-time period (from 1960 to 2017)": http://www.fao.org/nr/water/aquastat/data/query/index.html?lang=en
The GEMStat which allows you to "access GEMStat water quality data and to produce a statistical and graphical analysis of water quality data at station, country or catchment level." https://gemstat.bafg.de/applications/public.html?publicuser=PublicUser#gemstat/Stations