This topic describes the ST_MeshFromEWKT function.This function ...{"version":1,"srid":4490,"root":0,"meshgeoms":["MESHGEOM(PATCH(TRIANGLESTRIP(0 0,0 10,10 10,10 0)))"],"primitives":[{"meshgeom":0}],"nodes":[{"primitive":0}]}
This topic describes the ST_MeshFromEWKT function.This function ...{"version":1,"srid":4490,"root":0,"meshgeoms":["MESHGEOM(PATCH(TRIANGLESTRIP(0 0,0 10,10 10,10 0)))"],"primitives":[{"meshgeom":0}],"nodes":[{"primitive":0}]}
2 patches，1 is point and 2 is indexsurface MESHGEOM(PATCH(POINT(0 0 1),INDEXSURFACE(VERTEX(0 0 1,0 10 2,10 10 3,10 0 4),INDEX((0,1,2),(1,2,3)))))-With Norma and texcoord MESHGEOM(PATCH(TRIANGLESTRIP(0 0 1,0 10 2,10 10 3,...
2 patches，1 is point and 2 is indexsurface MESHGEOM(PATCH(POINT(0 0 1),INDEXSURFACE(VERTEX(0 0 1,0 10 2,10 10 3,10 0 4),INDEX((0,1,2),(1,2,3)))))-With Norma and texcoord MESHGEOM(PATCH(TRIANGLESTRIP(0 0 1,0 10 2,10 10 3,...
从meshgeom构造sfmesh对象。...{"version":1,"root":0,"meshgeoms":["MESHGEOM(PATCH(INDEXSURFACE(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}]}
从meshgeom构造sfmesh对象。...{"version":1,"root":0,"meshgeoms":["MESHGEOM(PATCH(INDEXSURFACE(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}]}
This topic describes the ST_MeshGeomFromBinary function.This function constructs a meshgeom object from the well-known binary(WKB)...MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))
This topic describes the ST_MeshGeomFromBinary function.This function constructs a meshgeom object from the well-known binary(WKB)...MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))
TRIANGLESTRIP(0 0 1 1,0 10 2 2,10 10 3 3,10 0 4 4)The TriangleStrip geometric structure also supports Z and M dimensional information.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(0 0 1 1,0 10 2 2,10 10 3 3,10 0 4 4)The TriangleStrip geometric structure also supports Z and M dimensional information.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)...
This topic describes the ST_GeometryN function.This function returns the Nth geometry of an input geometry.Syntax meshgeom ST_...MESHGEOM(PATCH(INDEXSURFACE Z(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))
This topic describes the ST_MeshGeomFromWKB function.This function constructs a meshgeom object from the well-known binary...st_asewkt-MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),1,2,3)))))
This topic describes the ST_GeometryN function.This function returns the Nth geometry of an input geometry.Syntax meshgeom ST_...MESHGEOM(PATCH(INDEXSURFACE Z(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))
This topic describes the ST_MeshGeomFromWKB function.This function constructs a meshgeom object from the well-known binary...st_asewkt-MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),1,2,3)))))
This topic describes the ST_MeshFromText function.This function ...{"version":1,"srid":4490,"root":0,"meshgeoms":["MESHGEOM(PATCH(TRIANGLESTRIP(0 0,0 10,10 10,10 0)))"],"primitives":[{"meshgeom":0}],"nodes":[{"primitive":0}]}
This topic describes the ST_MeshFromText function.This function ...{"version":1,"srid":4490,"root":0,"meshgeoms":["MESHGEOM(PATCH(TRIANGLESTRIP(0 0,0 10,10 10,10 0)))"],"primitives":[{"meshgeom":0}],"nodes":[{"primitive":0}]}
more meshgeom vertices are generated.Effect diagram The following figure shows that a 2D polygon with holes is lofted along a 3D path with the chamfer parameter set to 4.Examples SELECT ST_AsText(ST_Loft('POLYGON((0...,10 0 0...
more meshgeom vertices are generated.Effect diagram The following figure shows that a 2D polygon with holes is lofted along a 3D path with the chamfer parameter set to 4.Examples SELECT ST_AsText(ST_Loft('POLYGON((0...,10 0 0...
从HexEWKB构造sfmesh对象。...st_asewkt-{"version":1,"root":0,"meshgeoms":["MESHGEOM(PATCH(INDEXSURFACE(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}]}
从HexEWKB构造sfmesh对象。...st_asewkt-{"version":1,"root":0,"meshgeoms":["MESHGEOM(PATCH(INDEXSURFACE(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_AsText(ST_SwapOrdinates(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_AsText(ST_SwapOrdinates(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_3DIntersects('MESHGEOM(PATCH(TRIANGLESTRIP Z(0 0 0,0 10 0,0 0 10,0 10 10),POINT Z(0 0 0)))':meshgeom,'MESHGEOM(PATCH(LINESTRING(-1 0 0,-1-0.5 0)))':meshgeom);f
This topic describes the ST...NULL is returned.Examples select ST_3DIntersects('MESHGEOM(PATCH(TRIANGLESTRIP Z(0 0 0,0 10 0,0 0 10,0 10 10),POINT Z(0 0 0)))':meshgeom,'MESHGEOM(PATCH(LINESTRING(-1 0 0,-1-0.5 0)))':meshgeom);f
计算轨迹每个中间点的转向角，返回一个浮点...st_angle-{90,0,45,NaN,NaN,45,90}(1 row)SELECT ST_Angle(ST_MakeTrajectory('LINESTRING(0 0,0 10,10 10,20 10,30 0,30 0,20 10,0 10,0 0)'),true);st_angle-{90,0,45,NaN,NaN,-45,-90}(1 row)
计算轨迹每个中间点的转向角，返回一个浮点...st_angle-{90,0,45,NaN,NaN,45,90}(1 row)SELECT ST_Angle(ST_MakeTrajectory('LINESTRING(0 0,0 10,10 10,20 10,30 0,30 0,20 10,0 10,0 0)'),true);st_angle-{90,0,45,NaN,NaN,-45,-90}(1 row)
示例 select ST_AsText(ST_MeshFromText('{"version":1,"root":0,"meshgeoms":["MESHGEOM(PATCH(INDEXSURFACE(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_AsText(ST_MeshFromText('{"version":1,"root":0,"meshgeoms":["MESHGEOM(PATCH(INDEXSURFACE(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}]...
返回结果：{"version":1,"root":0,"meshgeoms":["MESHGEOM(PATCH(INDEXSURFACE Z(VE RTEX(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,"matrix":[1,0,0,-1,0,0,0,0,...
返回结果：{"version":1,"root":0,"meshgeoms":["MESHGEOM(PATCH(INDEXSURFACE Z(VE RTEX(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,"matrix":[1,0,0,1,0,0,0,0,-...
返回结果：{"version":1,"root":0,"meshgeoms":["MESHGEOM(PATCH(INDEXSURFACE Z(VE RTEX(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,"matrix":[1,0,0,-1,0,0,0,0,...