Oracle8 Spatial Cartridge User's Guide and Reference Release 8.0.4 A5326402 

This chapter contains descriptions of the geometric functions and procedures shown in Table 71.:
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])
Consider the following when using this procedure:
Example 71 adds a polygon element for geometry 25 in the LAYER1 data set. The polygon is a square.
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.
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 SDO_GEOM.INIT_ELEMENT() and SDO_GEOM.ADD_NODES().
This function determines if two geometry 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. The data type is VARCHAR2.
Use the first form of the function to test two stored geometry 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 geometry 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() function can return three types of answers:
The data type is VARCHAR2.
Use the first form of the function to examine two stored geometry 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 singleelement 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. The data type is VARCHAR2.
This function checks for the following:
None