Description

Apply a colormap to the band at nband of rast resulting a new raster comprised of up to four 8BUI bands. The number of 8BUI bands in the new raster is determined by the number of color components defined in colormap.

If nband is not specified, then band 1 is assumed.

colormap can be a keyword of a pre-defined colormap or a set of lines defining the value and the color components.

Valid pre-defined colormap keyword:

Users can pass a set of entries (one per line) to colormap to specify custom colormaps. Each entry generally consists of five values: the pixel value and corresponding Red, Green, Blue, Alpha components (color components between 0 and 255). Percent values can be used instead of pixel values where 0% and 100% are the minimum and maximum values found in the raster band. Values can be separated with commas (','), tabs, colons (':') and/or spaces. The pixel value can be set to nv, null or nodata for the NODATA value. An example is provided below.

5 0 0 0 255
4 100:50 55 255
1 150,100 150 255
0% 255 255 255 255
nv 0 0 0 0
					

The syntax of colormap is similar to that of the color-relief mode of GDAL gdaldem.

Valid keywords for method:

	A great reference for colormaps is ColorBrewer.

	The resulting bands of new raster will have no NODATA value set. Use ST_SetBandNoDataValue to set a NODATA value if one is needed.

Availability: 2.1.0

Examples

This is a junk table to play with

-- setup test raster table --
DROP TABLE IF EXISTS funky_shapes;
CREATE TABLE funky_shapes(rast raster);

INSERT INTO funky_shapes(rast)
WITH ref AS (
	SELECT ST_MakeEmptyRaster( 200, 200, 0, 200, 1, -1, 0, 0) AS rast
)
SELECT
	ST_Union(rast)
FROM (
	SELECT 
		ST_AsRaster(
			ST_Rotate(
				ST_Buffer(
					ST_GeomFromText('LINESTRING(0 2,50 50,150 150,125 50)'),
					i*2
				),
				pi() * i * 0.125, ST_Point(50,50)
			),
			ref.rast, '8BUI'::text, i * 5
		) AS rast
	FROM ref
	CROSS JOIN generate_series(1, 10, 3) AS i
) AS shapes;
					

SELECT
	ST_NumBands(rast) As n_orig,
	ST_NumBands(ST_ColorMap(rast,1, 'greyscale')) As ngrey,
	ST_NumBands(ST_ColorMap(rast,1, 'pseudocolor')) As npseudo,
	ST_NumBands(ST_ColorMap(rast,1, 'fire')) As nfire,
	ST_NumBands(ST_ColorMap(rast,1, 'bluered')) As nbluered,
	ST_NumBands(ST_ColorMap(rast,1, '
100% 255   0   0
 80% 160   0   0
 50% 130   0   0
 30%  30   0   0
 20%  60   0   0
  0%   0   0   0
  nv 255 255 255
	')) As nred
FROM funky_shapes;
					

 n_orig | ngrey | npseudo | nfire | nbluered | nred
--------+-------+---------+-------+----------+------
      1 |     1 |       4 |     4 |        4 |    3
					

Examples: Compare different color map looks using ST_AsPNG

SELECT
	ST_AsPNG(rast) As orig_png,
	ST_AsPNG(ST_ColorMap(rast,1,'greyscale')) As grey_png,
	ST_AsPNG(ST_ColorMap(rast,1, 'pseudocolor')) As pseudo_png,
	ST_AsPNG(ST_ColorMap(rast,1, 'nfire')) As fire_png,
	ST_AsPNG(ST_ColorMap(rast,1, 'bluered')) As bluered_png,
	ST_AsPNG(ST_ColorMap(rast,1, '
100% 255   0   0
 80% 160   0   0
 50% 130   0   0
 30%  30   0   0
 20%  60   0   0
  0%   0   0   0
  nv 255 255 255
	')) As red_png
FROM funky_shapes;
					

orig_png	grey_png	pseudo_png
fire_png	bluered_png	red_png

See Also

ST_AsPNG, ST_AsRaster ST_MapAlgebra, ST_NumBands, ST_Reclass, ST_SetBandNoDataValue, ST_Union