EEA

Navigation

Account Services

I have

WISE SoE - Biology data (WISE-2) WISE

WISE-2 dataflow was established to obtain a harmonised flow of biology data reported as Ecological Quality Ratios (EQRs) from all surface water categories; rivers, lakes, transitional and coastal waters.

Biology data can be reported in two alternative ways:

  1. as national EQR values, together with information on the national classification system (class boundaries in national EQR scale)
  2. as normalised EQR values; then information on the national classification system is not required

Selected biological determinands with original metric values and units can be reported to WISE-6 dataflow: chlorophyll-a, total phytoplankton biomass, cyanobacteria biomass and cyanbacteria proportion.

The EEA WISE-2 database currently contains data from different phases of biology data reporting:

  1. Reporting years 2011 - 2013: biology in rivers and lakes reported to WISE Rivers and WISE Lakes (stored as legacy data and migrated to WISE-4 dataset)
  2. Reporting years 2015 - 2019: biology in rivers and lakes reported to WISE-4 dataflow
  3. Reporting year 2019: biology in all water categories reported to WISE-2 dataflow

WISE-2 database does not contain biology data reported during the test reporting years 2009-2010, nor biology data from transitional and coastal waters reported prior to 2019.

Biology data (from rivers and lakes) were not requested in 2014 due to the reorganization of WISE dataflows. Biology data (from all water categories) were not requested in 2020 due to lack of resources; any biology data that were attempted reported in 2020 have not been processed.

In cases where biology data have been previously delivered to CDR but have not been processed in WISE-2 for the reasons mentioned above, reporters are kindly asked to re-deliver the data in the most recent template format.

The following material is intended for national reporters of WISE-2 data.
It describes how to use Reportnet during the reporting process and how to improve the quality of deliveries.

Dataflow specific instructions

Changes in the 2021 data call

All biology data (EQR values) must now be reported to WISE-2 dataflow; WISE-4 dataflow has been retired.

BiologyEQRClassificationProcedure

The table BiologyEQRClassificationProcedure no longer needs to be filled in by reporters for each reporting. Instead, EEA provides a pre-filled excel template for each country, which can be downloaded directly from the CDR envelope. The template contains the BiologyEQRClassificationProcedure table pre-filled with harmonized data from the previous reporting. Reporters are asked to check and, if necessary, correct the pre-filled information (classification system, applicable water body types, class boundaries etc.).

New records may be added to the prefilled table, but no prefilled records may be deleted. During the QC the table will be compared with the reference list of the classification procedures. The delivery will be blocked if any of the records are found missing. Instead of deleting them, the retired or invalid entries should be marked by using flag 'Z' in the resultObservationStatus field. When the deliveries are harvested and processed by the EEA, such records will be retired, and excluded from the future prefilled tables.

Even if there are no changes in the data, the BiologyEQRClassificationProcedure still needs to be uploaded to the CDR envelope as part of the delivery. There may be just one filled BiologyEQRClassificationProcedure table (or xml file) in the envelope, containing unique list of classification procedures. If there are multiple tables (or xml files) in the envelope, or any of the classification procedures are duplicated, the delivery will be blocked.

The element parameterWFDIntercalibrationWaterBodyType has been removed from the table BiologyEQRClassificationProcedure. Instead, information on IC types is available as additional information in the element procedureClassificationSystem.

BiologyEQRData and BiologyEQRDataByWaterBody

The pre-filled template, that can be downloaded directly from a CDR envelope, contains also the BiologyEQRData and BiologyEQRDataByWaterBody sheets. Reporters can, therefore, report these data directly into the prefilled template. They do not need to download a separate, empty template from the Data Dictionary to do that.

WISE dataflows

More information

If you need support please contact WISE SoE Helpdesk