[postgis-users] ST_Clip

[Pierre Racine]

Is this table tiled? Why does your WHERE is about the rid and not ST_Intersects(rast, geom)?

Pierre
________________________________________
From: postgis-users-bounces at postgis.refractions.net [postgis-users-bounces at postgis.refractions.net] On Behalf Of Paolo Cavallini [cavallini at 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