Determining Relationships Between geography Instances

The geography data type provides many built-in methods you can use to determine relationships between two geography instances.

To determine if two instances comprise the same point set

STEquals (geometry Data Type)

To determine if two instances are disjoint

STDisjoint (geometry Data Type)

To determine if two instances intersect

STIntersects (geometry Data Type)

To determine the point or points where two instances intersect

STIntersection (geography Data Type)

To determine the shortest distance between points in two geography instances

STDistance (geometry Data Type)

To determine the difference in points between two geography instances

STDifference (geography Data Type)

To derive the symmetric difference, or unique points, of one geography instance compared with another instance

STSymDifference (geography Data Type)