stefan feigenspan
DESCRIPTION
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). - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: Stefan Feigenspan](https://reader036.vdocuments.us/reader036/viewer/2022062314/56814089550346895dac131e/html5/thumbnails/1.jpg)
Stefan Feigenspan
Umweltbundesamt - Unit II 4.2 – Air Quality Assessment
German air quality database – country experience on e-reporting
![Page 2: Stefan Feigenspan](https://reader036.vdocuments.us/reader036/viewer/2022062314/56814089550346895dac131e/html5/thumbnails/2.jpg)
Stefan Feigenspan EIONET Workshop 2013 24.10.2013
EIONET Workshop Madrid
Bring your house in order!(Sheila 2012)
![Page 3: Stefan Feigenspan](https://reader036.vdocuments.us/reader036/viewer/2022062314/56814089550346895dac131e/html5/thumbnails/3.jpg)
Stefan Feigenspan EIONET Workshop 2013 24.10.2013
Main issues
- Di I have all AQ data available?- Are my datasets conistent to the metadata?- In which zone is my station located?- Do I have all mandatory information?- Are my aggregation routines valid (Are EEA and MS in
compliance)?
You have to know, what your are measuring? Where?
When? How? Exceedance situation…
![Page 4: Stefan Feigenspan](https://reader036.vdocuments.us/reader036/viewer/2022062314/56814089550346895dac131e/html5/thumbnails/4.jpg)
- Primary Up-to-date assessment data- Primary pre-validated assessment data (monthly)- Primary validated assessment data (yearly)
Connection between the dataflows
Stefan Feigenspan EIONET Workshop 2013 24.10.2013
- Information on assessment methods (metadata of stations and measurements)
- Information on zones and agglomerations- Information on zones with time extension - Information on low emission zones
![Page 5: Stefan Feigenspan](https://reader036.vdocuments.us/reader036/viewer/2022062314/56814089550346895dac131e/html5/thumbnails/5.jpg)
Metadata +
completeness+
aggregation
Data delivery
Way to consistent data and metadata
Format check
Additional delivery
or correction
of metadata
Stefan Feigenspan EIONET Workshop 2013 24.10.2013
Database
import
![Page 6: Stefan Feigenspan](https://reader036.vdocuments.us/reader036/viewer/2022062314/56814089550346895dac131e/html5/thumbnails/6.jpg)
EEA data flows:
Stefan Feigenspan EIONET Workshop 2013 24.10.2013
e-reporting
31.12.2013
01.01.2014
![Page 7: Stefan Feigenspan](https://reader036.vdocuments.us/reader036/viewer/2022062314/56814089550346895dac131e/html5/thumbnails/7.jpg)
Stefan Feigenspan EIONET Workshop 2013 24.10.2013
e-reporting
German AQ system:- MS SQL Server database (data, metadata, aggregation
results)
- ArcGIS for zones
- Java programming language- „add-on“ Java XML Beans exchange between Italy
and Germany- Java JAXB (Java Architecture for XML Bindings)
problems with complex element
![Page 8: Stefan Feigenspan](https://reader036.vdocuments.us/reader036/viewer/2022062314/56814089550346895dac131e/html5/thumbnails/8.jpg)
Stefan Feigenspan EIONET Workshop 2013 24.10.2013
e-reporting
Steps of XML Beans approach:- Read AQD-schema with Java Apache Ant
- Generates programm classes
- Build own datatyps like myZone, myStation- Select mandatory fields from the database
- „give“ myZone to the xml export routine
- Schema validation is included only valid export, if all
mandatory elements are filled in the right way
- That‘s it!
![Page 9: Stefan Feigenspan](https://reader036.vdocuments.us/reader036/viewer/2022062314/56814089550346895dac131e/html5/thumbnails/9.jpg)
- B finished- C in preparation- D partly finished- E2a in preparation (similar to E1a)
- F open- G open
- H-K web interface (JRC pilot)
Stefan Feigenspan EIONET Workshop 2013 24.10.2013
German progress
![Page 10: Stefan Feigenspan](https://reader036.vdocuments.us/reader036/viewer/2022062314/56814089550346895dac131e/html5/thumbnails/10.jpg)
- Use EEA AQ portal
- Use the codelists
- Use the „User guidance to XML & data model“- Chapters for F, G and E1b (model data) are missing (in
version v19.3b)
- Use EEA QA checks (if available)
Stefan Feigenspan EIONET Workshop 2013 24.10.2013
e-reporting recommendations