a. How would you turn this pseudocode into a PostGIS SQL query so this action
is
done quickly (we are not particularly skilled at SQL and new to PostGIS raster
processing functions)? That is, should we use an intersection approach or a
map
algebra approach? What would the SQL look like?
Pixel selection is possible via three options:
1) one raster ST_MapAlgebra
2) ST_Reclass
3) ST_DumpAsPolygons (with a where clause)
OK, we will test the different approaches to see what works best/fastest.
When
a query refers to multiple raster layers (e.g., select