TSQL vs CLR (Common Language Runtime) stored procedures
Why the SQL Server Spatial functions available on this site are written in T-SQL and not as CLR stored procedures.
Year: 2019
STScale
STScale is a TSQL function that moves a geometry object’s ordinates using the supplied delta X, Y, Z and M. Function Specification. Example. Description. This function scales the supplied geometry’s ordinates using the supplied scale factors. The computed ordinates of the new geometry are rounded to the appropriate decimal digits of precision. Parameters. Results. TheRead More
ST_Translate (ie move)
The member function ST_Translate is the Oracle implementation of the STMove TSQL function for SQL Server Spatial and the ST_Move function for MySQL Spatial.
ST_Move
ST_Move This is a MySQL function which moves a geometry the supplied delta X and delta Y. Function Specification. Description. ST_Move is a function that moves the supplied geometry’s ordinates the supplied x and y deltas. The computed ordinates of the new geometry are rounded to p_round_xy number of decimal digits of precision. Parameters. Results.Read More
STMove
STMoveis a function that moves a geometry using the supplied delta X, Y, Z and M ordinate values. TSQL Function Specification. Description. The STMove function moves the supplied geometry’s ordinates using the supplied x, y, z and m delta ordinate values. The computed ordinates of the new geometry are rounded to @p_round_xy/@p_round_zm number of decimalRead More
STReverseMeasure
STReverseMeasure reverses M ordinate values in a (multi)linestring.
STScaleMeasure
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
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
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
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