View table

There are 0 QA scripts and 4 conversion scripts registered for this table.
Link to the schema page on XMLCONV
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 based on biology EQR data
Short Description Classification procedure for ecological status or potential 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 the scale of national EQR (Ecological Quality Ratio) values.

Each record in this table must have a unique combination of the values in these fields (no duplicates can exist):
- countryCode
- parameterWaterBodyCategory
- observedPropertyDeterminandBiologyEQRCode
- parameterNCSWaterBodyType
- parameterNaturalAWBHMWB

The "parameterNaturalAWBHMWB" is mandatory because it is needed for the definition of some classification systems for rivers and lakes.

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

For artificial and highly modified water bodies, 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, one intercalibration water body type can be reported as additional information in the field "parameterWFDIntercalibrationWaterBodyType".

Each "parameterNCSWaterBodyType" value reported in this table must be identical to one or more "parameterNCSWaterBodyType" values reported in the tables BiologyEQRdata or BiologyEQRdataByWaterBody.
Descriptive image

Elements

Element name Datatype Element type
* Country Code (countryCode)  (PK) 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 (procedureClassificationSystem) C reference Vocabulary
Boundary value between High (or Maximum) 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
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)