View table

Identifier	BiologyEQRData
Short name	BiologyEQRData
Dataset	WISE SoE - Water Quality
Reference URL	http://dd-test.01dev.eea.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