You are here:
Eionet
Data Dictionary
Dataset table

View table

There are 0 QA scripts and 0 conversion scripts registered for this table.
Identifier AggregatedDataByWaterBody
Short name AggregatedDataByWaterBody
Dataset WISE SoE - Water Quality ICM
Reference URL http://dd.eionet.europa.eu/datasets/latest/WISE-SoE_WaterQualityICM/tables/AggregatedDataByWaterBody
Name Annual statistics data by water body
Short Description Annual mean values and other statistics of determinands on water quality, by water body.
Definition Annual mean values and other statistics of determinands on water quality, by water body.
Methodology for obtaining data Annually aggregated data by groundwater body is accepted only for selected determinands – nitrate, nitrite, ammonium and dissolved oxygen – although reporting of these determinands in the disaggregated data structure is strongly preferred.

Each record in this table must have a unique combination of the values in these fields (no duplicates can exist):
- waterBodyIdentifier
- waterBodyIdentifierScheme
- observedPropertyDeterminandCode
- procedureAnalysedMatrix
- phenomenonTimeReferenceYear

The water body is uniquely identified by combination of values in the fields "waterBodyIdentifier" and "waterBodyIdentifierScheme".
The water body identifier should be present in the list of water bodies (http://dd.eionet.europa.eu/vocabulary/wise/WaterBo...) that is kept updated with the data reported under the WISE Spatial Data and/or the WFD 2022 Spatial data flows.

Select the adequate unit of measure according to the type of the determinand.

The aggregation to annual mean and median for the water body should consist of two phases: first, calculate the annual mean and median values by monitoring site; then use the results to calculate the annual mean and median values by water body. Using this approach, the influence of different number of sample at monitoring site level is eliminated.

The annual minimum and maximum are set as the minimum or maximum sample value, respectively, i.e. the minimum or maximum sample value across all monitoring sites in the water body for the specific year.

When preparing annually aggregated data, sample concentrations below the limits of quantification must be treated in accordance to the QA/QC Directive (Commission directive 2009/90/EC of 31 July 2009 laying down, pursuant to Directive 2000/60/EC of the European Parliament and of the Council, technical specifications for chemical analysis and monitoring of water status):

- If a sample concentration value is below the limit of quantification, then, for the mean value per monitoring site calculation only, it must be replaced with a value equivalent to HALF THE LIMIT OF QUANTIFICATION value. Then, use this value in the subsequent calculation of the annual mean value per water body;

- If the calculated annual mean value per water body is below the limit of quantification value set for the aggregated record, then report the limit of quantification value set for the aggregated record in the "resultMeanValue" field and set 'True' (or '1') in the boolean "resultQualityMeanBelowLOQ" field. If the samples in the aggregation had different limits of quantification, then the highest of the different LOQ values from samples below LOQ, must be used in these cases. Where all sample values are above or equal to LOQ, while the mean value is below the aggregated LOQ set for the aggregated record (which is the highest of the sample LOQs when all values are above or equal to their LOQ), the original mean value is reported and the mean is set as not being below LOQ. Report minimum, maximum and median values in the same way, but here the values are evaluated against the limit of quantification of the sample value.

Elements

Element name Datatype Element type
* Water body identifier (waterBodyIdentifier) C  (PK) string Quantitative
* Water body identifier scheme (waterBodyIdentifierScheme) C  (PK) string Fixed values
* Water body category code (parameterWaterBodyCategory) C string Vocabulary
* Determinand code (observedPropertyDeterminandCode) C  (PK) string Vocabulary
* Analysed matrix (procedureAnalysedMatrix) C  (PK) reference Vocabulary
* Unit of measure (resultUom) C reference Vocabulary
* Reference period (year) (phenomenonTimeReferenceYear) C  (PK) integer Quantitative
Sampling period (parameterSamplingPeriod) C string Quantitative
Limit of quantification (procedureLOQValue) C float Quantitative
* Number of samples (resultNumberOfSamples) C integer Quantitative
Number of samples below LOQ (resultQualityNumberOfSamplesBelowLOQ) C integer Quantitative
* Minimum value below LOQ (resultQualityMinimumBelowLOQ) C boolean Fixed values
* Minimum value (resultMinimumValue) C float Quantitative
* Mean value below LOQ (resultQualityMeanBelowLOQ) C boolean Fixed values
* Mean value (resultMeanValue) C float Quantitative
* Maximum value below LOQ (resultQualityMaximumBelowLOQ) C boolean Fixed values
* Maximum value (resultMaximumValue) C float Quantitative
* Median value below LOQ (resultQualityMedianBelowLOQ) C boolean Fixed values
* Median value (resultMedianValue) C float Quantitative
Sample standard deviation value (resultStandardDeviationValue) C float Quantitative
Number of sites in Class 1 (resultNumberOfSitesClass1) C integer Quantitative
Number of sites in Class 2 (resultNumberOfSitesClass2) C integer Quantitative
Number of sites in Class 3 (resultNumberOfSitesClass3) C integer Quantitative
Number of sites in Class 4 (resultNumberOfSitesClass4) C integer Quantitative
Number of sites in Class 5 (resultNumberOfSitesClass5) C integer Quantitative
Observation status flag (resultObservationStatus) C string Fixed values
Remarks (Remarks) C string Quantitative
(an asterisk in front of element name indicates that the element is mandatory in this table)
(the C sign marks a common element)