1 / 11

Stefan Feigenspan

German air quality database – country experience on e- reporting. Stefan Feigenspan. Umweltbundesamt - Unit II 4.2 – Air Quality Assessment. EIONET Workshop Madrid. Bring your house in order! (Sheila 2012).

kirima
Download Presentation

Stefan Feigenspan

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. German airqualitydatabase – countryexperience on e-reporting Stefan Feigenspan Umweltbundesamt - Unit II 4.2 – Air Quality Assessment

  2. EIONET Workshop Madrid Bring yourhouse in order! (Sheila 2012) Stefan Feigenspan EIONET Workshop 2013 24.10.2013

  3. Main issues • Di I have all AQ dataavailable? • Are mydatasetsconistenttothemetadata? • In whichzoneismystationlocated? • Do I have all mandatoryinformation? • Are myaggregationroutines valid (Are EEA and MS in compliance)? • Youhavetoknow, whatyouraremeasuring? Where? When? How? Exceedancesituation… Stefan Feigenspan EIONET Workshop 2013 24.10.2013

  4. Connection betweenthedataflows • Primary Up-to-dateassessmentdata • Primary pre-validatedassessmentdata (monthly) • Primary validatedassessmentdata (yearly) • Information on assessmentmethods (metadataofstationsandmeasurements) • Information on zonesandagglomerations • Information on zoneswith time extension • Information on lowemissionzones Stefan Feigenspan EIONET Workshop 2013 24.10.2013

  5. Way toconsistentdataandmetadata Data delivery Database import Format check Metadata + completeness + aggregation Additional delivery orcorrectionofmetadata Stefan Feigenspan EIONET Workshop 2013 24.10.2013

  6. e-reporting EEA data flows: 31.12.2013 01.01.2014 Stefan Feigenspan EIONET Workshop 2013 24.10.2013

  7. e-reporting • German AQ system: • MS SQL Server database (data, metadata, aggregationresults) • ArcGISforzones • Java programminglanguage • „add-on“ Java XML Beans exchangebetweenItalyand Germany • Java JAXB (Java Architecturefor XML Bindings)  problemswithcomplexelement Stefan Feigenspan EIONET Workshop 2013 24.10.2013

  8. e-reporting • Steps of XML Beans approach: • Read AQD-schemawith Java Apache Ant • Generates programmclasses • BuildowndatatypslikemyZone, myStation • Select mandatoryfieldsfromthedatabase • „give“ myZonetothexmlexportroutine • Schema validationisincluded only valid export, if all mandatoryelementsarefilled in therightway • That‘sit! Stefan Feigenspan EIONET Workshop 2013 24.10.2013

  9. German progress • B  finished • C  in preparation • D  partlyfinished • E2a  in preparation (similarto E1a) • F  open • G  open • H-K  web interface (JRC pilot) Stefan Feigenspan EIONET Workshop 2013 24.10.2013

  10. e-reportingrecommendations • Use EEA AQ portal • Usethecodelists • Usethe „User guidanceto XML & data model“ • Chaptersfor F, G and E1b (model data) aremissing (in version v19.3b) • Use EEA QA checks (ifavailable) Stefan Feigenspan EIONET Workshop 2013 24.10.2013

  11. Bring yourhouse in order! E-Mail: Stefan.Feigenspan@uba.de

More Related