This notebook summarises the work done so far in preparation for the Task Force meeting in Helsinki in June.
The ICPW programme comprises two main datasets: a "core" selection of 264 stations and a broader "trends" grouping of 432 stations (as of May 2019). These are organised separately in the database, but with some duplication that makes processing a little awkward/messy. These two datasets overlap, such that there are currently 556 unique stations within the programme as a whole.
Analysis for the Thematic Report initially considered data from all 556 stations, but selection criteria have been applied for checking time series length and completeness (see below). The results so far are therefore based (hopefully!) on a high quality subset of the full dataset.
Where stations are present in both the "core" and "trends" datasets, I have preferentially chosen to work with data from the "trends" stations. This is because these stations have already been through several iterations of quality control for the TOC Trends paper drafted by Heleen, Don and John.
The main time period of interest is 1990 to 2016. To be comnsidered in the analysis, each series for each staion and parameter must begin before 1995, end after 2011 and be at least 75% complete in the interval between these years. Completeness is assessed based on monthly resampled values for rivers and seasonal (i.e. quarterly) resampled values for lakes. The justification for this is that robust annual estimates of concentration for lakes can be obtained more easily than for rivers (i.e about 4 samples per year are required for lakes compared to ~12 for rivers).
Using these criteria, 231 stations have at least some relevant data, although only a few of these have suitable records for all the parameters of interest.
The following parameters have been considered (calculated from the raw data as required):
Corrections (denoted by X) are calculated as
Where $\left( \frac{EPar}{ECl} \right)_{ref}$ is a reference ratio assumed to be constant for all locations:
| Species | Molar mass | Valency | Ref. ratio |
|---|---|---|---|
| SO4 | 96 | 2 | 0.103 |
| Cl | 35 | 1 | 1 |
| Ca | 40 | 2 | 0.037 |
| Mg | 24 | 2 | 0.196 |
| NO3-N | 14 | 1 | N/A |
Note: Using the same reference ratios everywhere produces some strange effects, especially in countires like Germany or the Czech Republic where chloride is not necessarily marine. This probably needs revisiting as the "one-size-fits-all" approach taken here is clearly not appropriate in some locations.
The following notebooks describe different stages of the analysis so far:
Update "trends" dataset. The latest work using the "trends" dataset is documented here 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 for the 231 stations with time series matching the criteria defined in section 2, above