WQQDB - water quality metrics for catchments across Germany


Authors: This resource does not have an author who is an active HydroShare user. Contact CUAHSI (help@cuahsi.org) for information on this resource.
Owners: This resource does not have an owner who is an active HydroShare user. Contact CUAHSI (help@cuahsi.org) for information on this resource.
Resource type: Composite Resource
Storage: The size of this resource is 246.5 KB
Created: Jun 08, 2020 at 5:10 p.m.
Last updated: Mar 16, 2021 at 4:16 p.m.
DOI: 10.4211/hs.9b4deeca259b4f7398ce72121b4e2979
Citation: See how to cite this resource
Sharing Status: Published
Views: 598
Downloads: 24
+1 Votes: Be the first one to 
 this.
Comments: No comments (yet)

Abstract

This repository provides metrics of water quality and quantity of 1386 German catchments based on time series of the
"WQQDB - water quality and quantity data base Germany" (Musolff, 2020) subsetting years from 2000 to 2015.
The data from this repository were created for Ebeling et al. (2021). Selection criteria and results are presented more in depth therein.
Natural and anthropogenic catchment characteristics are provided in another, linked repository "CCDB - catchment characteristics data base Germany" (https://doi.org/10.4211/hs.0fc1b5b1be4a475aacfd9545e72e6839). Both repositories use the same unique identifier OBJECTID for each water quality station.

This repository includes:

1.) Data table with unique identifier (OBJECTID), station name and calculated metrics of water quality dynamics for nitrate (NO3-N), phosphate (PO4-P) and total organic carbon (TOC). The metrics are mean concentrations, the slope b of the concentration (C) - discharge (Q) regression in logspace, the corresponding R2, and the ratio of the coefficients of variation CVC/CVQ. The data table also includes a flag "indep" for the independence of catchments (max. 20% area overlap with each of its subcatchments) including criteria (e.g. priority of C-Q catchments) as described in Ebeling et al. (2021). Accordingly 787 catchments are considered as independent.
2.) Readme file providing information on provided data.

Reference:
Ebeling, P., Kumar, R., Weber, M., Knoll, L., Fleckenstein, J. H., & Musolff, A. (2021). Archetypes and Controls of Riverine Nutrient Export Across German Catchments. Water Resources Research, 57, e2020WR028134. https://doi.org/10.1029/2020WR028134

Conditions: Please, reference both the original data publisher and this repository for correct acknowledgements, when using the provided data.

Subject Keywords

Resource Level Coverage

Spatial

Coordinate System/Geographic Projection:
WGS 84 EPSG:4326
Coordinate Units:
Decimal degrees
Place/Area Name:
Germany
North Latitude
55.0618°
East Longitude
16.5984°
South Latitude
46.3269°
West Longitude
4.3156°

Content

readme.txt

Provided data include:
OBJECTID - unique identifier
Station  - station name

the three major nutrients: 
NO3 - nitrate-N (NO3-N)
PO4 - orthophosphate-P (PO4-P)
TOC - total organic carbon

variables calculated from WQQDB data starting in the year 2000:
n       - number of samples
mean    - mean concentration
cv      - coefficient of variation
f_cens  - fraction of left-censored samples (below the detection limit)
b       - slope b of linear regression between concentration and discharge in logspace
R2      - coefficient of determination of C-Q regression
cvC_cvQ - ratio of the coefficients of variation of concentration and discharge
indep   - catchments recognized as independent catchments (1-true) following criteria as presented in Ebeling et al. (2021)

reference: 
Ebeling, P., Kumar, R., Weber, M., Knoll, L., Fleckenstein, J. H., & Musolff, A. (2021). Archetypes and Controls of Riverine Nutrient Export Across German Catchments. Water Resources Research, 57, e2020WR028134. https://doi.org/10.1029/2020WR028134 

Related Resources

The content of this resource was created by a related App or software program https://doi.org/10.1029/2020WR028134
The content of this resource references https://doi.org/10.4211/hs.a42addcbd59a466a9aa56472dfef8721
The content of this resource references http://www.ufz.de/record/dmp/archive/7754
The content of this resource references https://doi.org/10.4211/hs.0fc1b5b1be4a475aacfd9545e72e6839
The content of this resource is derived from http://www.ufz.de/record/dmp/archive/7754
The content of this resource is derived from https://doi.org/10.4211/hs.a42addcbd59a466a9aa56472dfef8721

Credits

Contributors

People or Organizations that contributed technically, materially, financially, or provided general support for the creation of the resource's content but are not considered authors.

Name Organization Address Phone Author Identifiers
Andreas Musolff UFZ - Helmholtz-Centre for Environmental Research GmbH

How to Cite

Ebeling, P. (2021). WQQDB - water quality metrics for catchments across Germany, HydroShare, https://doi.org/10.4211/hs.9b4deeca259b4f7398ce72121b4e2979

This resource is shared under the Creative Commons Attribution CC BY.

http://creativecommons.org/licenses/by/4.0/
CC-BY

Comments

There are currently no comments

New Comment

required