ST_Intersects

Tests whether two geography objects intersect on the sphere using S2 spherical boolean operations. Returns true if A and B share any portion of space (including a single boundary point), and false if they are fully disjoint. Edges are interpreted as great-circle arcs, so the test is correct even when geographies cross the antimeridian or wrap around the poles — situations where a planar ST_Intersects would be wrong.

Signatures

ST_Intersects (A: Geography, B: Geography)

Parameters

Geography

required

The first geography.

Geography

required

The second geography.

Return type

true if A and B intersect.

Example

Overlapping polygons:

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

true

Disjoint polygons:

SELECT ST_Intersects(
  ST_GeogFromWKT('POLYGON ((0 0, 1 0, 1 1, 0 1, 0 0))', 4326),
  ST_GeogFromWKT('POLYGON ((10 10, 11 10, 11 11, 10 11, 10 10))', 4326)
);

false

ST_GeometryType

ST_Length

⌘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