6.83 SDO_NET.GET_PT
Format
SDO_NET.GET_PT( network IN VARCHAR2, link_id IN NUMBER, percentage IN NUMBER ) RETURN SDO_GEOMETRY;
Description
Returns the point geometry that is a specified percentage of the distance along a link's line string geometry.
Parameters
Usage Notes
To find the percentage along a link geometry for a specified point, use the SDO_NET.GET_PERCENTAGE function.
Examples
The following example returns the point geometry that is 25 percent of the distance from the start node along the geometry associated with the link whose link ID is 101 in the network named ROADS_NETWORK
.
SELECT SDO_NET.GET_PT('ROADS_NETWORK', 101, 0.25) FROM DUAL; SDO_NET.GET_PT('ROADS_NETWORK',101,0.25)(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z) -------------------------------------------------------------------------------- SDO_GEOMETRY(2001, NULL, SDO_POINT_TYPE(2, 2.5, NULL), NULL, NULL)
Parent topic: SDO_NET Package Subprograms