View table

There are 1 QA scripts and 4 conversion scripts registered for this table.
Link to the schema page on XMLCONV
Identifier DisaggregatedData
Short name DisaggregatedData
Dataset WISE SoE - Water Quality
Reference URL
Name Sample data by monitoring site
Short Description Raw disaggregated data on the observed values (e.g. concentrations) of determinands.
Definition Raw disaggregated water quality data on the observed values (e.g. concentrations) of determinands in rivers, lakes and groundwater as reported by EEA Member Countries on an annual basis.
Methodology for obtaining data Disaggregated data should be reported for hazardous substances in rivers or lakes and for all determinands in groundwater.

Each record in this table must have a unique combination of the values in the fields "monitoringSiteIdentifier", "monitoringSiteIdentifierScheme", "observedPropertyDeterminandCode", "procedureAnalysedFraction", "procedureAnalysedMedia" and "phenomenonTimeSamplingDate".

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.

If the measured concentration is below the limit of quantification, then report the limit of quantification value in the "Observed Value" field and report 'True' in the boolean "resultQualityObservedValueBelowLOQ" field.

Fields "procedureAnalyticalMethod" and "parameterSampleDepth" are mandatory for rivers and lakes data.


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  (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
* Sampling time (date) (phenomenonTimeSamplingDate) C  (PK) date Quantitative
* Observed value (resultObservedValue) C decimal Quantitative
* Observed value below LOQ (resultQualityObservedValueBelowLOQ) C boolean Fixed values
Limit of quantification (procedureLOQValue) 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)