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
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