Skip to main content
The ST_INTERSECTS function determines whether two input GEOGRAPHY objects intersect each other. If either input is empty, ST_INTERSECTS will return FALSE. Before performing the intersection check, the two inputs are aligned through a snapping process, ensuring precise calculation. For more details on snapping, refer to the snapping documentation.

​
Syntax

ST_INTERSECTS(<geo1>, <geo2>)

​
Parameters

ParameterDescriptionSupported input types
<geo1>The first GEOGRAPHY object to check for intersection with the second object.GEOGRAPHY
<geo2>The second GEOGRAPHY object to check for intersection with the first object.GEOGRAPHY

​
Return Type

ST_INTERSECTS returns a value of type BOOLEAN.

​
Example

The following code example constructs two LineStrings near Times Square in New York City from their WKT representations as GEOGRAPHY objects and determines if the LineStrings intersect: 
SELECT ST_INTERSECTS(ST_GEOGFROMTEXT('LINESTRING(-73.98507474330196 40.75858394491826, -73.98601039902333 40.7573327842733)'), ST_GEOGFROMTEXT('LINESTRING(-73.98625022413634 40.758256445020976, -73.98473358363454 40.757637261118134)')) AS result;
result boolean
True

Rows: 1Execution time: 5.62ms