SlideShare a Scribd company logo
1 of 33
Download to read offline
Spatial Data Harmonization
On how to realize it in Spatial Planning

        Karel JANECKA, Otakar CERBA,
         Karel JEDLICKA, Jan JEZEK

            University of West Bohemia




                http://portal.sdi-edu.zcu.cz   1
Harmonization and its role in spatial planning
Spatial data harmonization

• Providing access to data through network services in a
  representation that allows for combining it with other INSPIRE data
  in a coherent way by using within the European Spatial Data
  Infrastructure (ESDI) a common set of data product specifications.
• This includes agreements about coordinate reference systems,
  classification systems, application schemes, etc.




                          http://portal.sdi-edu.zcu.cz             3
Spatial data harmonization




        http://portal.sdi-edu.zcu.cz   4
Spatial data harmonization

Components of harmonization:

• INSPIRE principles                   • Metadata
• Reference model                      • Maintenance
• Data translation model               • Quality
• Portrayal model                      • Data transfer
• Application schemes and              • Derived reporting & multiple
  feature catalogues                     representations
• Dictionaries                         • Consistency between data
                                       • Data Capturing


                       http://portal.sdi-edu.zcu.cz                 5
An example of Spatial Data
   Harmonization using
  PostgreSQL + PostGIS




         http://portal.sdi-edu.zcu.cz   6
HARMONIZATION

Source data model                                      Target data model

   Zemgale urban
                                                         CORINE land
       planing
                                                           cover
(specific data model)




                             Geometry




                        Reclassification

                        HARMONIZATION

                        http://portal.sdi-edu.zcu.cz                       7
HARMONIZATION STEPS

   Definition of reclassification rules
   Data reclassification
   Union of touching geometries in same class
   Transformation from multipolygon to polygons




                           http://portal.sdi-edu.zcu.cz   8
HARMONIZATION STEPS IN

   Definition of reclassification rules → Create mapping table
   Data reclassification → SQL JOIN using mapping table
   Union of touching geometries in same class → Spatial aggregate
    function Union
   Transformation from multipolygon to polygons → Spatial function
    dump for converting multipolygon to polygon




                          http://portal.sdi-edu.zcu.cz            9
ZEMGALE DATA MODEL


Atribute Field   Explanation                                       Type

VEIDS            Planed land use type (see possible values down)   Text 50

INDEKSS          Area with speciffic restrictions                  Text 10

PLATIBA          Area(m2)                                          Long Integer

TER_VIEN         territorial unit                                  Text 50

ADM_TER          administrative area                               Text 50

LAYER            Layer number in CAD systems                       Text 50

PIEZIMES         notes                                             Text 100




                                http://portal.sdi-edu.zcu.cz                      10
LAND COVER DATA MODEL




          CORINE land
      http://portal.sdi-edu.zcu.cz   11
            cover
RECLASSIFICATION RULES
          ZEMGALE CLASSIFICATION → CORINE NOMENCLATURE

1 DzM Low-rise residential dwellings                 →         11 Urban fabric
2 DzV Multi-residential dwellings                    →         11 Urban fabric
3 P Public Building                                  →         11 Urban fabric
4 RR Production facilities and warehouses            →         121 Industrial or commercial units
5 RD Mining area                                     →         131 Mineral extraction sites
6 T Technical Building                               →         12 Industrial, commercial...
7 Ū Waters                                           →         5 Water bodies
8 M Forests                                          →         31 Forests
9 ZĪ Outstanding foliage sites                                 No corresponding class
10 ZC Other groomed greenery space                   →         141 Green urban areas
11 L Rural Land                                      →         2 Agriculture areas
12 No data                                                     No corresponding class




                                       http://portal.sdi-edu.zcu.cz                                 12
Database tables

   plan_zonejums_part       –       orginal               dataset   (imported   from
    shapefile)
   lc_original - original classification for land cover
   lc_standardized – standardized classification for land cover
   standardized_to_original – classification mapping
   plan_zonejums_part_harm – reclassified data




                            http://portal.sdi-edu.zcu.cz                           13
Database schema




   http://portal.sdi-edu.zcu.cz   14
Harmonization query

    We have: plan_zonejums_part, lc_original, lc_standardized,
     standardized_to_original
    We need: plan_zonejums_part_harm
    SQL Query:
CREATE TABLE plan_zonejums_part_harm AS

    SELECT nextval('gid_seq'::regclass) AS gid, orig.gid AS original_gid,
      orig.the_geom, orig.veids, orig.standardized_cl, lc_standardized.lc_class

     FROM lc_standardized, ( SELECT plan_zonejums_part.gid,
     plan_zonejums_part.the_geom, plan_zonejums_part.veids,
     standardized_to_original.standardized_cl

              FROM plan_zonejums_part

        RIGHT JOIN standardized_to_original ON plan_zonejums_part.veids =
     standardized_to_original.original_cl) orig

     WHERE orig.standardized_cl::text = lc_standardized.classification::text;
                                http://portal.sdi-edu.zcu.cz                    15
Database tables

   plan_zonejums_part       –       orginal               dataset   (imported   from
    shapefile)
   lc_original – original classification for land cover
   lc_standardized – standardized classification for land cover
   standardized_to_original – classification mapping
   plan_zonejums_part_harm – reclassified data




                            http://portal.sdi-edu.zcu.cz                           16
RECLASSIFIED DATA SET




     http://portal.sdi-edu.zcu.cz   17
Next step – union of adjacent features with
                     same class

SELECT
NEXTVAL('gid_seq'::regclass)::integer AS gid,
(ST_Dump(foo.the_geom)).geom AS the_geom, standardized_cl,
lc_class FROM (
   SELECT
      ST_union(the_geom) AS the_geom, standardized_cl, lc_class
      FROM plan_zonejums_part_harm
   WHERE the_geom IS NOT NULL
   GROUP BY standardized_cl, lc_class) AS foo
WHERE foo.the_geom IS NOT NULL;




                         http://portal.sdi-edu.zcu.cz       18
Final dataset




 http://portal.sdi-edu.zcu.cz   19
An example of Spatial Data
Harmonization using commercial
    GIS software - ArcGIS




           http://portal.sdi-edu.zcu.cz   20
Using ArcGIS Model Builder
for transformations between
         data models
    P4A Land Cover example




          http://portal.sdi-edu.zcu.cz   21
Understanding target data

• Plan4all Land Cover data model




                          http://portal.sdi-edu.zcu.cz   22
Understanding target data

          • Plan4all Land Cover data model
                       – ERA diagram of database schema in ESRI Geodatabase.
                                                                              Geometry Polygon                                                                      Coded value domain
    Simple feature class                                              Contains M values No                                                                          CorineLandCoverCode
    LandCoverStandardisedArea                                         Contains Z values Yes                                                                          Description     CorineLandCoverCod
                                  Allow                                         Prec-                                                                                 Field type     e
    Field name          Data type nulls   Default value        Domain           ision Scale Length                                                                   Split policy    String
                                                                                                            Relationship class                                      Merge policy     Default value
     OBJECTID           Object ID                                                                           StandardisedArea_OriginalArea                                            Default value
                                                                                                                                                                                    Code                         Description
       SHAPE            Geometry    Yes                                                                     Type Simple           Forward label OriginalArea                         1                        Artificial surfaces
      inspireId          String     Yes                                                       15     Cardinality One to many     Backward label StandardArea
                                                                                                                                                                                     2                        Agricultural areas
       source            String     Yes                                                       50     Notification None
                                                                                                                                                                                     3               Forest and semi natural areas
    classification       String     Yes                   CorineLandCoverCode                 21         Origin feature class           Destination feature class
                                                                                                                                                                                     4                            Wetlands
beginLifespanVersion      Date      Yes                                           0     0      8           Name StandardArea                NameOriginalArea                         5                          Water bodies
 endLifespanVersion       Date      Yes                                           0     0      8     Primary key inspireId
                                                                                                                                                                                     11                          Urban fabric
   SHAPE_Length          Double     Yes                                           0     0            Foreign key inspireId                                                                                Industrial, commercial and
                                                                                                                                                                                     12
    SHAPE_Area           Double     Yes                                           0     0                            No relationship rules defined.                                                            transport units
                                                                                                                                                                                                      Mine, dump and construction
                                                                                                                                                                                     13
                                                                                                                                                                                                                     sites
                                                                                                                                                                                                        Artificial, non-agricultural
                                                                                                                                                                                     14
                                                                                                                                                                                                               vegetated areas
                                                                              Geometry Polygon                                                                                       21                          Arable land
    Simple feature class                                              Contains M values No                                                                                           22                       Permanent crops
    LandCoverOriginalArea                                             Contains Z values Yes
                                                                                                                                                                                     23                            Pastures
                                  Allow                                         Prec-                                                                                                24             Heterogeneous agricultural areas
    Field name          Data type nulls   Default value        Domain           ision Scale Length
                                                                                                                                                                                     31                         Forests
     OBJECTID           Object ID                                                                                                                                                    32
                                                                                                                                                                                                       Scrub and/or herbaceous
       SHAPE            Geometry    Yes                                                                                                                                                               Open spaces associationsno
                                                                                                                                                                                                        vegetation with little or
                                                                                                                                                                                     33
      inspireId          String     Yes                                                       15                                                                                                                  vegetation
                                                                                                                                                                                     41                        Inland wetlands
       source            String     Yes                                                       50                                                                                     42                       Maritime wetlands
    classification       String     Yes                                                       21                                                                                     51                        Inland waters
  classificationLink     String     Yes                                                       50                                                                                     52                         Marine waters
  SHAPE_Length           Double     Yes                                           0     0                                                                                           111                    Continuous urban fabric
    SHAPE_Area           Double     Yes                                           0     0                                                                                           112                   Discontinuous urban fabric
                                                                                                                                                                                    121               Industrial or commercial units
                                                                                                                                                                                                       Road and rail networks and
                                                                                                                                                                                    122
                                                                                                                                                                                                             associated land
                                                                                                                                                                                    123                         Port areas
                                                                                                                                                                                    124                            Airports
                                                                                                                                                                                    131                    Mineral extraction sites
                                                                                                                                                                                    132                         Dump sites
                                                                                                                                                                                    133                       Construction sites
                                                                                                                                                                                    141                      Green urban areas
                                                                                   http://portal.sdi-edu.zcu.cz                                                                     142                             23
                                                                                                                                                                                                          Sport and leisure facilities
                                                                                                                                                                                    211                   Non-irrigated arable land
                                                                                                                                                                                    212                   Permanently irrigated land
Understanding target data

       • Plan4all Land Cover data model

    Simple feature class                                                      Geometry Polygon
                                                                      Contains M values No
    LandCoverStandardisedArea                                         Contains Z values Yes
                                 Allow                                          Prec-
    Field name         Data type nulls    Default value        Domain           ision Scale Length          Relationship class
     OBJECTID          Object ID                                                                            StandardisedArea_OriginalArea
       SHAPE           Geometry    Yes                                                                      Type Simple           Forward label OriginalArea
      inspireId         String     Yes                                                        15     Cardinality One to many     Backward label StandardArea
       source           String     Yes                                                        50     Notification None
    classification      String     Yes                    CorineLandCoverCode                 21         Origin feature class           Destination feature class
beginLifespanVersion     Date      Yes                                            0     0      8           Name StandardArea                NameOriginalArea
 endLifespanVersion      Date      Yes                                            0     0      8     Primary key inspireId
   SHAPE_Length         Double     Yes                                            0     0            Foreign key inspireId
    SHAPE_Area          Double     Yes                                            0     0                            No relationship rules defined.



    Simple feature class                                                      Geometry Polygon
                                                                      Contains M values No
    LandCoverOriginalArea                                             Contains Z values Yes
                                 Allow                                          Prec-
    Field name         Data type nulls    Default value        Domain           ision Scale Length
     OBJECTID          Object ID
       SHAPE           Geometry    Yes
      inspireId         String     Yes                                                        15
       source           String     Yes                                                        50
    classification      String     Yes                                                        21
  classificationLink    String     Yes                                                        50
  SHAPE_Length          Double     Yes                                            0     0
    SHAPE_Area          Double     Yes                                            0     0
                                                          http://portal.sdi-edu.zcu.cz                                                                 24
Understanding source data

         • Zemgale (Latvia) data model
                             Geometry Polygon
                     Contains M values No
                                                                                                                           Coded value domain
                                                                                                                           CorineLandCoverCode
                     Contains Z values Yes                                                                                  Description     CorineLandCoverCod
                         Prec-                                                                                               Field type     e
lue    Simple feature class
           Domain         ision Scale Length                                                    Geometry Polygon            Split policy    String
                                                              Relationship class Contains M values       No                Merge policy     Default value
       plan_zonejums_JelgavaSurroundings                      StandardisedArea_OriginalArea
                                                                                 Contains Z values       No                                 Default value
                                                                                                                                           Code                         Description
                                     Allow                     Type Simple      Forward label Prec-
                                                                                               OriginalArea                                 1                        Artificial surfaces
      Field name           Data type nulls
                                         15         Default valueOne to many Domain label ision Scale Length
                                                        Cardinality            Backward        StandardArea
                                                                                                                                            2                        Agricultural areas
                                              50        Notification None
       OBJECTID              Object ID                                                                                                      3                Forest and semi natural areas
       CorineLandCoverCodeGeometry
          Shape                           Yes 21           Origin feature class        Destination feature class
                                                                                                                                            4                            Wetlands
            gid                  0
                              Double    0 Yes 8              Name StandardArea                   0       0
                                                                                           NameOriginalArea                                 5                          Water bodies
           veids               String 0 Yes 8
                                 0                     Primary key inspireId                                      21                        11                        Urban fabric
                                                       Foreign key inspireId
         indekss               String 0 Yes
                                 0                                                                                254                       12
                                                                                                                                                              Industrial, commercial and
                                                                                                                                                                    transport units
          platiba              String 0 Yes
                                 0
                                                    Atribute FieldNo relationship rules defined.
                                                                       Explanation                                21                        13   Type        Mine, dump and construction
                                                                                                                                                                              sites
                                                                                                                                                                 Artificial, non-agricultural
           pasv                String     Yes                                                                     254                       14
                                                                                                                                                                      vegetated areas
        piezimes               String     Yes                                                                     254                21                                  Arable land
        map_leaf
                             Geometry Polygon
                               String     Yes
                                                    VEIDS                   Planed land use type (see          possible
                                                                                                                  254
                                                                                                                          values down)            Text 50
                     Contains M values No                                                                                                   22                       Permanent crops
           dept       Contains String
                               Z values Yes
                                          Yes                                                                     254                       23                           Pastures
      Shape_Length            Prec-
                              Double      Yes       INDEKSS                 Area with speciffic0restrictions
                                                                                                      0                                     24    Text 10 Heterogeneous agricultural areas
lue            Domain
       Shape_Area             ision ScaleYes
                              Double       Length                                                  0       0                                31                            Forests
                                                    PLATIBA                  Area(m2)                                                       32    Long Integer and/or herbaceous
                                                                                                                                                            Scrub
                                                                                                                                                             vegetation associations
                                                                                                                                                              Open spaces with little or no
                                                                                                                                            33
                                            15                                                                                                                        vegetation
                                                                                                                                            41                     Inland wetlands
                                            50      TER_VIEN                 territorial unit                                                     Text 50
                                                                                                                                            42                       Maritime wetlands
                                            21                                                                                              51                         Inland waters
                                            50      ADM_TER                  administrative area                                            52    Text 50              Marine waters
                                0     0                                                                                                    111                    Continuous urban fabric
                                0     0
                                                    LAYER                   Layer number in CAD systems                                    112   Text 50         Discontinuous urban fabric
                                                                                                                                           121               Industrial or commercial units
                                                                                                                                                              Road and rail networks and
                                                                                                                                           122
                                                    PIEZIMES                notes                                                          123
                                                                                                                                                 Text 100           associated land
                                                                                                                                                                       Port areas
                                                                                                                                           124                            Airports
                                                                         http://portal.sdi-edu.zcu.cz                                      131
                                                                                                                                                                                  25
                                                                                                                                                                  Mineral extraction sites
                                                                                                                                           132                          Dump sites
Attribute mapping
             ZEMGALE CLASSIFICATION → CORINE NOMENCLATURE

1 DzM Low-rise residential dwellings          →          11 Urban fabric
2 DzV Multi-residential dwellings             →          11 Urban fabric
3 P Public Building                           →          11 Urban fabric
4 RR Production facilities and warehouses →              121 Industrial or commercial units
5 RD Mining area                              →          131 Mineral extraction sites
6 T Technical Building                        →          12 Industrial, commercial...
7 Ū Waters                                    →          5 Water bodies
8 M Forests                                   →          31 Forests
9 ZĪ Outstanding foliage sites                           No corresponding class
10 ZC Other groomed greenery space            →          141 Green urban areas
11 L Rural Land                               →          2 Agriculture areas
12 No data                                                  No
                                 http://portal.sdi-edu.zcu.cz    corresponding class    26
Transformation steps

• Understanding both source and target data
     – A necessary condition!


1.   Transform source data to WGS 84.
2.   Transform the source data geometry and attributes to match the
     target scheme.
3.   Apply domain.




                                http://portal.sdi-edu.zcu.cz          27
Transformation of coordinate system

1.   Transform source data to WGS 84.
     –   Explore source coordinate system,
     –   Run transformation




                                http://portal.sdi-edu.zcu.cz   28
Transformation of geometry and attributes

2.   Transform the source data geometry and attributes to match the
     target scheme.
     –       Create classes:
         •       LandCoverOriginalArea,
         •       LandCoverStandardisedArea.
     –       Fill them with data.
     –       Create relationship between them.




                                     http://portal.sdi-edu.zcu.cz     29
Transformation of geometry and attributes




               http://portal.sdi-edu.zcu.cz   30
Applying a domain

3.   Apply a StandardClassification domain to
     LandCoverStandardisedArea.




                            http://portal.sdi-edu.zcu.cz   31
Result




http://portal.sdi-edu.zcu.cz   32
References

•   JEDLICKA, K.: Using ArcGIS Model Builder for transformations between data models
    - P4A Land Cover example. In: PLAN4ALL workshop on spatial data harmonization.
    Riga, 2011.

•   JEZEK, J.: Technological aspect of spatial data harmonization.
    [ONLINE] http://prezi.com/ro8cfb114n2d/harmonization/

•   Project HUMBOLDT
    http://www.esdi-humboldt.eu/home.html

•   Project PLAN4ALL
    http://portal.plan4all.eu

•   Project SDI-EDU
    http://portal.sdi-edu.zcu.cz
                                   http://portal.sdi-edu.zcu.cz                   33

More Related Content

Viewers also liked

Digital Adoption by SMBs: A Preview of BIA/Kelsey’s Latest SMB Research - Loc...
Digital Adoption by SMBs: A Preview of BIA/Kelsey’s Latest SMB Research - Loc...Digital Adoption by SMBs: A Preview of BIA/Kelsey’s Latest SMB Research - Loc...
Digital Adoption by SMBs: A Preview of BIA/Kelsey’s Latest SMB Research - Loc...BIA/Kelsey
 
ICAMERA SHOP TRUC TUYEN
ICAMERA SHOP TRUC TUYENICAMERA SHOP TRUC TUYEN
ICAMERA SHOP TRUC TUYENTran Tien
 
Pricing Native Advertising - BIA/Kelsey Presentation to LMA Native Advertisin...
Pricing Native Advertising - BIA/Kelsey Presentation to LMA Native Advertisin...Pricing Native Advertising - BIA/Kelsey Presentation to LMA Native Advertisin...
Pricing Native Advertising - BIA/Kelsey Presentation to LMA Native Advertisin...BIA/Kelsey
 
僕が銀座のキャバ嬢と付き合えた方法
僕が銀座のキャバ嬢と付き合えた方法僕が銀座のキャバ嬢と付き合えた方法
僕が銀座のキャバ嬢と付き合えた方法大和 金太郎
 
QM2011_MobileStrategies
QM2011_MobileStrategiesQM2011_MobileStrategies
QM2011_MobileStrategiesHeather Zink
 
Connect 1.0 pods and layouts
Connect 1.0 pods and layoutsConnect 1.0 pods and layouts
Connect 1.0 pods and layoutsHeather Zink
 
Tell your story: promoting yourself and your research online
Tell your story: promoting yourself and your research onlineTell your story: promoting yourself and your research online
Tell your story: promoting yourself and your research onlineJo Hawkins
 
Presentacio complerta de pnzvg amb gravacions
Presentacio complerta de pnzvg amb gravacionsPresentacio complerta de pnzvg amb gravacions
Presentacio complerta de pnzvg amb gravacionsmiosmp
 
GI2014 ppt fryml+charvat_cesko jede
GI2014 ppt fryml+charvat_cesko jedeGI2014 ppt fryml+charvat_cesko jede
GI2014 ppt fryml+charvat_cesko jedeIGN Vorstand
 
Presentacion de Coqui comun
Presentacion de Coqui comunPresentacion de Coqui comun
Presentacion de Coqui comunNahir328
 
Boland ifa presentation
Boland ifa presentationBoland ifa presentation
Boland ifa presentationBIA/Kelsey
 
Using the lessons of golf to develop a financial strategy for 2013 and beyond
Using the lessons of golf to develop a financial strategy for 2013 and beyondUsing the lessons of golf to develop a financial strategy for 2013 and beyond
Using the lessons of golf to develop a financial strategy for 2013 and beyondNathan Gazzard
 
GI2014 ppt charvat+mildorf_from plan4all to plan4business and back – the futu...
GI2014 ppt charvat+mildorf_from plan4all to plan4business and back – the futu...GI2014 ppt charvat+mildorf_from plan4all to plan4business and back – the futu...
GI2014 ppt charvat+mildorf_from plan4all to plan4business and back – the futu...IGN Vorstand
 
Eo 4 glava
Eo 4 glavaEo 4 glava
Eo 4 glavakaatyy
 

Viewers also liked (20)

Digital Adoption by SMBs: A Preview of BIA/Kelsey’s Latest SMB Research - Loc...
Digital Adoption by SMBs: A Preview of BIA/Kelsey’s Latest SMB Research - Loc...Digital Adoption by SMBs: A Preview of BIA/Kelsey’s Latest SMB Research - Loc...
Digital Adoption by SMBs: A Preview of BIA/Kelsey’s Latest SMB Research - Loc...
 
Adp the big picture
Adp the big pictureAdp the big picture
Adp the big picture
 
ICAMERA SHOP TRUC TUYEN
ICAMERA SHOP TRUC TUYENICAMERA SHOP TRUC TUYEN
ICAMERA SHOP TRUC TUYEN
 
Pricing Native Advertising - BIA/Kelsey Presentation to LMA Native Advertisin...
Pricing Native Advertising - BIA/Kelsey Presentation to LMA Native Advertisin...Pricing Native Advertising - BIA/Kelsey Presentation to LMA Native Advertisin...
Pricing Native Advertising - BIA/Kelsey Presentation to LMA Native Advertisin...
 
僕が銀座のキャバ嬢と付き合えた方法
僕が銀座のキャバ嬢と付き合えた方法僕が銀座のキャバ嬢と付き合えた方法
僕が銀座のキャバ嬢と付き合えた方法
 
Evaluation
EvaluationEvaluation
Evaluation
 
QM2011_MobileStrategies
QM2011_MobileStrategiesQM2011_MobileStrategies
QM2011_MobileStrategies
 
Connect 1.0 pods and layouts
Connect 1.0 pods and layoutsConnect 1.0 pods and layouts
Connect 1.0 pods and layouts
 
Tell your story: promoting yourself and your research online
Tell your story: promoting yourself and your research onlineTell your story: promoting yourself and your research online
Tell your story: promoting yourself and your research online
 
Presentacio complerta de pnzvg amb gravacions
Presentacio complerta de pnzvg amb gravacionsPresentacio complerta de pnzvg amb gravacions
Presentacio complerta de pnzvg amb gravacions
 
Daftar peserta
Daftar pesertaDaftar peserta
Daftar peserta
 
GI2014 ppt fryml+charvat_cesko jede
GI2014 ppt fryml+charvat_cesko jedeGI2014 ppt fryml+charvat_cesko jede
GI2014 ppt fryml+charvat_cesko jede
 
Presentacion de Coqui comun
Presentacion de Coqui comunPresentacion de Coqui comun
Presentacion de Coqui comun
 
Boland ifa presentation
Boland ifa presentationBoland ifa presentation
Boland ifa presentation
 
Using the lessons of golf to develop a financial strategy for 2013 and beyond
Using the lessons of golf to develop a financial strategy for 2013 and beyondUsing the lessons of golf to develop a financial strategy for 2013 and beyond
Using the lessons of golf to develop a financial strategy for 2013 and beyond
 
GI2014 ppt charvat+mildorf_from plan4all to plan4business and back – the futu...
GI2014 ppt charvat+mildorf_from plan4all to plan4business and back – the futu...GI2014 ppt charvat+mildorf_from plan4all to plan4business and back – the futu...
GI2014 ppt charvat+mildorf_from plan4all to plan4business and back – the futu...
 
Shot types
Shot typesShot types
Shot types
 
Eo 4 glava
Eo 4 glavaEo 4 glava
Eo 4 glava
 
Swt qt ese-2009
Swt qt ese-2009Swt qt ese-2009
Swt qt ese-2009
 
Level 1 Instruction
Level 1 InstructionLevel 1 Instruction
Level 1 Instruction
 

Similar to Cerba ppt gi2011-harmonization-of-spatial-planning-data_final

Spatial data harmonization
Spatial data harmonizationSpatial data harmonization
Spatial data harmonizationplan4all
 
The Construction of the Internet Geological Data System Using WWW+Java+DB Tec...
The Construction of the Internet Geological Data System Using WWW+Java+DB Tec...The Construction of the Internet Geological Data System Using WWW+Java+DB Tec...
The Construction of the Internet Geological Data System Using WWW+Java+DB Tec...Channy Yun
 
Berzina ppt gi2011_conference_decin_ib_final
Berzina ppt gi2011_conference_decin_ib_finalBerzina ppt gi2011_conference_decin_ib_final
Berzina ppt gi2011_conference_decin_ib_finalIGN Vorstand
 
High-Performance Graph Analysis and Modeling
High-Performance Graph Analysis and ModelingHigh-Performance Graph Analysis and Modeling
High-Performance Graph Analysis and ModelingNesreen K. Ahmed
 
Prepare Your Data For The Cloud
Prepare Your Data For The CloudPrepare Your Data For The Cloud
Prepare Your Data For The CloudIndicThreads
 
Cluster Computing with Dryad
Cluster Computing with DryadCluster Computing with Dryad
Cluster Computing with Dryadbutest
 
rasdaman: from barebone Arrays to DataCubes
rasdaman: from barebone Arrays to DataCubesrasdaman: from barebone Arrays to DataCubes
rasdaman: from barebone Arrays to DataCubesEUDAT
 
Generating Executable Mappings from RDF Data Cube Data Structure Definitions
Generating Executable Mappings from RDF Data Cube Data Structure DefinitionsGenerating Executable Mappings from RDF Data Cube Data Structure Definitions
Generating Executable Mappings from RDF Data Cube Data Structure DefinitionsChristophe Debruyne
 
Neo4j spatial-nosql-frankfurt
Neo4j spatial-nosql-frankfurtNeo4j spatial-nosql-frankfurt
Neo4j spatial-nosql-frankfurtPeter Neubauer
 
Apdm 101 Arc Gis Pipeline Data Model (1)
Apdm 101 Arc Gis Pipeline Data Model  (1)Apdm 101 Arc Gis Pipeline Data Model  (1)
Apdm 101 Arc Gis Pipeline Data Model (1)David Nichter, GISP
 
GRAPHITE: An Extensible Graph Traversal Framework for Relational Database Ma...
GRAPHITE:  An Extensible Graph Traversal Framework for Relational Database Ma...GRAPHITE:  An Extensible Graph Traversal Framework for Relational Database Ma...
GRAPHITE: An Extensible Graph Traversal Framework for Relational Database Ma...Marcus Paradies
 
Skills portfolio
Skills portfolioSkills portfolio
Skills portfolioyeboyerp
 
NOSQL Overview, Neo4j Intro And Production Example (QCon London 2010)
NOSQL Overview, Neo4j Intro And Production Example (QCon London 2010)NOSQL Overview, Neo4j Intro And Production Example (QCon London 2010)
NOSQL Overview, Neo4j Intro And Production Example (QCon London 2010)Emil Eifrem
 
Giving MongoDB a Way to Play with the GIS Community
Giving MongoDB a Way to Play with the GIS CommunityGiving MongoDB a Way to Play with the GIS Community
Giving MongoDB a Way to Play with the GIS CommunityMongoDB
 
Cluster Computing with Dryad
Cluster Computing with DryadCluster Computing with Dryad
Cluster Computing with Dryadbutest
 

Similar to Cerba ppt gi2011-harmonization-of-spatial-planning-data_final (20)

Spatial data harmonization
Spatial data harmonizationSpatial data harmonization
Spatial data harmonization
 
The Construction of the Internet Geological Data System Using WWW+Java+DB Tec...
The Construction of the Internet Geological Data System Using WWW+Java+DB Tec...The Construction of the Internet Geological Data System Using WWW+Java+DB Tec...
The Construction of the Internet Geological Data System Using WWW+Java+DB Tec...
 
Soumyadip_Chandra
Soumyadip_ChandraSoumyadip_Chandra
Soumyadip_Chandra
 
Berzina ppt gi2011_conference_decin_ib_final
Berzina ppt gi2011_conference_decin_ib_finalBerzina ppt gi2011_conference_decin_ib_final
Berzina ppt gi2011_conference_decin_ib_final
 
Dancing with the Elephant
Dancing with the ElephantDancing with the Elephant
Dancing with the Elephant
 
Sector CloudSlam 09
Sector CloudSlam 09Sector CloudSlam 09
Sector CloudSlam 09
 
High-Performance Graph Analysis and Modeling
High-Performance Graph Analysis and ModelingHigh-Performance Graph Analysis and Modeling
High-Performance Graph Analysis and Modeling
 
Prepare Your Data For The Cloud
Prepare Your Data For The CloudPrepare Your Data For The Cloud
Prepare Your Data For The Cloud
 
Preparing your data for the cloud
Preparing your data for the cloudPreparing your data for the cloud
Preparing your data for the cloud
 
Cluster Computing with Dryad
Cluster Computing with DryadCluster Computing with Dryad
Cluster Computing with Dryad
 
rasdaman: from barebone Arrays to DataCubes
rasdaman: from barebone Arrays to DataCubesrasdaman: from barebone Arrays to DataCubes
rasdaman: from barebone Arrays to DataCubes
 
Generating Executable Mappings from RDF Data Cube Data Structure Definitions
Generating Executable Mappings from RDF Data Cube Data Structure DefinitionsGenerating Executable Mappings from RDF Data Cube Data Structure Definitions
Generating Executable Mappings from RDF Data Cube Data Structure Definitions
 
Neo4j spatial-nosql-frankfurt
Neo4j spatial-nosql-frankfurtNeo4j spatial-nosql-frankfurt
Neo4j spatial-nosql-frankfurt
 
Apdm 101 Arc Gis Pipeline Data Model (1)
Apdm 101 Arc Gis Pipeline Data Model  (1)Apdm 101 Arc Gis Pipeline Data Model  (1)
Apdm 101 Arc Gis Pipeline Data Model (1)
 
GRAPHITE: An Extensible Graph Traversal Framework for Relational Database Ma...
GRAPHITE:  An Extensible Graph Traversal Framework for Relational Database Ma...GRAPHITE:  An Extensible Graph Traversal Framework for Relational Database Ma...
GRAPHITE: An Extensible Graph Traversal Framework for Relational Database Ma...
 
Skills portfolio
Skills portfolioSkills portfolio
Skills portfolio
 
NOSQL Overview, Neo4j Intro And Production Example (QCon London 2010)
NOSQL Overview, Neo4j Intro And Production Example (QCon London 2010)NOSQL Overview, Neo4j Intro And Production Example (QCon London 2010)
NOSQL Overview, Neo4j Intro And Production Example (QCon London 2010)
 
Giving MongoDB a Way to Play with the GIS Community
Giving MongoDB a Way to Play with the GIS CommunityGiving MongoDB a Way to Play with the GIS Community
Giving MongoDB a Way to Play with the GIS Community
 
Preparing yourdataforcloud
Preparing yourdataforcloudPreparing yourdataforcloud
Preparing yourdataforcloud
 
Cluster Computing with Dryad
Cluster Computing with DryadCluster Computing with Dryad
Cluster Computing with Dryad
 

More from IGN Vorstand

GI2016 final programm & proceedings of abstracts & summaries
GI2016 final programm & proceedings of abstracts & summariesGI2016 final programm & proceedings of abstracts & summaries
GI2016 final programm & proceedings of abstracts & summariesIGN Vorstand
 
GI2016 ppt hoffmann address+history from_gi2000_to_gi2016
GI2016 ppt hoffmann address+history from_gi2000_to_gi2016GI2016 ppt hoffmann address+history from_gi2000_to_gi2016
GI2016 ppt hoffmann address+history from_gi2000_to_gi2016IGN Vorstand
 
GI2016 ppt böhm saxonian_gdi_1_grenze_hi_hedo
GI2016 ppt böhm saxonian_gdi_1_grenze_hi_hedoGI2016 ppt böhm saxonian_gdi_1_grenze_hi_hedo
GI2016 ppt böhm saxonian_gdi_1_grenze_hi_hedoIGN Vorstand
 
GI2016 ppt böhm saxonian_gdi_2_eine_bwk_entsteht
GI2016 ppt böhm saxonian_gdi_2_eine_bwk_entstehtGI2016 ppt böhm saxonian_gdi_2_eine_bwk_entsteht
GI2016 ppt böhm saxonian_gdi_2_eine_bwk_entstehtIGN Vorstand
 
GI2016 ppt böhm saxonian_gdi_3_vimage
GI2016 ppt böhm saxonian_gdi_3_vimageGI2016 ppt böhm saxonian_gdi_3_vimage
GI2016 ppt böhm saxonian_gdi_3_vimageIGN Vorstand
 
GI2016 ppt charvat senslog api as tools for collection of big vgi data
GI2016 ppt charvat senslog api as tools for collection of big vgi dataGI2016 ppt charvat senslog api as tools for collection of big vgi data
GI2016 ppt charvat senslog api as tools for collection of big vgi dataIGN Vorstand
 
GI2016 ppt charvat workshop geoss & conference inspire2016
GI2016 ppt charvat workshop geoss & conference inspire2016GI2016 ppt charvat workshop geoss & conference inspire2016
GI2016 ppt charvat workshop geoss & conference inspire2016IGN Vorstand
 
GI2016 ppt mayer copernicus_dresden
GI2016 ppt mayer copernicus_dresdenGI2016 ppt mayer copernicus_dresden
GI2016 ppt mayer copernicus_dresdenIGN Vorstand
 
GI2016 ppt schiller dbd-bauprofessor & zuse-dualsemantik
GI2016 ppt schiller dbd-bauprofessor & zuse-dualsemantikGI2016 ppt schiller dbd-bauprofessor & zuse-dualsemantik
GI2016 ppt schiller dbd-bauprofessor & zuse-dualsemantikIGN Vorstand
 
GI2016 ppt schiller kostenkalkül
GI2016 ppt schiller kostenkalkülGI2016 ppt schiller kostenkalkül
GI2016 ppt schiller kostenkalkülIGN Vorstand
 
GI2016 ppt shi (automatic interaction and seamless integration of big data hu...
GI2016 ppt shi (automatic interaction and seamless integration of big data hu...GI2016 ppt shi (automatic interaction and seamless integration of big data hu...
GI2016 ppt shi (automatic interaction and seamless integration of big data hu...IGN Vorstand
 
GI2016 ppt shi (big data analytics on the internet)
GI2016 ppt shi (big data analytics on the internet)GI2016 ppt shi (big data analytics on the internet)
GI2016 ppt shi (big data analytics on the internet)IGN Vorstand
 
GI2016 ppt shi (cartography and communication)
GI2016 ppt shi (cartography and communication)GI2016 ppt shi (cartography and communication)
GI2016 ppt shi (cartography and communication)IGN Vorstand
 
GI2016 Open Call for Presentations
GI2016 Open Call for PresentationsGI2016 Open Call for Presentations
GI2016 Open Call for PresentationsIGN Vorstand
 
GI2015 ppt hoffmann_address_intro
GI2015 ppt hoffmann_address_introGI2015 ppt hoffmann_address_intro
GI2015 ppt hoffmann_address_introIGN Vorstand
 
GI2015 programme+proceedings
GI2015 programme+proceedingsGI2015 programme+proceedings
GI2015 programme+proceedingsIGN Vorstand
 
CoO + GI2015 ppt_charvat ict for a sustainable agriculture – public support n...
CoO + GI2015 ppt_charvat ict for a sustainable agriculture – public support n...CoO + GI2015 ppt_charvat ict for a sustainable agriculture – public support n...
CoO + GI2015 ppt_charvat ict for a sustainable agriculture – public support n...IGN Vorstand
 
CoO + GI2015 ppt_mayer ict for a sustainable agriculture - status and missing
CoO + GI2015 ppt_mayer ict for a sustainable agriculture - status and missingCoO + GI2015 ppt_mayer ict for a sustainable agriculture - status and missing
CoO + GI2015 ppt_mayer ict for a sustainable agriculture - status and missingIGN Vorstand
 
GI2015 ppt karas dresden j.karas
GI2015 ppt karas dresden j.karasGI2015 ppt karas dresden j.karas
GI2015 ppt karas dresden j.karasIGN Vorstand
 
GI2015 ppt hladikova copernicus_agriculture_forestry_lh
GI2015 ppt hladikova copernicus_agriculture_forestry_lhGI2015 ppt hladikova copernicus_agriculture_forestry_lh
GI2015 ppt hladikova copernicus_agriculture_forestry_lhIGN Vorstand
 

More from IGN Vorstand (20)

GI2016 final programm & proceedings of abstracts & summaries
GI2016 final programm & proceedings of abstracts & summariesGI2016 final programm & proceedings of abstracts & summaries
GI2016 final programm & proceedings of abstracts & summaries
 
GI2016 ppt hoffmann address+history from_gi2000_to_gi2016
GI2016 ppt hoffmann address+history from_gi2000_to_gi2016GI2016 ppt hoffmann address+history from_gi2000_to_gi2016
GI2016 ppt hoffmann address+history from_gi2000_to_gi2016
 
GI2016 ppt böhm saxonian_gdi_1_grenze_hi_hedo
GI2016 ppt böhm saxonian_gdi_1_grenze_hi_hedoGI2016 ppt böhm saxonian_gdi_1_grenze_hi_hedo
GI2016 ppt böhm saxonian_gdi_1_grenze_hi_hedo
 
GI2016 ppt böhm saxonian_gdi_2_eine_bwk_entsteht
GI2016 ppt böhm saxonian_gdi_2_eine_bwk_entstehtGI2016 ppt böhm saxonian_gdi_2_eine_bwk_entsteht
GI2016 ppt böhm saxonian_gdi_2_eine_bwk_entsteht
 
GI2016 ppt böhm saxonian_gdi_3_vimage
GI2016 ppt böhm saxonian_gdi_3_vimageGI2016 ppt böhm saxonian_gdi_3_vimage
GI2016 ppt böhm saxonian_gdi_3_vimage
 
GI2016 ppt charvat senslog api as tools for collection of big vgi data
GI2016 ppt charvat senslog api as tools for collection of big vgi dataGI2016 ppt charvat senslog api as tools for collection of big vgi data
GI2016 ppt charvat senslog api as tools for collection of big vgi data
 
GI2016 ppt charvat workshop geoss & conference inspire2016
GI2016 ppt charvat workshop geoss & conference inspire2016GI2016 ppt charvat workshop geoss & conference inspire2016
GI2016 ppt charvat workshop geoss & conference inspire2016
 
GI2016 ppt mayer copernicus_dresden
GI2016 ppt mayer copernicus_dresdenGI2016 ppt mayer copernicus_dresden
GI2016 ppt mayer copernicus_dresden
 
GI2016 ppt schiller dbd-bauprofessor & zuse-dualsemantik
GI2016 ppt schiller dbd-bauprofessor & zuse-dualsemantikGI2016 ppt schiller dbd-bauprofessor & zuse-dualsemantik
GI2016 ppt schiller dbd-bauprofessor & zuse-dualsemantik
 
GI2016 ppt schiller kostenkalkül
GI2016 ppt schiller kostenkalkülGI2016 ppt schiller kostenkalkül
GI2016 ppt schiller kostenkalkül
 
GI2016 ppt shi (automatic interaction and seamless integration of big data hu...
GI2016 ppt shi (automatic interaction and seamless integration of big data hu...GI2016 ppt shi (automatic interaction and seamless integration of big data hu...
GI2016 ppt shi (automatic interaction and seamless integration of big data hu...
 
GI2016 ppt shi (big data analytics on the internet)
GI2016 ppt shi (big data analytics on the internet)GI2016 ppt shi (big data analytics on the internet)
GI2016 ppt shi (big data analytics on the internet)
 
GI2016 ppt shi (cartography and communication)
GI2016 ppt shi (cartography and communication)GI2016 ppt shi (cartography and communication)
GI2016 ppt shi (cartography and communication)
 
GI2016 Open Call for Presentations
GI2016 Open Call for PresentationsGI2016 Open Call for Presentations
GI2016 Open Call for Presentations
 
GI2015 ppt hoffmann_address_intro
GI2015 ppt hoffmann_address_introGI2015 ppt hoffmann_address_intro
GI2015 ppt hoffmann_address_intro
 
GI2015 programme+proceedings
GI2015 programme+proceedingsGI2015 programme+proceedings
GI2015 programme+proceedings
 
CoO + GI2015 ppt_charvat ict for a sustainable agriculture – public support n...
CoO + GI2015 ppt_charvat ict for a sustainable agriculture – public support n...CoO + GI2015 ppt_charvat ict for a sustainable agriculture – public support n...
CoO + GI2015 ppt_charvat ict for a sustainable agriculture – public support n...
 
CoO + GI2015 ppt_mayer ict for a sustainable agriculture - status and missing
CoO + GI2015 ppt_mayer ict for a sustainable agriculture - status and missingCoO + GI2015 ppt_mayer ict for a sustainable agriculture - status and missing
CoO + GI2015 ppt_mayer ict for a sustainable agriculture - status and missing
 
GI2015 ppt karas dresden j.karas
GI2015 ppt karas dresden j.karasGI2015 ppt karas dresden j.karas
GI2015 ppt karas dresden j.karas
 
GI2015 ppt hladikova copernicus_agriculture_forestry_lh
GI2015 ppt hladikova copernicus_agriculture_forestry_lhGI2015 ppt hladikova copernicus_agriculture_forestry_lh
GI2015 ppt hladikova copernicus_agriculture_forestry_lh
 

Recently uploaded

Planetek Italia Srl - Corporate Profile Brochure
Planetek Italia Srl - Corporate Profile BrochurePlanetek Italia Srl - Corporate Profile Brochure
Planetek Italia Srl - Corporate Profile BrochurePlanetek Italia Srl
 
How to release an Open Source Dataweave Library
How to release an Open Source Dataweave LibraryHow to release an Open Source Dataweave Library
How to release an Open Source Dataweave Libraryshyamraj55
 
20140402 - Smart house demo kit
20140402 - Smart house demo kit20140402 - Smart house demo kit
20140402 - Smart house demo kitJamie (Taka) Wang
 
UiPath Studio Web workshop series - Day 1
UiPath Studio Web workshop series  - Day 1UiPath Studio Web workshop series  - Day 1
UiPath Studio Web workshop series - Day 1DianaGray10
 
UiPath Studio Web workshop Series - Day 3
UiPath Studio Web workshop Series - Day 3UiPath Studio Web workshop Series - Day 3
UiPath Studio Web workshop Series - Day 3DianaGray10
 
Patch notes explaining DISARM Version 1.4 update
Patch notes explaining DISARM Version 1.4 updatePatch notes explaining DISARM Version 1.4 update
Patch notes explaining DISARM Version 1.4 updateadam112203
 
LF Energy Webinar - Unveiling OpenEEMeter 4.0
LF Energy Webinar - Unveiling OpenEEMeter 4.0LF Energy Webinar - Unveiling OpenEEMeter 4.0
LF Energy Webinar - Unveiling OpenEEMeter 4.0DanBrown980551
 
Outage Analysis: March 5th/6th 2024 Meta, Comcast, and LinkedIn
Outage Analysis: March 5th/6th 2024 Meta, Comcast, and LinkedInOutage Analysis: March 5th/6th 2024 Meta, Comcast, and LinkedIn
Outage Analysis: March 5th/6th 2024 Meta, Comcast, and LinkedInThousandEyes
 
March Patch Tuesday
March Patch TuesdayMarch Patch Tuesday
March Patch TuesdayIvanti
 
GraphSummit Copenhagen 2024 - Neo4j Vision and Roadmap.pptx
GraphSummit Copenhagen 2024 - Neo4j Vision and Roadmap.pptxGraphSummit Copenhagen 2024 - Neo4j Vision and Roadmap.pptx
GraphSummit Copenhagen 2024 - Neo4j Vision and Roadmap.pptxNeo4j
 
Key Trends Shaping the Future of Infrastructure.pdf
Key Trends Shaping the Future of Infrastructure.pdfKey Trends Shaping the Future of Infrastructure.pdf
Key Trends Shaping the Future of Infrastructure.pdfCheryl Hung
 
The Importance of Indoor Air Quality (English)
The Importance of Indoor Air Quality (English)The Importance of Indoor Air Quality (English)
The Importance of Indoor Air Quality (English)IES VE
 
UiPath Studio Web workshop series - Day 4
UiPath Studio Web workshop series - Day 4UiPath Studio Web workshop series - Day 4
UiPath Studio Web workshop series - Day 4DianaGray10
 
Scenario Library et REX Discover industry- and role- based scenarios
Scenario Library et REX Discover industry- and role- based scenariosScenario Library et REX Discover industry- and role- based scenarios
Scenario Library et REX Discover industry- and role- based scenariosErol GIRAUDY
 
Explore the UiPath Community and ways you can benefit on your journey to auto...
Explore the UiPath Community and ways you can benefit on your journey to auto...Explore the UiPath Community and ways you can benefit on your journey to auto...
Explore the UiPath Community and ways you can benefit on your journey to auto...DianaGray10
 
Extra-120324-Visite-Entreprise-icare.pdf
Extra-120324-Visite-Entreprise-icare.pdfExtra-120324-Visite-Entreprise-icare.pdf
Extra-120324-Visite-Entreprise-icare.pdfInfopole1
 
Introduction - IPLOOK NETWORKS CO., LTD.
Introduction - IPLOOK NETWORKS CO., LTD.Introduction - IPLOOK NETWORKS CO., LTD.
Introduction - IPLOOK NETWORKS CO., LTD.IPLOOK Networks
 
Design and Modeling for MySQL SCALE 21X Pasadena, CA Mar 2024
Design and Modeling for MySQL SCALE 21X Pasadena, CA Mar 2024Design and Modeling for MySQL SCALE 21X Pasadena, CA Mar 2024
Design and Modeling for MySQL SCALE 21X Pasadena, CA Mar 2024Alkin Tezuysal
 
Emil Eifrem at GraphSummit Copenhagen 2024 - The Art of the Possible.pptx
Emil Eifrem at GraphSummit Copenhagen 2024 - The Art of the Possible.pptxEmil Eifrem at GraphSummit Copenhagen 2024 - The Art of the Possible.pptx
Emil Eifrem at GraphSummit Copenhagen 2024 - The Art of the Possible.pptxNeo4j
 
Flow Control | Block Size | ST Min | First Frame
Flow Control | Block Size | ST Min | First FrameFlow Control | Block Size | ST Min | First Frame
Flow Control | Block Size | ST Min | First FrameKapil Thakar
 

Recently uploaded (20)

Planetek Italia Srl - Corporate Profile Brochure
Planetek Italia Srl - Corporate Profile BrochurePlanetek Italia Srl - Corporate Profile Brochure
Planetek Italia Srl - Corporate Profile Brochure
 
How to release an Open Source Dataweave Library
How to release an Open Source Dataweave LibraryHow to release an Open Source Dataweave Library
How to release an Open Source Dataweave Library
 
20140402 - Smart house demo kit
20140402 - Smart house demo kit20140402 - Smart house demo kit
20140402 - Smart house demo kit
 
UiPath Studio Web workshop series - Day 1
UiPath Studio Web workshop series  - Day 1UiPath Studio Web workshop series  - Day 1
UiPath Studio Web workshop series - Day 1
 
UiPath Studio Web workshop Series - Day 3
UiPath Studio Web workshop Series - Day 3UiPath Studio Web workshop Series - Day 3
UiPath Studio Web workshop Series - Day 3
 
Patch notes explaining DISARM Version 1.4 update
Patch notes explaining DISARM Version 1.4 updatePatch notes explaining DISARM Version 1.4 update
Patch notes explaining DISARM Version 1.4 update
 
LF Energy Webinar - Unveiling OpenEEMeter 4.0
LF Energy Webinar - Unveiling OpenEEMeter 4.0LF Energy Webinar - Unveiling OpenEEMeter 4.0
LF Energy Webinar - Unveiling OpenEEMeter 4.0
 
Outage Analysis: March 5th/6th 2024 Meta, Comcast, and LinkedIn
Outage Analysis: March 5th/6th 2024 Meta, Comcast, and LinkedInOutage Analysis: March 5th/6th 2024 Meta, Comcast, and LinkedIn
Outage Analysis: March 5th/6th 2024 Meta, Comcast, and LinkedIn
 
March Patch Tuesday
March Patch TuesdayMarch Patch Tuesday
March Patch Tuesday
 
GraphSummit Copenhagen 2024 - Neo4j Vision and Roadmap.pptx
GraphSummit Copenhagen 2024 - Neo4j Vision and Roadmap.pptxGraphSummit Copenhagen 2024 - Neo4j Vision and Roadmap.pptx
GraphSummit Copenhagen 2024 - Neo4j Vision and Roadmap.pptx
 
Key Trends Shaping the Future of Infrastructure.pdf
Key Trends Shaping the Future of Infrastructure.pdfKey Trends Shaping the Future of Infrastructure.pdf
Key Trends Shaping the Future of Infrastructure.pdf
 
The Importance of Indoor Air Quality (English)
The Importance of Indoor Air Quality (English)The Importance of Indoor Air Quality (English)
The Importance of Indoor Air Quality (English)
 
UiPath Studio Web workshop series - Day 4
UiPath Studio Web workshop series - Day 4UiPath Studio Web workshop series - Day 4
UiPath Studio Web workshop series - Day 4
 
Scenario Library et REX Discover industry- and role- based scenarios
Scenario Library et REX Discover industry- and role- based scenariosScenario Library et REX Discover industry- and role- based scenarios
Scenario Library et REX Discover industry- and role- based scenarios
 
Explore the UiPath Community and ways you can benefit on your journey to auto...
Explore the UiPath Community and ways you can benefit on your journey to auto...Explore the UiPath Community and ways you can benefit on your journey to auto...
Explore the UiPath Community and ways you can benefit on your journey to auto...
 
Extra-120324-Visite-Entreprise-icare.pdf
Extra-120324-Visite-Entreprise-icare.pdfExtra-120324-Visite-Entreprise-icare.pdf
Extra-120324-Visite-Entreprise-icare.pdf
 
Introduction - IPLOOK NETWORKS CO., LTD.
Introduction - IPLOOK NETWORKS CO., LTD.Introduction - IPLOOK NETWORKS CO., LTD.
Introduction - IPLOOK NETWORKS CO., LTD.
 
Design and Modeling for MySQL SCALE 21X Pasadena, CA Mar 2024
Design and Modeling for MySQL SCALE 21X Pasadena, CA Mar 2024Design and Modeling for MySQL SCALE 21X Pasadena, CA Mar 2024
Design and Modeling for MySQL SCALE 21X Pasadena, CA Mar 2024
 
Emil Eifrem at GraphSummit Copenhagen 2024 - The Art of the Possible.pptx
Emil Eifrem at GraphSummit Copenhagen 2024 - The Art of the Possible.pptxEmil Eifrem at GraphSummit Copenhagen 2024 - The Art of the Possible.pptx
Emil Eifrem at GraphSummit Copenhagen 2024 - The Art of the Possible.pptx
 
Flow Control | Block Size | ST Min | First Frame
Flow Control | Block Size | ST Min | First FrameFlow Control | Block Size | ST Min | First Frame
Flow Control | Block Size | ST Min | First Frame
 

Cerba ppt gi2011-harmonization-of-spatial-planning-data_final

  • 1. Spatial Data Harmonization On how to realize it in Spatial Planning Karel JANECKA, Otakar CERBA, Karel JEDLICKA, Jan JEZEK University of West Bohemia http://portal.sdi-edu.zcu.cz 1
  • 2. Harmonization and its role in spatial planning
  • 3. Spatial data harmonization • Providing access to data through network services in a representation that allows for combining it with other INSPIRE data in a coherent way by using within the European Spatial Data Infrastructure (ESDI) a common set of data product specifications. • This includes agreements about coordinate reference systems, classification systems, application schemes, etc. http://portal.sdi-edu.zcu.cz 3
  • 4. Spatial data harmonization http://portal.sdi-edu.zcu.cz 4
  • 5. Spatial data harmonization Components of harmonization: • INSPIRE principles • Metadata • Reference model • Maintenance • Data translation model • Quality • Portrayal model • Data transfer • Application schemes and • Derived reporting & multiple feature catalogues representations • Dictionaries • Consistency between data • Data Capturing http://portal.sdi-edu.zcu.cz 5
  • 6. An example of Spatial Data Harmonization using PostgreSQL + PostGIS http://portal.sdi-edu.zcu.cz 6
  • 7. HARMONIZATION Source data model Target data model Zemgale urban CORINE land planing cover (specific data model) Geometry Reclassification HARMONIZATION http://portal.sdi-edu.zcu.cz 7
  • 8. HARMONIZATION STEPS  Definition of reclassification rules  Data reclassification  Union of touching geometries in same class  Transformation from multipolygon to polygons http://portal.sdi-edu.zcu.cz 8
  • 9. HARMONIZATION STEPS IN  Definition of reclassification rules → Create mapping table  Data reclassification → SQL JOIN using mapping table  Union of touching geometries in same class → Spatial aggregate function Union  Transformation from multipolygon to polygons → Spatial function dump for converting multipolygon to polygon http://portal.sdi-edu.zcu.cz 9
  • 10. ZEMGALE DATA MODEL Atribute Field Explanation Type VEIDS Planed land use type (see possible values down) Text 50 INDEKSS Area with speciffic restrictions Text 10 PLATIBA Area(m2) Long Integer TER_VIEN territorial unit Text 50 ADM_TER administrative area Text 50 LAYER Layer number in CAD systems Text 50 PIEZIMES notes Text 100 http://portal.sdi-edu.zcu.cz 10
  • 11. LAND COVER DATA MODEL CORINE land http://portal.sdi-edu.zcu.cz 11 cover
  • 12. RECLASSIFICATION RULES ZEMGALE CLASSIFICATION → CORINE NOMENCLATURE 1 DzM Low-rise residential dwellings → 11 Urban fabric 2 DzV Multi-residential dwellings → 11 Urban fabric 3 P Public Building → 11 Urban fabric 4 RR Production facilities and warehouses → 121 Industrial or commercial units 5 RD Mining area → 131 Mineral extraction sites 6 T Technical Building → 12 Industrial, commercial... 7 Ū Waters → 5 Water bodies 8 M Forests → 31 Forests 9 ZĪ Outstanding foliage sites No corresponding class 10 ZC Other groomed greenery space → 141 Green urban areas 11 L Rural Land → 2 Agriculture areas 12 No data No corresponding class http://portal.sdi-edu.zcu.cz 12
  • 13. Database tables  plan_zonejums_part – orginal dataset (imported from shapefile)  lc_original - original classification for land cover  lc_standardized – standardized classification for land cover  standardized_to_original – classification mapping  plan_zonejums_part_harm – reclassified data http://portal.sdi-edu.zcu.cz 13
  • 14. Database schema http://portal.sdi-edu.zcu.cz 14
  • 15. Harmonization query  We have: plan_zonejums_part, lc_original, lc_standardized, standardized_to_original  We need: plan_zonejums_part_harm  SQL Query: CREATE TABLE plan_zonejums_part_harm AS SELECT nextval('gid_seq'::regclass) AS gid, orig.gid AS original_gid, orig.the_geom, orig.veids, orig.standardized_cl, lc_standardized.lc_class FROM lc_standardized, ( SELECT plan_zonejums_part.gid, plan_zonejums_part.the_geom, plan_zonejums_part.veids, standardized_to_original.standardized_cl FROM plan_zonejums_part RIGHT JOIN standardized_to_original ON plan_zonejums_part.veids = standardized_to_original.original_cl) orig WHERE orig.standardized_cl::text = lc_standardized.classification::text; http://portal.sdi-edu.zcu.cz 15
  • 16. Database tables  plan_zonejums_part – orginal dataset (imported from shapefile)  lc_original – original classification for land cover  lc_standardized – standardized classification for land cover  standardized_to_original – classification mapping  plan_zonejums_part_harm – reclassified data http://portal.sdi-edu.zcu.cz 16
  • 17. RECLASSIFIED DATA SET http://portal.sdi-edu.zcu.cz 17
  • 18. Next step – union of adjacent features with same class SELECT NEXTVAL('gid_seq'::regclass)::integer AS gid, (ST_Dump(foo.the_geom)).geom AS the_geom, standardized_cl, lc_class FROM ( SELECT ST_union(the_geom) AS the_geom, standardized_cl, lc_class FROM plan_zonejums_part_harm WHERE the_geom IS NOT NULL GROUP BY standardized_cl, lc_class) AS foo WHERE foo.the_geom IS NOT NULL; http://portal.sdi-edu.zcu.cz 18
  • 20. An example of Spatial Data Harmonization using commercial GIS software - ArcGIS http://portal.sdi-edu.zcu.cz 20
  • 21. Using ArcGIS Model Builder for transformations between data models P4A Land Cover example http://portal.sdi-edu.zcu.cz 21
  • 22. Understanding target data • Plan4all Land Cover data model http://portal.sdi-edu.zcu.cz 22
  • 23. Understanding target data • Plan4all Land Cover data model – ERA diagram of database schema in ESRI Geodatabase. Geometry Polygon Coded value domain Simple feature class Contains M values No CorineLandCoverCode LandCoverStandardisedArea Contains Z values Yes Description CorineLandCoverCod Allow Prec- Field type e Field name Data type nulls Default value Domain ision Scale Length Split policy String Relationship class Merge policy Default value OBJECTID Object ID StandardisedArea_OriginalArea Default value Code Description SHAPE Geometry Yes Type Simple Forward label OriginalArea 1 Artificial surfaces inspireId String Yes 15 Cardinality One to many Backward label StandardArea 2 Agricultural areas source String Yes 50 Notification None 3 Forest and semi natural areas classification String Yes CorineLandCoverCode 21 Origin feature class Destination feature class 4 Wetlands beginLifespanVersion Date Yes 0 0 8 Name StandardArea NameOriginalArea 5 Water bodies endLifespanVersion Date Yes 0 0 8 Primary key inspireId 11 Urban fabric SHAPE_Length Double Yes 0 0 Foreign key inspireId Industrial, commercial and 12 SHAPE_Area Double Yes 0 0 No relationship rules defined. transport units Mine, dump and construction 13 sites Artificial, non-agricultural 14 vegetated areas Geometry Polygon 21 Arable land Simple feature class Contains M values No 22 Permanent crops LandCoverOriginalArea Contains Z values Yes 23 Pastures Allow Prec- 24 Heterogeneous agricultural areas Field name Data type nulls Default value Domain ision Scale Length 31 Forests OBJECTID Object ID 32 Scrub and/or herbaceous SHAPE Geometry Yes Open spaces associationsno vegetation with little or 33 inspireId String Yes 15 vegetation 41 Inland wetlands source String Yes 50 42 Maritime wetlands classification String Yes 21 51 Inland waters classificationLink String Yes 50 52 Marine waters SHAPE_Length Double Yes 0 0 111 Continuous urban fabric SHAPE_Area Double Yes 0 0 112 Discontinuous urban fabric 121 Industrial or commercial units Road and rail networks and 122 associated land 123 Port areas 124 Airports 131 Mineral extraction sites 132 Dump sites 133 Construction sites 141 Green urban areas http://portal.sdi-edu.zcu.cz 142 23 Sport and leisure facilities 211 Non-irrigated arable land 212 Permanently irrigated land
  • 24. Understanding target data • Plan4all Land Cover data model Simple feature class Geometry Polygon Contains M values No LandCoverStandardisedArea Contains Z values Yes Allow Prec- Field name Data type nulls Default value Domain ision Scale Length Relationship class OBJECTID Object ID StandardisedArea_OriginalArea SHAPE Geometry Yes Type Simple Forward label OriginalArea inspireId String Yes 15 Cardinality One to many Backward label StandardArea source String Yes 50 Notification None classification String Yes CorineLandCoverCode 21 Origin feature class Destination feature class beginLifespanVersion Date Yes 0 0 8 Name StandardArea NameOriginalArea endLifespanVersion Date Yes 0 0 8 Primary key inspireId SHAPE_Length Double Yes 0 0 Foreign key inspireId SHAPE_Area Double Yes 0 0 No relationship rules defined. Simple feature class Geometry Polygon Contains M values No LandCoverOriginalArea Contains Z values Yes Allow Prec- Field name Data type nulls Default value Domain ision Scale Length OBJECTID Object ID SHAPE Geometry Yes inspireId String Yes 15 source String Yes 50 classification String Yes 21 classificationLink String Yes 50 SHAPE_Length Double Yes 0 0 SHAPE_Area Double Yes 0 0 http://portal.sdi-edu.zcu.cz 24
  • 25. Understanding source data • Zemgale (Latvia) data model Geometry Polygon Contains M values No Coded value domain CorineLandCoverCode Contains Z values Yes Description CorineLandCoverCod Prec- Field type e lue Simple feature class Domain ision Scale Length Geometry Polygon Split policy String Relationship class Contains M values No Merge policy Default value plan_zonejums_JelgavaSurroundings StandardisedArea_OriginalArea Contains Z values No Default value Code Description Allow Type Simple Forward label Prec- OriginalArea 1 Artificial surfaces Field name Data type nulls 15 Default valueOne to many Domain label ision Scale Length Cardinality Backward StandardArea 2 Agricultural areas 50 Notification None OBJECTID Object ID 3 Forest and semi natural areas CorineLandCoverCodeGeometry Shape Yes 21 Origin feature class Destination feature class 4 Wetlands gid 0 Double 0 Yes 8 Name StandardArea 0 0 NameOriginalArea 5 Water bodies veids String 0 Yes 8 0 Primary key inspireId 21 11 Urban fabric Foreign key inspireId indekss String 0 Yes 0 254 12 Industrial, commercial and transport units platiba String 0 Yes 0 Atribute FieldNo relationship rules defined. Explanation 21 13 Type Mine, dump and construction sites Artificial, non-agricultural pasv String Yes 254 14 vegetated areas piezimes String Yes 254 21 Arable land map_leaf Geometry Polygon String Yes VEIDS Planed land use type (see possible 254 values down) Text 50 Contains M values No 22 Permanent crops dept Contains String Z values Yes Yes 254 23 Pastures Shape_Length Prec- Double Yes INDEKSS Area with speciffic0restrictions 0 24 Text 10 Heterogeneous agricultural areas lue Domain Shape_Area ision ScaleYes Double Length 0 0 31 Forests PLATIBA Area(m2) 32 Long Integer and/or herbaceous Scrub vegetation associations Open spaces with little or no 33 15 vegetation 41 Inland wetlands 50 TER_VIEN territorial unit Text 50 42 Maritime wetlands 21 51 Inland waters 50 ADM_TER administrative area 52 Text 50 Marine waters 0 0 111 Continuous urban fabric 0 0 LAYER Layer number in CAD systems 112 Text 50 Discontinuous urban fabric 121 Industrial or commercial units Road and rail networks and 122 PIEZIMES notes 123 Text 100 associated land Port areas 124 Airports http://portal.sdi-edu.zcu.cz 131 25 Mineral extraction sites 132 Dump sites
  • 26. Attribute mapping ZEMGALE CLASSIFICATION → CORINE NOMENCLATURE 1 DzM Low-rise residential dwellings → 11 Urban fabric 2 DzV Multi-residential dwellings → 11 Urban fabric 3 P Public Building → 11 Urban fabric 4 RR Production facilities and warehouses → 121 Industrial or commercial units 5 RD Mining area → 131 Mineral extraction sites 6 T Technical Building → 12 Industrial, commercial... 7 Ū Waters → 5 Water bodies 8 M Forests → 31 Forests 9 ZĪ Outstanding foliage sites No corresponding class 10 ZC Other groomed greenery space → 141 Green urban areas 11 L Rural Land → 2 Agriculture areas 12 No data No http://portal.sdi-edu.zcu.cz corresponding class 26
  • 27. Transformation steps • Understanding both source and target data – A necessary condition! 1. Transform source data to WGS 84. 2. Transform the source data geometry and attributes to match the target scheme. 3. Apply domain. http://portal.sdi-edu.zcu.cz 27
  • 28. Transformation of coordinate system 1. Transform source data to WGS 84. – Explore source coordinate system, – Run transformation http://portal.sdi-edu.zcu.cz 28
  • 29. Transformation of geometry and attributes 2. Transform the source data geometry and attributes to match the target scheme. – Create classes: • LandCoverOriginalArea, • LandCoverStandardisedArea. – Fill them with data. – Create relationship between them. http://portal.sdi-edu.zcu.cz 29
  • 30. Transformation of geometry and attributes http://portal.sdi-edu.zcu.cz 30
  • 31. Applying a domain 3. Apply a StandardClassification domain to LandCoverStandardisedArea. http://portal.sdi-edu.zcu.cz 31
  • 33. References • JEDLICKA, K.: Using ArcGIS Model Builder for transformations between data models - P4A Land Cover example. In: PLAN4ALL workshop on spatial data harmonization. Riga, 2011. • JEZEK, J.: Technological aspect of spatial data harmonization. [ONLINE] http://prezi.com/ro8cfb114n2d/harmonization/ • Project HUMBOLDT http://www.esdi-humboldt.eu/home.html • Project PLAN4ALL http://portal.plan4all.eu • Project SDI-EDU http://portal.sdi-edu.zcu.cz http://portal.sdi-edu.zcu.cz 33