View table

There are 0 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 - Biology
Reference URL http://dd.eionet.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 https://dd.eionet.europa.eu/visuals/DD_WISE2_figur...

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 WFD Spatial data flow (or the WISE-5 Spatial Data for countries that do not report under WFD).

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 integer 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)