ST_Points¶

Returns a MultiPoint geometry consisting of all the coordinates of the input geometry.

Usage¶

geometry ST_Points(geom: geometry)

Arguments¶

geom (geometry): Input geometry

Description¶

Returns a MultiPoint geometry consisting of all the coordinates of the input geometry. It preserves duplicate points as well as M and Z coordinates.

Examples¶

SELECT ST_AsText(ST_Points(ST_GeomFromText('LINESTRING (2 4, 3 3, 4 2, 7 3)')));

┌──────────────────────────────────────────────────────────────────────────────┐
│ st_astext(st_points(st_geomfromtext(Utf8("LINESTRING (2 4, 3 3, 4 2, 7 3)")) │
│                                      ))…                                     │
╞══════════════════════════════════════════════════════════════════════════════╡
│ MULTIPOINT((2 4),(3 3),(4 2),(7 3))                                          │
└──────────────────────────────────────────────────────────────────────────────┘