ST_Intersection

Introduction: Return the intersection geometry of A and B

Format: ST_Intersection (A: Geometry, B: Geometry)

Since: v1.0.0

Note

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.

SQL 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))")
    )

Output:

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