ST_Locate_Along

ST_Locate_Along_Measure
Prev	8. Linear Referencing	Next

Name

ST_Locate_Along_Measure — Extracts Points from a Geometry object that have the specified m coordinate value.

Synopsis

geometry ST_Locate_Along_Measure(bytea Geometry, double M);

Alias

ST_Locate_Along_Measure, ST_LocateAlong, LocateAlong

Description

Extracts Points from a Geometry object that have the specified m coordinate value.

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.12 ST_LocateAlong

Examples

SELECT ST_AsEWKT(the_geom)
	FROM
	(SELECT ST_Locate_Along_Measure(
		ST_GeomFromEWKT('MULTILINESTRINGM((1 2 3, 3 4 2, 9 4 3),
	(1 2 3, 5 4 5))'),3) As the_geom) As foo;

--Result
GEOMETRYCOLLECTION (MULTIPOINT ((1 2 0 3), (9 4 0 3)), POINT (1 2 0 3))

Related functions

ST_Locate_Between_Measures