4.48 SDO_TOPO_MAP.SEARCH_FACE_RTREE_TOPO_MAP
Format
SDO_TOPO_MAP.SEARCH_FACE_RTREE_TOPO_MAP( topo_map IN VARCHAR2, xmin IN NUMBER, ymin IN NUMBER, xmax IN NUMBER, ymax IN NUMBER, capacity IN NUMBER ) RETURN SDO_NUMBER_ARRAY;
Description
Returns an array with the face ID numbers of the faces that interact with a specified query window. The query uses the face R-tree built on the specified TopoMap object.
Parameters
- topo_map
-
Name of the TopoMap object. (TopoMap objects are explained in TopoMap Objects.)
- xmin
-
Lower-left X coordinate value for the query window.
- ymin
-
Lower-left Y coordinate value for the query window.
- xmax
-
Upper-right X coordinate value for the query window.
- ymax
-
Upper-right Y coordinate value for the query window.
- capacity
-
Maximum number of face ID values to be returned. If you specify 0 or a negative number, 100 is used.
Usage Notes
This procedure is equivalent to using the searchFaceRTree
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 numbers (up to 200) of faces that interact with a query window whose lower-left corner is at (5,5) and upper-right corner is at (30,40). (The example refers to definitions and data from Topology Built from Topology Data.)
SELECT SDO_TOPO_MAP.SEARCH_FACE_RTREE_TOPO_MAP('CITY_DATA_TOPOMAP', - 5,5, 30,40, 200) FROM DUAL; SDO_TOPO_MAP.SEARCH_FACE_RTREE_TOPO_MAP('CITY_DATA_TOPOMAP',5,5,30,40,200) -------------------------------------------------------------------------------- SDO_NUMBER_ARRAY(6, 7, 3, 4, 9, 1, 2)
Parent topic: SDO_TOPO_MAP Package Subprograms