ST_transform

Updated at:

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

ParameterTypeDefaultDescription
pcpcpatch—The source pcpatch object to transform.
pcidinteger—The ID of the target schema in the pointcloud_formats table.
deffloat80.0For dimensions that exist in the target schema but not in the source schema, attribute dimensions are set to this value.

Description

Unlike ST_setPcid, ST_transform returns a new pcpatch object based on different dimension interpretations, scales, or offsets in the target schema.

Examples

UPDATE patches SET pa = ST_transform(pa, 2, 0.0);

Output:

--------------------------------------
(1 rows)