spatial data to support business processes at munich airport...19 munich airport / wolfgang haller,...
TRANSCRIPT
![Page 1: Spatial Data to Support Business Processes at Munich Airport...19 Munich Airport / Wolfgang Haller, Markus Strauss / 2017 GIS inside Room Cable Fire Detector ID, feature-class, co-ordinates,](https://reader033.vdocuments.us/reader033/viewer/2022052611/5f05acf77e708231d4142464/html5/thumbnails/1.jpg)
Wolfgang Haller, Markus StraussFeb 1, 2017
Spatial Data to Support Business Processes at Munich Airport
![Page 2: Spatial Data to Support Business Processes at Munich Airport...19 Munich Airport / Wolfgang Haller, Markus Strauss / 2017 GIS inside Room Cable Fire Detector ID, feature-class, co-ordinates,](https://reader033.vdocuments.us/reader033/viewer/2022052611/5f05acf77e708231d4142464/html5/thumbnails/2.jpg)
Head of Technical DocumentationCAD, CAFM, RoombookGIS, spatial dataDMSTaxonomy
2 Munich Airport / Wolfgang Haller, Markus Strauss / 2017
Computer Aided Facility Management and Geographic Information Systems
Operational Property and Facility Management
GIS for Environmental Engineering – case studies from Munich Airport
For 26 years For 13 years
International Consulting
![Page 3: Spatial Data to Support Business Processes at Munich Airport...19 Munich Airport / Wolfgang Haller, Markus Strauss / 2017 GIS inside Room Cable Fire Detector ID, feature-class, co-ordinates,](https://reader033.vdocuments.us/reader033/viewer/2022052611/5f05acf77e708231d4142464/html5/thumbnails/3.jpg)
Munich Airport / Wolfgang Haller, Markus Strauss / 20173 Munich Airport / Wolfgang Haller, Markus Strauss / 20173
![Page 4: Spatial Data to Support Business Processes at Munich Airport...19 Munich Airport / Wolfgang Haller, Markus Strauss / 2017 GIS inside Room Cable Fire Detector ID, feature-class, co-ordinates,](https://reader033.vdocuments.us/reader033/viewer/2022052611/5f05acf77e708231d4142464/html5/thumbnails/4.jpg)
Munich Airport / Wolfgang Haller, Markus Strauss / 20174
Points Lines Polygons
Web Services
Raster Networks (line)
Routing
3D (dtm)
ZROB
![Page 5: Spatial Data to Support Business Processes at Munich Airport...19 Munich Airport / Wolfgang Haller, Markus Strauss / 2017 GIS inside Room Cable Fire Detector ID, feature-class, co-ordinates,](https://reader033.vdocuments.us/reader033/viewer/2022052611/5f05acf77e708231d4142464/html5/thumbnails/5.jpg)
Munich Airport / Wolfgang Haller, Markus Strauss / 20175 Munich Airport / Wolfgang Haller, Markus Strauss / 20175
![Page 6: Spatial Data to Support Business Processes at Munich Airport...19 Munich Airport / Wolfgang Haller, Markus Strauss / 2017 GIS inside Room Cable Fire Detector ID, feature-class, co-ordinates,](https://reader033.vdocuments.us/reader033/viewer/2022052611/5f05acf77e708231d4142464/html5/thumbnails/6.jpg)
Planning Approval (47 Ring Binders)
Munich Airport / Wolfgang Haller, Markus Strauss / 20176
![Page 7: Spatial Data to Support Business Processes at Munich Airport...19 Munich Airport / Wolfgang Haller, Markus Strauss / 2017 GIS inside Room Cable Fire Detector ID, feature-class, co-ordinates,](https://reader033.vdocuments.us/reader033/viewer/2022052611/5f05acf77e708231d4142464/html5/thumbnails/7.jpg)
The Wide World of Airport GISFauna – BatsThe Wide World of Airport GISFauna – Bats
Munich Airport / Wolfgang Haller, Markus Strauss / 20177
BatsSource: wikipedia
![Page 8: Spatial Data to Support Business Processes at Munich Airport...19 Munich Airport / Wolfgang Haller, Markus Strauss / 2017 GIS inside Room Cable Fire Detector ID, feature-class, co-ordinates,](https://reader033.vdocuments.us/reader033/viewer/2022052611/5f05acf77e708231d4142464/html5/thumbnails/8.jpg)
The Wide World of Airport GISFauna – Breeding birdsThe Wide World of Airport GISFauna – Breeding birds
Munich Airport / Wolfgang Haller, Markus Strauss / 20178
![Page 9: Spatial Data to Support Business Processes at Munich Airport...19 Munich Airport / Wolfgang Haller, Markus Strauss / 2017 GIS inside Room Cable Fire Detector ID, feature-class, co-ordinates,](https://reader033.vdocuments.us/reader033/viewer/2022052611/5f05acf77e708231d4142464/html5/thumbnails/9.jpg)
Fauna – Altitude measurement of birdsFauna – Altitude measurement of birds
Source: wikipedia
![Page 10: Spatial Data to Support Business Processes at Munich Airport...19 Munich Airport / Wolfgang Haller, Markus Strauss / 2017 GIS inside Room Cable Fire Detector ID, feature-class, co-ordinates,](https://reader033.vdocuments.us/reader033/viewer/2022052611/5f05acf77e708231d4142464/html5/thumbnails/10.jpg)
The Wide World of Airport GISFauna – GrasshoppersThe Wide World of Airport GISFauna – Grasshoppers
Munich Airport / Wolfgang Haller, Markus Strauss / 201710
GrasshoppersSource: wikipedia
![Page 11: Spatial Data to Support Business Processes at Munich Airport...19 Munich Airport / Wolfgang Haller, Markus Strauss / 2017 GIS inside Room Cable Fire Detector ID, feature-class, co-ordinates,](https://reader033.vdocuments.us/reader033/viewer/2022052611/5f05acf77e708231d4142464/html5/thumbnails/11.jpg)
The Wide World of Airport GISFlora – Flavorsome LeekThe Wide World of Airport GISFlora – Flavorsome Leek
Munich Airport / Wolfgang Haller, Markus Strauss / 201711
![Page 12: Spatial Data to Support Business Processes at Munich Airport...19 Munich Airport / Wolfgang Haller, Markus Strauss / 2017 GIS inside Room Cable Fire Detector ID, feature-class, co-ordinates,](https://reader033.vdocuments.us/reader033/viewer/2022052611/5f05acf77e708231d4142464/html5/thumbnails/12.jpg)
Munich Airport / Wolfgang Haller, Markus Strauss / 201712 Munich Airport / Wolfgang Haller, Markus Strauss / 201712
![Page 13: Spatial Data to Support Business Processes at Munich Airport...19 Munich Airport / Wolfgang Haller, Markus Strauss / 2017 GIS inside Room Cable Fire Detector ID, feature-class, co-ordinates,](https://reader033.vdocuments.us/reader033/viewer/2022052611/5f05acf77e708231d4142464/html5/thumbnails/13.jpg)
E31
901A
901
903B
E29A
903A903
E29
E27
E42
E37
E47
E
901D
901C
901B
E30Parcel
Street-light
Sewage Canal
ID, feature-class, co-ordinates, attributes, spatial databases
Y
X
13 Munich Airport / Wolfgang Haller, Markus Strauss / 2017
GIS
outside
CAD
E47
inside
![Page 14: Spatial Data to Support Business Processes at Munich Airport...19 Munich Airport / Wolfgang Haller, Markus Strauss / 2017 GIS inside Room Cable Fire Detector ID, feature-class, co-ordinates,](https://reader033.vdocuments.us/reader033/viewer/2022052611/5f05acf77e708231d4142464/html5/thumbnails/14.jpg)
E31
901A
901
903B
E29A
903A903
E29
E27
E42
E37
E47
E
901D
901C
901B
E30Parcel
Street-light
Sewage Canal
ID, feature-class, co-ordinates, attributes, spatial databases
Y
X
14 Munich Airport / Wolfgang Haller, Markus Strauss / 2017
GIS
outside
CAD
E47
inside
Files, dwg, layers, plots
![Page 15: Spatial Data to Support Business Processes at Munich Airport...19 Munich Airport / Wolfgang Haller, Markus Strauss / 2017 GIS inside Room Cable Fire Detector ID, feature-class, co-ordinates,](https://reader033.vdocuments.us/reader033/viewer/2022052611/5f05acf77e708231d4142464/html5/thumbnails/15.jpg)
E31
901A
901
903B
E29A
903A903
E29
E27
E42
E37
E47
E
901D
901C
901B
E30Parcel
Street-light
Sewage Canal
ID, feature-class, co-ordinates, attributes, spatial databases
Y
X
15 Munich Airport / Wolfgang Haller, Markus Strauss / 2017
GIS
outside
GIS
E47
inside
Room
Cable
Fire Detector
ID, feature-class, co-ordinates, attributes, spatial databases
Take GIS inside the building
![Page 16: Spatial Data to Support Business Processes at Munich Airport...19 Munich Airport / Wolfgang Haller, Markus Strauss / 2017 GIS inside Room Cable Fire Detector ID, feature-class, co-ordinates,](https://reader033.vdocuments.us/reader033/viewer/2022052611/5f05acf77e708231d4142464/html5/thumbnails/16.jpg)
GIS elements
• Examples: Doors, fire-detectors, telephone-outlets, electrical distributions, fire protection flaps
ID, feature-class, co-ordinates, attributes, spatial databases
Munich Airport / Wolfgang Haller, Markus Strauss / 201716
1,093,665 Point-Objects, 40,464 Room-Polygons inside the building
![Page 17: Spatial Data to Support Business Processes at Munich Airport...19 Munich Airport / Wolfgang Haller, Markus Strauss / 2017 GIS inside Room Cable Fire Detector ID, feature-class, co-ordinates,](https://reader033.vdocuments.us/reader033/viewer/2022052611/5f05acf77e708231d4142464/html5/thumbnails/17.jpg)
E31
901A
901
903B
E29A
903A903
E29
E27
E42
E37
E47
E
901D
901C
901B
E30
Y
X
17 Munich Airport / Wolfgang Haller, Markus Strauss / 2017
GIS
E47
inside
Room
Cable
Fire Detector
ID, feature-class, co-ordinates, attributes, spatial databases
• Where are rooms available?
• What area do they have?
• Appendix for Lease Contract
Business Processes / BenefitsLease Management
![Page 18: Spatial Data to Support Business Processes at Munich Airport...19 Munich Airport / Wolfgang Haller, Markus Strauss / 2017 GIS inside Room Cable Fire Detector ID, feature-class, co-ordinates,](https://reader033.vdocuments.us/reader033/viewer/2022052611/5f05acf77e708231d4142464/html5/thumbnails/18.jpg)
E31
901A
901
903B
E29A
903A903
E29
E27
E42
E37
E47
E
901D
901C
901B
E30
Y
X
18 Munich Airport / Wolfgang Haller, Markus Strauss / 2017
GIS
E47
inside
Room
Cable
Fire Detector
ID, feature-class, co-ordinates, attributes, spatial databases
• Types of cleaning
• Size of rooms to be cleaned
• Boundaries between contractors
Business Processes / BenefitsCleaning Management
![Page 19: Spatial Data to Support Business Processes at Munich Airport...19 Munich Airport / Wolfgang Haller, Markus Strauss / 2017 GIS inside Room Cable Fire Detector ID, feature-class, co-ordinates,](https://reader033.vdocuments.us/reader033/viewer/2022052611/5f05acf77e708231d4142464/html5/thumbnails/19.jpg)
E31
901A
901
903B
E29A
903A903
E29
E27
E42
E37
E47
E
901D
901C
901B
E30
Y
X
19 Munich Airport / Wolfgang Haller, Markus Strauss / 2017
GIS
E47
inside
Room
Cable
Fire Detector
ID, feature-class, co-ordinates, attributes, spatial databases
Business Processes / BenefitsMaintenance Management
• Reactive Maintenance
• Where is the fire protection flap 112.21-RLT-00.004?
![Page 20: Spatial Data to Support Business Processes at Munich Airport...19 Munich Airport / Wolfgang Haller, Markus Strauss / 2017 GIS inside Room Cable Fire Detector ID, feature-class, co-ordinates,](https://reader033.vdocuments.us/reader033/viewer/2022052611/5f05acf77e708231d4142464/html5/thumbnails/20.jpg)
Munich Airport / Wolfgang Haller, Markus Strauss / 201720
Oracle Environment
Implementation at the Airport
![Page 21: Spatial Data to Support Business Processes at Munich Airport...19 Munich Airport / Wolfgang Haller, Markus Strauss / 2017 GIS inside Room Cable Fire Detector ID, feature-class, co-ordinates,](https://reader033.vdocuments.us/reader033/viewer/2022052611/5f05acf77e708231d4142464/html5/thumbnails/21.jpg)
Technical DocumentationCAD, CAFM, Roombook
Software Development (GIS)Oracle Specialist
21 Munich Airport / Wolfgang Haller, Markus Strauss / 2017
For 3 years
Facility Organizing Systems a Service Provider for CAD and Software Development
Software Development and Administration (GIS & DB)
For 20 years
![Page 22: Spatial Data to Support Business Processes at Munich Airport...19 Munich Airport / Wolfgang Haller, Markus Strauss / 2017 GIS inside Room Cable Fire Detector ID, feature-class, co-ordinates,](https://reader033.vdocuments.us/reader033/viewer/2022052611/5f05acf77e708231d4142464/html5/thumbnails/22.jpg)
Early attempts in 1998
Munich Airport / Wolfgang Haller, Markus Strauss / 201722
• Points (Symbols) in numeric fields in the database only.
• Building Extents in numeric Fields
• Room Extents in numeric Fields
• Additional technical data in the database. The graphic for thematic areas and (poly)lines still persists in AutoCAD drawing files.
![Page 23: Spatial Data to Support Business Processes at Munich Airport...19 Munich Airport / Wolfgang Haller, Markus Strauss / 2017 GIS inside Room Cable Fire Detector ID, feature-class, co-ordinates,](https://reader033.vdocuments.us/reader033/viewer/2022052611/5f05acf77e708231d4142464/html5/thumbnails/23.jpg)
Dual strategy
Munich Airport / Wolfgang Haller, Markus Strauss / 201723
• Since 2013 Rooms and Floor Areas are mirrored to Oracle SDO geometries with FME
![Page 24: Spatial Data to Support Business Processes at Munich Airport...19 Munich Airport / Wolfgang Haller, Markus Strauss / 2017 GIS inside Room Cable Fire Detector ID, feature-class, co-ordinates,](https://reader033.vdocuments.us/reader033/viewer/2022052611/5f05acf77e708231d4142464/html5/thumbnails/24.jpg)
The last step
Munich Airport / Wolfgang Haller, Markus Strauss / 201724
• Since 2015 points (symbols) are stored as Oracle SDO objects
• Since 2016 thematic areas are stored directly and only as Oracle SDO objects
• Since 2016 thematic (poly)lines are stored directly and only as Oracle SDO objects
Performance Boost through Oracle 12c Enterprice
• Vector Acceleration
• Table Partitioning
MDSYS.SDO_GEOMETRY(2003,262148,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(11743.75,4499.5,11743.75,4499.4,11743.7,4499.4,11743.7,4496.05,11748.6,4496.05,11748.6,4499.4,11748.25,4499.4,11748.25,4499.5,11743.75,4499.5))
![Page 25: Spatial Data to Support Business Processes at Munich Airport...19 Munich Airport / Wolfgang Haller, Markus Strauss / 2017 GIS inside Room Cable Fire Detector ID, feature-class, co-ordinates,](https://reader033.vdocuments.us/reader033/viewer/2022052611/5f05acf77e708231d4142464/html5/thumbnails/25.jpg)
VisMan Overview
Munich Airport / Wolfgang Haller, Markus Strauss / 201725
Filesystem
VisMan Admintool
VisMan Core
VisMan Go Sync
VisMan Go App
Desktop
Map
BB
A
OIS
KB
M
SIS
WebLogic – Oracle MapViewer
VisMan Web [R4]
VisManWeb[R4]mobileIn
terfa
ces
^^
VisMan AcadVisMan
Click App
Browser Mobile.
Filesystem
ORACLEMapBuilder
Version 12.2.1.0
![Page 26: Spatial Data to Support Business Processes at Munich Airport...19 Munich Airport / Wolfgang Haller, Markus Strauss / 2017 GIS inside Room Cable Fire Detector ID, feature-class, co-ordinates,](https://reader033.vdocuments.us/reader033/viewer/2022052611/5f05acf77e708231d4142464/html5/thumbnails/26.jpg)
VisMan Acad
Munich Airport / Wolfgang Haller, Markus Strauss / 201726
VisMan.Acad
![Page 27: Spatial Data to Support Business Processes at Munich Airport...19 Munich Airport / Wolfgang Haller, Markus Strauss / 2017 GIS inside Room Cable Fire Detector ID, feature-class, co-ordinates,](https://reader033.vdocuments.us/reader033/viewer/2022052611/5f05acf77e708231d4142464/html5/thumbnails/27.jpg)
VisMan Web
Munich Airport / Wolfgang Haller, Markus Strauss / 201727
![Page 28: Spatial Data to Support Business Processes at Munich Airport...19 Munich Airport / Wolfgang Haller, Markus Strauss / 2017 GIS inside Room Cable Fire Detector ID, feature-class, co-ordinates,](https://reader033.vdocuments.us/reader033/viewer/2022052611/5f05acf77e708231d4142464/html5/thumbnails/28.jpg)
VisMan Web is easy
Munich Airport / Wolfgang Haller, Markus Strauss / 201728
• Easy navigation with the CAFM Navigator
• Easy searching with auto text completion
• Easy printing
![Page 29: Spatial Data to Support Business Processes at Munich Airport...19 Munich Airport / Wolfgang Haller, Markus Strauss / 2017 GIS inside Room Cable Fire Detector ID, feature-class, co-ordinates,](https://reader033.vdocuments.us/reader033/viewer/2022052611/5f05acf77e708231d4142464/html5/thumbnails/29.jpg)
VisMan Web - Gallery
Munich Airport / Wolfgang Haller, Markus Strauss / 201729
![Page 30: Spatial Data to Support Business Processes at Munich Airport...19 Munich Airport / Wolfgang Haller, Markus Strauss / 2017 GIS inside Room Cable Fire Detector ID, feature-class, co-ordinates,](https://reader033.vdocuments.us/reader033/viewer/2022052611/5f05acf77e708231d4142464/html5/thumbnails/30.jpg)
VisMan Web - Gallery
Munich Airport / Wolfgang Haller, Markus Strauss / 201730
![Page 31: Spatial Data to Support Business Processes at Munich Airport...19 Munich Airport / Wolfgang Haller, Markus Strauss / 2017 GIS inside Room Cable Fire Detector ID, feature-class, co-ordinates,](https://reader033.vdocuments.us/reader033/viewer/2022052611/5f05acf77e708231d4142464/html5/thumbnails/31.jpg)
VisMan Web - Gallery
Munich Airport / Wolfgang Haller, Markus Strauss / 201731
![Page 32: Spatial Data to Support Business Processes at Munich Airport...19 Munich Airport / Wolfgang Haller, Markus Strauss / 2017 GIS inside Room Cable Fire Detector ID, feature-class, co-ordinates,](https://reader033.vdocuments.us/reader033/viewer/2022052611/5f05acf77e708231d4142464/html5/thumbnails/32.jpg)
VisMan Web – raster & co
Munich Airport / Wolfgang Haller, Markus Strauss / 201732
![Page 33: Spatial Data to Support Business Processes at Munich Airport...19 Munich Airport / Wolfgang Haller, Markus Strauss / 2017 GIS inside Room Cable Fire Detector ID, feature-class, co-ordinates,](https://reader033.vdocuments.us/reader033/viewer/2022052611/5f05acf77e708231d4142464/html5/thumbnails/33.jpg)
Oracle MapBuilder
Munich Airport / Wolfgang Haller, Markus Strauss / 201733
![Page 34: Spatial Data to Support Business Processes at Munich Airport...19 Munich Airport / Wolfgang Haller, Markus Strauss / 2017 GIS inside Room Cable Fire Detector ID, feature-class, co-ordinates,](https://reader033.vdocuments.us/reader033/viewer/2022052611/5f05acf77e708231d4142464/html5/thumbnails/34.jpg)
VisMan Admintool
Munich Airport / Wolfgang Haller, Markus Strauss / 201734
![Page 35: Spatial Data to Support Business Processes at Munich Airport...19 Munich Airport / Wolfgang Haller, Markus Strauss / 2017 GIS inside Room Cable Fire Detector ID, feature-class, co-ordinates,](https://reader033.vdocuments.us/reader033/viewer/2022052611/5f05acf77e708231d4142464/html5/thumbnails/35.jpg)
Thank you
![Page 36: Spatial Data to Support Business Processes at Munich Airport...19 Munich Airport / Wolfgang Haller, Markus Strauss / 2017 GIS inside Room Cable Fire Detector ID, feature-class, co-ordinates,](https://reader033.vdocuments.us/reader033/viewer/2022052611/5f05acf77e708231d4142464/html5/thumbnails/36.jpg)
Facts
Munich Airport / Wolfgang Haller, Markus Strauss / 201736
Trade groups 12
Trades 150
Buildings (even container) 1.536
Floors 69
Rooms 40.464
Points (symbols) total 2.304.722
Symbols indoor 1.093.704
Symbols outdoor 1.209.425
Areas 364.484
(Poly) lines 328.225
Object Definitions 9.598
User groups 128
Named user 1.649
Data tables for additional information 777
System tables 717
MapViewer Styles 5.751
MapViewer Themes 1.930
Objects for architecture (simple) 2.282.868
Objects for architecture (advanced) 3.559.340
Objects from layer (without DB context) 721.109
Size of Database 100 GB
Database instances on the airport 130