Mosaics one or more raster objects into a destination raster object.
Syntax
raster ST_MosaicTo(raster raster_obj, raster source[]);Parameters
| Parameter | Description |
|---|---|
raster_obj | The destination raster object to mosaic into. |
source | The source raster object or array of raster objects to mosaic from. |
Usage notes
The source and destination raster objects must meet the following requirements:
They have the same number of bands.
They are all georeferenced, or none of them is georeferenced. If all are georeferenced, world coordinates (geographic coordinates) are used for the mosaic operation.
They can have different pixel types, but must share the same spatial reference system identifier (SRID) and affine parameters when world coordinates are used.
Before running the mosaic operation, configure the following parameter:
| Parameter | Type | Description |
|---|---|---|
ganos.raster.mosaic_must_same_nodata | Boolean | Specifies whether the values of NoData in a data source must be the same during the mosaic operation. Valid values: true and false. NoData values are not changed during the mosaic operation. If set to false, the pixel semantics after the mosaic may change. |
Example:
Set ganos.raster.mosaic_must_same_nodata = false;Example
Update raster_table Set raster_obj = ST_MosaicTo(raster_obj, Array(select raster_obj from raster_table where id < 10)) where id = 11;