STIsPseudoMultiCurve — Checks if supplied @p_geometry is a GeometryCollection object containing only LineString, CircularString and CompoundCurve elements. Function Specification. Description. This function checks if the supplied @p_geometry is a GeometryCollection object containing only LineString, CircularString and CompoundCurve elements. One cannot create a MultiLineString object where an element is a CircularString or CompoundCurve. Any attempt toRead More
STFindPointByMeasure — Returns (possibly offset) point geometry at supplied measure along linestring. Function Specification. Description. Given a measure, this function returns a geometry point at that measure. If a non-zero/null value is suppied for @p_offset, the found point is offset (perpendicular to line) to the left (if @p_offset < 0) or to the right (ifRead More
Given a ratio (0 to 1.0), this function returns a geometry point at the position described by that ratio with optional offset to left or right.
Function finds point at position @p_length along linestring (does not need to be measured) with optional offset to left or right of @p_linestring
STLocateAlong — Returns (possibly offset) point geometry at supplied measure along linestring. Function Specification. Function [lrs].[STLocateAlong] ( @p_linestring geometry, @p_measure Float, @p_offset Float = 0.0, @p_round_xy int = 3, @p_round_zm int = 2 ) Returns geometry Description. This function is identical to STFindPointByName and so is a synonym for it. Given a measure, this functionRead More
STLocateBetween — Extracts, and possibly offet, linestring using supplied start and end measures and @p_offset value. Function Specification. Function [lrs].[STLocateBetween] ( @p_linestring geometry, @p_start_measure Float, @p_end_measure Float = null, @p_offset Float = 0, @p_round_xy int = 3, @p_round_zm int = 2 ) Returns geometry Description. Given a start and end measure, this function extracts theRead More
This function snaps a point to a linestring. If there is more than one possible solution the first point is returned. Computes Z and M values if exist on linestring. If linestring is 2D, the length from start of the linestring to the point is returned in M ordinate of point.
STFindMeasureByPoint — Returns value of the measure dimension of a point on the provided linesting closest to the provided point. Function Specification. Function [lrs].[STFindMeasureByPoint] ( @p_linestring geometry, @p_point geometry, @p_round_xy int = 3, @p_round_zm int = 2 ) Returns geometry Description. Given a point near a the supplied measure @p_linestring, this function returns the measureRead More
STFindMeasure — Snaps input point to measured linestring returning measure value Function Specification. Function [lrs].[STFindMeasure] ( @p_linestring geometry, @p_point geometry, @p_round_xy int = 3, @p_round_zm int = 2 ) Returns float Description. Given a point near a the supplied measure @p_linestring, this function returns the measure of the closest point on the measured @p_linestring. ReturnedRead More
STInterpolatePoint — Returns value of the measure dimension of a point on the provided linesting closest to the provided point. Function Specification. Function [lrs].[STInterpolatePoint] ( @p_linestring geometry, @p_point geometry, @p_round_xy int = 3, @p_round_zm int = 2 ) Returns geometry Description. This function snaps supplied point to @p_linestring, returning the measure value of the snappedRead More