Database Reference
In-Depth Information
round(min::numeric, 2) AS min,
round(max::numeric, 2) AS max
FROM stats
ORDER BY bandnum;
The output is as follows:
bandnum | count | sum | mean |
stddev | min
---------+-------+------------+---------+--------+--------1
| 7081 | 8987349.00 | 1269.22 | 125.87 |
943.00 2 | 7081 | 89873.49 | 12.69 |
1.26 | 9.43
The summary statistics show that band
2
is correct (the band
1
value divided by
100
.). The values now make sense for the average monthly minimum temperature.
How it works...
Inthisrecipe,weappliedasimplemap-algebraoperationwith
ST_MapAlgebra()
to correct the pixel values. In a later recipe, we will present an advanced map-al-
gebra operation to demonstrate the power of
ST_MapAlgebra()
.
