jaydelano
- 浏览: 3169 次
- 性别:
- 来自: 苏州
-
最新评论
文章列表
SELECT
address,X(address_loc),Y(address_loc),
(2 * 6378.137 * ASIN(SQRT(POW(SIN(PI() * (:lat - X(p.shop_point)) / 360),2) + COS(PI() * :lat / 180) * COS(X(p.shop_point) * PI() / 180) * POW(SIN(PI() * (:lng - Y(p.shop_point)) / 360),2)))) as distance
FROM
address
WHERE
MBRContains (
LineSt ...