Methodology for obtaining data
|
*********************************************************** Summary of changes in 2012 ************************************************************
Table Spatial_Unit_Characterisation: Identifier of the field RBD code was changed from RBD-code to RBDcode to become identical with Short name. Field Remarks was added.
Tables Nutrients_Point_Emission, Haz_Subst_Point_Emission: Fields MethodEmissionsPointSources, DataSources and Remarks were added. Field EPRTRFacilities is now mandatory in both point emission tables.
Tables Nutrients_Diffuse_Emission, Haz_Subst_Diffuse_Emission: Fields MethodEmissionsDiffuseSources, DataSources and Remarks were added. Field SourceDiffEmission: multiple choice was removed, new item NP9 = NP3 + NP5 was added to the codelist instead.
Tables Haz_Subst_Point_Emission, Haz_Subst_Diffuse_Emission: Fields DeterminandHazSubsID, DeterminandHazSubsName: Codelist of hazardous substances was updated, 25 substances were added, together 75 substances were specified as Preferred SoE Hazardous substances for Emissions reporting. Names of 3 hazardous substances available in the past were updated by expert: 908: CAS: 12002-48-1 Trichlorobenzene -> Trichlorobenzenes 927: CAS: 35694-08-7 PCB194 -> PCB194 (1,2,3,4-tetrachloro-5-(2,3,4,5-tetrachlorophenyl)benzene) 1215: CAS: 100-02-7 4-nitrophenol -> Nitrophenol
Emission values already provided within E-PRTR does not have to be reported or indicated within SoE Emissions reporting once more. All Emissions of selected most important substances reported under E-PRTR will be aggegated by River Basin Districts, substance and year by ETC/ICM and the results will be included into final SoE Emissions European reference datasets. Therefore, emissions flag value -3 relevant for indication of data already provided under E-PRTR was excluded from the list of allowed negative flag values. On the other hand, please provide emisison values from the smaller facilities that are below the required E-PRTR threshold for reporting, if available.
Codelists of Nutrients and Hazardous substances (incl. specification of Preferred SoE Hazardous substances) as well as codelists of River Basin Districts and RBD SubUnits are available on the public section of Forum in Excel table format: http://forum.eionet.europa.eu/nrc-eionet-freshwate...
************************************************************ ************************************************************
The data requested through the WISE-SoE Reporting process should be derived from existing national and/or regional sources within each EEA Member Country. Member Countries are asked to provide data on emissions. It is expected that these data should provide a general overview, based on truly comparable data, of emissions to water at a European level. It is recognised that whilst Member Countries already report data under various obligations (e.g. UWWTD, E-PRTR and WFD) there may be information gaps in the data supplied in terms of the requirements of the EEA; for example, with respect to pollutant discharges from UWWT plants It is not the intention of the EEA that Member Countries should make duplicate deliveries of data, so any data already submitted via existing (legislative) reporting obligations need not be resupplied through the WISE-SoE Reporting process. Member Countries are only asked to provide missing or additional data. If data has been provided already under WFD, UWWTD, SoE Quantity or SoE TCM waters (Riverine Load or Direct Discharges) reporting then please flag using value -1, - 2, - 4 or -5 respectively.
Please consider the following when compiling your data delivery:
1. Submit data up to and including 2011. Do not supply any data for 2012. 2. Submit data on annual nutrient, organic matter and hazardous substances emissions aggregated at the national RBD level. If more spatially detailed information is available at sub-unit or water body level, then this would be appreciated.
3. Submit emissions data from both source (gross) and load (net) oriented approaches where available, providing full methodological details.. Source (gross) approaches estimate the emission to – but not within - an inland waterbody and do not account for retention (loss) processes within that waterbody. Load or net approaches describe a total pollutant load (ideally separated into source categories) at the river mouth or downstream point and, account for in-river processes.
4. Provide as long a time series of data, for as many determinands and as many individual source of pollutants as possible. To facilitate comparison of emissions data between years, it is preferred that assessment methods remain consistent over time. Any change in method should be clearly indicated.
5. Modify and add to the information on the characteristics of the spatial units used (national RBDs, sub-units or water bodies) Provide this permanent data only once for each assessment unit unless there are changes between reporting periods. Provide population information for each reporting unit. If information regarding proxy pressures has already been provided under WFD reporting, please flag using value -1.
6. Provide a data description with, for example, a summary of the methodology used for quantifying significant point and diffuse sources including a description of the following where appropriate: Screening criteria, numerical models (including whether they are source (gross) or load (net) based), data sources etc. All such information should be delivered in an accompanying text file.
7. Use the templates (XML schemas, MS Excel or MS Access) and these specifications to guide you in formatting and collating your data delivery. All are available for download from the data dictionary.
8. Supply data in XML, MS Excel (preferred) or MS Access format. In the case of Excel format, xls files (= Excel 1997 – 2003) can be used only. Do not use xlsx files. Ensure commas are not used as decimal separators. Please do not use formulas in Excel template fields, fill values only. In the case of MS Access format, it can be used for data delivery only in combination with XML or MS Excel format. The MS Access template has directly implemented functions for exporting data into these two formats.
9. Upload your data files to your nominated repository: the Central Data Repository at http://cdr.eionet.europa.eu/ or your national Eionet server.
Categories of point and diffuse sources of emissions:
Point sources to coastal and transitional waters: D0....Direct Discharges (total)
Point sources to inland waters: U1....Urban Waste Water Untreated (U11-U14) U2....Urban Waste Water Treated (U21-U24) I3......Industrial Waste Water Treated I4......Industrial Waste Water Untreated O5....Other Waste Water Treated O6....Other Waste Water Untreated G7....Point Sources to GW (total)
Difuse (non-point) sources to inland waters: NP1...Agriculture Emissions NP2...Atmospheric Deposition NP3...Un-Connected Dwellings Emissions NP4...Urban Diffuse Emissions NP5...Storm Overflows Emissions NP6...Abandoned Industrial Sites Emissions NP7...Other Diffuse Emissions NP8...Background Emissions NP9...NP3 + NP5
More details are available in the emission data dictionary accompanying file: Emission Source Discharges Scheme and Legend, which is available on: http://eea.eionet.europa.eu/Public/irc/eionet-circ...
The ETC Water contact person for the WISE-SoE Emissions reporting is Hana Prchalova, based at the CENIA, Prague, Czech Republic. If you have any questions about the format and content of the data request, please contact her by e-mail at: hana.prchalova@cenia.cz.
|