Breaking News: Grepper is joining You.com. Read the official announcement!

distance calculator from lat long sql query

Add Answer

Lokesh003 answered on November 18, 2020 Popularity 9/10 Helpfulness 2/10

answer distance calculator from lat long sql query

related calculate distance between two latitude longitude points sql

distance calculator from lat long sql query

Comment

-1

COALESCE(
  	( 
      6371 * acos( cos( radians({$latitude}) ) * cos( radians( `latitude` ) ) * cos( radians( `longitude` ) - radians({$longitude}) ) + sin( radians({$latitude}) ) * sin( radians( `latitude` ) ) ) 
    )
  , 0) AS distance

Popularity 9/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: calculator distance sql

Link to this answer
Share Copy Link

Contributed on Nov 18 2020

Lokesh003

0 Answers Avg Quality 2/10

Closely Related Answers

calculate distance between two latitude longitude points sql

Comment

CREATE OR REPLACE FUNCTION calculate_distance(lat1 float, lon1 float, lat2 float, lon2 float, units varchar)
            RETURNS float AS $dist$
                DECLARE
                    dist float = 0;
                    radlat1 float;
                    radlat2 float;
                    theta float;
                    radtheta float;
                BEGIN
                    IF lat1 = lat2 OR lon1 = lon2
                        THEN RETURN dist;
                    ELSE
                        radlat1 = pi() * lat1 / 180;
                        radlat2 = pi() * lat2 / 180;
                        theta = lon1 - lon2;
                        radtheta = pi() * theta / 180;
                        dist = sin(radlat1) * sin(radlat2) + cos(radlat1) * cos(radlat2) * cos(radtheta);
                        IF dist > 1 THEN dist = 1; END IF;
                        dist = acos(dist);
                        dist = dist * 180 / pi();
                        dist = dist * 60 * 1.1515;
                        IF units = 'K' THEN dist = dist * 1.609344; END IF;
                        IF units = 'N' THEN dist = dist * 0.8684; END IF;
                        RETURN dist;
                    END IF;
                END;
            $dist$ LANGUAGE plpgsql;


//Usage:
SELECT calculate_distance(41.311081, 69.240562, 39.7681, 64.4556, 'M');
SELECT calculate_distance(41.311081, 69.240562, 39.7681, 64.4556, 'K');
SELECT calculate_distance(41.311081, 69.240562, 39.7681, 64.4556, 'N');

Popularity 9/10 Helpfulness 5/10 Language sql

Source: Grepper

Tags: between

Link to this answer
Share Copy Link

Contributed on Mar 08 2022

Mirik

0 Answers Avg Quality 2/10

distance calculator from lat long sql query

Contents

More Related Answers

distance calculator from lat long sql query

Closely Related Answers

calculate distance between two latitude longitude points sql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.