ST_MakePatch-PolarDB(PolarDB)-阿里云帮助中心

Creates a pcpatch from a flat array of double-precision floating-point values.

Syntax

pcpatch ST_MakePatch(integer pcid, float8[] vals);

Parameter	Description
`pcid`	The point cloud schema ID from the `pointcloud_formats` table.
`vals`	A flat `float8[]` array of point values. The number of elements must be a multiple of the number of dimensions defined in the schema.

SELECT ST_asText(ST_MakePatch(1, ARRAY[-126.99,45.01,1,0, -126.98,45.02,2,0, -126.97,45.03,3,0]));

Output:

{"pcid":1,"pts":[
 [-126.99,45.01,1,0],[-126.98,45.02,2,0],[-126.97,45.03,3,0]
]}