MySQL Great Circle交叉路口(两条道路交叉吗?) [英] MySQL Great Circle intersection (do two roads cross?)

问题描述

MySQL OpenGIS CROSSES似乎不适用于我:

MySQL OpenGIS CROSSES doesn't seem to work for me:

SET @ls = 'LineString(1 1, 2 2, 3 3)';
SET @xx = 'LineString(0 2, 10 2)';

# SELECT AsText(EndPoint(GeomFromText(@ls)));
select crosses(GeomFromText(@ls), GeomFromText(@xx))

返回0-预期为1

我如何将其重写为MySQL函数?

How would I rewrite this as a MySQL function?

使用纬度，经度和球面投影(可能还有大圆)的奖励点

Bonus points for using lat, lon and spherical projection (and maybe the Great Circle.)

PS我无法创建标签，但我已经失去了旧的登录信息:有用的标签为:MySQL OpenGIS CROSSES greatcircle lat lon-:)

PS I can't create tags and I have lost my old login: Useful tags would be: MySQL OpenGIS CROSSES greatcircle lat lon - :)

推荐答案

好，最后我只是实现了这一点:

OK, in the end I just implemented this: http://local.wasp.uwa.edu.au/~pbourke/geometry/lineline2d/

这篇关于MySQL Great Circle交叉路口(两条道路交叉吗?)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！