Oracle9i Supplied PL/SQL Packages and Types Reference
Release 1 (9.0.1)

Part Number A89852-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Introduction, 4 of 7


SDO_LRS Package

Table 1-4 SDO_LRS Package Subprograms  
Subprogram  Description 

CLIP_GEOM_SEGMENT 

Clips a geometric segment (synonym of DYNAMIC_SEGMENT). 

CONCATENATE_GEOM_SEGMENTS 

Concatenates two geometric segments into one segment. 

CONNECTED_GEOM_SEGMENTS 

Checks if two geometric segments are connected. 

CONVERT_TO_LRS_DIM_ARRAY 

Converts a standard dimensional array to a Linear Referencing System dimensional array by creating a measure dimension. 

CONVERT_TO_LRS_GEOM 

Converts a standard SDO_GEOMETRY line string to a Linear Referencing System geometric segment by adding measure information. 

CONVERT_TO_LRS_LAYER 

Converts all geometry objects in a column of type SDO_GEOMETRY from standard line string geometries without measure information to Linear Referencing System geometric segments with measure information, and updates the metadata. 

CONVERT_TO_STD_DIM_ARRAY 

Converts a Linear Referencing System dimensional array to a standard dimensional array by removing the measure dimension. 

CONVERT_TO_STD_GEOM 

Converts a Linear Referencing System geometric segment to a standard SDO_GEOMETRY line string by removing measure information. 

CONVERT_TO_STD_LAYER 

Converts all geometry objects in a column of type SDO_GEOMETRY from Linear Referencing System geometric segments with measure information to standard line string geometries without measure information, and updates the metadata. 

DEFINE_GEOM_SEGMENT  

Defines a geometric segment. 

DYNAMIC_SEGMENT 

Clips a geometric segment (synonym of CLIP_GEOM_SEGMENT). 

FIND_LRS_DIM_POS 

Returns the position of the measure dimension within the SDO_DIM_ARRAY structure for a specified SDO_GEOMETRY column. 

FIND_MEASURE 

Returns the measure of the closest point on a segment to a specified projection point. 

GEOM_SEGMENT_END_MEASURE 

Returns the end measure of a geometric segment. 

GEOM_SEGMENT_END_PT 

Returns the end point of a geometric segment. 

GEOM_SEGMENT_LENGTH 

Returns the length of a geometric segment. 

GEOM_SEGMENT_START_MEASURE 

Returns the start measure of a geometric segment. 

GEOM_SEGMENT_START_PT 

Returns the start point of a geometric segment. 

GET_MEASURE 

Returns the measure of an LRS point. 

IS_GEOM_SEGMENT_DEFINED 

Checks if an LRS segment is defined correctly. 

IS_MEASURE_DECREASING 

Checks if the measure values along an LRS segment are decreasing (that is, descending in numerical value). 

IS_MEASURE_INCREASING 

Checks if the measure values along an LRS segment are increasing (that is, ascending in numerical value). 

LOCATE_PT 

Returns the point located at a specified distance from the start of a geometric segment. 

MEASURE_RANGE 

Returns the measure range of a geometric segment, that is, the difference between the start measure and end measure. 

MEASURE_TO_PERCENTAGE 

Returns the percentage (0 to 100) that a specified measure is of the measure range of a geometric segment. 

OFFSET_GEOM_SEGMENT 

Returns the geometric segment at a specified offset from a geometric segment. 

PERCENTAGE_TO_MEASURE 

Returns the measure value of a specified percentage (0 to 100) of the measure range of a geometric segment. 

PROJECT_PT 

Returns the projection point of a point on a geometric segment. 

REDEFINE_GEOM_SEGMENT  

Populates the measures of all shape points of a geometric segment based on the start and end measures, overriding any previously assigned measures between the start point and end point. 

RESET_MEASURE 

Sets all measures of a geometric segment, including the start and end measures, to null values, overriding any previously assigned measures. 

REVERSE_MEASURE 

Returns a new geometric segment by reversing the original geometric segment. 

REVERSE_GEOMETRY 

Returns a new geometric segment by reversing the measure values and the direction of the original geometric segment. 

SCALE_GEOM_SEGMENT 

Scales a geometric segment. 

SET_PT_MEASURE 

Sets the measure value of a specified point. 

SPLIT_GEOM_SEGMENT  

Splits a geometric segment into two segments. 

TRANSLATE_MEASURE 

Returns a new geometric segment by translating the original geometric segment (that is, shifting the start and end measures by a specified value). 

VALID_GEOM_SEGMENT 

Checks if a geometric segment is valid. 

VALID_LRS_PT 

Checks if an LRS point is valid. 

VALID_MEASURE 

Checks if a measure falls within the measure range of a geometric segment. 

VALIDATE_LRS_GEOMETRY 

Checks if an LRS geometry is valid. 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback