示例 TRIANGLEFAN(0 0 1 1,0 10 2 2,10 10 3 3,10 0 4 4)同样支持Z和M值 TRIANGLEFAN Z(0 0 1,0 10 2,10 10 3,10 0 4)TRIANGLEFAN M(0 0 1,0 10 2,10 10 3,10 0 4)TRIANGLEFAN ZM(0 0 1 1,0 10 2 2,10 10 3 3,10 0 4 4)
示例 TRIANGLESTRIP(0 0 1 1,0 10 2 2,10 10 3 3,10 0 4 4)同样支持Z和M值 TRIANGLESTRIP Z(0 0 1,0 10 2,10 10 3,10 0 4)TRIANGLESTRIP M(0 0 1,0 10 2,10 10 3,10 0 4)TRIANGLESTRIP ZM(0 0 1 1,0 10 2 2,10 10 3 3,10 0 4 4)
示例 TRIANGLEFAN(0 0 1 1,0 10 2 2,10 10 3 3,10 0 4 4)同样支持Z和M值 TRIANGLEFAN Z(0 0 1,0 10 2,10 10 3,10 0 4)TRIANGLEFAN M(0 0 1,0 10 2,10 10 3,10 0 4)TRIANGLEFAN ZM(0 0 1 1,0 10 2 2,10 10 3 3,10 0 4 4)
示例 TRIANGLESTRIP(0 0 1 1,0 10 2 2,10 10 3 3,10 0 4 4)同样支持Z和M值 TRIANGLESTRIP Z(0 0 1,0 10 2,10 10 3,10 0 4)TRIANGLESTRIP M(0 0 1,0 10 2,10 10 3,10 0 4)TRIANGLESTRIP ZM(0 0 1 1,0 10 2 2,10 10 3 3,10 0 4 4)
计算三维闭合模型的体积。语法 float8 ST_Volume(meshgeom geom);...示例 select ST_Volume('MESHGEOM(PATCH(TRIANGLESTRIP Z(0 0 0,0 10 0,0 0 10,10 0 0,0 0 0),TRIANGLE Z(0 0 0,0 10 0,10 0 0)))':mesh);166.666666666667
计算三维闭合模型的体积。语法 float8 ST_Volume(meshgeom geom);...示例 select ST_Volume('MESHGEOM(PATCH(TRIANGLESTRIP Z(0 0 0,0 10 0,0 0 10,10 0 0,0 0 0),TRIANGLE Z(0 0 0,0 10 0,10 0 0)))':mesh);166.666666666667
计算三维模型的表面积。语法 float8 ST_3DArea(meshgeom geom);float8 ST_3DArea(sfmesh ...示例 SELECT ST_3DArea('MESHGEOM(PATCH(INDEXSURFACE Z(VERTEX(0 0 0,0 10 0,0 0 10,10 0 0),INDEX((0,1,2),(1,0,3)))))':meshgeom);100
计算三维模型的表面积。语法 float8 ST_3DArea(meshgeom geom);float8 ST_3DArea(sfmesh ...示例 SELECT ST_3DArea('MESHGEOM(PATCH(INDEXSURFACE Z(VERTEX(0 0 0,0 10 0,0 0 10,10 0 0),INDEX((0,1,2),(1,0,3)))))':meshgeom);100
MESHGEOM(PATCH(INDEXSURFACE M(VERTEX(0 0 1,0 10 2,10 10 3,10 0 4),INDEX((0,1,2),(1,2,3)))))SRID=4326;SOLID=true;MESHGEOM(PATCH(INDEXSURFACE M(VERTEX(0 0 1,0 10 2,10 10 3,10 0 4),INDEX((0,1,2),(1,2,3)))))
MESHGEOM(PATCH(INDEXSURFACE M(VERTEX(0 0 1,0 10 2,10 10 3,10 0 4),INDEX((0,1,2),(1,2,3)))))SRID=4326;SOLID=true;MESHGEOM(PATCH(INDEXSURFACE M(VERTEX(0 0 1,0 10 2,10 10 3,10 0 4),INDEX((0,1,2),(1,2,3)))))
计算两个模型之间的三维距离。语法 float8 ST_3DDistance...1 select ST_3DDistanc('MESHGEOM(PATCH(INDEXSURFACE Z(VERTEX(0 0 0,0 10 0,0 0 10,10 0 0),INDEX((0,1,2),(1,0,3),(3,0,2),(2,1,3)))))':meshgeom,'POINT(-1 0 0)':geometry);1
计算两个模型之间的三维距离。语法 float8 ST_3DDistance...1 select ST_3DDistanc('MESHGEOM(PATCH(INDEXSURFACE Z(VERTEX(0 0 0,0 10 0,0 0 10,10 0 0),INDEX((0,1,2),(1,0,3),(3,0,2),(2,1,3)))))':meshgeom,'POINT(-1 0 0)':geometry);1
示例 SELECT ST_AsEWKT(ST_MeshFromWKT('{"version":1,"root":0,"meshgeoms":["MESHGEOM(PATCH(TRIANGLESTRIP(0 0,0 10,10 10,10 0)))"],"primitives":[{"meshgeom":0}],"nodes":[{"primitive":0}]}',4490));{"version":1,"srid":4490,...
示例 SELECT ST_AsEWKT(ST_MeshFromWKT('{"version":1,"root":0,"meshgeoms":["MESHGEOM(PATCH(TRIANGLESTRIP(0 0,0 10,10 10,10 0)))"],"primitives":[{"meshgeom":0}],"nodes":[{"primitive":0}]}',4490));{"version":1,"srid":4490,...
示例 select ST_AsEWKT(ST_MeshGeomFromText('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))',4326));SRID=4326;MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX(...
示例 select ST_AsEWKT(ST_MeshGeomFromText('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))',4326));SRID=4326;MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX(...
示例 select ST_AsEWKT(ST_MeshGeomFromWKT('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))',4326));SRID=4326;MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0...
示例 select ST_AsEWKT(ST_MeshGeomFromWKT('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))',4326));SRID=4326;MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0...
{"version":1,"root":0,"meshgeoms":["MESHGEOM(PATCH(INDEXSURFACE Z(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))"],"primitives":[{"meshgeom":0}],"nodes":[{"primitive":0}]} select ST_AsWKT(ST_MeshGeomFromText...
{"version":1,"root":0,"meshgeoms":["MESHGEOM(PATCH(INDEXSURFACE Z(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))"],"primitives":[{"meshgeom":0}],"nodes":[{"primitive":0}]} select ST_AsWKT(ST_MeshGeomFromText...
{"version":1,"root":0,"meshgeoms":["MESHGEOM(PATCH(INDEXSURFACE Z(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))"],"primitives":[{"meshgeom":0}],"nodes":[{"primitive":0}]} select ST_AsEWKT(ST_...
示例 SELECT ST_3DContains('MESH(INDEXSURFACE Z(VERTEX(0 0 0,0 10 0,0 0 10,10 0 0),INDEX((0,1,2),(1,0,3),(3,0,2),(2,1,3))))':meshgeom,'MESH(TRIANGLESTRIP Z(0.1 0.1 0.1,0.1 1 0.1,0.1 0.1 1,0.1 1 1))':meshgeom);t
{"version":1,"root":0,"meshgeoms":["MESHGEOM(PATCH(INDEXSURFACE Z(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))"],"primitives":[{"meshgeom":0}],"nodes":[{"primitive":0}]} select ST_AsEWKT(ST_...
示例 示例一:select ST_NumGeometries('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))':meshgeom);1 示例二:select ST_NumGeometries('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,...
示例 示例一:select ST_NumGeometries('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))':meshgeom);1 示例二:select ST_NumGeometries('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,...
示例 SELECT ST_Angle(ST_MakeTrajectory('STPOINT':leaftype,'LINESTRING(0 0,0 10,10 10,20 10,30 0,30 0,20 10,0 10,0 0)','2000-01-01','2000-01-01':timestamp+'1 day':interval*(ST_NPoints('LINESTRING(0 0,0 10,10 10,20 10,30 0,...
示例 select ST_AsEWKT(ST_MeshGeomFromEWKB(ST_AsEWKB('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))':meshgeom)));MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),...
示例 select ST_AsEWKT(ST_MeshGeomFromEWKB(ST_AsEWKB('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))':meshgeom)));MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),...
从EWKT构造meshgeom对象。语法 meshgeom ST_MeshGeomFromEWKT(text ewkt);参数 参数名称 描述 ewkt 基于EWKT描述的meshgeom对象。...MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0),INDEX((0,1,2),(1,2,3)))))
从EWKT构造meshgeom对象。语法 meshgeom ST_MeshGeomFromEWKT(text ewkt);参数 参数名称 描述 ewkt 基于EWKT描述的meshgeom对象。...MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0),INDEX((0,1,2),(1,2,3)))))
示例 select ST_AsWKT(ST_AsGeometry(ST_MeshFromText('{"version":1,"root":0,"meshgeoms":["MESHGEOM(PATCH(INDEXSURFACE Z(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))"],"primitives":[{"meshgeom":0}],"nodes":[{...
示例 select ST_AsWKT(ST_AsGeometry(ST_MeshFromText('{"version":1,"root":0,"meshgeoms":["MESHGEOM(PATCH(INDEXSURFACE Z(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))"],"primitives":[{"meshgeom":0}],"nodes":[{...
示例 select ST_AsEWKT(ST_MeshGeomFromHexEWKB(ST_AsHexEWKB('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))':meshgeom)));st_asewkt-MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10...
示例 select ST_AsEWKT(ST_MeshGeomFromHexEWKB(ST_AsHexEWKB('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))':meshgeom)));st_asewkt-MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10...
示例 SELECT ST_AsEWKT(ST_MeshFromEWKT('{"version":1,"srid":4490,"root":0,"meshgeoms":["MESHGEOM(PATCH(TRIANGLESTRIP(0 0,0 10,10 10,10 0)))"],"primitives":[{"meshgeom":0}],"nodes":[{"primitive":0}]}'));{"version":1,"srid":...
示例 SELECT ST_AsText(ST_FlipCoOrdinates(ST_MeshFromText('{"version":1,"root":0,"meshgeoms":["MESHGEOM(PATCH(INDEXSURFACE Z(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))"],"primitives":[{"meshgeom":0}],...
示例 SELECT ST_AsEWKT(ST_MeshFromEWKT('{"version":1,"srid":4490,"root":0,"meshgeoms":["MESHGEOM(PATCH(TRIANGLESTRIP(0 0,0 10,10 10,10 0)))"],"primitives":[{"meshgeom":0}],"nodes":[{"primitive":0}]}'));{"version":1,"srid":...
示例 SELECT ST_AsText(ST_FlipCoOrdinates(ST_MeshFromText('{"version":1,"root":0,"meshgeoms":["MESHGEOM(PATCH(INDEXSURFACE Z(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))"],"primitives":[{"meshgeom":0}],...
示例 select ST_AsEWKT(ST_MeshGeomFromBinary(ST_AsBinary('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))':meshgeom)));MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1...
示例 select ST_AsEWKT(ST_MeshGeomFromBinary(ST_AsBinary('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))':meshgeom)));MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1...