Skip to content
πŸŽ‰ SedonaDB 0.4.0 is out now! πŸ—ΊοΈ Python DataFrame API, R dplyr, Geography support & GPU-accelerated spatial joins. Read the release blog β†’

ST_Intersects

Introduction: Return true if two geographies share any portion of space.

ST_Intersects on the sphere: two geographies intersect

Format:

ST_Intersects (geogA: Geography, geogB: Geography)

Return type: Boolean

Since: v1.9.1

Polygon ring roles follow the simple-features structure: the first ring is a shell and subsequent rings are holes, regardless of input winding. Sedona preserves the submitted coordinate order for structural output such as ST_AsText, while normalizing only the S2-facing traversal used by spherical operations.

Each Geography polygon shell is normalized to an area of at most one hemisphere. A shell intended to represent more than half the sphere is therefore interpreted as its complement; reversing the ring's coordinate sequence does not select the larger region.

SQL Example:

SELECT ST_Intersects(ST_GeogFromWKT('POLYGON ((0 0, 2 0, 2 2, 0 2, 0 0))', 4326), ST_GeogFromWKT('POINT (1 1)', 4326))

Output:

true