MySQL Forums
Forum List  »  GIS

Re: Points within km range
Posted by: Thomas Schlage
Date: March 19, 2015 04:26AM

The solution here is the function ST_Distance_Sphere which came with the MySql release 5.7.6 this month.

SELECT * FROM image WHERE ST_Distance(GeomFromText('POINT(13.430692 52.518139)', 4326), location) <= 5000

Get all images from Point within 5km range.

Options: ReplyQuote


Subject
Views
Written By
Posted
3585
March 11, 2015 07:57AM
1611
March 18, 2015 05:55AM
Re: Points within km range
1664
March 19, 2015 04:26AM


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.