View table

Identifier DisaggregatedData
Short name DisaggregatedData
Dataset WISE SoE - Water Quality TCM
Reference URL http://dd.eionet.europa.eu/datasets/latest/WISE-SoE_WaterQualityICM/tables/DisaggregatedData
Name Disaggregated data in water, sediment and biota
Short Description Raw disaggregated data on the observed values (e.g. concentrations) of determinands in water, sediment and biota samples.
Definition Raw disaggregated water quality data on the observed values (e.g. concentrations) of determinands in water, sediment and biota samples in transitional, coastal and marine waters as reported by EEA Member Countries on an annual basis.
Methodology for obtaining data The monitoring site is uniquely identified by combination of values in the fields "monitoringSiteIdentifier" and "monitoringSiteIdentifierScheme". The monitoring site identifier must be present in the list of monitoring sites (link to the vocabulary) that is kept updated with the data reported under the WISE Spatial Data flow (WISE-5).

Each record must have a unique combination of the values in the fields "monitoringSiteIdentifier", "monitoringSiteIdentifierScheme", "observedPropertyDeterminandCode", "procedureAnalysedMatrix", "sampleIdentifier", and "phenomenonTimeSamplingDate". In the case of sediment, "parameterSedimentDepthSampled" is also part of the unique combination. In the case of biota samples, "parameterSpecies" is also part of the unique combination.

The field "parameterSampleDepth" is only applicable to water samples.

The field "parameterSedimentDepthSample" is only requested for sediment data.

The fields "parameterSpecies", "parameterMoisture", "parameterFat", "parameterExtratableLipid" and "parameterLipid" are only requested for biota data.

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.

If there is a PlatformCode_SHIPC, provide it under Remarks.

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
* Sampling time (date) (phenomenonTimeSamplingDate) C  (PK) date Quantitative
* Determinand code (observedPropertyDeterminandCode) C  (PK) string Vocabulary
* Observed value (resultObservedValue) C decimal Quantitative
* Unit of measure (resultUom) C reference Vocabulary
* Analysed matrix (procedureAnalysedMatrix) C  (PK) reference Vocabulary
* Observed value below LOQ (resultQualityObservedValueBelowLOQ) C boolean Fixed values
Limit of quantification (procedureLOQValue) C float Quantitative
Observation status flag (resultObservationStatus) C string Fixed values
Sample depth (parameterSampleDepth) C float Quantitative
Depth of the sediment sample (parameterSedimentDepthSampled)  (PK) string Quantitative
Species (parameterSpecies) C  (PK) string Fixed values
Percent Moisture (parameterMoisture) float Quantitative
Fat content of the analysed tissue (parameterFat) float Quantitative
Extractable Lipid Percent (parameterExtractableLipid) float Quantitative
Lipid Weight Percent (parameterLipid) float Quantitative
Sample identifier (sampleIdentifier) C  (PK) string Quantitative
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)