find location details within circle buffer
Hi
I am using mysql 5.6
I need to display location details within circle buffer.
ie when i enter buffer (in meters) in the text box it is drawing the circle on the map and the same time it has to display the details (from database) of the points within the circle drawn
My database is having
Columns- latitude,longitude, poi_name, poi_address
Please tell me the spatial query to get the details of the points with in the buffer
I am using the below query, but i m not getting the details
SELECT `Name` FROM bhopalpoint WHERE (ST_Buffer( ST_GeomFromText('POINT(8616177.3994376 2660144.4384414)',3857), (50000)) )
Subject
Written By
Posted
find location details within circle buffer
March 03, 2017 12:07AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.