Is this table tiled? Why does your WHERE is about the rid and not ST_Intersects(rast, geom)?
Pierre ________________________________________ From: postgis-users-boun...@postgis.refractions.net [postgis-users-boun...@postgis.refractions.net] On Behalf Of Paolo Cavallini [cavall...@faunalia.it] Sent: Wednesday, July 25, 2012 6:42 PM To: PostGIS Users Discussion Subject: [postgis-users] ST_Clip Hi all. I may well be tired, but I cannot understand why: CREATE TABLE clip2 AS SELECT rid, ST_Clip(rast, 1,ST_Buffer(ST_Centroid(ST_Envelope (rast)),5000)) AS rast from hdr WHERE rid = 4; does not result in a circle, but in a square, contained in the buffer but smaller. See attached pictures, with the buffer in green, and the clipped raster inside. Any hint? 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 _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users