ST_EnvelopesIntersect
Signatures
BOOLEAN ST_EnvelopesIntersect(GEOMETRY geomA, GEOMETRY geomB);
Description
Returns TRUE if the envelope of geomA intersects the envelope of geomA.
As a consequence, if ST_Intersects(geomA, geomB) is true, then
ST_EnvelopesIntersect(geomA, geomB) is true.
Examples
Cases where ST_EnvelopesIntersect is true
SELECT ST_EnvelopesIntersect(geomA, geomB) FROM input_table;
-- Answer: TRUE
geomA POLYGON |
geomB POLYGON |
|---|---|
POLYGON((3 1, 3 4, 5 7, 1 5, 3 1)) |
POLYGON((7 2, 7 6, 4 4, 7 2)) |
geomA LINESTRING |
geomB LINESTRING |
|---|---|
LINESTRING(2 2, 6 3, 3 6) |
LINESTRING(1 4, 2 5, 4 3) |
geomA MULTIPOINT |
geomB MULTIPOINT |
|---|---|
MULTIPOINT((1 4), (3 5), (5 2)) |
MULTIPOINT((3 3), (4 4), (6 6)) |
geomA POLYGON |
geomB GEOMETRYCOLLECTION |
|---|---|
POLYGON((4 2, 5 2, 5 4, 4 5, 3 4, 4 3, 4 2)) |
GEOMETRYCOLLECTION(POINT(2 3), LINESTRING(6 4, 4 6), POLYGON((2 5, 3 5, 3 6, 2 6, 2 5))) |
Cases where ST_EnvelopesIntersect is false
SELECT ST_EnvelopesIntersect(geomA, geomB) FROM input_table;
-- Answer: FALSE
geomA POLYGON |
geomB POLYGON |
|---|---|
POLYGON((3 1, 3 4, 5 7, 1 5, 3 1)) |
POLYGON((8 2, 8 6, 6 5, 8 2)) |
