Oracle Spatial Operation Geometry method

Relationship between two objects:

RELATE

Sdo_geom. RELATE--Determine how two objects interact

Within_distance

Verify:

Validate_geometry_with_context

Validate_layer_with_context

Single-Object operation:

Sdo_arc_densify

Sdo_geom. Sdo_arc_densify-simplifies, simplifies arcs to approximate polylines made up of straight lines; approximate circles to n polygons

Sdo_area

Sdo_geom. Sdo_area -Calculate the area of a polygon

Sdo_buffer

Sdo_geom. Sdo_buffer --generate buffers outside or inside the geometry

Sdo_centroid

Sdo_geom. Sdo_centroid --Calculate the centroid of a polygon

Sdo_convexhull

Sdo_geom. Sdo_convexhull --The Polygon type object that returns the convex hull of the Geometry object

Sdo_length

Sdo_max_mbr_ordinate

Sdo_min_mbr_ordinate

Sdo_mbr

Sdo_pointonsurface

Sdo_volume

Dual-target operation:

Sdo_closest_points

Sdo_geom. Sdo_closest_points -Calculates the minimum distance between two geometries and returns the two points in the geometry at the nearest hour

Sdo_distance

Sdo_geom. Sdo_distance -Calculates the distance between two geometric objects

Sdo_difference

Sdo_geom. Sdo_difference --Returns the geometry (topological differences of two geometries, minus operations)

Sdo_intersection

Sdo_geom. Sdo_intersection --Returns the geometric object (the topology intersection of two geometries, and operation)

Sdo_union

Sdo_xor

Oracle Spatial Operation Geometry method