Spatial Solutions Architect and Database Expert
STValidLrsGeometry — Checks if supplied @p_linestring is a valid measured linestring. Function Specification. Description. This function checks for geometry type and number of dimensions of the geometric segment. Function returns 1 (true) if provided geometry is a linestring with valid measured, and 0 (false) otherwise. Linestring must have either increasing or decreasing measures. The functionRead More
STSetM — Function that adds or updates (replaces) M value of supplied geometry point. 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 of decimal digits ofRead More
STEndMeasure — Returns M value of last point in a measured geometry. Function Specification. Description. Returns the measure associated with the last point in a measured (multi)line-string. If the line-string is not measured it returns 0. Supports Linestrings with CircularString elements (2012). Parameters. Result. The value of the measure ordinates of the last point inRead More
STStartMeasure — Returns M value of first point in measured geometry. Function Specification. Description. Returns start measure associated with first point in a measured (multi)line-string. If the line-string is not measured it returns 0. Supports Linestrings with CircularString elements (2012). Parameters. Result. This function returns the M ordinate value of first point in a measuredRead More
Why the SQL Server Spatial functions available on this site are written in T-SQL and not as CLR stored procedures.
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
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 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
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 reverses M ordinate values in a (multi)linestring.