mysql计算两GPS坐标的距离函数

	drop function getDistance;

	DELIMITER $$  

	CREATE DEFINER=`root`@`localhost` FUNCTION `getDistance`(

	     lon1 float(10,7) 

	    ,lat1 float(10,7)

	    ,lon2 float(10,7) 

	    ,lat2 float(10,7)

	) RETURNS double

	begin

	    declare d double;

	    declare radius int;

	    set radius = 6378140; #假设地球为正球形，直径为6378140米

	    set d = (2*ATAN2(SQRT(SIN((lat1-lat2)*PI()/180/2)   

	        *SIN((lat1-lat2)*PI()/180/2)+   

	        COS(lat2*PI()/180)*COS(lat1*PI()/180)   

	        *SIN((lon1-lon2)*PI()/180/2)   

	        *SIN((lon1-lon2)*PI()/180/2)),   

	        SQRT(1-SIN((lat1-lat2)*PI()/180/2)   

	        *SIN((lat1-lat2)*PI()/180/2)   

	        +COS(lat2*PI()/180)*COS(lat1*PI()/180)   

	        *SIN((lon1-lon2)*PI()/180/2)   

	        *SIN((lon1-lon2)*PI()/180/2))))*radius;

	    return d;

end

$$

	DELIMITER ; 

select getDistance(116.3899,39.91578,116.3904,39.91576); #调用函数

		Mysql计算两GPS坐标的距离SQL语句：
		#lat为纬度, lng为经度, 一定不要弄错

		declare @lon1 float;

		declare @lat1 float;

		declare @lon2 float;

		declare @lat2 float;

		set @lon1=116.3899;

		set @lat1=39.91578;

		set @lon2=116.3904;

		set @lat2=39.91576;  

		select (2*ATAN2(SQRT(SIN((@lat1-@lat2)*PI()/180/2)   

		        *SIN((@lat1-@lat2)*PI()/180/2)+   

		        COS(@lat2*PI()/180)*COS(@lat1*PI()/180)   

		        *SIN((@lon1-@lon2)*PI()/180/2)   

		        *SIN((@lon1-@lon2)*PI()/180/2)),   

		        SQRT(1-SIN((@lat1-@lat2)*PI()/180/2)   

		        *SIN((@lat1-@lat2)*PI()/180/2)   

		        +COS(@lat2*PI()/180)*COS(@lat1*PI()/180)   

		        *SIN((@lon1-@lon2)*PI()/180/2)   

		        *SIN((@lon1-@lon2)*PI()/180/2))))*6378140;

mysql计算两GPS坐标的距离函数

Mysql计算两GPS坐标的距离SQL语句：

相关文章

栏目导航

最新文章

点击排行

推荐文章

打赏