STIsPseudoMultiCurve

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

STFindPointByRatio

STFindPointByRatio — Returns (possibly offset) point geometry at supplied length ratio along linestring. Function Specification. Description. Given a ratio (0 to 1.0), this function returns a geometry point at the position described by that ratio. Ratio is combined with length, so @p_ratio of 1.0 is equivalent to @p_linestring.STLength() ie @p_linestring.STEndPoint(). For example, @p_ratio value ofRead More

STLocateAlong

STLocateAlong — Returns (possibly offset) point geometry at supplied measure along linestring. Function Specification. Description. This function is identical to STFindPointByName and so is a synonym for it. 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 toRead More

STProjectPoint

STProjectPoint — Returns a measured point by snapping provided point to the provided line. Function Specification. Description. This function snaps supplied point to @p_linestring, returning the snapped point. If there is more than one possible solution the first point is retuend. Computes Z and M values if exist on @p_linestring. If input @p_linestring is 2D,Read More

STFindMeasureByPoint

STFindMeasureByPoint — Returns value of the measure dimension of a point on the provided linesting closest to the provided point. Function Specification. 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. Returned measure value is rounded to @p_round_zm decimal digits ofRead More

STFindMeasure

STFindMeasure — Snaps input point to measured linestring returning measure value Function Specification. 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. Returned measure value is rounded to @p_round_zm decimal digits of precision. Notes. Is wrapper over [lrs].[STInterpolatePoint]. Srid of @p_linestringRead More

STInterpolatePoint

STInterpolatePoint — Returns value of the measure dimension of a point on the provided linesting closest to the provided point. Function Specification. Description. This function snaps supplied point to @p_linestring, returning the measure value of the snapped point. Returned measure value is rounded to @p_round_zm decimal digits of precision. Notes. Supports linestrings with CircularString elements.Read More