FOTO-NL chemical pollution monitoring data for Dutch surface waters
Year: 2026
Type: article
Abstract: FOTO-NL chemical pollution monitoring data for Dutch surface waters This archive contains the data products underlying the FOTO-NL workflow for long-term analysis of chemical pollution in Dutch surface waters. The data were collated from the 21 current Dutch regional water boards and from Rijkswaterstaat for the rivers Rhine and Meuse. The dataset covers the Netherlands and the period from 1954-01-14 to 2020-01-08. The package contains both the final harmonized datasets and the supporting input/output bundles needed to reproduce the workflow. The workflow starts from heterogeneous provider-specific raw files, reconstructs standardized per-board input tables in script_0, harmonizes and cleans the data in script_1, applies Dutch spatial filtering in script_2, and generates summary statistics and example outputs in script_3. The two main final datasets are provided directly as CSV files: foto_nl_dataset_raw.csv: broader raw-derived collated dataset with 51,557,114 records foto_nl_dataset_clean.csv: cleaned and harmonized dataset with 35,756,662 records containing only those measurements with valid CAS-numbers. In these files: Location identifiers and X and Y coordinates Sampling dates Parameter codes (Aquocodes) and CAS-numbers (added where missing) Sample pretreatment flags (e.g. filtered vs unfiltered) Measured values and original units Archive contents water_board_data_script_0_input.zipOriginal raw board-delivered input tree used as input to script_0. This archive contains the heterogeneous source exports received from the 21 Dutch water boards, including CSV files, text exports, Excel workbooks, and provider-delivered zip bundles. These are the original source files used to reconstruct the standardized per-board inputs. auxiliary_workflow_input.zipAuxiliary workflow inputs that are not part of the original raw provider delivery tree. This archive includes supplementary coordinate files, Rijkswaterstaat support workbooks, the Dutch boundary file used in spatial filtering, and board-specific lookup and adjustment tables used during script_0. Examples include parameter lookup tables for Rivierenland, Rijnland, Scheldestromen, and Hollands Noorderkwartier, as well as SI_2_table.xlsx which contains CAS-codes for innitially unrecognized substances. workflow_outputs/script_0_output.zipStandardized per-board outputs produced by script_0. For each board, this archive contains a board_input.csv file. These files are the direct outputs of script_0 and the direct inputs to script_1. workflow_outputs/foto_nl_dataset_raw.csvBroader raw-derived final dataset, provided as plain CSV for direct reuse. It preserves the full collated record set after workflow reconstruction and spatial processing, including physicochemical variables and other measurements that are not retained in the final cleaned subset. workflow_outputs/foto_nl_dataset_clean.csvCleaned and harmonized final dataset, provided as plain CSV for direct reuse. This dataset contains the workflow-standardized observations used for downstream analyses and reporting. workflow_outputs/rds_outputs.zipRDS versions of the two final datasets: foto_nl_dataset_raw.rds foto_nl_dataset_clean.rds workflow_outputs/summary_statistics.zipSummary tables and figures generated by script_3. This archive includes yearly counts of measurements, substances, and sample sites; water-board by year summaries; heatmaps; sample-day summaries; interquartile-range tables; and example plots for selected general chemistry, metals, and pesticides. workflow_outputs/example_pesticides_delfland.zipExample Delfland case-study outputs produced by PesticesDelfland.R. This archive includes compound-specific extracted datasets for chloride, nitrate, imidacloprid, and tolclofos-methyl; threshold values used in the plots; summary tables; and the generated point, violin, and GAM figures. MANIFEST.txtFile inventory for the Zenodo package contents. Notes The rendered workflow HTML reports are distributed with the accompanying GitHub repository https://github.com/rivm-syso/FOTO-NL, not with this Zenodo data package. Original board-delivered files and workflow helper files are intentionally separated: original source data are stored in water_board_data_script_0_input.zip lookup tables and helper files are stored in auxiliary_workflow_input.zip
Authors: Hofman, Thomas, Posthuma, Leo
Language: English
Subfield: Water Science and Technology
Field: Environmental Science
Domain: Physical Sciences
Open Access status: green
OpenAlex ID: W7154234070
FWCI:
Cites:
Cited by:
Related to: