Intersects

The Intersects function determines if one geography intersects another geography. If the two geographies intersect, the function returns True. Otherwise, it returns False.

📘
This function isn't compatible with all data platform connections. To check if your connection supports it, see Supported data platforms and feature compatibility.

Intersects is a Geography function.

Syntax

Intersects(geography1, geography2)

The function arguments are:

geography1: Required; The first geography to check for intersection.
geography2: Required; The second geography to check for intersection.

Examples

Intersects(Geography("POLYGON((0 0, 2 0, 2 2, 0 2, 0 0))"), Geography("POLYGON((1 1, 3 1, 3 3, 1 3, 1 1))"))

The function returns True because the two polygons overlap.

Intersects([Brooklyn], [Queens])

If you define the Brooklyn and Queens boroughs as polygons (see Geography functions overview for coordinates), then the Intersects function returns True because they share a waterway; see the following illustration.