laravel-geo
laravel-geo copied to clipboard
Is the distance query accurate?
Using ST_DISTANCE_SPHERE
SELECT
ST_DISTANCE_SPHERE(
POINT(-0.32170480372414134, 35.85398240387264),
POINT(-0.6368148560996869, 35.70035747269707)
)
-- 33164.40908920633
Using the package used formula
SELECT
(
6378137 * ACOS(
COS(RADIANS(-0.32170480372414134)) * COS(RADIANS(-0.6368148560996869)) * COS(
RADIANS(35.70035747269707) - RADIANS(35.8539824038726)
) + SIN(RADIANS(-0.32170480372414134)) * SIN(RADIANS(-0.6368148560996869))
)
)
-- 39024.309979598984