View table

Identifier	BiologyEQRData
Short name	BiologyEQRData
Dataset	WISE SoE - Biology
Reference URL	http://dd-test.01dev.eea.europa.eu/datasets/latest/WISE-SoE_Biology/tables/BiologyEQRData
Name	Annual biology EQR data by monitoring site
Short Description	Annually aggregated biological ecological quality ratio (EQR) data from rivers, lakes, transitional and coastal waters, by monitoring site.
Definition	Annually aggregated biological ecological quality ratio (EQR) data from rivers, lakes, transitional and coastal waters, by monitoring site.
Methodology for obtaining data	Biological data should be reported as national Ecological Quality Ratios (EQR) and/or as normalised EQR values. For information on calculating normalised EQR values, see http://dd.eionet.europa.eu/visuals/BiologyEQRSchem... Each record in this table must have a unique combination of the values in these fields (no duplicates can exist): - monitoringSiteIdentifier - monitoringSiteIdentifierScheme - observedPropertyDeterminandBiologyEQRCode - phenomenonTimeReferenceYear The monitoring site is uniquely identified by combination of values in the fields: - monitoringSiteIdentifier - monitoringSiteIdentifierScheme The monitoring site 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 the WFD 2016 Spatial data flows. The value "parameterNCSWaterBodyType" reported in this table must be identical to a value "parameterNCSWaterBodyType" reported in the table BiologyEQRClassificationProcedure. Intercalibration water body types are preferred as the parameterNCSWaterBodyType to be reported, as far as possible.

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	string	Vocabulary
* Water body type in the National Classification System (parameterNCSWaterBodyType) C	string	Quantitative
* Natural, artificial or heavily modified water body (parameterNaturalAWBHMWB) C	string	Fixed values
* Determinand code for biology data (Impact-specific BQE) (observedPropertyDeterminandBiologyEQRCode) C  (PK)	string	Vocabulary
Classification system (procedureClassificationSystem) C	reference	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