View table

Identifier BiologyEQRClassificationProcedure
Short name BiologyEQRClassificationProcedure
Dataset WISE SoE - Biology
Reference URL http://dd.eionet.europa.eu/datasets/latest/WISE-SoE_Biology/tables/BiologyEQRClassificationProcedure
Name Classification procedure for ecological status or potential status based on biology EQR data
Short Description Classification procedure for ecological status or potential status based on biology EQR data
Definition Information on national classification system for each biological determinand and waterbody type, including the boundaries of ecological status classes (and of ecological potential classes, for artificial or heavily modified waterbodies).
Methodology for obtaining data Class boundaries for the national classification system should be reported using the national EQR (Ecological Quality Ratio) values.

Each record in this table must have a unique combination of the values in the fields "CountryCode", "parameterWaterBodyCategory", "observedPropertyDeterminandBiologyEQRCode", "parameterNCSWaterBodyType" and "procedureMethod".

Please see the descriptive image below on the "Reporting of biological metric values and class boundaries in EQR scale".

For artificial waterbodies and highly modified waterbodies, the information given on class boundaries will represent ecological potential instead of ecological status.

Classification systems for the different national EQRs can depend on water body type, therefore the field "parameterNCSWaterBodyType" should always be filled in. Intercalibration water body types are preferred, but in cases where this is not possible, other national water body types can be reported instead. Where applicable, the intercalibration water body type should be reported in the field "parameterWFDIntercalibrationWaterBodyType".

Each "parameterNCSWaterBodyType" value reported in this table must be identical to one or more "parameterNCSWaterBodyType" values reported in the tables EQRdata_ms and EQRdata_wb.

Elements

Element name Datatype Element type
* Country Code (CountryCode) C string Fixed values
* Water body category code (parameterWaterBodyCategory) C  (PK) string Vocabulary
* Water body type in the National Classification System (parameterNCSWaterBodyType) C  (PK) string Quantitative
Water body type code in the WFD Intercalibration System (parameterWFDIntercalibrationWaterBodyType) C string Vocabulary
Natural, artificial or heavily modified water body (parameterNaturalAWBHMWB) C  (PK) string Fixed values
* Determinand code for biology data (Impact-specific BQE) (observedPropertyDeterminandBiologyEQRCode) C  (PK) string Vocabulary
Classification system (ClassificationSystem) C reference Vocabulary
Boundary value between High and Good ecological status or potential classes (parameterBoundaryValueClasses12) C float Quantitative
Boundary value between Good and Moderate ecological status or potential classes (parameterBoundaryValueClasses23) C float Quantitative
Boundary value between Moderate and Poor ecological status or potential classes (parameterBoundaryValueClasses34) C float Quantitative
Boundary value between Poor and Bad ecological status or potential classes (parameterBoundaryValueClasses45) C float 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)