MBRINTERSECTS

最新推荐文章于 2024-03-15 10:00:24 发布

路口游子

最新推荐文章于 2024-03-15 10:00:24 发布

阅读量717

点赞数

CC 4.0 BY-SA版权

分类专栏： MySql

本博客仅供免费阅读，不提供咨询服务。请勿私信。

本文链接：https://blog.youkuaiyun.com/durongze/article/details/81123999

MySql 专栏收录该内容

4 篇文章

订阅专栏

'root@localhost:test>'select ogr_fid, astext(shape) from tuku where ogr_fid = 37341;
+---------+---------------------------------------------------------------------------------+
| ogr_fid | astext(shape) |
+---------+---------------------------------------------------------------------------------+
| 37341 | LINESTRING(60390.3439770672 -25918.3409153351,60390.3439770672 -25919.77362169) |
+---------+---------------------------------------------------------------------------------+
1 row in set, 1 warning (0.00 sec)

'root@localhost:test>'select shape into @lineOne from tuku where ogr_fid = 37341;
Query OK, 1 row affected (0.00 sec)

'root@localhost:test>'select ogr_fid,astext(shape) from tuku where MBRINTERSECTS(shape,@lineOne) and ogr_fid != 37341;
+---------+-----------------------------------------------------------------------------------+
| ogr_fid | astext(shape)                                                                     |
+---------+-----------------------------------------------------------------------------------+
|   37342 | LINESTRING(60390.3439770672 -25919.77362169,60388.9097064654 -25919.77362169)     |
|   37340 | LINESTRING(60391.7782476689 -25918.3409153351,60390.3439770672 -25918.3409153351) |
+---------+-----------------------------------------------------------------------------------+
2 rows in set, 1 warning (0.00 sec)

'root@localhost:test>'