[postgis-users] ST_SetValue takes too much time..

[Pierre Racine]

Hi,

We are very well aware of the problem but focus was not on raster edition for this first release. Next releases will certainly do better. We already have one ticket summarizing this problem:

http://trac.osgeo.org/postgis/ticket/595

Pierre

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-
> bounces at postgis.refractions.net] On Behalf Of Sandro Santilli
> Sent: Monday, February 20, 2012 10:58 AM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] ST_SetValue takes too much time..
> 
> On Mon, Feb 20, 2012 at 04:50:17PM +0100, daniel spiering wrote:
> 
> >    UPDATE target_tbl SET rast = ST_SetValue(rast, 1, COL, ROW,
> CLIMATE_VALUE)
> >    WHERE EXTRACT(DOY FROM datum) = CURRENT_DAY;
> >
> >    The problem is that updating each cell, using the ST_SetValue-function
> ...
> >    Is there any other way to create rasters from the original data than
> >    updating an empty raster cell by cell?
> 
> Hi Daniel, I had a similar requirement a few weeks ago, see:
> http://postgis.refractions.net/pipermail/postgis-devel/2012-
> February/018033.html
> 
> --strk;
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users