ST_Combine is an aggregate function that merges all 3D scene objects in a column into a single scene object.
Syntax
scene ST_Combine(scene sc);Parameters
| Parameter | Description |
|---|---|
sc | The scene column or expression to aggregate. All scene objects in the column are merged into one. |
Usage notes
ST_Combine only merges scene objects of the same format. Merging objects of different formats — for example, a gltf scene with an osg scene — is not supported.
Examples
The following examples use a table t with a scene column that stores 3D models.
Merge all scene objects in the table:
SELECT ST_AsText(ST_Combine(scene)) FROM t;Output:
{"type" : "gltf", "content" : {"accessors":[{"bufferView":0,......The following figures show how ST_Combine merges four neighboring 3D tile models into one.
Before merging — four separate 3D tile models:
After merging — one combined 3D model:
