The MDSIS.SDO_GEOM package contains subprograms for working with geometry objects.

This chapter contains descriptions of the geometry-related PL/SQL subprograms in the SDO_GEOM package, which can be grouped into the following categories:

• Relationship (True/False) between two objects: RELATE, WITHIN_DISTANCE

• Validation: VALIDATE_GEOMETRY_WITH_CONTEXT, VALIDATE_LAYER_WITH_CONTEXT, SDO_SELF_UNION

• Single-object operations: SDO_ALPHA_SHAPE, SDO_ARC_DENSIFY, SDO_AREA, SDO_BUFFER, SDO_CENTROID, SDO_CONVEXHULL, SDO_CONCAVEHULL, SDO_CONCAVEHULL_BOUNDARY, SDO_DIAMETER, SDO_DIAMETER_LINE, SDO_LENGTH, SDO_MBC, SDO_MBC_CENTER, SDO_MBC_RADIUS, SDO_MAX_MBR_ORDINATE, SDO_MIN_MBR_ORDINATE, SDO_MBR, SDO_POINTONSURFACE, SDO_TRIANGULATE, SDO_VOLUME, SDO_WIDTH, SDO_WIDTH_LINE

• Two-object operations: SDO_CLOSEST_POINTS, SDO_DISTANCE, SDO_DIFFERENCE, SDO_INTERSECTION, SDO_MAXDISTANCE, SDO_MAXDISTANCE_LINE, SDO_UNION, SDO_XOR

The following usage information applies to the geometry subprograms. (See also the Usage Notes under the reference information for each subprogram.)

• Certain combinations of input parameters and operations can return a null value, that is, an empty geometry. For example, requesting the intersection of two disjoint geometry objects returns a null value.

• A null value (empty geometry) as an input parameter to a geometry function (for example, SDO_GEOM.RELATE) produces an error.

• Certain operations can return a geometry of a different type than one or both input geometries. For example, the intersection of a line and an overlapping polygon returns a line; the intersection of two lines returns a point; and the intersection of two tangent polygons returns a line.

• SDO_GEOM subprograms are supported for two-dimensional geometries only, except for the following, which are supported for both two-dimensional and three-dimensional geometries:

  Note:

  The listed SDO_GEOM subprograms for three-dimensional geometries are supported only if Oracle JVM is enabled on your Oracle Autonomous Database Serverless deployments. To enable Oracle JVM, see Use Oracle Java in Using Oracle Autonomous Database Serverless for more information.

  • SDO_GEOM.RELATE with (A) the ANYINTERACT mask, or (B) the INSIDE mask (3D support for solid geometries only)

  • SDO_GEOM.SDO_AREA

  • SDO_GEOM.SDO_DISTANCE

  • SDO_GEOM.SDO_LENGTH

  • SDO_GEOM.SDO_MAX_MBR_ORDINATE

  • SDO_GEOM.SDO_MBR

  • SDO_GEOM.SDO_MIN_MBR_ORDINATE

  • SDO_GEOM.SDO_VOLUME

  • SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT

  • SDO_GEOM.VALIDATE_LAYER_WITH_CONTEXT

  • SDO_GEOM.WITHIN_DISTANCE

• SDO_GEOM.DTW_DISTANCE
  
• SDO_GEOM.RELATE
  
• SDO_GEOM.SDO_ALPHA_SHAPE
  
• SDO_GEOM.SDO_ARC_DENSIFY
  
• SDO_GEOM.SDO_AREA
  
• SDO_GEOM.SDO_BUFFER
  
• SDO_GEOM.SDO_CENTROID
  
• SDO_GEOM.SDO_CLOSEST_POINTS
  
• SDO_GEOM.SDO_CONCAVEHULL
  
• SDO_GEOM.SDO_CONCAVEHULL_BOUNDARY
  
• SDO_GEOM.SDO_CONVEXHULL
  
• SDO_GEOM.SDO_DIAMETER
  
• SDO_GEOM.SDO_DIAMETER_LINE
  
• SDO_GEOM.SDO_DIFFERENCE
  
• SDO_GEOM.SDO_DISTANCE
  
• SDO_GEOM.SDO_INTERSECTION
  
• SDO_GEOM.SDO_LENGTH
  
• SDO_GEOM.SDO_MAX_MBR_ORDINATE
  
• SDO_GEOM.SDO_MAXDISTANCE
  
• SDO_GEOM.SDO_MAXDISTANCE_LINE
  
• SDO_GEOM.SDO_MBC
  
• SDO_GEOM.SDO_MBC_CENTER
  
• SDO_GEOM.SDO_MBC_RADIUS
  
• SDO_GEOM.SDO_MBR
  
• SDO_GEOM.SDO_MIN_MBR_ORDINATE
  
• SDO_GEOM.SDO_POINTONSURFACE
  
• SDO_GEOM.SDO_SELF_UNION
  
• SDO_GEOM.SDO_TRIANGULATE
  
• SDO_GEOM.SDO_UNION
  
• SDO_GEOM.SDO_VOLUME
  
• SDO_GEOM.SDO_WIDTH
  
• SDO_GEOM.SDO_WIDTH_LINE
  
• SDO_GEOM.SDO_XOR
  
• SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT
  
• SDO_GEOM.VALIDATE_LAYER_WITH_CONTEXT
  
• SDO_GEOM.WITHIN_DISTANCE