Data cleaning and analysis for the ICP Waters Programme.
Getting to grips with the ICPW database and recoding/extending Tore's original work on TOC trends.
-
Database clean-up. Identifying and fixing issues with the ICPW database identified during 2016
-
Trend analyses. Estimate trends using data from 1990 to 2012
A major review of the ICPW database was undertaken during 2018/19. The work can be divided into two components: (i) a expanded analysis comprising 430 "TOC trends" stations, with the aim of updating the work published in 2007; and (ii) a clean-up of the ~260 "core" ICP Waters stations, with the aim of writing a more general "Thematic Report" on TOC trends during 2019.
For the broader "TOC Trends" work, a new project was created, site selections were reviewed and datasets expanded to cover the period 1990 to 2016. Trends were then recalculated using the improved datasets.
A selection of tidied/processed datasets used in the subsequent analysis is here.
Data for the "core" ICP Waters project(s) was first reviewed and tidied, and then checked for consistency with the data provided for the broader trends paper (above). Corrections were made as necessary, including replacing/substituting stations in some countries in order to make use of the best long-term monitoring datasets currently available.
-
Update "trends" dataset. The latest work using the "trends" dataset is documented above under the heading "TOC Trends paper"
-
Update "core" dataset. Adding recent data for the "core" stations and dealing with data issues
-
Combining the "core" and "trends" datasets. An overview of the unified ICPW dataset of 556 stations
-
Scatterplots of annual data. A high-level overview of the raw data, aggregated to annual medians
-
Stations with high frequency monitoring. Ten stations have substantially more detailed monitoring than the others (approximately 25 to 100 samples per year from 1990 to 2016). This notebook performs trend and change point analyses based on monthly data, using algorithms that are too "data hungry" to be applied elsewhere
-
Stations with "standard" monitoring. Trend and change point analyses using annually aggregated data
-
Summary of work for Task Force meeting. An overview of the analysis prior to the Task Force meeting in Helsinki in June 2019