Skip to main content

GEO_INTERSECTION

Returns the overlapping portion of two geometries

Updated today

Description

The GEO_INTERSECTION() function returns the portion of two geometries that overlaps.

Syntax

GEO_INTERSECTION(geometry1, geometry2)

Output

geometry

Variables

  • geometry1: The first geometry.

  • geometry2: The second geometry.

Example

GEO_INTERSECTION(`trade area a`, `trade area b`)

Trade Area A

Trade Area B

Geo Intersection

Trade Area A

Trade Area B

Overlap geometry

Region 1

Region 2

Shared area

Did this answer your question?