data harmonisation in theory and in practice case study...
TRANSCRIPT
Co-funded by the
Community programme
eContentplus
European Network of Best
Practices for Interoperability
of Spatial Planning Information
Data harmonisation
in theory and in practice
Case study Sumperk/Olomouc
INSPIRE Conference
27.6. - 1.7. 2011
Petr Horak, Martin Vlk, Sarka Horakova
Lea Manakova, Miloslav Dvorak
Overview of the Presentation
• Plan4all participants and themes
• Data harmonisation idea
• Harmonisation steps
• Inputs into harmonisation process
• Transformation tables
• How to publish harmonised data
• Towards to INSPIRE data specification
Experience of Help forest Sumperk and Municipality of the
Olomouc city with LandUse data harmonisation within the
Plan4all project
Plan4all Participants and Themes
Plan4all - 24 partners from 15 European countries
• 16 of them test their own data sets
Annex II
• Land cover
Annex III
• Land use
• Utility and Government services
• Production and industrial facilities
• Agricultural and aquaculture facilities
• Area management/restriction/regulation zones and reporting
units
• Natural risk zones
Plan4all Harmonisation Idea
Source Data
HF
Source Data
MEDDTL
Source Data
LAZIO
Source Data
ADR
Source Data
EPF
Source Data
DIPSU
Source Data
AVINET
Source Data
MAC
Source Data
GIJONSource Data
NASURSA
Source Data
GEORAMA
Source Data
FTZ
Source Data
PROVROMA
Source Data
ZPR
Source Data
LGV
Source Data
TDF
Source Data
OLOMOUC
Conceptual
model
Target Data
Structure
Plan4all Harmonisation Idea
Source Data Transformation Harmonised data
Source Data HF
Number
Name_area
Number_area
LandUse_code
LandUse_descr
55
Source Data
Olomouc
Level
Layer
PLFEST
GLUF
MACRO
55
Plan4all
Land Use
model
Target Data Structure
InspireID
Status
RegulationNature
IsOverlayArea
Geometry
Property
LUCAs_Code
MacroClassificationOfL
and
GeneralLandUseType
SpecificLandUseType
55
Land Use data model modification
Necessary
Described in metadata
Optional
Not solved in this stage
Key field
Necessary fields
Optional fields
Land Use data model modification
Harmonization steps
1. Description of the source data structure – the exact description of
the source data enables better understanding of data and definition of the
transformation table. The description includes a scheme of data structure,
description of data formats, object types and Code lists or enumerations.
2. Data transformation – it is a main harmonisation process where data from
the original source structure is transformed into the target structure. The target data
structure is created on the basis of conceptual models. The transformation has two
levels – at first, the transformation of features has to be specified and then also
transformation of code lists or enumerations must be defined for each
transformed attribute. The transformation can be done through transformation tools
or directly through SQL query.
3. Publication – there are several ways how to publish the harmonised data
stored in the target structure. The Plan4all regions test the publication of the
harmonised spatial planning data in their own web map applications and also
provided the data through OGC web services WMS and WFS.
Source Data Description
Description of the source data
- General principle of the data management in regions
- Description of structures of the source data
- Translation of national terms
Data Transformation
Transformation methodes1. Transformation tools
2. Direct editing of database - SQL queries (used in Sumperk and Olomouc)
Data transformation process (HF example)
• The target structure has been established on the basis of LandUse conceptual data
model defined in WP4. Because this conceptual data model is not fully
corresponding to the source data structure, some modifications have been
proposed and only some of the fields have been used. The target database is
PostGIS.
• The transformation (harmonisation) scheme have been defined in two steps
• The scheme for attributes transformation
• The scheme for values transformation – comparison of enumerations of the
source and target data
• The target PostGIS tables have been filled on the basis of transformation
(harmonisation) schemes
Data Transformation
Transformation schemes1. Features transformation
2. Attributes transformation
Data Transformation
Transformation schemes1. Features transformation
2. Attributes transformation
Publication
Publication of Harmonised Data via Geohosting tool
• Web Map Client
• OGC Web Services (WMS, WFS)
Agreement on:
• Coordination system and projection: ETSR (EPSG 3035)
• Legends for Land Use data presentation
Publication
Map Compositions via Geohosting tool
Publication in Web Map Client
Original data Harmonised General Land Use Harmonised Status of Area
WMS Compositions
Examples of Harmonised Data
Building Percentage
in developing areas Height indication
Examples of Harmonised Data
Specific LandUse Type Indirect Executions
Connection to INSPIRE
Plan4all project has been invited to participate in the testing of the
INSPIRE Annex II and III data specifications.
Plan4all joined to the INSPIRE testing team. Within the Plan4all wil be
tested the INSPIRE themes:
- Land Cover
- Land Use
- Natural Risk Zones
Plan4all conceptual data models will be replaced by INSPIRE
data specifications
=> the present experience with tests on conceptual models will be
re-used in following INSPIRE tests
