ST_Force2D¶

Forces a geometry into a XY coordinate model.

Usage¶

geometry ST_Force2D(geom: geometry)

Arguments¶

geom (geometry): Input geometry

Description¶

Discards any Z and M values present (if any).

Examples¶

SELECT ST_Force2D(ST_GeomFromWKT('POINT Z (1 2 3)'));

┌─────────────────────────────────────────────────────┐
│ st_force2d(st_geomfromwkt(Utf8("POINT Z (1 2 3)"))) │
│                       geometry                      │
╞═════════════════════════════════════════════════════╡
│ POINT(1 2)                                          │
└─────────────────────────────────────────────────────┘