Il 26/07/2012 19:54, Paolo Cavallini ha scritto: > Il 26/07/2012 19:39, Pierre Racine ha scritto: >> What happen if do a query like this: >> >> SELECT (gv).geom, (gv).val >> FROM (SELECT >> ST_PixelAsPolygons(ST_AsRaster(ST_Buffer(ST_Centroid(ST_Envelope(rast)), >> 0.5000), rast, ST_BandPixelType(rast, 1), 1, -1)) gv >> FROM hdr >> WHERE rid = 4 >> ) foo >> >> and display the resulting geometries labelled with the values? >> >> This is the first step of the clipping: creating a rasterized version of the >> buffer geometry aligned on the raster. If I redo the query with the same buffer size as my previous one, I obtain a grid that encloses exactly the buffer; the raster is smaller. See attached. Thanks.
-- Paolo Cavallini - Faunalia www.faunalia.eu Full contact details at www.faunalia.eu/pc Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario
<<attachment: Schermata del 2012-07-26 20:03:43.png>>
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users