@@ -18,10 +18,9 @@ To make the database also useful to manage data which needs to be reported under
The environmental compartments foreseen at the moment (extension is possible) and depicted in different schemata are:
- Surface water: Data from rivers, lakes and reservoirs including concentrations in the liquid phase, suspended particulate matter and biota (for WISE compatibility).
- Groundwater: Concentrations measured in springs and wells.
- Wastewater (ww): Concentrations in municipal and industrial wastewater treated and untreated.
- Sewage sludge (swsl): Concentrations in different kinds of sewage sludge.
- Wastewater (ww): Concentrations in municipal and industrial wastewater treated and untreated and in different kinds sewage sludge.
- Stromwater runoff (stw): Concentrations in stormwater runoff from urban surfaces sampled from storm sewers in the separate sewer system and combined sewer overflows (CSO) in the combined sewer system. Untreated wastewater sampled during storm events from combined sewers might be stored here or in the wastewater section. Untreated wastewater from dry weather periods should be stored in the wastewater section.
- atmospheric deposition (ad): Deposition from the atmosphere onto surfaces. Given either as deposition rates (mass per area and time) or as concentration in a collection container which was collecting deposition for a certain period. To calculte deposition rates from these concentrations, the exposed collection area, the exposition time and the total sample volume need to be known.
- atmospheric deposition (ad): Deposition from the atmosphere onto surfaces. Given either as deposition rates (mass per area and time) or as concentration in a collection container which was collecting deposition for a certain period. To calculate deposition rates from these concentrations, the exposed collection area, the exposition time and the total sample volume need to be known.
- soil: Substance content in soil samples (usually topsoil) given in mass of a substance per dry matter mass of soil.
- sediment (sed): Substance content in bottom sediment samples.
...
...
@@ -46,10 +45,11 @@ All data are stored in the schema _hidden_, for user interaction they are presen
### Views
The same data are presented in different views for different purpose:
- For data import purpose only the columns which can be filled during data import are shown, additional columns filled automatically during data import are hidden here (e.g. the numerical id, the time of import and the user importing the data). Here only data created by the user itself are visible and only Data are visible in this views as long as they have not gone through the quality assessment workflow. These views are appended with the suffix __import_.
- For data import purpose only the columns which can be filled during data import are shown, additional columns filled automatically during data import are hidden here (e.g. the numerical id, the time of import and the user importing the data). Here only data created by the user itself are visible and only data are visible in this views as long as they have not gone through the quality assessment workflow. These views are appended with the suffix __import_.
- A different view on the data is available for the quality assessment for quality assessors. here some additional data are included (like the user who created the data set) and only the two columns regarding quality assessment (quality_check_passed, comments_quality_assessment) can be updated. These views are appended with the suffix __qa_.
- The data which were not acceppted by the quality assessor are presented in a further view to the tethys_user for correction or deletion. These views are appended with the suffix __qa_rejected_.
- View for data evaluation and extraction: ... filtered for quality checked data.
- The data which were not accepted by the quality assessor are presented in a further view to the tethys_user for correction or deletion. These views are appended with the suffix __qa_rejected_.
- To check all imported data independently of their quality assessment status, views without a suffix are available for every table. These Views are read-only, for changing or deleting data, please use the aforementioned views.
- View for data evaluation and extraction: In the schema _public_ quality checked data are combined to wide tables combining all collected information. They only miss columns which are recorded for data traceability, e.g. columns with the originally reported text strings, which were mapped on the controlled vocabularies.
## User rights management
User rights for working with the database depend on PostgreSQL roles. The following roles were defined:
