Export (0) Print
Expand All

Geography Methods Supported by Spatial Indexes

Under certain conditions, spatial indexes support the following set-oriented geography methods: STIntersects(), STEquals(), and STDistance(). To be supported by a spatial index, these methods must be used within the WHERE clause of a query, and they must occur within a predicate of the following general form:

geography1.method_name(geography2) comparison_operator valid_number

To return a non-null result, geography1 and geography2 must have the same Spatial Reference Identifier (SRID). Otherwise, the method returns NULL.

Spatial indexes support the following predicate forms:

  • geography1.STIntersects(geography2) = 1

  • geography1.STEquals(geography2) = 1

  • geography1.STDistance(geography2) < number

  • geography1.STDistance(geography2) <= number

    Important noteImportant

    In either form of STDistance() predicate, at least one of geography arguments (geography1 or geography2) must specify a geography instance that represents a point. Otherwise, the method returns NULL.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft