Tag: SQL Azure

How to find users near a central coordinate (spatial nearest neighbor queries)

Scenario You have a database table of users who have a location specified. Given an input location point, coordinate, or city - find the top N (or all) of the nearest neighbors in range. So for example, if I am in Seattle, return 15 nearest users to my location within a 50 mile range. This is a classic … Continue reading How to find users near a central coordinate (spatial nearest neighbor queries)