View table

There are 0 QA scripts and 4 conversion scripts registered for this table.
Link to the schema page on XMLCONV
Identifier AggregatedData
Short name AggregatedData
Dataset WISE SoE - Water Quality ICM
Reference URL
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 the fields "monitoringSiteIdentifier", "monitoringSiteIdentifierScheme", "observedPropertyDeterminandCode", "procedureAnalysedFraction", "procedureAnalysedMedia" and "phenomenonTimeReferenceYear".

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 ( 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.


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 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)