ST_Dump¶

Expands multi-part geometries into child parts

Usage¶

struct ST_Dump(geom: geometry)
struct ST_Dump(geog: geography)

Arguments¶

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

Description¶

If the geometry is simple it returns the geometry itself, if the geometry is collection or multi it returns record for each of collection components.

Examples¶

SELECT ST_Dump(ST_GeomFromText('MULTIPOINT ((10 40), (40 30), (20 20), (30 10))'));

┌──────────────────────────────────────────────────────────────────────────────┐
│ st_dump(st_geomfromtext(Utf8("MULTIPOINT ((10 40), (40 30), (20 20), (30 10) │
│                                    )")))…                                    │
╞══════════════════════════════════════════════════════════════════════════════╡
│ [{path: [1], geom: POINT(10 40)}, {path: [2], geom: POINT(40 30)}, {path: [… │
└──────────────────────────────────────────────────────────────────────────────┘