Edwin Sanchez takes a look at SQL Server’s GEOGRAPHY data type:
A common application in geography spatial data is called the nearest neighbor query. In this query, you want to know how far or close something is to another object or place.
In my post about the SQL graph, I described how a customer could find the nearby restaurants from the current location. Let’s refer to that example again:
Read on for a primer on the data type and some useful examples.