european topic centre on water eea/etc water/ eionet workshop, budapest, hungary, 22-23 may 2003...

71
EUROPEAN TOPIC CENTRE ON WATER C Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 s EUROWATERNET-Emissions and EPER EUROWATERNET-Emissions and EPER EEA - ETC Water / EIONET WORKSHOP Budapest, Hungary 22-23 May 2003 Benoît FRIBOURG-BLANC

Upload: isabella-powell

Post on 21-Jan-2016

214 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 2: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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)

Page 3: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 4: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 5: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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)

Page 6: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 7: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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)

Page 8: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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.

Page 9: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 10: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 11: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 12: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 13: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 14: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 15: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 16: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 17: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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)

Page 18: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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)

Page 19: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 20: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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.

Page 21: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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.

Page 22: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 23: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

EUROPEAN TOPIC CENTRE ON WATER

EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 23

Relationships scheme

Page 24: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 25: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 26: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 27: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 28: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 29: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 30: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 31: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 32: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 33: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 34: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 35: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 36: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 37: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 38: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 39: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 40: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 41: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 42: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 43: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 44: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 45: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 46: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC 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

Page 47: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 48: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 49: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 50: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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 :

Page 51: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 52: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 53: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 54: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 55: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 56: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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.

Page 57: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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.

Page 58: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 59: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 60: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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.

Page 61: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 62: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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.

Page 63: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 64: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 65: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 66: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 67: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 68: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 69: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 70: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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

Page 71: EUROPEAN TOPIC CENTRE ON WATER EEA/ETC Water/ EIONET Workshop, Budapest, Hungary, 22-23 May 2003 slide 1 EUROWATERNET-Emissions and EPER EEA - ETC Water

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.