APPROX_GEOGRAPHY_INTERSECTS

Syntax

APPROX_GEOGRAPHY_INTERSECTS ( geo1, geo2 )

Important

If both geo1 and geo2 are points, this function only returns true if they are identical.

Boolean

SQL

SELECT COUNT(1)
    -> FROM jogging_paths j1, jogging_paths j2
    -> WHERE
    -> APPROX_GEOGRAPHY_INTERSECTS(j1.shape, j2.shape);

+----------+
| COUNT(1) |
+----------+
|    11569 |
+----------+

SQL

SELECT COUNT(1)
    -> FROM jogging_paths j1, jogging_paths j2
    -> WHERE
    -> GEOGRAPHY_INTERSECTS(j1.shape, j2.shape);

+----------+
| COUNT(1) |
+----------+
|     9134 |
+----------+

SQL

 SELECT *
 FROM neighborhoods WITH (index = shape, resolution = 16)
 WHERE APPROX_GEOGRAPHY_INTERSECTS(shape,"POLYGON(...)");

Important

The with (index = c, resolution = n) syntax is an optional optimization discussed in Special Spatial Tuning Parameters.

For more information about working with geospatial data, see Working with Geospatial Features.