Name
ST_Locate_Between_Measures — Returns a derived geometry whose measures are in the specified M range.
Synopsis
geometry
ST_Locate_Between_Measures(bytea
Geometry, double
start_M, double
end_M);
Description
Returns a derived geometry whose measures are in the specified M range.
Coordinate Dimensions
| 2D | 3D | M |
|---|---|---|
 | | |
Spatial Standards Support
| OGC SFS for SQL. 1.1 (1999) | OGC SFS for SQL. 1.1.0 (2005) | OGC SFS for SQL. 1.2.0 (2006) | SQL-MM Part 3 |
|---|---|---|---|
| - | - | - | 5.1.13 ST_LocateBetween |
Examples
SELECT ST_AsEWKT(the_geom)
FROM
(SELECT ST_Locate_Between_Measures(
ST_GeomFromEWKT('MULTILINESTRING((1 1 2 8, 1 5 4 0, 6 5 4 2),
(4 3 2 2, 8 3 0 -4, 8 8 0 -6))'),2,8) As the_geom) As foo;
--Result
GEOMETRYCOLLECTION (GEOMETRYCOLLECTION (LINESTRING (1 1 2 8, 1 4 3.5 2), POINT (6 5 4 2)), POINT (4 3 2 2))