SQL Server Spatial

STMeasureToPercentage — Converts supplied measure value to a percentage. Function Specification. Description. The end measure minus the start measure of a measured line-string defines the range of the measures (see ST_Measure_Range). The supplied measure is divided by this range and multiplied by 100 to return the measure as a percentage. For non measured line-strings allRead More

STMeasureRange — Returns (Last Point M Value) – (First Point M Value). Function Specification. Description. Returns end point measure value – start point measure value. If line-string not measured, returns length of line. Parameters. Result. Returns the measure range for measured line-string: NULL if not measured. Example.

STValidMeasure — Checks if supplied measure falls within the linestring’s measure range. Function Specification. Description. Function returns 1 (true) if measure falls within the underlying linestring’s measure range or the 0 (false) string if the supplied measure does not fall within the measure range. Supports All Linestring geometry types Parameters. Result. Returns 1 (true) ifRead More

STValidLrsPoint — Checks if supplied @p_point is a valid LRS point. Function Specification. Description. Function returns 1 (true) if point is measured, and 0 (false) if point is not measured. A valid LRS point has measure information. The function checks for the Point geometry type and has a measured ordinate. Parameters. Result. The function returnsRead More

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