MySQL Forums
Forum List  »  Newbie

find location details within circle buffer
Posted by: rishe rishe
Date: March 03, 2017 12:07AM

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)) )

Options: ReplyQuote


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.