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

[Bborie Park]

ST_Intersection(rast, geom) does vectorize the raster before intersecting
with the polygon. ST_Clip(rast, geom) rasterizes the polygon before
intersecting with the raster.

Can you provide more information? Such as the query and the version of
PostGIS?

-bborie

On Thu, Feb 5, 2015 at 2:05 PM, Jean Marchal <jean.d.marchal at gmail.com>
wrote:

> 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
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150205/78253392/attachment.html>