25 SDO_GEOM Package (Geometry)

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 do not support three-dimensional geometries in Oracle Autonomous Database Serverless deployments.

  • 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.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