1 / 32

Implementation of OGC Table Joining Service and health statistics Michel Grothe

Implementation of OGC Table Joining Service and health statistics Michel Grothe INSPIRE MIG-T meeting 12 March 2015. Agenda. INSPIRE and TJS Introduction OGC Table Joining Service (OGC TJS) Some background information about OGC TJS

jrivas
Download Presentation

Implementation of OGC Table Joining Service and health statistics Michel Grothe

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. Implementation of OGC TableJoining Service and health statistics Michel Grothe INSPIRE MIG-T meeting 12 March 2015

  2. Agenda • INSPIRE and TJS • Introduction OGC TableJoining Service (OGC TJS) • Some background information about OGC TJS • The implementation: E.L.F. Regional Health statistics • Conclusions • Discussion: TJS, an INSPIRE download service?

  3. 2. INSPIRE and TJS Statistical data is linked to statitical units by referencing Source: Annex D of Statistical Units data specification

  4. 2. INSPIRE and TJS Object referencing through InspireId, thematic identifiers or unit’s codes Source: Annex D of Statistical Units data specification

  5. 2. INSPIRE and TJS Building bridges between statistical and spatial data infrastructures Source: Annex D of Statistical Units data specification

  6. 2. INSPIRE and TJS The incentive for TJS Source: Annex D of Statistical Units data specification

  7. 1. INSPIRE and TJS INSPIRE themes with statistical (tabular) data

  8. 2. Introduction OGC TableJoining Service boundary data tabular data

  9. 2. Introduction OGC TableJoining Service Tabellen joinen met gebiedsindelingen boundary data tabular data TJS

  10. 2. Introduction OGC TableJoining 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.

  11. 2. Introduction OGC TableJoining Service OGC TJS operations

  12. 2. Introduction OGC TableJoining Service Client application and TJS operations tabular data boundary data

  13. 2. Introduction OGC TableJoining Service Table joining (service) and unique id’s (keys) tabular data Unique id’s (keys) OGC TJS boundary data

  14. 2. Introduction OGC TableJoining Service TJS and the Geographic Data Attribute Set (GDAS) format tabular data data transformation OGC TJS Geo data boundary data

  15. 2. Introduction OGC TableJoining Service A typical client and TJS interaction diagram

  16. 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 : the concept and functional possibilities the existing implementations and applications, roles and tasks and cost-benefits for organizations that might implement TJS Statistics Netherlands with Grant of Eurostat Research study document for download.

  17. 3. Some background info about the OGC TJS TJS implemenation and availiable software products • No broadimplementations of OGC TJS exist • Software implementations are lacking (server side) • Almost no clientsthatcaninteractwith TJS • Only in France and Canada we found operationalimplementationsso far

  18. 3. Some background info about the OGC TJS No OGC reference implementation

  19. 4. The implementationfor health statistics E.L.F. European Location Framework 19 http://www.elfproject.eu/

  20. 4. The implementationfor health statistics

  21. 4. The implementationfor health statistics EU regional health statistics application (E.L.F. demonstrator) • Eurostat’sregional health statistics • Euroboundarymap of Eurogeographics • Implementation TJS (server side and open source software) byGeonovum/Kadaster NL • Implementationclient CASPER byGeodetic Institute of Slovenia • Plannedimplementation of OskariclientbyFinish Geodeticinstitute • Oskariplatform offeredby Finish Geodeticinstitute

  22. 4. The implementationfor health statistics Case regional health statisticsEurostat’s health statistics (>300 tables) 4. Intro gezondheidsstatistieken app (E.L.F.) TJS Eurostat’s health statistics (>300 tables) EuroboundaryMap

  23. 4. The implementationfor health statistics Regional health statistics at EUROSTAT (>300 tables)

  24. 4. The implementationfor health statistics Input and output formats of TJS

  25. 4. The implementationfor health statistics CASPER Client

  26. 4. The implementationfor health statistics Architecture final deployment

  27. 4. The implementationfor 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/

  28. 4. The implementationfor 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/

  29. 4. The implementationfor health statistics Upcomingfinalwork (delivery autumn 2015) • Testing CASPER clientconnectiontoallEurostatregional health statisticstables • Andtestingstability of the TJS • Betterintegration of data transformation tool intoGeoserverforeasierdeployment • Finaldeployment at the E.L.F. OSKARI platform • Finish technicaldocumentation

  30. 5. Conclusions (so far) OGC TJS is potentiallyinteresting! Esp. in case of large numbertabular datasets and/or frequentlyupdatedtabular datasets. BUT … • No broadimplementations of OGC TJS exist • Tabulardata transformations are needed. Geoserverimplementation has onlyimplemented GDAS. • We needfurtherexperiences, investmentsandbroaderimplementationtofurtherexplore the benefits!

  31. 6. Discussion TJS, an INSPIRE download service?

  32. Questions? Thank you for your attention! More info: http://www.geonovum.nl/onderwerpen/services/table-joining-services m.grothe@geonovum.nl | www.geonovum.nl | @geonovum

More Related