Intersects Operator - Latest

Intersects is a boolean spatial operator that returns true if the two objects intersect at some point, or if part of the first object is within the second object, or if the first object contains part of the second object.

SELECT city FROM table WHERE obj Intersects <geometry>

If the data source provider supports Intersects, the entire query is delegated to the data source provider.

If the data source provider does not support Intersects, it is rephrased as an EnvelopesIntersect which will return more records than an Intersects operation but a lot fewer if the entire table was returned.

SELECT city, obj FROM table WHERE obj EnvelopesIntersect <geometry>

Spectrum Spatial executes the entire query, using the results from the data source provider:

SELECT city FROM <results from the delegation> WHERE obj Intersects <geometry>

SELECT city FROM table WHERE <geometry> Intersects obj

This example is the opposite of the first example. As written, this query does not meet the rules of the WHERE clause, where boolean operators must be in the form WHERE <column> operator <geometry>. The query is rephrased with the operands reversed and delegated to the data source provider. This does not affect the results since the inverse of Intersects is Intersects.

SELECT city FROM table WHERE obj Intersects <geometry>