Locate_Between_Elevations
LOCATE_BETWEEN_ELEVATIONS(g Geometry, float f1, float f2);
Alias: ST_LOCATE_BETWEEN_ELEVATIONS
Returns a point collection containing all points of g that have a Z ordinate between f1 and f2.
The first argument g must be of type PointM, PointZM, LinestringM, LinestringZM, MultiLinestringM, MultiLinestringZM, MultiPointM, or MultiPointZM.
The second and third argument, f1 and f2, make up the elevation (Z) range that you want to locate geometries between.
Result Type: A geometry collection of appropriate type.
Example:
SELECT ASTEXT(LOCATE_BETWEEN_ELEVATIONS(GEOMFROMTEXT('MULTILINESTRING Z ((1 2 3, 3 4 2, 9 4 3), (1 2 3, 5 4 5))'), 1.5, 3));
-------------
col1
-------------
GEOMETRYCOLLECTION Z(LINESTRING Z(1 2 3, 3 4 2, 9 4 3), POINT Z(1 2 3))
-------------