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 of SDO_GEOM.RELATE.
  * @note Supports JTS named topological relationships and 
  *       not Oracle specific keywords like OVERLAPBDYDISJOINT
  * @param p_geom1 : SDO_GEOMETRY : Geometry compared to second
  * @param p_mask  : varchar2    : Mask...