spacespaceite/mysql是否支持3D点? [英] Does spatialite/mysql support 3D point?

问题描述

最近，我正在研究spacespaceite.我可以将2D数据(例如:POINT(1 1 1))写入空间数据表，但是不能写3D数据(例如:POINT(1 1 1)).进入空间数据表.谁能告诉我spacespaceite是否支持3D?如果有支持，我该如何写3D数据?

Recently, I was studying spatialite.I can write 2D data(like this:POINT(1 1)) into the spatial data table,but I can't write 3D data(like this:POINT(1 1 1) ) into the spatial data table. Who can tell me spatialite whether support 3D? If support ,how can I write a 3D data?

推荐答案

要添加三个3维的点，必须使用正确的WKT表达式: POINTZ(x，y，z).

To add points with three 3 dimensions you have to use the correct WKT expression: POINTZ(x,y,z).

(另请参见: https://www.gaia-gis.it/gaia-sins/spatialite-cookbook/html/wkt-wkb.html )

还必须确保将几何列正确定义为XYZ列.(请参见函数: Dimension CoordDimension Is3D ).因此， GeometryType 应该返回 POINTZ

You also have to make sure, that you geometry column is correctly defined as XYZ column. (see functions: Dimension CoordDimension Is3D). GeometryType should therefore return POINTZ

(另请参见: http://www.gaia-gis.it/gaia-sins/spatialite-sql-4.2.0.html )

这篇关于spacespaceite/mysql是否支持3D点?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！