Transcript German National Inventory System, Ulrike Döringr

Federal Environmental Agency Germany
German Emission Inventory
Ulrike Doering, FEA Germany (UBA)
The 3rd Joint UN ECE Task Force Meeting & EIONET Workshop
on Emission Inventories and Projections,
6th – 8th May 2002, Córdoba, Spain
Federal Environmental Agency Germany
• Database System
Dataflow & Structure
• Software MESAP
Database CSE & Point Source
• Preview
Expert Information
National Database System
Reporting Obligations
ArcView
Energy,
EMEP
gridded
data
Gridding
Tool
Surrog.
Data
UNFCCC/
CRF tables
Transpor
t,
Agricultu
re,
CSE
Small
Combust
.Plants,
Waste
Water
Analyst
Time series
National
requirements
UNECE/
EMEP
(CORINAIR)
NEC
Point Source
Modul
LCPD
Federal Environmental Agency Germany
The CSE-MESAP Solution
M e t h o d o l o CalQlator
gies
UNFCC
CRF
MESAP Information System
Data
Administration
Handling
Reports
Excel
Analyst
LCP
Data
Management for Input Data and Results
MS Access
CSE
PoSoof Results
MS SQL
Server and
Analysis
Presentation
ORACLE Server
Database
Database
Federal Environmental Agency Germany
Time Series Object
Annual CO2 Emission of Passenger Cars in Urban
Driving Sector for the City Berlin in Germany in Gg
Berlin
Emission
CO2 Pass. Cars
Multi-dimensional
Time Series Key
Diesel
Gg
a
REF
Specs
1996
1997
1998
56,673
62,829
60,821
Data Values
Federal Environmental Agency Germany
Multi-dimensional Key
Spatial
Unit
Data
Content
Bavaria
Activity rate
Germany
Em.factor
Berlin
Emission
Pollutant
CO2
Source
Category
Fuel
Technology
Boilers
Rd Transp.
P.Cars
Sector
Biogas
Urban driving Diesel
Europe
NH3
Agriculture
Trucks
Heat production
Peat
Stuttgart
NMVOC
Comb.plants
...
Metal degreasing
...
...
1996
Berlin
Emission
CO2 Pass. Cars
Diesel
Gg
a
REF
56,673
Federal Environmental Agency Germany
Documentation
Federal Environmental Agency Germany
Workflow in CSE
CSE
Data Entry
 User Defined Data Views
 Import Facilities
 Plausibility Checks
 Unit Conversion (SI)
 Currency Exchange Rates
 Documentation
Database
Federal Environmental Agency Germany
Workflow in CSE
CSE
Database
Emission Calculation
 Equation Editor
 Integrity Checker
 Solver
Federal Environmental Agency Germany
Workflow in CSE
CSE
Database
Update Report
 MS Excel Environment
 Hot-Links to Database
 Shift Inventory Year
 MESAP Unit Handling
Federal Environmental Agency Germany
Facility / Point Source Data
Navigation Tree
Master Data Form
Federal Environmental Agency Germany
Conclusions
High Degree of Flexibility:
=> Formats of Reporting, no Problem!
=> Projections
=> Implementation of Point Source Data as well
as Facilities
Federal Environmental Agency Germany
Preview
Contemporary Reporting of Emissions
Internet => Data Warehouse
Updating the data material => further research
projects
Federal Environmental Agency Germany
Thank you
for your attention!
Federal Environmental Agency Germany
Advantages of CSE/MESAP
 lower cost:
standardized software
 higher consistency: single relational DB
 faster reporting:
Excel reports with Hot-links
 higher quality:
extensive documentation
automated processing
 secure data:
access rights management
 expandable:
modular, flexible design
 scalable:
client/server architecture

without programming
Flexibility