UK Oracle User Group


Assembling a Large Scale Map for the Netherlands Using Oracle 12c Spatial and Graph

« Return to event

Time: 1:45 PM - 2:45 PM

Track: Track 1

Abstract:

In the Netherlands, large scale map data is being maintained by numerous government agencies. These data reside in proprietary data sets which are stored in different formats. As of January 1st 2016, all these data need to be combined into a single, topologically correct dataset, from which all overlaps have been eliminated. By maintaining a single dataset, data can be presented consistently and re-used more frequently.


This dataset is known as BGT (Basisregistratie Grootschalige Topografie). The BGT will cover the entire country and is intended for usages on a scale from 1:500 – 1:5000. It includes features like buildings, roads, railroads, waterways, agricultural areas and forests. Eventually it will hold over 100.000.000 different objects.
The SVB-BGT is the organisation which is responsible for all activities related to collecting and maintaining the BGT. On behalf of the SVB-BGT, Transfer Solutions has implemented the BRAVO system to assemble these data into a single dataset. The BRAVO system is built on top of Oracle Spatial 12c, and this presentation will cover the team’s experience with this Oracle Spatial release.


Oracle Spatial 12c comes with a new feature which is called Spatial Vector Acceleration (SVA). The BRAVO system depends heavily on this new feature. In some cases, this feature has interesting side effects which will be highlighted in this presentation.


All data exchanged by the BRAVO system is stored in XML files. The geometries are recorded according to the GML 3.1 Simple Features Profile, with the addition of the GM_Arc (circular arc) primitive. This addition did not only cause additional complexity in the conversion of GML to Oracle’s SDO_GEOMETRY datatype, but also in detecting and resolving overlaps between features. In order to handle this complexity, advanced spatial techniques have been developed. As a result, the BRAVO system automatically eliminates overlaps, without the need for manual corrections and additions.

Biography:

I have nearly 20 years of experience with developing applications and Oracle databases. Over the last 8 years I specialized in Oracle Spatial. I have been involved with the BRAVO project from the start in 2013.

Presented by

  • Richard Huesken, Transfer Solutions

Attached Documents

Top