Name
ST_Force_3DM — Forces the incoming geometry to be 3D, with X,Y and M coordinates.
Synopsis
geometry ST_Force_3DM(bytea
Geometry);
Description
Forces the incoming geometry to be 3D, with X,Y and M coordinates. 0 is set for unknown M coordinate. In any case, Z coordinate is set to 0.
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 |
|---|---|---|---|
| - | - | - | - |
Examples
SELECT ST_AsEWKT(ST_Force_3DM(ST_GeomFromEWKT('LINESTRING (0 0, 10 10, 20 10)')));
--Result
LINESTRING (0 0 0 0, 10 10 0 0, 20 10 0 0)
SELECT ST_AsEWKT(Force_3DM(ST_GeomFromEWKT('GEOMETRYCOLLECTION(POINTM(0 0 -4),POINT(5 5 10 -4))')));
--Result
GEOMETRYCOLLECTION (POINT (0 0 0 -4), POINT (5 5 0 -4))