Skip to content
PlaidCloud

Spatial Poly-Split

Description

Section titled “Description”

The Spatial Poly-Split step breaks each input geometry into its constituent pieces and writes one row per piece. It is the equivalent of the Alteryx Poly-Split tool and runs in the workflow engine.

The number of pieces is a property of the geometry rather than a projection over columns, so this cannot be expressed as SQL.

Source & Options

Section titled “Source & Options”
  • Source Table / Output Table — the input geometries and where the pieces are written.
  • Geometry column — the WKT geometry column to split.
  • Split to — what counts as a piece:
    • Points — one row per vertex of the geometry.
    • Regions — one row per component polygon.
    • Detailed regions — component polygons plus their holes.

Any other value fails the step rather than falling back to a default.

Output Columns

Section titled “Output Columns”

The source columns pass through, and two columns are appended:

Column Type Contents
Split_SpatialObj text The piece, as WKT
Split_SequenceNum bigint The piece’s position within its source geometry
Section titled “Related”