我有以下问题:
SELECT
ST_Overlaps(a,b) AS a_overlap_b
FROM
(SELECT ST_GeomFromText
('LINESTRING(-118.291686 34.018886,-118.292677 34.022562,-118.291231 34.025650,-118.2906224 34.0244091,-118.286493 34.020362)')
AS a,
ST_GeomFromText
('LINESTRING(-118.282340 34.018824,-118.289132 34.020923,-118.287198 34.023338,-118.282791 34.021858,-118.280270 34.022503)')
AS b)
AS Foo)当我使用ST_Overlaps运行这个查询时,它给出了false,而ST_Intersects给出了true。但是当我构建KML文件并在google中可视化它时,我也会看到这两个多边形重叠。有人能告诉我原因吗?
发布于 2016-10-31 18:35:46
将几何学更改为多边形,而不是一行字符串。
https://stackoverflow.com/questions/40346523
复制相似问题