ST_Force3DM¶

Forces a geometry or geography into a XYM coordinate model with an optional M value.

Usage¶

geometry ST_Force3DM(geom: geometry)
geometry ST_Force3DM(geom: geometry, m: double)
geography ST_Force3DM(geog: geography)
geography ST_Force3DM(geog: geography, m: double)

Arguments¶

geog (geography): Input geography
m (double)
geom (geometry): Input geometry

Description¶

If the geometry already has M values they are preserved; otherwise the optional m argument (default 0) is used.

Examples¶

SELECT ST_Force3DM(ST_GeomFromWKT('POINT (1 2)'), 10.0);

┌──────────────────────────────────────────────────────────────┐
│ st_force3dm(st_geomfromwkt(Utf8("POINT (1 2)")),Float64(10)) │
│                           geometry                           │
╞══════════════════════════════════════════════════════════════╡
│ POINT M(1 2 10)                                              │
└──────────────────────────────────────────────────────────────┘

SELECT ST_Force3DM(ST_GeomFromWKT('POINT (1 2)'));

┌──────────────────────────────────────────────────┐
│ st_force3dm(st_geomfromwkt(Utf8("POINT (1 2)"))) │
│                     geometry                     │
╞══════════════════════════════════════════════════╡
│ POINT M(1 2 0)                                   │
└──────────────────────────────────────────────────┘

SELECT ST_Force3DM(ST_GeogFromWKT('POINT (1 2)'), 10.0);

┌──────────────────────────────────────────────────────────────┐
│ st_force3dm(st_geogfromwkt(Utf8("POINT (1 2)")),Float64(10)) │
│                           geography                          │
╞══════════════════════════════════════════════════════════════╡
│ POINT M(1 2 10)                                              │
└──────────────────────────────────────────────────────────────┘