4.16 SDO_TOPO_MAP.GET_CONTAINING_FACE
Format
SDO_TOPO_MAP.GET_CONTAINING_FACE( topology IN VARCHAR2, topo_map IN VARCHAR2, point IN SDO_GEOMETRY ) RETURN NUMBER;
or
SDO_TOPO_MAP.GET_CONTAINING_FACE( topology IN VARCHAR2, topo_map IN VARCHAR2, x IN NUMBER, y IN NUMBER ) RETURN NUMBER;
Description
Returns the face ID number of the face that contains the specified point.
Parameters
- topology
-
Name of the topology that contains the face and the point, or a null value, as explained in Using GET_xxx Topology Functions. Must not exceed 20 characters.
- topo_map
-
Name of the TopoMap object, or a null value, as explained in Using GET_xxx Topology Functions. (TopoMap objects are explained in TopoMap Objects.)
- point
-
Geometry object specifying the point.
- x
-
X-axis value of the point.
- y
-
Y-axis value of the point.
Usage Notes
The topology
or topo_map
parameter should specify a valid name, as explained in Using GET_xxx Topology Functions.
This function determines, from the faces in the specified TopoMap object (including any island faces), which one face (if any) contains the specified point in its open set, excluding islands. (The open set, excluding islands, of a face consists of all points inside, but not on the boundary of, the face.) If the point is exactly on the boundary of a face, the function returns a value of 0 (zero).
If the entire topology has been loaded into the TopoMap object and if the point is not in any finite face in the cache, this function returns a value of -1 (for the universe face). If a window from the topology has been loaded into the TopoMap object and if the point is not in any finite face in the cache, this function returns a value of -1 (for the universe face) if the point is inside the window and a value of 0 (zero) if the point is outside the window. If neither the entire topology nor a window has been loaded, this function returns 0 (zero).
This function is equivalent to using the getContainingFace
method of the TopoMap
class of the client-side Java API (described in Topology Data Model Java Interface).
Examples
The following example returns the face ID number of the face that contains the point at (22, 37) in the CITY_DATA_TOPOMAP
TopoMap object. (The example refers to definitions and data from Topology Built from Topology Data.)
SELECT SDO_TOPO_MAP.GET_CONTAINING_FACE(null, 'CITY_DATA_TOPOMAP', SDO_GEOMETRY(2001, NULL, SDO_POINT_TYPE(22,37,NULL), NULL, NULL)) FROM DUAL; SDO_TOPO_MAP.GET_CONTAINING_FACE(NULL,'CITY_DATA_TOPOMAP',SDO_GEOMETRY(2001,NULL -------------------------------------------------------------------------------- 2
Parent topic: SDO_TOPO_MAP Package Subprograms