150 likes | 291 Views
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. Database System Dataflow & Structure Software MESAP Database CSE & Point Source Preview.
E N D
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
Database SystemDataflow & Structure • Software MESAPDatabase CSE & Point Source • Preview
Expert Information National Database System Reporting Obligations ArcView EMEPgridded data Surrog. Data GriddingTool UNFCCC/ CRF tables Energy, Transport, Agriculture, Small Combust.Plants, Waste Water CSE Time series National requirements Analyst UNECE/ EMEP (CORINAIR) NEC Point Source Modul LCPD
CalQlator Reports UNFCC CRF MESAP Information System Data Handling Administration Excel Analyst L C P CSE Database PoSo Database MS SQL Server ORACLE Server MS Access The CSE-MESAP Solution M e t h o d o l o g i e s Data Management for Input Data and Results Analysis and Presentation of Results
Multi-dimensional Time Series Key Specs 1997 1998 1996 Berlin Emission CO2 Pass. Cars Diesel Gg a REF 56,673 62,829 60,821 Data Values Time Series Object Annual CO2 Emission of Passenger Cars in Urban Driving Sector for the City Berlin in Germany in Gg
Spatial Unit Data Content Fuel Technology Source Category Bavaria Germany Europe Stuttgart Activity rate Em.factor Pollutant Sector Biogas Peat . . . Boilers Trucks . . . NH3 NMVOC . . . Agriculture Comb.plants Heat production Metal degreasing Berlin Emission CO2 Rd Transp. P.Cars Urban driving Diesel 1996 Gg a REF 56,673 Emission Berlin CO2 Pass. Cars Diesel Multi-dimensional Key
CSE Database Workflow in CSE Data Entry • User Defined Data Views • Import Facilities • Plausibility Checks • Unit Conversion (SI) • Currency Exchange Rates • Documentation
CSE Database Workflow in CSE Emission Calculation • Equation Editor • Integrity Checker • Solver
CSE Database Workflow in CSE Update Report • MS Excel Environment • Hot-Links to Database • Shift Inventory Year • MESAP Unit Handling
Facility / Point Source Data Master Data Form Navigation Tree
Conclusions • High Degree of Flexibility: • => Formats of Reporting, no Problem! • => Projections • => Implementation of Point Source Data as well as Facilities
Preview • Contemporary Reporting of Emissions • Internet => Data Warehouse • Updating the data material => further research projects
Thank you for your attention!
Advantages of CSE/MESAP • lower cost: standardized software • higher consistency: single relational DB • faster reporting: Excel reports with Hot-links • higher quality: extensive documentationautomated processing • secure data: access rights management • expandable: modular, flexible design • scalable: client/server architecture Flexibility without programming