View table

Identifier AggregatedDataByWaterBody
Short name AggregatedDataByWaterBody
Dataset WISE SoE - Water Quality
Reference URL http://dd.eionet.europa.eu/datasets/latest/WISE-SoE_WaterQuality/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 the fields "waterBodyIdentifier", "waterBodyIdentifierScheme", "observedPropertyDeterminandCode", "procedureAnalysedFraction", "procedureAnalysedMedia" and "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 2016 Spatial data flows.

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

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 calculation only, it must be replaced with a value equivalent to HALF THE LIMIT OF QUANTIFICATION value;

- If the calculated annual mean value of the measurements results is below the limit of quantification value, then report the limit of quantification value in the "resultMeanValue" field and set 'True' (or '1') in the boolean "resultQualityMeanBelowLOQ" field. Use the same rule when reporting minimum, maximum and median values. If the samples in the aggregation had different limits of quantification, then the highest of the different LOQ values must be used in these cases.

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

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  (PK) string Vocabulary
* Determinand code (observedPropertyDeterminandCode) C  (PK) string Vocabulary
* Analysed fraction (procedureAnalysedFraction) C  (PK) string Fixed values
* Analysed media (procedureAnalysedMedia) C  (PK) string Fixed values
* 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)