ST_Locate_Along_Elevation
Prev 8. Linear Referencing Next

Name

ST_Locate_Along_Elevation — Extracts Points from a Geometry object that have the specified z coordinate value.

Synopsis

geometry ST_Locate_Along_Elevation(bytea Geometry, double Z);

Alias

Locate_Along_Elevation

Description

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

Coordinate Dimensions
2D3DM
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
----

Examples

SELECT ST_AsEWKT(geom)
	FROM
	(SELECT ST_Locate_Along_Elevation(
		ST_GeomFromEWKT('MULTILINESTRING ((1 1 2 8, 2 1 4 0, 3 1 5 2), (4 1 2 2, 5 3 0 -4, 8 8 0 -6))'),2) As geom) 
As foo;

--Result
GEOMETRYCOLLECTION (POINT (1 1 2 8), POINT (4 1 2 2))
Geom
ST_Along_Elevation(Geom,2)

Related functions

ST_Locate_Between_Elevations

Prev Up Next
ST_Locate_Between_Measures Home ST_Locate_Between_Elevations