Product is for SQL Server Spatial
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 — 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 — 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
STFindOffset — Compute smallest perpendicular offset from supplied point to the supplied linestring. Function Specification. Description. Given a point near @p_linestring, this function returns the perpendicular distance from it to the closest point on @p_linestring. Notes. Calls [lrs].[STInterpolatePoint] Srid of @p_linestring and @p_point must be the same. Parameters. Result. The function returns the perpendicular offsetRead More
STSplitProcedure — Procedure that splits a line into two parts. Function Specification. Description. Splits @p_linestring at position defined by @p_point. If @p_point is not on the line it is first snapped to the line. Supports CircularString and CompoundCurve geometry objects and subelements from 2012 onewards. Honours measures. Parameters. Result. Returns two parts of split linestring.Read More
The STSplit TSQL function splits a linestring into two parts at a supplied point. If the point is not on the line it is first snapped (cf STSnap function) to the line. The function supports LineStrings, and CircularStrings or CompoundCurves.
STRemoveMeasure — Function that removes measure values from all points in linestring. Function Specification. Description. Removes all measure ordinate values. Linestring with XYM ordinates is returned with XY ordinates. Linestring with XYZM ordinates is returned with XYZ ordinates. If all Z values are NULL, the Z is removed. Supports CircularString and CompoundCurve geometry objects andRead More
STIsMeasureDecreasing — Checks if M values decrease in value over the whole linestring. Function Specification. Description. Checks all measures of all vertices in a linestring from start to end. Computes difference between each pair of measures. If all measure differences decrease then TRUE is returned, otherwise FALSE. For non-measured line-strings the value is always TRUE.Read More
STIsMeasureIncreasing — Checks if M values increase in value over the whole linestring. Function Specification. Description. Checks all measures of all vertices in a linestring from start to end. Computes difference between each pair of measures. If all measure differences increase then TRUE is returned, otherwise FALSE. For non-measured line-strings the value is always TRUE.Read More
STPercentageToMeasure — Converts supplied Percentage value to a Measure. Function Specification. Description. The supplied percentage value (between 0 and 100) is multipled by the measure range (see STMeasureRange) to return a measure value between the start and end measures. For non measured line-strings all values are computed using lengths. Parameters. Result. Returns measure value atRead More