Dataset of predicted daily nutrient concentrations for NO3-N and TP for 150 monitoring stations along 60 German rivers

DOI

The main component of this data publication is a dataset of predicted daily nutrient concentrations for NO3-N and TP for 150 monitoring stations along 60 German rivers (main rivers). The aim of this dataset is to fill the data gap of daily nutrient concentrations for a better understanding of nutrient transport from the rivers to the seas. So far, nutrient concentrations are sampled on a fortnightly basis, which can be insufficient for nutrient retention models working on a daily basis. With this method and available datasets, river basin managers have the opportunity to look at nutrient concentrations or load patterns on a finer resolution to adapt their management to improve water quality.

The dataset was obtained by a random forest model (RF) based on measured NO3-N and TP concentrations between the years 2000 and 2019. The data was requested or where available downloaded from official websites of the Federal States or River Basins. Different variables for NO3-N and TP were finally considered in the models to produce the RF, like discharge, land use, day of the year.

The following data is found in the data download zip file:

Dataset as csv: Dataset of predicted daily nutrient concentrations for NO3-N and TP for 150 monitoring stations along 60 German rivers.

Figures as pdf: Comparison of predicted values based on different distributions (mean and mode) for annual cycles of NO3-N and TP concentrations and loads for 150 locations along 60 rivers in Germany.

Coding of monitoring stations as csv: The basic step for the analysis was finding pairs of gauges and water quality stations. These pairs were then coded and used in the model as ID. This coding file contains the names of monitoring stations and gauges for each ID as well as the number of NO3-N, TP concentrations, discharges and years applied.

Variable importance as figure and explanation as csv: Several RF variants with different sets of variables were built. Starting with 11 variables and iteratively considering which were most important. Variables are explained in a csv and their importance for each variant is shown in the figure.

Random Forests for TP and NO3-N as R.data: The best performing Random Forests for NO3-N (variant 7) and TP (variant 1) are stored as R.data files for further application.

Identifier
DOI https://doi.org/10.5880/fidgeo.2023.007
Related Identifier https://www.gkd.bayern.de/de/fluesse/chemie
Related Identifier https://www.gkd.bayern.de
Related Identifier https://www.bafg.de/DE/08_Ref/M2/03_Fliessgewmod/01_FLYS/flys_node.html
Related Identifier https://geoportal.bafg.de/swe-client/
Related Identifier https://undine.bafg.de/
Related Identifier https://doi.bafg.de/BfG/2014/BfG-1650.pdf
Related Identifier https://portal.grdc.bafg.de/applications/public.html?publicuser=PublicUser#dataDownload/Stations
Related Identifier https://www.hlnug.de/themen/wasser/fliessgewaesser/fliessgewaesser-chemie/standardparameter/landesweite-messungen
Related Identifier https://www.elwasweb.nrw.de
Related Identifier https://gda-wasser.rlp-umwelt.de/GDAWasser/client/gisclient/index.html?applicationId=12344
Related Identifier https://pegelportal.brandenburg.de/home/-/bereich/pegeldaten/5827000
Related Identifier http://www.hochwasser-rlp.de/karte/einzelpegel/flussgebiet/mosel/pegel/FREMERSDORF
Related Identifier https://udo.lubw.baden-wuerttemberg.de
Related Identifier https://www.hvz.baden-wuerttemberg.de/
Related Identifier https://www.dgj.de/
Related Identifier https://www.elwasweb.nrw.de/elwas-web/index.xhtml#
Related Identifier http://www.wasserdaten.niedersachsen.de/cadenza/pages/selector/index.xhtml
Related Identifier https://geodaten-wasser.rlp-umwelt.de/prj-wwvauskunft/projects/messstellen/wasserstand/register3.jsp?intern=true%26msn=2540005400%26pegelname=Heimbach+Bhf.%26gewaesser=Nahe%26dfue=1
Related Identifier https://www.wasser.sachsen.de/gewaesserguetedaten-9343.html
Related Identifier https://www.umwelt.sachsen.de/umwelt/infosysteme/ida/
Related Identifier https://www.umwelt.sachsen.de/umwelt/infosysteme/mnqhq-regio/website/
Related Identifier https://hnz.thueringen.de/hw-portal/
Related Identifier https://www.umweltbundesamt.de/sites/default/files/medien/1968/dokumente/chemische_guteklassifikation.pdf
Metadata Access http://doidb.wdc-terra.org/oaip/oai?verb=GetRecord&metadataPrefix=oai_datacite&identifier=oai:doidb.wdc-terra.org:7743
Provenance
Creator Natho, Stephanie ORCID logo; Sieg, Tobias ORCID logo
Publisher GFZ Data Services
Contributor Natho, Stephanie; Sieg, Tobias; Natho; Sieg
Publication Year 2023
Funding Reference Deutsche Forschungsgemeinschaft, 390612937
Rights CC BY 4.0; http://creativecommons.org/licenses/by/4.0/
OpenAccess true
Contact Natho, Stephanie (University of Potsdam, Potsdam, Germany); Sieg, Tobias (University of Potsdam, Potsdam, Germany); Natho (University of Potsdam, Potsdam, Germany); Sieg (University of Potsdam, Potsdam, Germany)
Representation
Resource Type Dataset
Discipline Chemistry; Natural Sciences
Spatial Coverage (6.406W, 47.095S, 14.711E, 54.184N); The data comprises main rivers in Germany with data between the years 2000 and 2019
Temporal Coverage Begin 2000-01-01T00:00:00Z
Temporal Coverage End 2019-12-31T00:00:00Z