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

Functions for processing two geometries

In the previous example, we constructed a Java function that processed a single Geometry object to buffer a geometry using a number of styles. In this section, we will introduce a number of functions that will process two converted SDO_GEOMETRY objects.

Spatially (Topological) comparing two geometries – ST_Relate

Oracle Spatial contains a special licensed function called SDO_GEOM.RELATE that examines two SDO_GEOMETRY objects to determine their spatial relationship.

This functionality is something that is often required when processing geometry objects and is often something Locator users look for.

The chosen PL/SQL call interface mimics the Oracle equivalent:

/** * ST_Relate * Implements a license free version ...

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