Builds a table-based raster overview by mosaicking raster objects from a source table at a specified pyramid level.
Syntax
raster ST_BuildOverview(cstring srcTableName, cstring srcColumnName, integer srcPyramidLevel, cstring chunkTableName);Parameters
| Parameter | Type | Description |
|---|---|---|
tableName | cstring | The name of the source table. |
columnName | cstring | The name of the raster object column in the source table. |
pyramidLevel | integer | The pyramid level of the overview to build. |
chunkTableName | cstring | The name of the chunk table that stores the raster object created as the overview. |
Usage notes
All raster objects in the source table must meet the following requirements:
They have the same number of bands.
Either all or one of the raster objects is geographically referenced. If all are geographically referenced, world coordinates (geographic coordinates) are used for the mosaic operation.
Their pixel types can differ. If world coordinates are used for the mosaic operation, all raster objects must share the same spatial reference system identifier (SRID) and pixel resolution.
Example
INSERT INTO raster_table_overview VALUES(1, ST_BuildOverview('raster_table', 'raster_obj', 0, 'chunk_table_overview'));该文章对您有帮助吗？