Add range with coordinates in MySQL query

Question

I want to enter a range of 100 meters radius. The following query works, but I want to add a radius to the point.

select *
from rivers
where contains(shape, point(11.698366, 42.235607))

I have the points of a river and I want that although I am beside the river I find that I'm on the river

Is this possible, and if so, how would I accomplish this?

i believe you can use the Haversine formula so you can find rivers within a radius of 100 meters from your longitude and latitude.. — Raymond Nijland, Nov 08 '17 at 17:13
are you asking how calculate distance? https://stackoverflow.com/questions/1006654/fastest-way-to-find-distance-between-two-lat-long-points — Juan Carlos Oropeza, Nov 08 '17 at 17:14
check @JuanCarlosOropeza 's link that is indeed the Haversine formula — Raymond Nijland, Nov 08 '17 at 17:16

score 0 · Answer 1 · answered Nov 08 '17 at 18:05

0

You could apply a buffer to your point, and check if the two geometries intersect:

select *
from rivers
where MBRIntersects(shape, st_buffer(point(11.698366, 42.235607), 100))

answered Nov 08 '17 at 18:05

Sentinel

#1305 - FUNCTION table.st_buffer does not exist – Massimiliano Allegretti Nov 13 '17 at 10:22
I have seen that it needs at least version 5.6 of MySQLto use st_buffer. I have 5.5 of My sql, I need to update. https://mariadb.com/kb/en/library/mysqlmariadb-spatial-support-matrix/ – Massimiliano Allegretti Nov 13 '17 at 11:46

1 Answers1