4.47 SDO_TOPO_MAP.SEARCH_EDGE_RTREE_TOPO_MAP
Format
SDO_TOPO_MAP.SEARCH_EDGE_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 edge ID numbers of the edges that interact with a specified query window. The query uses the edge 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 edge 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 searchEdgeRTree
method of the TopoMap
class of the client-side Java API (described in Topology Data Model Java Interface).
Examples
The following example returns the edge ID numbers (up to 200) of edge 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_EDGE_RTREE_TOPO_MAP('CITY_DATA_TOPOMAP', - 5,5, 30,40, 200) FROM DUAL; SDO_TOPO_MAP.SEARCH_EDGE_RTREE_TOPO_MAP('CITY_DATA_TOPOMAP',5,5,30,40,200) -------------------------------------------------------------------------------- SDO_NUMBER_ARRAY(12, 13, 22, 20, 9, 21, 19, 6, 10, 7, 26, 3, 1, 25, 2)
Parent topic: SDO_TOPO_MAP Package Subprograms