Oracle Spatial operation Geometry method ____oracle

Sdo_geometry type in Oracle spatial:

CREATE TYPE Sdo_geometry as OBJECT (

Sdo_gtype number,--geometry type, such as Dot line surface

Space reference coordinate system of Sdo_srid number,--geometry

Sdo_point Sdo_point_type,--If geometry is a point type, store point coordinates, otherwise null

Sdo_elem_info Sdo_elem_info_array,--Define how to understand the sequence of coordinates in Sdo_ordinates

Sdo_ordinates sdo_ordinate_array--stores the actual coordinates, separated by commas between x,y and different points

)

Two relationships between objects:

RELATE

Sdo_geom. RELATE--Determine how two objects interact

eg

Sdo_geom. RELATE (geom1 in sdo_geometry,dim1 in Sdo_dim_array,mask in VARCHAR2, geom2 in sdo_geometry,dim2 on Sdo_dim_array) return V ARCHAR2;
Sdo_geom. RELATE (geom1 in Sdo_geometry,mask in Varchar2,geom2 at Sdo_geometry, tol in number) return Varchar2;--tol allowable precision Range

Mask

The anyinteract:geom2 fell on the geom1 surface, including the edges.

The contains:geom2 is completely contained in the Geom1 geometry object, and the edges of the two geometric objects are not crossed

The coveredby:geom1 is fully contained in the geom2, and the edges of two geometric objects have one or more points overlapping each other

The covers:geom2 is fully contained in the geom1, and the edges of two geometric objects have one or more points overlapping each other

Disjoint: Two geometry without overlapping intersections, and no common side

EQUAL: Two equal geometry

The inside:geom1 is completely contained in the Geom2 geometry object, and the edges of the two geometric objects are not crossed

The on:geom1 and inner lines are entirely on the geom2.

Overlapbdydisjoint: Two overlapping geometry objects, but no edges crossed

Overlapbdyintersect: Two geometric objects are called overlapping, and the edges are partially crossed

Touch: Two binding objects have a common side, but no cross

Within_distance

Sdo_geom. Within_distance--Determine whether two geometry is within the distance specified by each other

eg

Sdo_geom.  Within_distance (geom1 in Sdo_geometry,dim1-sdo_dim_array,dist in number, geom2 in sdo_geometry,dim2, in sdo_dim_array[, Units in VARCHAR2]) return VARCHAR2;
Sdo_geom. Within_distance (geom1 in Sdo_geometry,dist in Number,geom2 in Sdo_geometry,tol, number[in units]) return VARCHAR2 HAR2;

Verify:

Validate_geometry_with_context

Sdo_geom. Validate_geometry_with_context--Determines whether the geometry is valid, and returns contextual information if the geometry is not valid

eg

Sdo_geom. Validate_geometry_with_context (Thegeometry in Sdo_geometry, Thediminfo in sdo_dim_array,conditional in VARCHAR2 DEFAULT ' TRUE ') return VARCHAR2;
Sdo_geom. Validate_geometry_with_context (Thegeometry in Sdo_geometry,tolerance, number,conditional in VARCHAR2 DEFAULT ' TRUE ') return VARCHAR2;

Validate_layer_with_context

Sdo_geom. Validate_layer_with_context--Determines whether all geometry stored in the column is valid and returns contextual information about any invalid geometry

eg

Sdo_geom. Validate_layer_with_context (geom_table in Varchar2,geom_column, varchar2,result_table in VARCHAR2,commit_interval In number of Default-1, conditional in VARCHAR2 default ' TRUE ');

Single Object action:

Sdo_arc_densify

Sdo_geom. Sdo_arc_densify-simplifies, simplifies the arc into an approximate multi-line line composed of straight lines; approximate a circle to an n-polygon

eg

Sdo_geom. Sdo_arc_densify (Geom in Sdo_geometry,dim in Sdo_dim_array, params into VARCHAR2) return sdo_geometry;
Sdo_geom. Sdo_arc_densify (Geom in Sdo_geometry,tol of number, params in VARCHAR2) return sdo_geometry;

Sdo_area

Sdo_geom. Sdo_area--Calculating the area of a polygon

eg

Sdo_geom. Sdo_area (Geom in Sdo_geometry,dim in Sdo_dim_array [, Unit in VARCHAR2]) return number;
Sdo_geom. Sdo_area (Geom in Sdo_geometry,tol of number [, Unit in VARCHAR2]) return number;

Sdo_buffer

Sdo_geom. Sdo_buffer-generates buffers outside or inside the geometry

eg

Sdo_geom. Sdo_buffer (Geom in Sdo_geometry,dim in Sdo_dim_array,dist in number[, params in VARCHAR2]) return sdo_geometry;
Sdo_geom. Sdo_buffer (Geom in Sdo_geometry,dist in Number,tol in number[, params in VARCHAR2]) return sdo_geometry;

Sdo_centroid

Sdo_geom. Sdo_centroid--Calculating the center of mass of a polygon

eg

Sdo_geom. Sdo_centroid (geom1 in Sdo_geometry,dim1, Sdo_dim_array) return sdo_geometry;
Sdo_geom. Sdo_centroid (geom1 in Sdo_geometry,tol, number) return sdo_geometry;

Sdo_convexhull

Sdo_geom. Sdo_convexhull--A Polygon type object that returns a convex package of a geometric object

eg

Sdo_geom. Sdo_convexhull (geom1 in Sdo_geometry,dim1, Sdo_dim_array) return sdo_geometry;
Sdo_geom. Sdo_convexhull (geom1 in Sdo_geometry, tol in number) return sdo_geometry;

Sdo_length

Sdo_geom. Sdo_length--Calculate the length or perimeter of a geometry

eg

Sdo_geom. Sdo_length (Geom in Sdo_geometry,dim-sdo_dim_array[, unit in VARCHAR2