ST_transform

更新时间:
复制 MD 格式

Transforms a pcpatch object to a new schema and returns the result as a new pcpatch object.

Syntax

pcpatch ST_transform(pcpatch pc, integer pcid, float8 def default 0.0);

Parameters

ParameterDescription
pcThe pcpatch object to transform.
pcidThe ID of the target schema. The ID comes from the pointcloud_formats table.
defThe default value assigned to attribute dimensions that exist in the target schema but not in the source schema. Default: 0.0.

Description

ST_transform re-interprets the point data according to the target schema's dimension definitions — including any differences in scale or offset — and returns a new pcpatch object with values recalculated accordingly.

This differs from ST_setPcid, which only reassigns the schema ID without reinterpreting the underlying values.

Example

update patches set pa=ST_transform(pa, 2, 0.0);

Output:

(1 rows)