|
Keywords
|
Groundwater, Inland water, Lake, Marine, Ocean, River, Sea, Surface water, Water, Water quality
|
|
Methodology for obtaining data
|
OVERVIEW:
Water quality in inland, coastal and marine waters is reported under WISE-SoE using a harmonised data model. All determinands (nutrients, hazardous substances and supportive determinands) are coded using a unique identifier.
Raw data (i.e. sample values) are reported in the DisaggregatedData table. Annually aggregated data, by monitoring site, are reported in the AggregatedData table. Annually aggregated data, by water body, are reported in the AggregatedDataByWaterBody table.
The full list of determinands, and the indicative thresholds for "potentially high mean annual value" (i.e. used to flag potential outliers in the quality control procedures), is available in http://cdr.eionet.europa.eu/help/WISE_SoE/wise6.
1. Coverage and reference period
The data should be derived from existing national or regional monitoring programs within each EEA Member Country.
It is recognised that whilst member countries already deliver data to the Marine Conventions, there may be gaps in the data supplied in terms of the requirements of the EEA. It is not the intention of the EEA that member countries should make duplicate deliveries, so any data already submitted to the Marine Conventions need not be resupplied through the WISE-SOE process, as these will be requested directly from the Marine Conventions. Member countries are only asked to provide missing or additional data.
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
Submit data on nutrients in water and hazardous substances in biota, sediment and water in disaggregated (sample dates) or aggregated (yearly averages or aggregated by water bodies) format. For hazardous substances single sample determinations are preferred, as many values may be below the limits of quantification and this approach will provide a more robust assessment of how the data should be statistically treated and presented. Data will be aggregated to annual averages by the ETC-ICM, to be used for the publication of EEA water indicators. If, for a specific sample value, the measured concentration is below the limit of quantification, then report the limit of quantification value in the "Observed Value" field and report 'True' (or '1') in the boolean "Observed value below LOQ" field.
3. Spatial reference data
The time series reported under the water, sediment and biota table must be linked to a monitoring site, using a unique identifier. The location, identification and characteristics of the monitoring sites must be provided via the WISE Spatial data flow (WISE-5).
If a monitoring site is also reported under the WFD, then use the WFD identifier as the unique identifier.
Through quality control procedures, the consistency of these identifiers for the reported data will be checked against the spatial data already reported.
Please note that the spatial data need not be reported annually. However, updates to the spatial data (new monitoring sites, changes in the identifiers, etc.) should be reported.
4. Decimal separators and precision of the reported data.
Use a decimal point '.' as the decimal separator. Do not use a comma ','.
The general recommendation concerning the decimal precision is as follows:
- Use 1 to 3 decimal places in reporting nutrients (usually in milligrams per litre),
- Use 3 to 4 decimals places in reporting hazardous substances (usually in micrograms per litre).
5. Other recommendations
Please provide long time series without gaps and as complete a geographic coverage as possible.
6. Reporting format and delivery
Use the reporting templates (MS Excel, XML schemas) and template 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 worksheets or column names. The file name can be renamed.
Delivery can be split into a 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 http://cdr.eionet.europa.eu/. A WISE-6 folder will be 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: wisesoe.helpdesk@eionet.europa.eu
|
|
Feedback