View table

There are 0 QA scripts and 4 conversion scripts registered for this table.
Link to the schema page on XMLCONV
Identifier BiologyEQRDataByWaterBody
Short name BiologyEQRDataByWaterBody
Dataset WISE SoE - Biology
Reference URL http://dd.eionet.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
(an asterisk in front of element name indicates that the element is mandatory in this table)
(the C sign marks a common element)