reclassarg — A composite type used as input into the ST_Reclass function defining the behavior of reclassification.
A composite type used as input into the ST_Reclass function defining the behavior of reclassification.
| Field | Type | Description |
|---|---|---|
nband
|
integer | The band number of band to reclassify. |
reclassexpr
|
text | Comma-delimited range:map_range mappings that define how old band values map to new band values. |
pixeltype
|
text | One of defined pixel types as described in ST_BandPixelType. |
nodataval
|
double precision | Value to treat as no data. For image outputs that support transparency, these will be blank. |
The reclassexpr range delimiters mean: ( greater than, ) less than, ] less than or equal, and [ greater than or equal.
[a-b] means a <= x <= b.
(a-b] means a < x <= b.
[a-b) means a <= x < b.
(a-b) means a < x < b.
Opening-parenthesis notation is optional, so a-b means the same as (a-b).
Reclassify band 2 as an 8BUI where 255 is nodata value.
SELECT ROW(2, '0-100:1-10, 101-500:11-150,501 - 10000: 151-254', '8BUI', 255)::reclassarg;
Reclassify band 1 as an 1BB and no nodata value defined.
SELECT ROW(1, '0-100]:0, (100-255:1', '1BB', NULL)::reclassarg;