|
Methodology for obtaining data
|
OVERVIEW:
Biology data as EQR values in rivers, lakes, 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 biological 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 preferably be derived from national monitoring programs defined under the Water Framework Directive. Countries reporting under the WFD should use WFD monitoring sites and WFD water bodies.
The countries that do not report under WFD must use EIONET identifiers.
Submit data collected up to the end of the previous year (e.g. in 2024, submit data collected until the end of 2023).
2. Data content: EQR values
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, if reporting at the monitoring site level is not possible. EQR data can be reported as national EQR values together with the associated status class boundaries and/or as normalised EQR values (without the need for class boundaries).
3. Data content: classification tables.
A prefilled-table with previously reported national data on Classification procedures is available in the Reportnet (under ‘Import dataset data’ -> ‘Other custom imports -> ‘prefilling BiologyEQRClassificationProcedure‘). Check and revise the class boundary values using the pre-filled BiologyEQRClassificationProcedure table.
4. Data publication
The data will be primarily used to derive indicator values, and display temporal and geographical trends in European data products, upon which EEA assessment reports are based. Processed and quality-checked data are also published in the Waterbase - Biology (Waterbase - Biology (europa.eu)).
5. Spatial reference data
The data reported under the WISE-2 flow must be linked to a monitoring site (or to a water body, for data aggregated by water body), using an existing spatial identifier.
The location, identification and characteristics of the spatial objects must have been provided via the WFD Spatial data flow (or WISE-5 data flow, for countries that do not report under the Water Framework Directive).
If a monitoring site or water body is reported under the WFD, 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.) must be reported under the WFD Spatial data flow (or WISE-5 data flow, for countries that do not report under the Water Framework Directive). Only then can new identifiers be used in the WISE-2 reporting
6. Water body types
For monitoring sites and water bodies where a water body type has already been reported to the WFD [surfaceWaterBodyTypeCode], the same water body type must be used in WISE-2 reporting (since 2021). For the WISE-2 reporting until 2022, the allowed set of water body types was limited to those reported to WFD under the 2nd RBMP. For subsequent WISE-2 reportings, this set has been expanded with the additional water body types reported under the 3rd RBMP
7. 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.
8. 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). Data series starting from 2012 (or from 2018) can be included in the analysis of “long series” (or “short” series, respectively).
9. Reporting format and delivery
Use the reporting templates (MS Excel) and these specifications when formatting and collating the data delivery. The template can be downloaded from Reportnet 3 under Dataflow Help, alternatively from the data dictionary in CDR.
Data can be uploaded in MS Excel file format into Reportnet 3 using “Import dataset data” functionality. Please do not use formulas in MS Excel files and do not rename the sheets or column names. The file name can be renamed.
If you have any questions about the format and content of the data request please contact the helpdesk, e-mail: wisesoe.helpdesk@eionet.europa.eu
|
|
Feedback