1 / 29

Presentation of data to the public – German experience

This workshop in Berlin on April 20-21, 2011 will showcase the German Environmental Specimen Bank's open data on the web. Learn about the structure, functions, and technical architecture of the ESB Information System.

terrancej
Download Presentation

Presentation of data to the public – German experience

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. Workshop, Berlin 20.-21. April 2011 Presentation of data to the public – German experience German Environmental Specimen Bank: Open Data on the Web Maria Rüther Umweltbundesamt, Dessau-Roßlau maria.ruether@uba.de

  2. Overview Introduction Environmental Specimen Bank (ESB) Information System ESB ESB web application Structure and functions Technical architecture Outlook

  3. UPB/Koschorreck The German Environmental Specimen Bank … …is an archive of periodically collected representive environmental and human specimens • Established by the BMU • managed by UBA • Collection of biotic, abiotic and human specimens • Chemical analysis prior to storage for a fixed set of substances • Long-term storage for retrospective monitoring • All data and information are administered in the ESB Information System • Photos: UKM Münster (5), UPB-Projektgruppe Trier (13) UPB/Koschorreck

  4. Workshop, Berlin 20.-21. April 2011 The Information System of the ESB Client/server application for the internal data administration and data retrieval MS Access client for data administration Oracle database for centralised data management Public access ESB website Data flow

  5. ESB website: Who are our target groups … Interested citizens Press and scientists Politicians and administration … and how can we serve these groups? Our user guidance approach: One view on our information and data for all groups A guiding website structure, which supports first time visitors and returning users, experts and non-experts 5 Workshop, Berlin 20.-21. April 2011 20. April 2011

  6. Workshop, Berlin 20.-21. April 2011 http://www.umweltprobenbank.de

  7. Workshop, Berlin 20.-21. April 2011 Basics: responsibilities, objectives, concept Overview: A profile catalogue of all search parameters Who? What? Where? When? Online data search Temporal and spatial trends of selected substances Description of the specimens (biometric/anamnestic data) Results: Evaluated and commented Selected results Publications What we would like to communicate

  8. Workshop, Berlin 20.-21. April 2011 User guidance: From the catalogue to data search Commented Data Search Example 2 Catalogue All Parameters Profile 1 3 Data Search 1 Parameter Data Search Result 4 Glossary 5 The catalogue contains interlinked profiles of all search parameters Data search results are linked to commented short assessment reports, introducing the search parameters Then the user can go to the data search dialogue and vary the combination The results contain additional information, e.g. evaluation criteria

  9. Synonyms, scientific name Profile Preferredname Teaser, also shown in references „Passport Photograph“ Description; Link to SOP Linkedexamplesoffindings Links topreselecteddatasearch Link to data search „earthworm“ Sampling period Links toprofiles oftheothersearchparamters Linked extended information Specimenspecificparameters

  10. Profile – Part 1 Synonyms, scientific name Path in thetaxonomy Preferredname Teaser, also shown in references „Passport Photograph“ Description; Link to SOP Linkedexamplesoffindings Link topreselecteddatasearch targetorgans/matrices Link todatasearch „earthworm“

  11. Profile - Part 2 Links toprofiles oftheothersearchparamters Sampling period Links to preselected data search Specimenspecificparameters Linked extended information

  12. Step 2 - Selected results: Analyses examples 2 1 3 4 5

  13. Step 3 - Structure of the data search 2 1 3 4 5

  14. Step 3 - Structure of the data search 2 1 3 4 5 To the profile Systematic Selection as bookmark

  15. Processing Search parameters Tables (default) Diagrams: Flash or static Data export: csv, Excel Step 4 - Data search results: Overview Standard display of data Mean value Footnotes with context information Additional functions Converting Dry weight to wet weight Wet weight to lipid weight Optional display Statistical parameters, measure-ment methods and institutes Classifying by gender (human) Legend 2 1 3 4 5 15

  16. 2 1 3 4 5 Step 4.1 - Data search results: Tables

  17. Step 4.2 - Data search results: Diagrams 2 1 3 4 5 Reference type wet weight Reference type lipid weight

  18. Hilfe

  19. Workshop, Berlin 20.-21. April 2011 Web application architecture http://www.umweltprobenbank.de/de/documents/profiles/specimen_types/10037 UBA internal XHTML Renderer IS-ESB Document Content Model Editorial UPB-DB WebDB Setting of parameter combinations Editorial content

  20. Workshop, Berlin 20.-21. April 2011 Outlook Projects started in 2010 • ESB and Linked Open Data (LOD) • Publishing ESB information and data on the web as LOD • Links to other applications, e.g. EUNIS, GEMET • New ESB data management • Generalised data model • Development as a web application Future developments by 2014 • Providing ESB meta data to INSPIRE (Annex 3) • Themes • Human health and safety • Soil • Environmental monitoring facilities

  21. Workshop, Berlin 20.-21. April 2011 Thank you for your attention! The UBA ESB team Marike Kolossa-Gehring André Conrad Andrea Körner Jan Koschorreck Christa Schröter-Kermani innoQ Deutschland GmbH wemove digital solutions GmbH chives Webdesign The developing team Maria Rüther maria.ruether@uba.de http://www.umweltprobenbank.de

  22. End of presentation

  23. Workshop, Berlin 20.-21. April 2011 Semantic Model

  24. Workshop, Berlin 20.-21. April 2011 Platform • Runtime Environment • JRuby (100% Pure-Java Implementation of the Ruby Programming Language) • Underlying Implementation • Ruby on Rails (Open Source Web Framework) • Application Server • Apache Tomcat • Database Management System (DBMS) • Oracle 10g • Chart Rendering • JFreeChart • Open Flash Chart

  25. Linked Data Principles Use URIs as names for things Use HTTP URIs so that people can look up those names. When someone looks up a URI, provide useful information, using the standards (RDF, SPARQL) Include links to other URIs. so that they can discover more things. Tim Berners-Lee, 2006-07-27 http://www.w3.org/DesignIssues/LinkedData.html

  26. „ look up those names”- Content Negotiation resource URI http://data.uba.de/upb/specimenType/10037 303 redirect content-types text/html text/turtle application/rdf+xml http://data.uba.de/rdfxml/upb/specimenType/10037 document URIs http://umweltprobenbank.de/de/documents/profiles/specimen_types/10037 http://data.uba.de/ttl/upb/specimenType/10037 http://www.w3.org/TR/cooluris/ 26

  27. Environment Specimen Bank Public environmental web portals and web applications A selection of … specific chemical data applications National Portals PRTR STARS PortalU GSBL ETOX DE POP-Dioxins MUDAB GeoPortal INSPIRE Annex 3 EU NORMAN OSPAR SEIS INSPIRE HELCOM

  28. PortalU – http://www.portalu.deGerman Environmental Information Portal with access to several hundred thousands of internet pages and database items of public institutions and organizations; maintained in a cooperation of the federal level and the Länder Geoportal - http://www.geoportal.bund.deNational geoportal and node for INSPIRE; maintained in a cooperation of the federal level and the Länder Specific applications dealing with chemical data (selection) GSBL - http://www.gsbl.deJoint Substance Data Pool of the German Federation and Laender (GSBL) with information on the environmental properties of chemical substances for hazard prevention POP-Dioxins - http://www.pop-dioxindb.de/POP-Dioxins Database of the German Federation and Laender ETOX - http://webetox.uba.de/webETOX/index.do?language=enDatabase for Ecotoxicological Effect Data and Quality Targets ETOX STARS - http://www.stoffdaten-stars.de/Database for soil and environmental relevant substances MUDABMarine Environmental Data Base (MUDAB), the central German data base for marine data collected within the framework of international and national conventions for the protection of the North Sea and Baltic Seahttp://www.informus.de:8080/mudab/welcome.faces PRTR - http://www.prtr.bund.dePollutant Release and Transfer Register (PRTR) Environmental Specimen Bank - http://www.umweltprobenbank.de/ Public Environmental Web Applications

  29. Step 4.1 - Data search results: Tables 2 1 3 4 5

More Related