ST_Force_3D
Prev 4. Geometry Editors Next

Name

ST_Force_3D — Forces the incoming geometry to be 3D, so it will have X,Y,Z coordinates.

Synopsis

geometry ST_Force_3D(bytea Geometry);

Alias

Force_3D, ST_Force_3DZ, Force_3DZ

Description

Forces the incoming geometry to be 3D, so it will have X,Y,Z coordinates. If the object doesn't have Z coordinate, it is set to 0.

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(ST_Force_3D(ST_GeomFromEWKT('LINESTRING (0 0, 10 10, 20 10)')));
--Result
LINESTRING (0 0 0, 10 10 0, 20 10 0)

SELECT ST_AsEWKT(ST_Force_3DZ(ST_GeomFromEWKT('GEOMETRYCOLLECTION(POINTM(0 0 -4),POINT(5 5 10 -4))')));
--Result
GEOMETRYCOLLECTION (POINT (0 0 0), POINT (5 5 10))

Related functions

ST_Force_2D, ST_Force_3DM, ST_Force_4D

Prev Up Next
ST_Force_2D Home ST_Force_3DM