View table

There are 1 QA scripts and 4 conversion scripts registered for this table.
Link to the schema page on XMLCONV
Identifier BiologyEQRData
Short name BiologyEQRData
Dataset WISE SoE - Water Quality
Reference URL http://dd.eionet.europa.eu/datasets/latest/WISE-SoE_WaterQuality/tables/BiologyEQRData
Name Annual biology EQR data by monitoring site
Short Description Annually aggregated biological ecological quality ratio (EQR) data from rivers and lakes, by monitoring site.
Definition Annually aggregated biological ecological quality ratio (EQR) data from rivers and lakes, by monitoring site.
Methodology for obtaining data Biological data should be reported as national Ecological Quality Ratios (EQR) that are specific for an impact type (eutrophication, acidification, etc.). Please report only one type of national EQR for each Biological Quality Element (BQE) and impact type. Normalised EQR values can be reported.

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

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.

If it is not possible to report only one national EQR value for a determinand (BQE and impact type) – e.g. if there is more than one index – then it is recommended to instead combine the indices and report the normalised EQR value for the BQE and impact type.

If it is not possible to report the national EQR or the normalised EQR values, then report the status class. However, these data may not be used in all assessments (e.g. time series analyses).

Classification systems for the different national EQRs can depend on water body type, therefore the field "parameterNCSWaterBodyType" must always be filled in. 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 BiologyEQRClassificationProcedure.

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
* Water body type in the National Classification System (parameterNCSWaterBodyType) C string Quantitative
* Determinand code for biology data (Impact-specific BQE) (observedPropertyDeterminandBiologyEQRCode) C  (PK) string Vocabulary
* Reference period (year) (phenomenonTimeReferenceYear) C  (PK) integer Quantitative
Sampling period (parameterSamplingPeriod) C string Quantitative
* Ecological status class (resultEcologicalStatusClassValue) C string Fixed values
* Number of samples (resultNumberOfSamples) C integer Quantitative
Ecological quality ratio value (resultEQRValue) C float Quantitative
Normalised ecological quality ratio value (resultNormalisedEQRValue) 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)