implementation of ogc table joining service and health statistics michel grothe inspire mig-t...
TRANSCRIPT
Implementation of OGC Table Joining Service
and health statistics
Michel Grothe
INSPIRE MIG-T meeting12 March 2015
Agenda
1. INSPIRE and TJS
2. Introduction OGC Table Joining Service (OGC TJS)
3. Some background information about OGC TJS
4. The implementation: E.L.F. Regional Health statistics
5. Conclusions
6. Discussion: TJS, an INSPIRE download service?
2. INSPIRE and TJS
Source: Annex D of Statistical Units data specification
Statistical data is linked to statitical units by referencing
2. INSPIRE and TJS
Source: Annex D of Statistical Units data specification
Object referencing through InspireId, thematic identifiers or unit’s codes
2. INSPIRE and TJS
Building bridges between statistical and spatial data infrastructures
Source: Annex D of Statistical Units data specification
2. INSPIRE and TJS
The incentive for TJS
Source: Annex D of Statistical Units data specification
1. INSPIRE and TJS
INSPIRE themes with statistical (tabular) data
Statistical INSPIRE themes
Attribute data
Population distribution/demography (PD)
Human health and safety (HH)
Energy resources (ER)
Statistical INSPIRE themes
Geographic data
Statistical Units (SU)
Administrative Units (AU)
Tabellen joinen met gebiedsindelingen
tabular data
boundary data
TJS
2. Introduction OGC Table Joining Service
OGC TJS offers an standardized web service interface for automatic joining of attribute data (e.g. statistical data) to geometry (administrative boundaries, postcodes, statistical units, etc.) through distributed access.
2. Introduction OGC Table Joining Service
OGC TJS operations
2. Introduction OGC Table Joining Service
Client application and TJS operations
tabular data
boundary data
2. Introduction OGC Table Joining Service
Table joining (service) and unique id’s (keys)
tabular data
boundary data
OGC TJS
Unique id’s
(keys)
2. Introduction OGC Table Joining Service
TJS and the Geographic Data Attribute Set (GDAS) format
tabular data
boundary data
data transformation
Geo data
OGC TJS
2. Introduction OGC Table Joining Service
A typical client and TJS interaction diagram
2. Introduction OGC Table Joining Service
3. Some background info about the OGC TJS
TJS research study 2013
To examine the potential of the implementing Table Joining Service concept (OGC TJS) and examine :
1. the concept and functional possibilities
2. the existing implementations and applications,
3. roles and tasks and cost-benefits for organizations that might implement TJS
Statistics Netherlands with Grant of Eurostat
Research study document for download.
3. Some background info about the OGC TJS
TJS implemenation and availiable software products
No broad implementations of OGC TJS exist Software implementations are lacking (server side)Almost no clients that can interact with TJSOnly in France and Canada we found operational implementations so far
3. Some background info about the OGC TJS
No OGC reference implementation
4. The implementation for health statistics
E.L.F. European Location Framework
19http://www.elfproject.eu/
4. The implementation for health statistics
• Eurostat’s regional health statistics • Euroboundarymap of Eurogeographics
• Implementation TJS (server side and open source software) by Geonovum/Kadaster NL
• Implementation client CASPER by Geodetic Institute of Slovenia
• Planned implementation of Oskari client by Finish Geodetic institute
• Oskari platform offered by Finish Geodetic institute
4. The implementation for health statistics
EU regional health statistics application (E.L.F. demonstrator)
4. The implementation for health statistics
Eurostat’s health statistics (>300 tables)
TJS
EuroboundaryMap
4. Intro gezondheidsstatistieken app (E.L.F.)
Case regional health statisticsEurostat’s health statistics (>300 tables)
Regional health statistics at EUROSTAT (>300 tables)
4. The implementation for health statistics
Input and output formats of TJS
4. The implementation for health statistics
CASPER Client
4. The implementation for health statistics
Architecture final deployment
data tables(SDMX)
Download Service
SDMX to
GDASEuroSTAT
E.L.F. - Oskari PlatformEuroboundarymap
Health statistics
Cached data
Casper(GINST)
Geographic data
Download Service
WFS
TJS test demonstrator
(Kadaster)
TJS join
Download Service
Download Service
WFSWMS
Join Service
TJS
Other clients
Transformation Service
SDMX REST
4. The implementation for health statistics
TJS tabular data transformation tool
GDAS Transformation tool
Input standards:
SDMX Odata - Open Data Protocol
CSV
Open source project. Code public available on GitHub:https://github.com/thijsbrentjens/geoserver/tree/tjs_2.2.x/
4. The implementation for health statistics
GeoServer TJS community extension
Open source project: GeoServer TJS extension
Thanks to
(improved) WMS and added WFS output by
Code public available on GitHub:https://github.com/thijsbrentjens/geoserver/tree/tjs_2.2.x/
4. The implementation for health statistics
Upcoming final work (delivery autumn 2015)
1. Testing CASPER client connection to all Eurostat regional health statistics tables
2. And testing stability of the TJS
3. Better integration of data transformation tool into Geoserver for easier deployment
4. Final deployment at the E.L.F. OSKARI platform
5. Finish technical documentation
4. The implementation for health statistics
5. Conclusions (so far)
OGC TJS is potentially interesting! Esp. in case of large number tabular datasets and/or frequently updated tabular datasets. BUT …•No broad implementations of OGC TJS exist
•Tabular data transformations are needed. Geoserver implementation has only implemented GDAS.
•We need further experiences, investments and broader implementation to further explore the benefits!
TJS, an INSPIRE download service?
6. Discussion
Questions?
More info:
http://www.geonovum.nl/onderwerpen/services/table-joining-services
[email protected] | www.geonovum.nl | @geonovum
Thank you for your attention!