Skip to content

Spatial Match (Intersect / Unmatched)

The Spatial Match (Intersect / Unmatched) step pairs each target geometry with the universe geometries it relates to and can emit either the intersection geometry of each matched pair (IntersectPoly) or the Unmatched target rows. It complements the SQL Spatial Match step, which covers the plain matched-pairs case; this executor-backed step covers the two outputs that cannot be expressed in database SQL.

  • Target Table / Universe Table — the geometries to match and the candidates to match against.
  • Output Table — where the result is written.
  • Target geometry / Universe geometry — the WKT geometry column on each side.
  • Relationship — intersects, within, or contains.
  • Also emit the intersection geometry (IntersectPoly) — add the overlap geometry of each matched pair as a column.
  • OutputMatched pairs or Unmatched target rows.

Each input has a mapping tab listing its columns, used to drive the geometry pickers and to pass columns through to the output.