You are here:
Eionet
Data Dictionary
Dataset table

View table

There are 0 QA scripts and 0 conversion scripts registered for this table.
Identifier AggregatedData
Short name AggregatedData
Dataset WISE SoE - Water Quality ICM
Reference URL http://dd.eionet.europa.eu/datasets/latest/WISE-SoE_WaterQualityICM/tables/AggregatedData
Name Annual statistics data by monitoring site
Short Description Annual mean values and other statistics of determinands on water quality, by monitoring site.
Definition Annual mean values and other statistics of determinands on water quality, by monitoring site.
Methodology for obtaining data Annually aggregated data by monitoring site should be reported if disaggregated data is not available for reporting (e.g. for nutrients and selected biological determinands in rivers or lakes). Reporting of annually aggregated is allowed also for hazardous substances in rivers and lakes, although reporting of disaggregated data is strongly preferred.

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

The monitoring site is uniquely identified by combination of values in the fields "monitoringSiteIdentifier" and "monitoringSiteIdentifierScheme".
The monitoring site identifier should be present in the list of monitoring sites (http://dd.eionet.europa.eu/vocabulary/wise/Monitor...) 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.

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 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
* Monitoring site identifier (monitoringSiteIdentifier) C  (PK) string Quantitative
* Monitoring site identifier scheme (monitoringSiteIdentifierScheme) 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
CEN/ISO analytical method code (procedureAnalyticalMethod) C string Quantitative
* Sample depth (parameterSampleDepth) C  (PK) float 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)