View dataset definition

Identifier WISE-SoE_Biology
Short name WISE SoE - Biology
Registration status Released 29 October 2019
Reference URL
Name WISE SoE - Biology in Rivers, Lakes, Transitional and Coastal Waters (WISE-2)
Keywords Biology, Water, water quality
Short Description Biological data from rivers, lakes, transitional and coastal waters
Definition Biological data from rivers, lakes, transitional and coastal waters collected annually through the WISE-SoE reporting. The data are expected to be collected within monitoring programs defined under the Water Framework Directive and used in the classification of the ecological status or potential of rivers, lakes, transitional and coastal water bodies.
Methodology for obtaining data OVERVIEW:

Biological data as EQR values in transitional and coastal waters (as defined under the Water Framework Directive), are requested either at the monitoring site level (BiologyEQRData table) or at the water body level (BiologyEQRDataByWaterBody table). The BiologyEQRClassificationProcedure table provides information on the EQR values used as boundaries for the classification of the ecological status or ecological potential of the water bodies for a given determinand and water body type. This information is needed for the calculation from national EQR values to normalised EQR values.

1. Coverage and reference period

The data should be derived from national monitoring programs defined under the Water Framework Directive regulation.

Submit data collected up to the end of the previous year (e.g. in 2019, submit data collected until the end of 2018).

2. Data content

Use the BiologyEQRData table to report the annual mean value of Ecological Quality Ratio (EQR) data from rivers, lakes, transitional and coastal monitoring sites. Alternatively, use the BiologyEQRDataByWaterBody to report them at the water body level. EQR data can be reported as national EQR values together with the associated status class boundaries and/or as normalised class EQR values (without the need for class boundaries). Report the class boundary values using the BiologyEQRClassificationProcedure table.

3. Data publication

The data are primarily used to compile indicator factsheets, upon which EEA assessment reports are based. Collected data are also published in the Waterbase.

4. Spatial reference data

The data reported under the WISE-2 flow must be linked to a monitoring site (or to a water body
body, for data aggregated by water body), using a unique identifier. The location, identification and characteristics of the spatial objects must be provided via the WISE Spatial data flow.
If a monitoring site or water body is reported also under the WFD, then use the WFD identifier as the unique identifier.
During the quality control procedures of the data reported under WISE-2, the consistency of these identifiers will be checked against the spatial data already reported. The spatial data do not have to be reported annually. However, updates to the spatial data (e.g. new monitoring sites, changes in the identifiers, etc.) should be reported.

5. Reporting data at water body level

Data can be reported at the water body level as an alternative to monitoring site level. The aggregation process should consist of two phases: first, calculate the annual average value by monitoring site; then use the results to calculate the annual average value by water body. Using this approach, the influence of different number of samples at monitoring site level is eliminated.

6. Other recommendations

Please provide long time series without gaps and as complete a geographic coverage as possible. Please ensure that reported data are representative for all status classes (e.g. not dominated by sites in good or high status).

7. Reporting format and delivery

Use the reporting templates (MS Excel or XML schemas) and these specifications when formatting and collating the data delivery. The templates can be downloaded from the data dictionary.

Data can be delivered in XML files or in MS Excel file format. Please do not use formulas in MS Excel files and do not rename the sheets or column names. The file name can be renamed.

A delivery can be split into multiple files if necessary. All the files must, however, be uploaded to the same envelope.

Upload the data files to the Central Data Repository at A WISE-2 folder has been created by the EEA under your country’s collection.

If you have any questions about the format and content of the data request please contact the helpdesk, e-mail:
Planned updating frequency Annual
Version October 2019
Reporting obligation

Data model

Click thumbnail to view large version of the data model

Dataset tables

Full name Short name
Annual biology EQR data by monitoring si ... BiologyEQRData
Annual biology EQR data by water body BiologyEQRDataByWaterBody
Classification procedure for ecological ... BiologyEQRClassificationProcedure