SUPD INSPIRE data harmonisation Pieter Bresters Krakow October
SU-PD INSPIRE data harmonisation Pieter Bresters, Krakow, October 2014
SU-PD population grid data harmonisation As is Harmonized GML-SU GML-PD 2
Contents – – – Explanation Approach Encountered problems Conclusions Discussion 3
Explanation Why harmonize? – INSPIRE directive ‐ 34 themes, 3 Annexes ‐ Statistical Units (SU) ‐ Population Distribution (PD) – Better data interoperability throughout Europe 4
Explanation – December 2013 data had to be published as-is. – October 2015 new Annex III datasets have to be harmonized. – Population grids concern 2 INSPIRE themes ‐ SU: Statistical Units (grid) ‐ PD: Population Distribution – TWG SU and PD has delivered 2 data specifications – They were translated in schema definition files (. xsd) 5
Explanation SU-Grid 6
Explanation PD 7
Approach – – – Download As-Is data from www. efgs. info Create Arc. GIS shape file in Arc. GIS Tried to do it with Data. Interop extension of Arc. GIS 10. 1 Create GML’s As-Is in QGIS Download output schema’s: http: //inspire. ec. europa. eu/schemas/ – Used HALE software to define transformation – Created 2 GML (SU and PD) – Tried to import them in GIS-software 8
The start. 9
Join the. csv file to the grid in Arc. GIS 10
Create GML-As Is in QGIS 11
Define transformation with HALE 12
Define transformation with HALE 13
Define transformation with HALE 14
Define transformation with HALE 15
Import output GML (SU and PD) 16
Import output GML (SU and PD) 17
Encountered problems – Many unknown attributes – What to fill in for mandatory ID’s? – How to import the resulting GML’s? – Geometry conversion – How to deal with no geometry in PD? 18
Encountered problems 19
Encountered problems – Many unknown attributes – What to fill in for mandatory ID’s? – How to import the resulting GML’s? – Geometry conversion – How to deal with no geometry in PD? 20
Encountered problems 21
Conclusions – HALE seems to do the job and has good forum support – Splitting one dataset into two does not make it easier for the GIS users – It is not clear how to implement SU and PD models in other encodings than GML 22
Discussion – Should there be a combined model (xsd) for SU-PD? If so, How do we arrange this? If not: ‐ How do we make PD useable for GIS-users? ‐ Should there be one SU-grid service for EU? ‐ Is there a need for a Table Joining Service for grids? – How do we deal with cross border pixels in INSPIRE? 23
Thank you for your attention Are there any questions? 24
- Slides: 24