Definition
The ST_Raster.setColormap function inserts a raster color map into an ST_Raster object. The function will overwrite a color map if one exists. The function returns an error if the ST_Raster object is not single band with either a 1-bit, 4-bit, 8-bit, or 16-bit pixel depth.
Syntax
Oracle
setColormap (fileName IN VARCHAR2) RETURN ST_RASTER
PostgreSQL
setColormap (raster IN ST_RASTER,
fileName IN TEXT) RETURN ST_RASTERSQL Server
setColormap (fileName IN VARCHAR) RETURN ST_RASTER
Returns
ST_Raster
Parameters
| Parameter | Description |
|---|---|
filename | The full path to the image file that contains the color map index to be loaded |
raster | The ST_Raster object for which the color map will be set |
Example
In this example, the color map is set on an ST_Raster object that corresponds to the table row that has a raster_id column value of 46.
Oracle
UPDATE AERIALS t
SET image = t.image.setColormap('colormap_table')
WHERE t.image.raster_id = 46;
PostgreSQL
UPDATE aerials
SET image = setColormap(image,'colormap_table')
WHERE raster_id(image) = 46;
SQL Server
UPDATE aerials
SET image = image.setColormap('colormap_table')
WHERE image.raster_id = 46;