Published March 14, 2024 | Version 2.0.0
Dataset Open

Inventory of hazardous substance concentrations in different environmental compartments in the Danube river basin

  • 1. International Commission for the Protection of the Danube River (ICPDR)
  • 2. ROR icon Romanian Waters National Administration
  • 3. ROR icon Jožef Stefan Institute
  • 4. Water Research Institute (WRI), Slovakia
  • 5. Center for Eco-Toxicological Research Podgorica
  • 6. Bulgarian Water Association
  • 7. ROR icon TU Wien
  • 8. ROR icon Budapest University of Technology and Economics
  • 9. ROR icon Environment Agency Austria
  • 10. ROR icon University of Zagreb
  • 11. ROR icon Bayerisches Landesamt für Umwelt
  • 12. Josip Juraj Strossmayer Water Institute

Description

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.

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.

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.

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.

Files

documentation_inventory_db_V2.0.pdf
Files (53.6 MiB)
Name Size
md5:16d61e4ff362318ba0062b81decae6d6
97.2 KiB Preview Download
md5:4b40262535b1cd72f967dd3689616bd5
755.6 KiB Preview Download
md5:5e3cdf2b27dbfa1a79721e262194cef7
52.8 MiB Preview Download

Additional details

Created:
March 14, 2024
Modified:
March 14, 2024