This function performs a mosaic operation to combine multiple raster objects into a new raster object.

Syntax

raster ST_MosaicFrom(raster source[], cstring chunkTableName); 

Parameters

Parameter Description
source The source raster objects.
chunkTableName The name of the chunk table for storing the created raster object. The name must comply with the table naming rules of ApsaraDB for PostgreSQL.

Description

This function creates a raster object.

All the specified raster objects must meet the following requirements:
  • They have the same number of bands.
  • Either all of them are geographically referenced, or none of them is geographically referenced. If all of them are geographically referenced, world coordinates (geographic coordinates) are used for the mosaic operation.
  • Their pixel types can be different. If world coordinates are used for the mosaic operation, they must have the same spatial reference system identifier (SRID) and affine parameters.

Examples

Insert Into raster_obj Values(1, ST_MosaicFrom(Array(select raster_obj from raster_table where id < 10), 'chunk_table_mosaic'))
Update raster_table Set raster_obj = ST_MosaicFrom(Array(select raster_obj from raster_table where id < 10), 'chunk_table_mosaic') where id = 11;