Create a grid of square cells and find the central lat/long of each RRS feed

  • Question

  • Hi,

    Currently using sql server 2012.

    I am looking to query a table of lat/longs to find the greatest number of points in a 200m radius. I believe that using the Geography capabilities in sql I can accomplish much of this. To be able to sample the table of points I wanted to create a grid (say of New York - 50m x 50m cells) and move a circle (200m radius) into the center of each square grid cell and then use the buffer function to find what was within the circle. However, I've been searching online and I haven't been able to find a way to create the gird and the central lat/longs.

    Many thanks.

    • Edited by jlahorn Friday, October 5, 2018 1:36 PM
    Friday, October 5, 2018 1:33 PM

All replies