Skip to main content

GEO_DIFFERENCE

Returns the non-overlapping portion of a geometry

Updated today

Description

The GEO_DIFFERENCE() function returns the portion of the first geometry that does not overlap with the second geometry.

Syntax

GEO_DIFFERENCE(geometry1, geometry2)

Output

geometry

Variables

  • geometry1: The base geometry.

  • geometry2: The geometry to subtract from the base geometry.

Example

GEO_DIFFERENCE(`full territory`, `exclusion zone`)

Full Territory

Exclusion Zone

Geo Difference

Territory A

Zone 1

Territory A minus Zone 1

Territory B

Zone 2

Territory B minus Zone 2

Did this answer your question?