ST_Intersection

Return the intersection geometry of A and B

Signatures

ST_Intersection (A: Geometry, B: Geometry)

Parameters

Geometry

required

The input geometry.

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

ST_ExtentBasedSubDivideExplode

ST_Split

⌘I

Wherobots Cloud REST API

WherobotsDB

Vector tiles (PMTiles)

Havasu (Iceberg) table management

GeoStats and Map Matching

Rasterflow

Signatures

Parameters

Return type

Example

​Signatures

​Parameters

​Return type

​Example

Signatures

Parameters

Return type

Example