Search database by longitude and latitude
776778Aug 20 2010 — edited Aug 23 2010We have a table that has lat-long data for each row.
We need to write a query that performs a search to find all pit location within the provided radius e.g. 1 mile, 5 miles etc.
We have the following query for this purpose:
***Parameters***
Longitude: -74.008680
Latitude: 40.711676
Radius: 1 mile
can someone help me how to do this, wrte a query to do search