Oracle8(TM) Server Spatial Cartridge User's Guide and Reference Release 8.0.3 A53264_01 

This chapter contains descriptions of the geometric functions and procedures shown in Table 61:
Table 61 Geometric Functions:
This procedure stores coordinate geometry points into the SDOGEOM table.
SDO_GEOM.ADD_NODES (layername, SDO_GID, SDO_ESEQ, SDO_ETYPE, Xord1,Yord1[,...,X125, Y125])
None
SDO_GEOM.INIT_ELEMENT()
and SDO_GEOM.ADD_NODES()
.
Example 61 adds polygon element for geometry 25 in the LAYER1 data set. The polygon is a square.
SQL> EXECUTE SDO_GEOM.ADD_NODES (`LAYER1', 25, 2> SDO_GEOM.POLYGON_TYPE, 3> 3,3, 7,3, 4> 7,7, 3,7, 5> 3,3);
This function initializes elements in the SDOINFO table or view for a new geometry element.
SDO_GEOM.INIT_ELEMENT (layername, SDO_GID)
This function returns the next element sequence number. The data type is INTEGER.
Consider the following when using this function:
This function initializes the element to be stored, but does not actually insert coordinates into the SDOGEOM table. The SDO_GEOM.ADD_NODES() procedure is used to insert associated coordinate data.
For layer objects created as views, you need to explicitly insert new geometries, as opposed to using the provided stored procedures SDO_GEOM.INIT_ELEMENT()
and SDO_GEOM.ADD_NODES()
.
This function determines if two geometric objects interact.
SDO_GEOM.INTERACT (layername1, SDO_GID1, [layername2,] SDO_GID2)
SDO_GEOM.INTERACT (layername1, SDO_GID1, X_tolerance, Y_tolerance, SDO_ETYPE, num_ordinates, X_ordinate1, Y_ordinate1 [, ..., Xn, Yn]
[,SDO_ETYPE, num_ordinates, X_ordinate1, Y_ordinate1 [,...Xn,Yn]])
This function returns TRUE if the first and second objects interact with each other and are not disjoint. Data type is VARCHAR2.
Use the first form of the function to test two stored geometric objects.
Use the second form of the function to compare a stored object against a userdefined object. You can specify up to 123 vertices for a single element geometry. If the geometry has multiple elements, the total number of arguments passed, including SDO_ETYPE, num_ordinates, and the list of vertex coordinates cannot exceed 250 values.
This function examines two geometric objects to determine their spatial relationship.
SDO_GEOM.RELATE (layername1, SDO_GID1, mask, [layername2,] SDO_GID2)
SDO_GEOM.RELATE (layername1, SDO_GID1, mask, X_tolerance, Y_tolerance, SDO_ETYPE, num_ordinates, X_ordinate1, Y_ordinate1 [,...,Xn, Yn] [,SDO_ETYPE, num_ordinates, X_ordinate1, Y_ordinate1 [,...,Xn, Yn]])
The SDO_GEOM.RELATE procedure can return three types of answers:
Use the first form of the function to examine two stored geometric objects.
Use the second form of the function to compare a stored object against a userdefined object. You can specify up to 123 vertices for a single element geometry. If the geometry has multiple elements, the total number of arguments passed, including SDO_ETYPE, num_ordinates, and the list of vertex coordinates cannot exceed 250 values.
The following relationships can be tested:
Mask values can be combined using a logical OR. For example, `INSIDE + TOUCH' returns TRUE if the objects pass either test.
This function provides a consistency check for valid geometry types. The function checks the representation of the geometry from the tables against the element definitions.
SDO_GEOM.VALIDATE_GEOMETRY (layername,SDO_GID)
This function returns TRUE if the geometry is valid. Data type is VARCHAR2.
Consider the following when using this function:
This function checks for the following:
None