View table

Identifier	DisaggregatedData
Short name	DisaggregatedData
Dataset	WISE SoE - Water Quality
Reference URL	http://dd-test.01dev.eea.europa.eu/datasets/latest/WISE-SoE_WaterQuality/tables/DisaggregatedData
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 (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 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.

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