Distance Calculation (long, lat)


#1

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?


#2

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(…),…)

https://postgis.net/docs/manual-1.4/ST_Distance_Sphere.html