New answers tagged postgis-raster
0
Try this:
WITH blade AS (
SELECT ST_MakeEnvelope(0, 0, 4, 4) geom
), butter AS (
SELECT ST_AddBand(ST_MakeEmptyRaster(4, 4, 1, 5, 1), '8BUI'::text, 4) rast
), blade_as_raster AS (
SELECT ST_AsRaster(geom, 4, 4, '8BUI'::text, 2) rast
FROM blade
)
SELECT ST_MapAlgebra(a.rast, b.rast, '[rast2]', '8BUI'::text, 'FIRST', NULL::text, '[rast1]') rast
FROM ...
Top 50 recent answers are included
