Skip to main content
Return the intersection geometry of A and B ST_Intersection

​
Signatures

ST_Intersection (A: Geometry, B: Geometry)

​
Parameters

​
A
Geometry
required
The input geometry.
​
B
Geometry
required
The second geometry.

​
Return type

The resulting geometry.
If you encounter a TopologyException with the message “found non-noded intersection”, try enabling the OverlayNG algorithm by setting the following Spark configuration:
spark.driver.extraJavaOptions=-Djts.overlay=ng
spark.executor.extraJavaOptions=-Djts.overlay=ng
The OverlayNG algorithm is more robust than the legacy overlay implementation in JTS and handles many edge cases that would otherwise cause errors.

​
Example

SELECT ST_Intersection(
    ST_GeomFromWKT("POLYGON((1 1, 8 1, 8 8, 1 8, 1 1))"),
    ST_GeomFromWKT("POLYGON((2 2, 9 2, 9 9, 2 9, 2 2))")
    )

POLYGON ((2 8, 8 8, 8 2, 2 2, 2 8))