All shapes with X miles or meters using SqlGeometery

Question

My table uses a SqlGeometery in SRID 3857.

Given a point, how would I find all shapes within a X miles or meters radius?

Answer 1

Put a Buffer around the point and run STIntersects to get all intersection shapes. Just make sure you put an index on the Geometry column otherwise it could get slow. Note that x is in meters (eg 10m).

SELECT *
FROM MyTable
WHERE MyGeometryShapesColumn.STIntersects(@MyGeometryPoint.STBuffer(10)) = 1;