![Page 1: IOUG Spatial Summit 2016 - Oracle... Speaker : Date : E-mail : IOUG Spatial Summit 2016 Assembling a large scale map for the Netherlands Richard Huesken Collected by different organizations](https://reader033.vdocuments.us/reader033/viewer/2022051905/5ff745782689b819a10f7332/html5/thumbnails/1.jpg)
WWW.TRANSFER-SOLUTIONS.COM
Speaker : Date : E-mail :
IOUG Spatial Summit 2016 Assembling a large scale map for the Netherlands
Richard Huesken January 28th, 2016 [email protected]
![Page 2: IOUG Spatial Summit 2016 - Oracle... Speaker : Date : E-mail : IOUG Spatial Summit 2016 Assembling a large scale map for the Netherlands Richard Huesken Collected by different organizations](https://reader033.vdocuments.us/reader033/viewer/2022051905/5ff745782689b819a10f7332/html5/thumbnails/2.jpg)
![Page 3: IOUG Spatial Summit 2016 - Oracle... Speaker : Date : E-mail : IOUG Spatial Summit 2016 Assembling a large scale map for the Netherlands Richard Huesken Collected by different organizations](https://reader033.vdocuments.us/reader033/viewer/2022051905/5ff745782689b819a10f7332/html5/thumbnails/3.jpg)
![Page 4: IOUG Spatial Summit 2016 - Oracle... Speaker : Date : E-mail : IOUG Spatial Summit 2016 Assembling a large scale map for the Netherlands Richard Huesken Collected by different organizations](https://reader033.vdocuments.us/reader033/viewer/2022051905/5ff745782689b819a10f7332/html5/thumbnails/4.jpg)
© WWW.TRANSFER-SOLUTIONS.COM
Introduction
■ Transfer Solutions ■ Oracle Gold Partner ■ Largest independent Oracle partner in the
Netherlands ■ Focus on Oracle and Java technology
■ Consulting ■ Managed services ■ Education
4
![Page 5: IOUG Spatial Summit 2016 - Oracle... Speaker : Date : E-mail : IOUG Spatial Summit 2016 Assembling a large scale map for the Netherlands Richard Huesken Collected by different organizations](https://reader033.vdocuments.us/reader033/viewer/2022051905/5ff745782689b819a10f7332/html5/thumbnails/5.jpg)
© WWW.TRANSFER-SOLUTIONS.COM
Assembling a large scale map
■ Large scale map data ■ Scale 1:500 – 1:5000
■ Business case ■ Requirements ■ Solution ■ Results ■ Recommendations
5
![Page 6: IOUG Spatial Summit 2016 - Oracle... Speaker : Date : E-mail : IOUG Spatial Summit 2016 Assembling a large scale map for the Netherlands Richard Huesken Collected by different organizations](https://reader033.vdocuments.us/reader033/viewer/2022051905/5ff745782689b819a10f7332/html5/thumbnails/6.jpg)
© WWW.TRANSFER-SOLUTIONS.COM
Business Case – Current problems
■ Collected by different organizations ■ Separate datasets ■ Different storage formats ■ Different object types ■ Different definitions ■ Data has been collected at different points in time ■ Data is collected with different quality standards
6
![Page 7: IOUG Spatial Summit 2016 - Oracle... Speaker : Date : E-mail : IOUG Spatial Summit 2016 Assembling a large scale map for the Netherlands Richard Huesken Collected by different organizations](https://reader033.vdocuments.us/reader033/viewer/2022051905/5ff745782689b819a10f7332/html5/thumbnails/7.jpg)
© WWW.TRANSFER-SOLUTIONS.COM
Business Case – Separate datasets
7
![Page 8: IOUG Spatial Summit 2016 - Oracle... Speaker : Date : E-mail : IOUG Spatial Summit 2016 Assembling a large scale map for the Netherlands Richard Huesken Collected by different organizations](https://reader033.vdocuments.us/reader033/viewer/2022051905/5ff745782689b819a10f7332/html5/thumbnails/8.jpg)
© WWW.TRANSFER-SOLUTIONS.COM
Business Case – Separate datasets
8
![Page 9: IOUG Spatial Summit 2016 - Oracle... Speaker : Date : E-mail : IOUG Spatial Summit 2016 Assembling a large scale map for the Netherlands Richard Huesken Collected by different organizations](https://reader033.vdocuments.us/reader033/viewer/2022051905/5ff745782689b819a10f7332/html5/thumbnails/9.jpg)
![Page 10: IOUG Spatial Summit 2016 - Oracle... Speaker : Date : E-mail : IOUG Spatial Summit 2016 Assembling a large scale map for the Netherlands Richard Huesken Collected by different organizations](https://reader033.vdocuments.us/reader033/viewer/2022051905/5ff745782689b819a10f7332/html5/thumbnails/10.jpg)
© WWW.TRANSFER-SOLUTIONS.COM
Business Case – BGT
■ Country wide ■ Area : 41,453 km2 (currently: 5,213 km2) ■ Land : 33,893 km2 ■ Water : 7,650 km2
■ BGT estimates ■ 100,000,000 objects
■ Source data providers ■ 450 organizations
■ Implementation ■ Required by Law
10
![Page 11: IOUG Spatial Summit 2016 - Oracle... Speaker : Date : E-mail : IOUG Spatial Summit 2016 Assembling a large scale map for the Netherlands Richard Huesken Collected by different organizations](https://reader033.vdocuments.us/reader033/viewer/2022051905/5ff745782689b819a10f7332/html5/thumbnails/11.jpg)
![Page 12: IOUG Spatial Summit 2016 - Oracle... Speaker : Date : E-mail : IOUG Spatial Summit 2016 Assembling a large scale map for the Netherlands Richard Huesken Collected by different organizations](https://reader033.vdocuments.us/reader033/viewer/2022051905/5ff745782689b819a10f7332/html5/thumbnails/12.jpg)
© WWW.TRANSFER-SOLUTIONS.COM
BGT – Automated Data Assembly
12
![Page 13: IOUG Spatial Summit 2016 - Oracle... Speaker : Date : E-mail : IOUG Spatial Summit 2016 Assembling a large scale map for the Netherlands Richard Huesken Collected by different organizations](https://reader033.vdocuments.us/reader033/viewer/2022051905/5ff745782689b819a10f7332/html5/thumbnails/13.jpg)
![Page 14: IOUG Spatial Summit 2016 - Oracle... Speaker : Date : E-mail : IOUG Spatial Summit 2016 Assembling a large scale map for the Netherlands Richard Huesken Collected by different organizations](https://reader033.vdocuments.us/reader033/viewer/2022051905/5ff745782689b819a10f7332/html5/thumbnails/14.jpg)
![Page 15: IOUG Spatial Summit 2016 - Oracle... Speaker : Date : E-mail : IOUG Spatial Summit 2016 Assembling a large scale map for the Netherlands Richard Huesken Collected by different organizations](https://reader033.vdocuments.us/reader033/viewer/2022051905/5ff745782689b819a10f7332/html5/thumbnails/15.jpg)
![Page 16: IOUG Spatial Summit 2016 - Oracle... Speaker : Date : E-mail : IOUG Spatial Summit 2016 Assembling a large scale map for the Netherlands Richard Huesken Collected by different organizations](https://reader033.vdocuments.us/reader033/viewer/2022051905/5ff745782689b819a10f7332/html5/thumbnails/16.jpg)
© WWW.TRANSFER-SOLUTIONS.COM
Requirements - BGT Specification
■ GML 3.1.1 ■ Simple features profile ■ Extended with circular arcs (GM_ARC)
■ Ordinates rounded to 3 decimals (“mm grid”) ■ Topology
■ Adjacent objects share coordinates
■ Technical tolerance ■ Minimum distance from point to a line.
Set to 0.0005 m ( 1/2 mm)
![Page 17: IOUG Spatial Summit 2016 - Oracle... Speaker : Date : E-mail : IOUG Spatial Summit 2016 Assembling a large scale map for the Netherlands Richard Huesken Collected by different organizations](https://reader033.vdocuments.us/reader033/viewer/2022051905/5ff745782689b819a10f7332/html5/thumbnails/17.jpg)
© WWW.TRANSFER-SOLUTIONS.COM
Automated Assembly - Solution
■ Phase 1: Geometric approach ■ Eliminate gaps and overlaps ■ Stroke arcs selectively
■ Phase 2: Topological finish ■ Locate missing vertices (nodes) ■ Add missing nodes ■ Replace arcs
17
![Page 18: IOUG Spatial Summit 2016 - Oracle... Speaker : Date : E-mail : IOUG Spatial Summit 2016 Assembling a large scale map for the Netherlands Richard Huesken Collected by different organizations](https://reader033.vdocuments.us/reader033/viewer/2022051905/5ff745782689b819a10f7332/html5/thumbnails/18.jpg)
![Page 19: IOUG Spatial Summit 2016 - Oracle... Speaker : Date : E-mail : IOUG Spatial Summit 2016 Assembling a large scale map for the Netherlands Richard Huesken Collected by different organizations](https://reader033.vdocuments.us/reader033/viewer/2022051905/5ff745782689b819a10f7332/html5/thumbnails/19.jpg)
![Page 20: IOUG Spatial Summit 2016 - Oracle... Speaker : Date : E-mail : IOUG Spatial Summit 2016 Assembling a large scale map for the Netherlands Richard Huesken Collected by different organizations](https://reader033.vdocuments.us/reader033/viewer/2022051905/5ff745782689b819a10f7332/html5/thumbnails/20.jpg)
![Page 21: IOUG Spatial Summit 2016 - Oracle... Speaker : Date : E-mail : IOUG Spatial Summit 2016 Assembling a large scale map for the Netherlands Richard Huesken Collected by different organizations](https://reader033.vdocuments.us/reader033/viewer/2022051905/5ff745782689b819a10f7332/html5/thumbnails/21.jpg)
![Page 22: IOUG Spatial Summit 2016 - Oracle... Speaker : Date : E-mail : IOUG Spatial Summit 2016 Assembling a large scale map for the Netherlands Richard Huesken Collected by different organizations](https://reader033.vdocuments.us/reader033/viewer/2022051905/5ff745782689b819a10f7332/html5/thumbnails/22.jpg)
![Page 23: IOUG Spatial Summit 2016 - Oracle... Speaker : Date : E-mail : IOUG Spatial Summit 2016 Assembling a large scale map for the Netherlands Richard Huesken Collected by different organizations](https://reader033.vdocuments.us/reader033/viewer/2022051905/5ff745782689b819a10f7332/html5/thumbnails/23.jpg)
© WWW.TRANSFER-SOLUTIONS.COM
Spatial Vector Acceleration (SVA)
■ New feature in 12c ■ New code path for spatial operations ■ Performance improvements
■ SVA optimizes sdo_geometry ■ Consecutive segments may be combined ■ Order of segments is not maintained ■ Collinear points are removed
23
![Page 24: IOUG Spatial Summit 2016 - Oracle... Speaker : Date : E-mail : IOUG Spatial Summit 2016 Assembling a large scale map for the Netherlands Richard Huesken Collected by different organizations](https://reader033.vdocuments.us/reader033/viewer/2022051905/5ff745782689b819a10f7332/html5/thumbnails/24.jpg)
![Page 25: IOUG Spatial Summit 2016 - Oracle... Speaker : Date : E-mail : IOUG Spatial Summit 2016 Assembling a large scale map for the Netherlands Richard Huesken Collected by different organizations](https://reader033.vdocuments.us/reader033/viewer/2022051905/5ff745782689b819a10f7332/html5/thumbnails/25.jpg)
![Page 26: IOUG Spatial Summit 2016 - Oracle... Speaker : Date : E-mail : IOUG Spatial Summit 2016 Assembling a large scale map for the Netherlands Richard Huesken Collected by different organizations](https://reader033.vdocuments.us/reader033/viewer/2022051905/5ff745782689b819a10f7332/html5/thumbnails/26.jpg)
![Page 27: IOUG Spatial Summit 2016 - Oracle... Speaker : Date : E-mail : IOUG Spatial Summit 2016 Assembling a large scale map for the Netherlands Richard Huesken Collected by different organizations](https://reader033.vdocuments.us/reader033/viewer/2022051905/5ff745782689b819a10f7332/html5/thumbnails/27.jpg)
![Page 28: IOUG Spatial Summit 2016 - Oracle... Speaker : Date : E-mail : IOUG Spatial Summit 2016 Assembling a large scale map for the Netherlands Richard Huesken Collected by different organizations](https://reader033.vdocuments.us/reader033/viewer/2022051905/5ff745782689b819a10f7332/html5/thumbnails/28.jpg)
© WWW.TRANSFER-SOLUTIONS.COM
Arcs – final result
28
![Page 29: IOUG Spatial Summit 2016 - Oracle... Speaker : Date : E-mail : IOUG Spatial Summit 2016 Assembling a large scale map for the Netherlands Richard Huesken Collected by different organizations](https://reader033.vdocuments.us/reader033/viewer/2022051905/5ff745782689b819a10f7332/html5/thumbnails/29.jpg)
© WWW.TRANSFER-SOLUTIONS.COM
Automated Assembly - Solution
■ Phase 1: Geometric approach ■ Eliminate gaps and overlaps ■ Stroke selected arcs
■ Phase 2: Topological finish ■ Locate missing vertices (nodes) ■ Add missing vertices ■ Replace arcs
29
![Page 30: IOUG Spatial Summit 2016 - Oracle... Speaker : Date : E-mail : IOUG Spatial Summit 2016 Assembling a large scale map for the Netherlands Richard Huesken Collected by different organizations](https://reader033.vdocuments.us/reader033/viewer/2022051905/5ff745782689b819a10f7332/html5/thumbnails/30.jpg)
![Page 31: IOUG Spatial Summit 2016 - Oracle... Speaker : Date : E-mail : IOUG Spatial Summit 2016 Assembling a large scale map for the Netherlands Richard Huesken Collected by different organizations](https://reader033.vdocuments.us/reader033/viewer/2022051905/5ff745782689b819a10f7332/html5/thumbnails/31.jpg)
![Page 32: IOUG Spatial Summit 2016 - Oracle... Speaker : Date : E-mail : IOUG Spatial Summit 2016 Assembling a large scale map for the Netherlands Richard Huesken Collected by different organizations](https://reader033.vdocuments.us/reader033/viewer/2022051905/5ff745782689b819a10f7332/html5/thumbnails/32.jpg)
© WWW.TRANSFER-SOLUTIONS.COM
Missing nodes - detail
32
![Page 33: IOUG Spatial Summit 2016 - Oracle... Speaker : Date : E-mail : IOUG Spatial Summit 2016 Assembling a large scale map for the Netherlands Richard Huesken Collected by different organizations](https://reader033.vdocuments.us/reader033/viewer/2022051905/5ff745782689b819a10f7332/html5/thumbnails/33.jpg)
© WWW.TRANSFER-SOLUTIONS.COM
Missing nodes – add node (vertex)
33
![Page 34: IOUG Spatial Summit 2016 - Oracle... Speaker : Date : E-mail : IOUG Spatial Summit 2016 Assembling a large scale map for the Netherlands Richard Huesken Collected by different organizations](https://reader033.vdocuments.us/reader033/viewer/2022051905/5ff745782689b819a10f7332/html5/thumbnails/34.jpg)
![Page 35: IOUG Spatial Summit 2016 - Oracle... Speaker : Date : E-mail : IOUG Spatial Summit 2016 Assembling a large scale map for the Netherlands Richard Huesken Collected by different organizations](https://reader033.vdocuments.us/reader033/viewer/2022051905/5ff745782689b819a10f7332/html5/thumbnails/35.jpg)
© WWW.TRANSFER-SOLUTIONS.COM
Replace Arc – detail
35
![Page 36: IOUG Spatial Summit 2016 - Oracle... Speaker : Date : E-mail : IOUG Spatial Summit 2016 Assembling a large scale map for the Netherlands Richard Huesken Collected by different organizations](https://reader033.vdocuments.us/reader033/viewer/2022051905/5ff745782689b819a10f7332/html5/thumbnails/36.jpg)
© WWW.TRANSFER-SOLUTIONS.COM
Replace Arc – result
36
![Page 37: IOUG Spatial Summit 2016 - Oracle... Speaker : Date : E-mail : IOUG Spatial Summit 2016 Assembling a large scale map for the Netherlands Richard Huesken Collected by different organizations](https://reader033.vdocuments.us/reader033/viewer/2022051905/5ff745782689b819a10f7332/html5/thumbnails/37.jpg)
© WWW.TRANSFER-SOLUTIONS.COM
Results
■ A topologically correct dataset ■ Arcs are preserved wherever possible ■ 99.99% Automatic resolution in the first run ■ Datasets with exceptions are rejected.
■ A few objects are adjusted manually ■ The data is processed successfully in a second run.
37
![Page 38: IOUG Spatial Summit 2016 - Oracle... Speaker : Date : E-mail : IOUG Spatial Summit 2016 Assembling a large scale map for the Netherlands Richard Huesken Collected by different organizations](https://reader033.vdocuments.us/reader033/viewer/2022051905/5ff745782689b819a10f7332/html5/thumbnails/38.jpg)
© WWW.TRANSFER-SOLUTIONS.COM
Recommendations
■ Technical ■ Use Oracle Spatial & Graph 12c ■ Use Spatial Vector Acceleration (SVA), with caution ■ Use Partitioning
■ Functional ■ Circular arcs are complicated ■ Use the simple features profile without arcs
38
![Page 39: IOUG Spatial Summit 2016 - Oracle... Speaker : Date : E-mail : IOUG Spatial Summit 2016 Assembling a large scale map for the Netherlands Richard Huesken Collected by different organizations](https://reader033.vdocuments.us/reader033/viewer/2022051905/5ff745782689b819a10f7332/html5/thumbnails/39.jpg)
Questions Answers
WWW.TRANSFER-SOLUTIONS.COM
CONSULTING | MANAGED SERVICES E
© WWW.TRANSFER-SOLUTIONS.COM 39
CONSULTING | MANAGED SERVICES | EDUCATION
WWW.TRANSFER-SOLUTIONS.COM