Description of the dataset
The data set contains an SQL-dump of a PostgreSQL data base. This data base contains concentrations of hazardous substances and other water quality parameters in different environmental compartments:
river water (water and suspended sediments)
ground water
waste water (treated and untreated) and sewage sludge
storm water runoff from combined and separate sewer systems
atmospheric deposition
soil
Data from many different data sources were collected, cheked and combined and meta data were harmonized to allow for a combined data evaluation.
Technical specifications
The SQL-file was exported from a PostgreSQL 15.2 data base and compressed using 7zip into a zip-file (dhm3cinventoryV2.zip).
Text-encoding is UTF-8.
Supplementary files
A short documentation (documentation_inventory_db_V2.0.pdf) and a listof known issues with the data which could not be resolved before publication (List_of_known_issues_V2.0.pdf) are enclosed as PDF files.
Versions
Version 2.0.1
During creation of Version 1.0.0 and 2.0.0 there was an processing error in the coordinates of atmospheric deposition and soil sampling sites leading to identical values for latitude and longitude for some sites. This was fixed in version 2.0.1.
Version 2.0.0
This Version 2.0.0 of the database contains more data as for further data sets a publication agreement was reached and some data were reimported to resolve some errors created during data preparation for import. The database structure was extended and corrected at different points, leading to an improved data model.