SQL Server Spatial

STReverseMeasure reverses M ordinate values in a (multi)linestring.

STScaleMeasure is a function that rescales a geometry’s measures and optionally offsets them, stretching the geometry. TSQL Function Signature. Description. This function can redistribute measure values between the supplied @p_start_measure (start vertex) and @p_end_measure (end vertex) by adjusting/scaling the measure values of all in between coordinates. In addition, if @p_shift_measure is not 0 (zero), theRead More

STUpdateMeasure is a TSQL function that re-scales (multi)linestring geometry measures from start to end using provided values. TSQL Function Specification. Description. This function resets all measures in a measured (multi)linestring by applying @p_start_measure to the start vertex and @p_end_measure to the end vertex. All vertices in between have the measures scaled between the start andRead More

STSetMeasure is a TSQL function that adds or updates (replaces) M value of supplied geometry point. TSQL Function Specification. Description. Function that adds/updates M ordinate of the supplied @p_point. The updated coordinate’s XY ordinates are rounded to @p_round_xy number of decimal digits of precision. The updated coordinate’s ZM ordinates are rounded to @p_round_ZM number ofRead More

STResetMeasure is a TSQL function that sets all existing assigned measures to NULL. TSQL Function Specification. Description. Sets all measures of a measured linestring to supplied @p_marker_measure value leaving dimensionality of geometry alone. So, a linestring with XYM remains so, but all measures are set to value of -999999999 if @p_marker_measure is NULL, and @p_marker_measureRead More

STRemoveMeasure is a TSQL function that removes measure values from all vertices in a (multi)linestring. TSQL Function Call Signature Description. Removes all measure ordinate values. Linestring with XYM ordinates is returned with XY ordinates. Linestring with XYZM ordinates is returned with XYZ ordinates. Supports CircularString and CompoundCurve geometry objects and subelements from 2012 onewards. ParametersRead More

STAddMeasure is a TSQL function that adds measures to the supplied linestring. TSQL Call Signature Description. Function that add measure ordinates to the supplied @p_linestring. The function supports LineString, CircularString, CompoundCurve geometries If geometry is already measured it is returned unchanged. Start Point is assigned @p_start_measure and End Point is assigned @p_end_measure. Intermediate Points’ measureRead More