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 | Die Nummer des Bandes das neu klasssifiziert werden soll. |
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 | Der Zellwert, der als NODATA/NULL betrachtet werden soll. Bei der Ausgabe von Bildern, die Transparenz unterstützen, bleibt dieser leer. |
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;