6.59 SDO_NET.GET_LINK_GEOMETRY
Format
SDO_NET.GET_LINK_GEOMETRY( network IN VARCHAR2, link_id IN NUMBER, start_percentage IN NUMBER DEFAULT 0, end_percentage IN NUMBER DEFAULT 1.0 ) RETURN SDO_GEOMETRY;
Description
Returns the entire geometry or a portion of the geometry associated with a link in a spatial network.
Parameters
- network
-
Network name.
- link_id
-
ID number of the link for which to return the geometry.
- start_percentage
-
Percentage of the distance along the link to be used for the start point of the returned geometry. Expressed as a number between 0 and 1.0; for example, 0.5 is 50 percent. The default value is 0; that is, the start of the returned geometry is associated with the start point of the link.
- end_percentage
-
Percentage of the distance along the link to be used for the end point of the returned geometry. Expressed as a number between 0 and 1.0; for example, 0.5 is 50 percent. The default value is 1.0; that is, the end of returned geometry is associated with the end point of the link.
Usage Notes
None.
Examples
The following example returns the geometry associated with the link whose link ID is 103 in the network named ROADS_NETWORK
.
SELECT SDO_NET.GET_LINK_GEOMETRY('ROADS_NETWORK', 103) FROM DUAL; SDO_NET.GET_LINK_GEOMETRY('ROADS_NETWORK',103)(SDO_GTYPE, SDO_SRID, SDO_POINT(X, -------------------------------------------------------------------------------- SDO_GEOMETRY(2002, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 2, 1), SDO_ORDINATE_ARRAY( 8, 4, 12, 4))
Parent topic: SDO_NET Package Subprograms