Hello, Im trying to calculate distance between two different locations. I’ve tried using something like this ST_Distance_Sphere(point(s.point_x,s.point_y), point(121.1005,14.5973)), but this function does not work. are there any functions which I can use for distance calculation for two locations?
This site is in read only mode. Please continue to browse, but replying, likes,
and other actions are disabled for now.
Hello, it depends on the database you are using, note redash I think.
I suppose you are using PostGIS so this should work :
SELECT ST_Distance_Sphere(st_setsrid(st_makepoint(s.point_x,s.point_y),4326), st_setsrid(st_makepoint(121.1005,14.5973),4326))
Yous should also use ST_GeomFromText instead of st_setsrid(st_makepoint(…),…)