View table

Identifier	BiologyEQRDataByWaterBody
Short name	BiologyEQRDataByWaterBody
Dataset	WISE SoE - Biology
Reference URL	http://dd-test.01dev.eea.europa.eu/datasets/latest/WISE-SoE_Biology/tables/BiologyEQRDataByWaterBody
Name	Annual biology EQR data by water body
Short Description	Annually aggregated biological ecological quality ratio (EQR) data from rivers, lakes, transitional and coastal waters, by water body.
Definition	Annually aggregated biological ecological quality ratio (EQR) data from rivers, lakes, transitional and coastal waters, by water body.
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): - waterBodyIdentifier - waterBodyIdentifierScheme - parameterNaturalAWBHMWB - observedPropertyDeterminandBiologyEQRCode - phenomenonTimeReferenceYear The water body is uniquely identified by combination of values in the fields: - waterBodyIdentifier - waterBodyIdentifierScheme The water body identifier should be present in the list of water bodies that is kept updated with the data reported under the WISE Spatial Data (WISE-5) and/or the WFD 2016 Spatial data flows. The value "parameterNCSWaterBodyType" reported in this table must be identical to a value "parameterNCSWaterBodyType" reported in the table EQRclassification. Intercalibration water body types are preferred as the parameterNCSWaterBodyType to be reported, as far as possible.

Elements

Element name	Datatype	Element type
* Water body identifier (waterBodyIdentifier) C  (PK)	string	Quantitative
* Water body identifier scheme (waterBodyIdentifierScheme) 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