거리계산

MS-SQL

날아올라↗↗ 2015. 12. 20. 13:42

728x90

/*
** 거리계산
*/
declare @x float --현재위치 위도
declare @y float --현재위치 경도
declare @dx float --위치 위도
declare @dy float --위치 경도
SET @x = 37.486273
SET @y = 126.995882
SET @dx = 35.177286
SET @dy = 126.900247
SELECT (6371 * ACOS(COS(RADIANS(@x)) * COS(RADIANS(@dx))
*COS(RADIANS(@dy) - RADIANS(@dy)) + SIN(RADIANS(@x)) * SIN(RADIANS(@dx)))) AS distance;
-- select (6371 * acos( cos( radians(nowLat) ) * cos( radians( setLat ) ) * cos( radians( setLng ) - radians(nowLng) ) + sin( radians(nowLat) ) * sin( radians( setLat ) ) ) ) as distance;
SELECT ROUND(6371 * acos( cos( radians(37.486273) ) * cos( radians( 35.177286 ) ) * cos( radians( 126.900247 ) - radians(126.900247) ) + sin( radians(37.486273) ) * sin( radians( 35.177286 ) ) ), 2) AS distance;

약간의 오편차가 발생한다..

728x90