View table

There are 0 QA scripts and 4 conversion scripts registered for this table.
Link to the schema page on XMLCONV
Identifier BiologyEQRDataByWaterBody
Short name BiologyEQRDataByWaterBody
Dataset WISE SoE - Biology
Reference URL http://dd.eionet.europa.eu/datasets/latest/WISE-SoE_Biology/tables/BiologyEQRDataByWaterBody
Name Annual biology EQR data by water body
Short Description Annually aggregated biological ecological quality ratio (EQR) data from transitional and coastal waters, by water body.
Definition Annually aggregated biological ecological quality ratio (EQR) data from transitional and coastal waters, by water body.
Methodology for obtaining data Biological data should be reported as Ecological Quality Ratios (EQR). Normalised EQR values can be reported.

Each record in this table must have a unique combination of the values in the fields "waterBodyIdentifier", "waterBodyIdentifierScheme”, "observedPropertyDeterminandBiologyEQRCode", "procedureMethod" and "phenomenonTimeReferenceYear".

The water body is uniquely identified by combination of values in the fields "waterBodyIdentifier" and "waterBodyIdentifierScheme".

The water body identifier should be present in the list of monitoring sites that is kept updated with the data reported under the WISE Spatial Data (WISE-5) and/or the WFD 2016 Spatial data flows.

Intercalibration water body types are preferred. Where applicable, the intercalibration water body type should be reported in the BiologyEQRClassificationProcedure table in the field "parameterWFDIntercalibrationWaterBodyType”.

The value "parameterNCSWaterBodyType" reported in this table must be identical to a value "parameterNCSWaterBodyType" reported in the table EQRclassification.

Elements

Element name Datatype Element type
* Water body identifier (waterBodyIdentifier) C  (PK) string Quantitative
* Water body identifier scheme (waterBodyIdentifierScheme) C  (PK) string Fixed values
* Water body category code (parameterWaterBodyCategory) C  (PK) string Vocabulary
* Water body type in the National Classification System (parameterNCSWaterBodyType) C string Quantitative
Natural, artificial or heavily modified water body (parameterNaturalAWBHMWB) C  (PK) string Fixed values
* Reference period (year) (phenomenonTimeReferenceYear) C  (PK) integer Quantitative
* Determinand code for biology data (Impact-specific BQE) (observedPropertyDeterminandBiologyEQRCode) C  (PK) string Vocabulary
Ecological quality ratio value (resultEQRValue) C float Quantitative
Normalised ecological quality ratio value (resultNormalisedEQRValue) C float Quantitative
* Ecological status class (resultEcologicalStatusClassValue) C string Fixed values
* Number of samples (resultNumberOfSamples) C integer Quantitative
Observation status flag (resultObservationStatus) C string Fixed values
Sampling period (parameterSamplingPeriod) C string Quantitative
Classification system (ClassificationSystem) C reference Vocabulary
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)