reclassarg
Name
reclassarg — A composite type used as input into the ST_Reclass function defining the behavior of reclassification.
Description
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]meansa <= x <= b. -
(a-b]meansa < x <= b. -
[a-b)meansa <= x < b. -
(a-b)meansa < x < b.
Opening-parenthesis notation is optional, so
a-b
means the same as
(a-b)
.
Examples
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;