For a project we have ongoing, I need to find the points that are in a certain distance of a particular coordinate (Circular buffer) and display the result as a list. The points are already geocoded and stored in a sql database. There is no map component involved. The user enters an address and the buffer distance, we geocode the address to find the center coordinates, and using the distance, we need to find the points from the sql dataset that lie inside the circular buffer.
What would be the best way to solve this?
a) I thought of using ESRI's geometry service, but we are not using any map component, and i'm not sure how I would do it otherwise.
b) Should I create a geoprocessing buffer task and host it on the server and go that route?
c) Or simply use a bounding circle sql query?
Thanks.