O'Reilly logo

Applying and Extending Oracle Spatial by Siva Ravada, Simon Gerard Greener

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Processing a collection of geometries

The preceding examples focused on the processing of one, then two geometries. In this section we will look at the processing of a collection (more than two) of SDO_GEOMETRY objects. The presentation of this type of processing will take place around solving a real world problem; creating land parcel polygons from their boundaries described by linestrings. This will require the following types of processing of collections of geometries:

  • Forming nodes between a collection of linestrings
  • Forming polygons from a collection of noded linestrings

Types of collections

Being inside the Oracle database, we have a limited number of methods or data types that can be used to represent a collection of geometry objects, which ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required