european topic centre on water eea/etc water/ eionet workshop, budapest, hungary, 22-23 may 2003...
TRANSCRIPT
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1
EUROWATERNET-Emissions and EPEREUROWATERNET-Emissions and EPER
EEA - ETC Water / EIONET WORKSHOP
Budapest, Hungary 22-23 May 2003
Benoît FRIBOURG-BLANC
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 2
INTRODUCTIONINTRODUCTIONTwo types of emissions reporting tools:
Mandatory tools, of which EPER, tool of IPPC Directive for DGEnv of the Commission
Non-mandatory, of which EUROWATERNET-Emissions for ETC/WTR of the EEA (=>they take into account mandatory reporting data first + other data)
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 3
EPER : Context Directive IPPC 96/61 on Integrated Pollution Prevention and
Control
Decision adopted on 17 July 2000 related to public access to information (art. 15) Implementation of a European Pollutant Emission
Register EPER• emissions from individual facilities to air and to water• 56 industrial activities (including waste treatment, landfills,
intensive rearing of poultry and pigs)
First reporting from MS in June 2003 (emissions in 2001)
EEA assists the Commission : data publicly accessible on the Internet
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 4
Status of EPER implementation Detailed description of data to report available (guidance)
Consultant to develop tools to collect, store and disseminate EPER data• tools for MS (validation and data exchange module)• tool at EEA (database, GIS, and web site)
Schedule• Tool for MS 15th May 2003• Reporting by MS End June 2003• Design document of the web site : Mid June 2003
Role of EEA• participation in the design of the tools, metadata, global
checks of the reported data…)• Operating the web site
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 5
Link with Eurowaternet emissions
Collection of data for individual facilities
Consistency between reporting years
… but some gaps
Not final emissions to water Limited set of substances Thresholds Reporting limited to MS (and not member countries of EEA)
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 6
EUROWATERNET-Emissions databaseEUROWATERNET-Emissions database
Objective : conduct a practical application of EWN-e database
• Ewn-e database is at a development stage• 6 data sources taken into account:
– OSPAR (HARP-HAZ)– Emissions Inventory of ICPDR (Danube)– EUROSTAT-Newcronos– Denmark, DMU– Hungary, Vituki Consult Rt– The Netherlands, Ministry of Environment
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 7
Thanks to all partners who have given Thanks to all partners who have given us data for 2003 programus data for 2003 program
• Austria (Karin WEBER)
• The Netherlands (Jan VAN DER PLAS)
• ROD (Anita KÜNITZER)
• Hungary (János FEHER)
• Denmark (Jens BOGESTRAND )
• Bavaria (Anton STEINER)
• UK (EA)
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 8
Status of data collection
• Marine Conventions: expecting data from OSPAR (HARP-Nut), HELCOM (IGMW),
• PRB’s: contact with EEA and PRB WGs,• EPER: expecting data from June 2003,• French data: received data from 1996 to 2000,• Germany data: data received in concentration,• Slovenia: contact with Slovenian NFP.
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 9
PRINCIPLE of EWN-e databasePRINCIPLE of EWN-e database
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 10
PRINCIPLE of EWN-e databasePRINCIPLE of EWN-e database
Required data• Assessment Unit: area code and area name
• Source categories: 7 emission sources in EWN-e
• Individual sources: activities/location behind emissions
• Determinands: name, amount and unit
• Temporal Aggregation: year and period
EWN-e database tables
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 11
PROCESS (1)PROCESS (1) Differences between collected data and required data :
• file format: ACCESS, Excel, etc• determinands name• emission units: kg/day, kg/year • sources categories• geographical coverage: country or sub-basin
Turn the collected data into the right format
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 12
PROCESS (2)PROCESS (2)
Data in original format
Table 2
Table 1
Table 3
Table 4
EWN-e database main structure
Data converted into Access format and processed
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 13
DATABASE STRUCTURE (1)DATABASE STRUCTURE (1) Main structure tables
T_EWN_e_DETERMINANDS
T_EMISSIONS
T_PRESSURES
T_ASSESSMENT_UNIT
T_IND_SOURCES_LIST
T_EWN_e_SOURCES_CATEGORY
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 14
T_EMISSIONS description Amount of emissions per determinand, per year, and links with others tables WB_ID # Unique code of the Assessment UnitYEAR Year of emissionsPERIOD Aggregation Period: Annual, Month (January to
December). List box.EWN-e_DETERMINAND # Determinand Name used in EWN-eEWN_Source_ID # Classification of emission sourcesOrientedApproach # Load Oriented Approach (LOA) or source Oriented
Approach (SOA). List box.Ind_Source_ID # Code of the individual sourceUNITS # Units : t/year or t/month. List box.Quantity QuantityREMARKS site RemarksRev_year Year of last revision
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 15
T_ASSESSMENT_UNIT description Localisation of emission area. It has a unique code and a unique name to allow future identification of the same area.
WB_ID Code of the assessment unitData_ID # Data Source name: Ospar, Eurostat, ICPDRSource_Unit_ID Original ID used in the data source if oneCountry_ID # Code of the countryBASIN_NM Basin name. For example :Country, Danube,…CATCH_NM Catchment name (river,…)AREA_ID # Sea area Catchment codeWater_ID # Water type code: surface water (SW), groundwater (GW),
coastal (CW) or transitional water (TW)REV_YEAR Last Year of RevisionMap_representation Address of the map file
Name_Coordinate_system Coordinate system as GISCO, Lambert 2 AzymuthalRemarks Site remarks
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 16
T_PRESSURES description
Pressures (type and value) by assessment unit and by year/period
WB_ID Code of the assessment unitPressure_NM # Name of the pressure. Referred to T_PRESSURES_LIST
table (perm_population, area, soil occupation…)Year Year of the pressurePeriod Period of the pressure : Annual, January, etc. Referred to
T_Period_ListAmount Amount of the pressure
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 17
T_EWN-e_DETERMINANDS description
Determinands used in EWN-e database, their unit and their identification code : CAS number, EU number, National code
EWN-e_DETERMINAND
EWN-e database determinand name
Other_name Other name used for the determinand : abbreviation, synonymUNIT EWN-e Waterbase Unit of MeasurementCATEGORY Pollution type: Organic, Nutrient, Chemical, PhysicochemicalCAS_code CAS Code of the determinand.EU_code EU Code of the determinand.Priority_substances Yes if the substance is a priority substance (Annex 10, WFD)
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 18
T_EWN-e_SOURCES_CATEGORY description
Classification of emission sources used in EWN-e.
EWN_Source_ID Code of the EWN-e source categoryEWN_source_name EWN classification of emission sources: 7 sources category
1 : Urban emissions2 : Industrial emissions3 : Agricultural emissions4 : Forestry emissions5 : Transport emissions6 : Waste emissions7 : Natural and semi-natural emissions8 : No determined10 : None (when the emissions from original data
source do not correspond to EWN-e qualification)
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 19
T_IND_SOURCES_LIST description Name of the individual sources (activities or locations) that are behind emissions
Ind_Source_ID Identification number (ID) of the individualsource (industrial, …) in EWN-e
Ind_Source_name Name of the individual sources that are behindemissions
Original_data_code Code used by the source data to qualify thelocation/activity
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 20
OTHER TABLES description (1)
T_COUNTRIES List of the countries with their 2 digits code and theirtype
T_COUNTRY_TYPE Type of the country type : PHARE, EFTA, EU, NIS.Used for List box.
T_DATA_SOURCE_DETERMINANDS
Link between determinand names/units used in EWN-eDB and the one used in others data source.Specify a correction factor between the previous valueand EWN-e value.
T_DATA_SOURCE_LIST List of original data source used in EWN-eT_EWN-e_SUBGROUPS Classification of sub-groups used in EWN-e and their
definition.
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 21
OTHER TABLES description (2)
T_ORIENTED_APPROACH_LIST
2 approaches can be used to obtain emissions value : SourceOriented Approach (SOA) and Load Oriented Approach(LOA).
T_PERIOD_LIST List of the different period of the emissions : Annual,January, February,… Used for List Box.
T_PRESSURE_LIST Contains the name of required pressure, their unit and theirdefinition. Used for List Box.
T_SEA_AREA List of sea catchments (Caspian Sea, Baltic sea,…). Used forList Box.
T_UNIT_LIST The emissions can be expressed in t/year and in t/month.Used for List Box.
T_WATER_TYPE The emissions can be discharged in different water recipient :surface water, groundwater, transitional water or coastalwater.. Used for List Box.
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 22
DATABASE STRUCTURE (2)DATABASE STRUCTURE (2) Relationships:
• ONE-TO-MANY. Enforced referential integrity (cascade update only)
T_ASSESSMENT_UNIT
T_EMISSIONS1
• LIST BOX : to facilitate addition of data
Ex:
Ex: name of determinands, units, emission source in T_Emissions table
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 23
Relationships scheme
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 24
OSPAR : HARP-HazOSPAR : HARP-Haz
Oslo-Paris Convention for the Protection of the Marine Environment of the North-East Atlantic: Harmonised Quantification and Reporting Procedures on Hazardous substances
Objective of OSPAR for hazardous substances: prevent pollution of the maritime area by continuously reducing their release
Data format: ACCESS tables
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 25
HARP-Haz vs EWN-e HARP-Haz vs EWN-e emission sources (1)emission sources (1)
EWN-esources
HARP-Haz sources
1- Urban HouseholdsWaste disposal: waste water treatmentDirect inputs: urban waste water treatmentplants
2- Industrial Small and medium enterprisesIndustrial activitiesBuilding materials
3- Agricultural Agriculture activitiesOther loads: Aquaculture
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 26
HARP-Haz vs EWN-e HARP-Haz vs EWN-e Emission sources (2)Emission sources (2)
EWN-e sources HARP-Haz sources
4- Forestry No source
5- Transport Transport and infrastructure
Other loads: Navigation
6- Wastes Waste/disposal: all except waste water treatment
Contaminated land and sediments
7- Natural and semi-natural contributions
Direct diffuse inputs
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 27
HARP-Haz vs EWN-e HARP-Haz vs EWN-e Emission sources (3)Emission sources (3)
HARP-Haz sources not classified:- Rivers- Directs inputs from point sources : general- Other loads directly into the marine environment:
general and offshore
EWN-e source not provided: - Forestry
Creation of the link between sources : addition of EWN-e sources code in OSPAR Sub-group of sources table
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 28
OSPAR HARP-Haz vs EWN-e:OSPAR HARP-Haz vs EWN-e:Assessment Unit (1)Assessment Unit (1)
Geographical coverage: national level but restricted to the river basins that discharge to the maritime area
8 countries in HARP-Haz
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 29
OSPAR HARP-Haz vs EWN-e:OSPAR HARP-Haz vs EWN-e:Assessment Unit (2)Assessment Unit (2)
8 Assessment Units:
WB_ID Data_IDSource_unit_
ID
Country_ID
BASIN_NMCATCH
_NM
AREA_ID
Water_ID
REV_YEAR
Maprepresen
tationWB000001 OSPAR BE COUNTRY X SW 2003
WB000002 OSPAR CH COUNTRY X SW 2003
WB000003 OSPAR DE COUNTRY X SW 2003
WB000004 OSPAR DK COUNTRY X SW 2003
WB000005 OSPAR FR COUNTRY X SW 2003
WB000006 OSPAR NL COUNTRY X SW 2003
WB000007 OSPAR NO COUNTRY X SW 2003
WB000008 OSPAR SE COUNTRY X SW 2003
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 30
OSPAR HARP-Haz vs EWN-e:OSPAR HARP-Haz vs EWN-e:EmissionsEmissions
Substances: 66 substances, 17 included in WFD priority substances
Units: kg/year in OSPAR Years provided: 1985 and 1990 Recipient: air and water Approach: SOA and LOA
Pressures and individual sources
No data provided
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 31
Process from OSPAR to EWN-e (1)Process from OSPAR to EWN-e (1)
Ospar_Country
Assessment Unit
• Realise links between EWN-e and OSPAR features• Create fields in table: primary and foreign key
Ospar_Hazardous Substances
Data source determinands
EWN-e Determinands
Ospar_SubGroupsOfSources
Ospar_Discharge
Ospar_Recipient
Emissions
Amount
Year
Water
SOA/LOA
EWN-e sources
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 32
Process from OSPAR to EWN-e (2)Process from OSPAR to EWN-e (2)
Data analysis• Removal of empty records
• Updating general category data : adding its sub-groups amount when there is no value
• Change of unit: from kg/year to t/year
• Sum of emission per EWN-e sources
Ex 1
Ex 2
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 33
Process from OSPAR to EWN-eProcess from OSPAR to EWN-eExampleExample
Amount 1 Amount 2
Subgroup 1a 100 100Subgroup 1b 200Group 1 200
= 100 + 200
Updating general category data
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 34
Process from OSPAR to EWN-eProcess from OSPAR to EWN-e Example
OSPAR Group EWN source Determinand AmountSmall enterprises 2 X 10Industrial activities 2 X 20Agriculture 3 X 50Agriculture 3 Y 100Aquaculture 3 Y 200
Sum of emission per EWN-e sources
EWN source Determinand Amount2 X = 10 + 203 X = 503 Y = 100 + 200
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 35
Conclusion about OSPAR use in EWN-eConclusion about OSPAR use in EWN-e• 8 assessment units• 66 determinands of which 17 are WFD priority
substances• 498 emissions for 6 sources (no forestry sources)
very interesting data source but:
• assessment unit at an aggregated level and limited to river basins that discharge into the maritime area
• no pressures specified
• no individual sources specified
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 36
ICPDRICPDR
International Commission for the Protection of the Danube River (ICPDR)
Emission Inventory realised by Emissions Expert Group (EMIS/EG)
Available in ICPDR web site
Data copied and imported in Excel sheets
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 37
ICPDR vs EWN-e ICPDR vs EWN-e emission sourcesemission sources
EWN-e
emission sources ICPDR sectors
1- Urban 14- Municipalities
2- Industrial 1- Food industry 6- Iron and steel industry
2- Chemical industry 7- Metal surface treatment
3- Pulp and paper industry 8- Textile industry
4- Fertiliser industry 9- Leather industry
5- Mining 11- Other relevant industry
3- Agricultural 10- Agriculture
Creation of a link table in EWN-e database
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 38
ICPDR vs EWN-e:ICPDR vs EWN-e:Assessment Unit (1)Assessment Unit (1)
13countries
Germany, Austria, Czech Republic, Slovakia, Hungary,Slovenia, Croatia, Bosnia-Herzegovina, Fed. Rep.Yugoslavia, Bulgaria, Romania, Moldova, Ukraine
15sub-basins
01 Upper Danube02 Inn03 Austrian Danube04 Morava05 Váh-Hron06 Pannonian Central Danube07 Drava-Mura08 Sava
09 Tisa10 Banat-Eastern Serbia11 Velika Morava12 Mizia-Dobrudzha13 Muntenia14 Prut-Siret15 Delta-Liman
245 rivers Alach, Inn, Danube, etc
270 Assessment Units created
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 39
ICPDR vs EWN-e:ICPDR vs EWN-e:Assessment Unit (2)Assessment Unit (2)
Link fields between ICPDR and Assessment Unit table:Country Country_IDRiver Basin Basin_NMMain River Catch_NM
Data_ID WB_ID Country_ID
BASIN_NM
CATCH_NM AREA_ID
ICPDR WB000097 DE INN INN BICPDR WB000020 AT INN INN BICPDR WB000021 AT INN INN (T) BICPDR WB000022 AT INN SALZACH BICPDR WB000023 AT INN SALZACH (T) B
Ex:
270 Assessment Units created
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 40
ICPDR vs EWN-e:ICPDR vs EWN-e:EmissionsEmissions
4 substances: BOD, COD, N, P
Other determinands can be added. Units: t/year Years provided: 2000 Approach: SOA
Pressures and individual sources No pressures specified
771 individual sources specified: activities and location name
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 41
Process from ICPDR to EWN-e (1)Process from ICPDR to EWN-e (1)
Country
Main River
River Basin
Assessment Unit
Location
AV Code
Individual sources
Sector COD
BOD
P
N
Emissions
EWN-e Sources Determinand/Amount
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 42
Process from ICPDR to EWN-e (2)Process from ICPDR to EWN-e (2)
Data analysis• no calculation• putting the right shape• other information about emissions and individual
sources available in next tables (one per individual source) but difficult to reach for a data treatment
Example
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 43
Process from ICPDR to EWN-eProcess from ICPDR to EWN-eExampleExample
Country River basin
AV Code
Location Main River
Sector COD BOD
Austria I nn 1506 M.real AG Hallein Salzach 3 7210 2170
WB_ID Data_ID Country Riverbasin
Mainriver
WB001 ICPDR Austria Inn Salzach
Ind_ Source_ID
Ind_ Source_NM
Original_ Data_code
IS001 M.real AG Hallein
1506
WB_ID EWN_Source_ID
Ind_Source_ID
EWN-eDet
Year Period Quantity Units
WB001 2 IS001 COD 2000 Annual 7210 T/year
WB001 2 IS001 BOD 2000 Annual 2170 T/year
ICPDR
T_EMISSION
T_ASSESSMENT_UNIT T_IND_SOURCE_LIST
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 44
Conclusion about ICPDR use in EWN-eConclusion about ICPDR use in EWN-e
• 270 assessment units
• 4 determinands: BOD, COD, N, P
• 2674 emissions for 3 sources (urban, industrial, agricultural)
• 771 individual sources
very interesting data source but:• Only 4 determinands and for one year• Quality of data variable• No pressures specified• The data must be completed afterwards
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 45
EUROSTAT-NewcronosEUROSTAT-Newcronos
• Statistical information service of the European Union
• Newcronos database available on internet and loaded in CSV format (Excel)
• 2 tables used in Environmental statistics domain (Theme 8) and Water section:
IWQ4
IWQ7
National population connected to waste watertreatment plants (%)Generation and discharge of waste water
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 46
TABLES PRESENTATION (1)TABLES PRESENTATION (1)IWQ 4 : % population connected
2 UWW treatment
2.1 Primary 2.3 Tertiary
3 Other UWW treatment
4 UWW collecting system with treatment
5 UWW collecting system without treatment
6 Total UWW collecting system 7 Independent WW collecting system
100 % National Population
2.2 Secondary
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 47
TABLES PRESENTATION (2)TABLES PRESENTATION (2)
Objective: calculate raw and net pollution from these values
Only 6 fields are used in the calculations
Relationships : data coherence verified in a Excel table
• When obvious missing value in these 6 fields, value completed by ETC/WTR
• When no coherence (underestimated emission), it would be specified in EWN-e database on remarks field
IWQ 4
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 48
TABLES PRESENTATION (3)TABLES PRESENTATION (3)
Raw pollution provided for 15 water parameters of which 13 are determinands.
20 sources provided, only 3 general sources are used:
• WW3_1_1 : Waste water generated by agriculture, forestry, fishing (point source)
• WW3_1_6: Waste water generated by all industrial activities
• WW3_1_7: Waste water generated by domestic sector (Total)
IWQ 7
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 49
Eurostat vs EWN-e Eurostat vs EWN-e emission sourcesemission sources
Eurostat tables EWN-e sources
IWQ4 1- Urban
IWQ7
IWQ7
IWQ7
W3_1_1: Waste water generated bydomestic sector (Total)
W3_1_6: Waste water generated by allindustrial activities
W3_1_7: Waste water generated byagriculture, forestry, fishing (point source)
1- Urban
2- Industrial
3- Agricultural
• Calculations necessary to calculate raw and net pollution• No distinction between agricultural emissions and forestry emissions
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 50
Eurostat vs EWN-e Eurostat vs EWN-e Assessment UnitAssessment Unit
Geographical coverage: national level
38 countries in IWQ 4 table 29 countries in IWQ 7 table
38 Assessment Unit but 9 of them have no value
Data_ID WB_ID Country_ID BASIN_NM CATCH_NM
EUROSTAT WB000280 AT COUNTRYEUROSTAT WB000287 DK COUNTRYEUROSTAT WB000289 EE COUNTRYEUROSTAT WB000290 ES COUNTRY
Ex :
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 51
Eurostat vs EWN-e:Eurostat vs EWN-e:EmissionsEmissions
13 Substances: BOD, COD, N, P, TSS, As, Cd, Cr, Cu, Pb, Hg, Ni, Zn (4 of them are priority substances)
Temporal aggregation: year (1970, 1975, 1980, 1985, 1990, 1995 to 2000)
Approach: SOA
Pressures and individual sources Population provided per year
No individual source specified
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 52
Process from Eurostat to EWN-e (1)Process from Eurostat to EWN-e (1) Calculations in Excel file necessary:
Raw pollution
From IWQ 4 table: only for BOD, COD, TSS, N, P
Population National Equivalent Population PollutionRaw
Population Equivalent per country: equal to French Decree values but could be changed by national expert
National Population provided by IWQ 4 table
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 53
Process from Eurostat to EWN-e (2)Process from Eurostat to EWN-e (2)
Raw pollution
From IWQ 7 table: for all the 13 determinands
Raw pollution provided in 1000 kg/day or 1000 kg/year
change of unit when necessary (correction factor = 365)
Raw pollution equal to Raw pollution from IWQ 7 (more accurate) and if there is no value, equal to Raw pollution from IWQ 4
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 54
Process from Eurostat to EWN-e (3)Process from Eurostat to EWN-e (3) In IWQ7 only raw pollution by source:
Yield of different treatments per sector necessary:
• Agricultural sector global treatment, considered to be 50%
• Industrial sector global treatment, considered to be 50 %
• Urban sector types of treatment :• Primary,• Secondary,• Tertiary,
• Autonomous,• Others.
Yields sources: UWWTD, Eurostat, propositions of ETC/WTR
Could be changed by national expert, consultation required
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 55
Process from Eurostat to EWN-e (4)Process from Eurostat to EWN-e (4)
• For one type of treatment,
1001 Yield connected population% pollutionRaw 1 PollutionNet
• For no treatment,
connected population% pollutionRaw 2 PollutionNet
For the whole net pollution,
2 PollutionNet 1 PollutionNet PollutionNet Total
URBAN SECTOR
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 56
Process from Eurostat to EWN-e (5)Process from Eurostat to EWN-e (5)
INDUSTRIAL AND AGRICULTURAL SECTOR
100
Yield-1 pollutionRaw PollutionNet
Before these calculations, the ‘ - ‘ and ‘ : ‘ in Newcronos table are replaced by zero.
The zero corresponding to null emissions have to be differentiate.
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 57
Process from Eurostat to EWN-e (6)Process from Eurostat to EWN-e (6)
Structure of Excel file :
• For one country, 2 sheets :
• a data sheet with yield, Population Equivalent, Newcronos table
• a calculation sheet with raw and net pollution tables per sector
• Creation of a results table with the net emission per country, per sector, per year and per determinand. It is this table which is introduced in EWN-e.
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 58
Process from Eurostat to EWN-e (7)Process from Eurostat to EWN-e (7)
EWN-e tables updating from results table :
BOD, COD, TSS, N, P, As, Cd, Cr, Cu, Pb, Hg,
Ni, Zn
Amount/Determinand
Assessment Unit
Country_ID
Country_NM
Emissions
Sector Years
EWN-e sources
Null amount, except those that correspond to null emissions, are removed in Emissions table
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 59
Conclusion about Eurostat use in EWN-eConclusion about Eurostat use in EWN-e• 38 assessment units, the whole of Europe covered• 13 determinands, 4 are WFD priority substances• 1469 emissions for 3 sources: urban, industrial,
agricultural
Interesting data source but:• First treatment in Excel required• No distinction between agricultural and forestry source• Geographical scale limited by national answers to the questionnaires• Comparability of data between countries variable• Consultations required to fix coefficients
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 60
Hungary emissions testHungary emissions test
• Data supplied in Excel file, in accordance with EWN-e guideline format;
• 3 emissions sources: urban, industrial, agricultural;• 3 Assessment Units with population and soil occupation;• data from 1997 to 2000;• 5 determinands: BOD5, Total nitrogen, Total phosphorus,
Cadmium, Lead.
Limited dataset provided to test the system, extension possible.
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 61
Denmark emissionsDenmark emissions
• Data supplied in Excel file;• 4 emissions sources: urban, industrial, agricultural,
natural and semi-natural;• 43 assessment units: river station catchments as in
EWN-River, pressures available in EWN-r wDB;• Data from 1989 to 2001;• 2 determinands: Total nitrogen and Total phosphorus.
Representative sample of emissions per sources in Denmark but limited to 2 determinands
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 62
The NetherlandsThe Netherlands
• Emission inventory of the Netherlands available on Ministry web site;
• 6 emission sources: urban, industrial, agricultural, transport, wastes, natural and semi-natural;
• 39 assessment units: geographical level of waterboards, no pressures available;
• Years: 1990, 1995, 1999 to 2001;• 98 substances, 16 are priority substances.
Accurate representation of emissions to water in the Netherlands but no pressures available.
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 63
Examples of application (1)
Indicator 1 : Trends in emission per Assessment Unit
Data source: DENMARK
AU: Guden A, Arhus Amt
Determinand:Total phosphorus
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 64
Examples of application (2)
Indicator 2 : Relative change of emissions between 1985 and 1999
Data source : OSPAR
AU: Norway, country
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 65
Examples of application (3)
Indicator 3 : Trends in emission per Assessment Unit
AU: Estonia,country
Data source:EUROSTAT
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 66
Examples of application (4)
Indicator 4 : Sources contribution to overall emission per Assessment Unit and per year
Data source: ICPDR
AU:Romania, Tisa, Mures
Year: 2000
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 67
Examples of application (5)
Indicator 5 : Contributions of sources to trend, between 1999 and 2000
Data source: Netherlands
AU:Netherlands, country
Determinand: Total nitrogen
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 68
Examples of application (6)
Indicator 6 : Comparison of trends between regions
Data source:Hungary
Determinand: Total phosphorus
Period: 1998-2000
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 69
CONCLUSION (1)CONCLUSION (1)
Test with 6 data sources, of which 4 from NFPs (UK, DK, HU, NL)
Data gathered into a unique database Data comparable: same determinands, same unit, same
emission sources Assessment unit: countries and sub-basins
March 03 April 03 May 03
Assessment 316 396 3138
Determinands 87 158 346
Emission 4 700 31 800 97850
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 70
CONCLUSION (2)CONCLUSION (2) Difficulties:
• Some operations necessary according to the data source;• Lack in some fields: pressures and individual sources;• Aggregation level: country, sub-basins;• Classification in emission sources generate some
approximations;• Quality of data variable;• Indicators on the dataset of a single provider
EUROPEAN TOPIC CENTRE ON WATER
EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 71
CONCLUSION (3): the way forwardCONCLUSION (3): the way forward
• WFD streamlining : test with IMPRESS in PRB• Import other data to have a representative sample of emissions in Europe: France, Slovenia and other data when/where available;• Create a determinand classification with CAS code and national code;• Create an emission sources classification with NOSE and NACE Codes and other systems;• Create applications to assess water conditions and its evolution;• Create maps of pressures with ETC/TE.