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