[postgis-users] [Raster] Finding pixels intersecting an extent (polygon)

[Jean Marchal]

Hi list,

I am trying to return all the pixels in a raster that intersect (not just
touch) an extent (say a rectangle). I tried ST_Clip and
ST_Intersection(raster, geom) but they don't return all the pixels that
intersect my extent polygon. Do I have to vectorize the raster first using
ST_PixelAsPolygons or there is a better / more efficient way to proceed?

Ultimately the goal is to fetch the resulting raster in R.

Thanks,

Jean
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150205/9cb2babc/attachment.html>