Folie 1

1
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_at_uba.de
2
Overview

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

3
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
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
http//www.umweltprobenbank.de
7
What we would like to communicate

• 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

8
User guidance From the catalogue to data search

• 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
Profile
Synonyms, scientific name
Preferred name
Teaser, also shown in references
Passport Photograph
Description Link to SOP
Linked examples of findings
Links to preselected data search
Link to data search earthworm
Sampling period
Links to profiles of the other search paramters
Linked extended information
Specimen specific parameters
10
Profile Part 1
Synonyms, scientific name
Path in the taxonomy
Preferred name
Teaser, also shown in references
Passport Photograph
Description Link to SOP
Linked examples of findings
Link to preselected data search target
organs/matrices
Link to data search earthworm
11
Profile - Part 2
Links to profiles of the other search paramters
Sampling period
Links to preselected data search
Specimen specific parameters
Linked extended information
12
Step 2 - Selected results Analyses examples
13
Step 3 - Structure of the data search
14
Step 3 - Structure of the data search
To the profile
Systematic
Selection as bookmark
15
Step 4 - Data search results Overview

• Processing
• Search parameters
• Tables (default)
• Diagrams Flash or static
• Data export csv, Excel

• 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

15
16
Step 4.1 - Data search results Tables
17
Step 4.2 - Data search results Diagrams
Reference type wet weight
Reference type lipid weight
18
Hilfe
19
Web application architecture
http//www.umweltprobenbank.de/de/documents/profil
es/specimen_types/10037
UBA internal
IS-ESB
XHTML Renderer
Document Content Model
Editorial
UPB-DB
WebDB
Setting of parameter combinations
Editorial content
20
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
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_at_uba.de
http//www.umweltprobenbank.de
22

• End of presentation

23
Semantic Model
24
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/Desi
  gnIssues/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/r
dfxml
http//data.uba.de/rdfxml/upb/specimenType/10037
document URIs
http//umweltprobenbank.de/de/documents/profiles/s
pecimen_types/10037
http//data.uba.de/ttl/upb/specimenType/10037
http//www.w3.org/TR/cooluris/
26
27
Public environmental web portals and web
applications
A selection of specific chemical data
applications
National Portals
STARS
PRTR
PortalU
GSBL
ETOX
DE
POP-Dioxins
MUDAB
GeoPortal
INSPIRE Annex 3
EU
INSPIRE
SEIS
NORMAN
OSPAR
HELCOM
28
Public Environmental Web Applications

• 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-Diox
  ins Database of the German Federation and Laender
• ETOX - http//webetox.uba.de/webETOX/index.do?lang
  uageenDatabase 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.d
  e8080/mudab/welcome.faces
• PRTR - http//www.prtr.bund.dePollutant Release
  and Transfer Register (PRTR)
• Environmental Specimen Bank - http//www.umweltpro
  benbank.de/

29
Step 4.1 - Data search results Tables