180 likes | 325 Views
Pollution Release and Transfer System (PRTR) in the Netherlands From monitoring via validation to presentation to the general public For EPER, EPRTR and Aarhus Iksan van der Putte.
E N D
Pollution Release and Transfer System (PRTR) in the Netherlands From monitoring via validation to presentation to the general public For EPER, EPRTR and Aarhus Iksan van der Putte Information sources: RIVM (National Institute for Public Health and Environment – the Netherlands and TNO- the Netherlands
30 years PRTR in the Netherlands • Since 1974 registration of emissions to air, water and soil into one integrated system • the national system • Started with the big industries (point sources) • Since 2003 electronic reporting and validation tool • Diffuse sources integrated • Agriculture, traffic, small industries, consumers • Integrated GIS (Geographical Information System) • Based on administrative data / activity data • Since 2002 datawarehouse available to the public • www.emissieregistratie.nl
General concept: three levels of hierarchy 2. Sources 1. Compounds • Economical sector • Individual industry / activity • Env. Themes • Profiles & blends • Individual compounds >2000 >180 Emissions >3500 • Grid 5*5 km / point sources • Community / Water catchment area • Provinces 3. Locations
Diffuse sources Why diffuse sources • Besides EPER in the future also diffuse source to be reported in the EPRTR (starting 2007-data in april 2009) • Increasing in importance in the Netherlands Our implementation of Aarhus: • a Datawarehouse (since 2002)
Non- industrial sources Industry Major Individual Companies in industry Database Estimates from special task forces Estimates based on statistical data and environmental reports Emission as reported in mandatory annual environmental reports (AER) General principles of the inventory:
How calculated: from the national total per activity • Some activities are related to line sources • (roads, rivers with number of cars per road) • Point sources (industries) • Rest of (smaller industries, per number of workers per sector per 4 digit postal code • Surface related • Land use (agriculture), consumers (houses) All the different locations in GIS are related to each other by their surface
(Inter)national Reports Query Allocation tables: Reporting code per Source/compound/activity Reporting procedures • Reporting requirements: • National • IPCC (CRF) • UNECE (LRTAP) • LCP • IPPC (EPER) Reporting codes Sources/compounds
National Emission Database MAPS GIS System For Spatial distribution of emissions Regional Reports Data Ware House On the Internet Informing the public • EMISSIONS per: • 5 X 5 km • Municipalities • Provinces • Catchments area
Part 2: electronic reporting for the industryA tax-form for the environment? • Since 1995 mandatory annual reporting by the industry • 250 biggest companies + 500 voluntary • Questionnaire on paper of 100+ pages (fixed format) • Increasing amount of themes • air, water, waste, noise, safety, soil... • 250 (local) authorities for validation • at least 7 copies on paper • Digitised after validation into one database • quality problems
Electronical: what’s in it for us • For the industries • Less administrative burden: easy to use, intelligent support, consistency check, validation, historical data for comparison ... • For the local authorities • Easier validation and higher quality of the data • For RIVM-EAA* and the Ministry of environment: • Higher quality of the reported data • Shorter timeframe for the reporting: faster evaluation of environmental policies • No error-prune digitalisation afterwards * RIVM: Netherlands Public Institute for Environment and Health
Who is who with the e-MJV (electronic Ann. Rep.) • Ministry for Housing, Spatial Planning and Environment • owns the system and its data • Ministry of economic affairs / NOVEM added de energy module • Deloitte & Touche • developed the e-MJV in co-operation with RIVM-MNP • Facilitating Organisation for the Industry • runs the helpdesk and support • responsible for digitising the paper versions • RIVM-MNP (Environmental Assessment Agency) • implementation of the system: hosting and maintaining, technical support
Introduction eMJV • In 2003 we finished a pilot (2 provinces) • most problems related to the technology used for data protection using internet • from single user to multiuser-application • In 2004 we did a full introduction • goal set on 60 percent participation in two years • the paper route is always the alternative
Introduction eMJV Results 2005 • 57 % participation of the industrial sites (272 out of 481) • Excluding voluntary reports: 68% • Start of integration with other inquiries related to energy • Less administrative burden for the industries in relation to the paper format (average from 26 to 20 days per industry) For years 2006 and further (release 3) • Integration with emission trade • Including IPPC permit registration by the local authorities
The e-MJV system • An intelligent form (100+ pages) • Many checks and balances • A central database with the historical and new data • A web-site (public and non-public part) to: • Give user support (additional helpdesk) • Reporting of data (to spreadsheets) • Reporting of status information
Technology used • Disconnected tax-form • Visual Basic application on CD or download • Synchronising via internet • XML, Soap toolkit, 128 bit encryption, SSL • Oracle database • Hosting in subnet, at least three components (firewalls) between internet and the (Oracle) database • Authentication via login, password and pin-code • (ldap) Verisign certification (comparable with financial transactions)
The four components of the Dutch Environmental Tax-form (eMJV) 1. A Visual Basic client application communicating directly with the central database 2. Web-services (for non anonymous use) and a central database 3. A non anonymous secure website • Company (700 in the Netherlands), • Receives CD with a Visual Basic application • Receives a letter with username, password, pincode • After installing the application connects with the central database • Receives the historical data • Uses the VB-application to fills in the form • Sends the current year to the central database Data layer 128 bit SSL, HTTPS For reporting, status information, Up- and downloads of XML files and CSV-files, FAQ list Oracle opslag Internet Oracle DBMS Application layer DotNet + IIS HTTP 128 bit SSL, HTTPS, SOAP, XML Presentation layer 4. A public website 128 bit SSL, HTTPS, SOAP, XML Www.rivm.mnp.nl I-Planet ent. Webserver HP UX Internet Internet For general information • (Local) authorities and supporting organisations (200 in the Netherlands) • Receives CD with a Visual Basic application, an username, password, pincode • After installing this application connects with the central database • Receives the historical data and the forms of this year of the companies under their authority • Use the same VB-application to judge the information, they can approve, ask for changes etc. • All communications goes via the central database
PIX firewall Storage Physical infrastructure Identification & Authentication Blue Blackt Red Win 2000 UNIX ICT architectuur of the Dutch Environmental Tax-form Companies, (Local) authorities, supporting organisations Non-anonymous internet zone www.rivm.nl Iplanet ent. webserver SUN/UX Reverse Proxy (iChain) Data layer SSL • Caching • SSL en/decoding • Tokens / certif. Oracle HTTP Internet SSL, HTTP HTTP HTTP Oracle DBMS Application layer • Cisco PIX firewall • IP filtering • Tunix firewall • application filtering (HTTP) • application logging • anti spoofing mechanisme • loggen of source-routed pakketten VPN, LDAP authorisation www.emjv.nl/beveiligd DotNet + IIS LDAP HTTP For authentication Presentation layer • Cisco PIX firewall • IP filtering • only known ports Www.rivm.mnp.nl I-Planet ent. Webserver HP UX FO/ I, Deloitte & Touche
Lessons learned • Keep it simple (the UK) • Dutch system initial costs > 2.000 k€, Annual costs (central) 6 fte + 300 k€ • Give the history as basis • Standards do help (fixed lists of chemical compounds, energy carriers etc. etc.) • Give profiles, but don’t make them obligatory (emission factors, VOC-profiles) • Spend more energy in communication and less in technology