[postgis-users] WKT Raster

[Volkmar Herbst privat]

That would indeed be a very good function. The same way one can set a
postgis geometry from a wkt/ text geometry one could set a raster from an
array. I think this is absolutely needed. Especially with regard to R/plr
but also for creating a raster from other date sources..


-----Ursprüngliche Nachricht-----
Von: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] Im Auftrag von Pierre
Racine
Gesendet: Samstag, 1. Oktober 2011 15:15
An: PostGIS Users Discussion
Betreff: Re: [postgis-users] WKT Raster

We should probably at some point provide a ST_SetValues(raster,
ARRAY[values]). Would this help?

Pierre

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-
> bounces at postgis.refractions.net] On Behalf Of Volkmar Herbst privat
> Sent: Tuesday, September 27, 2011 3:54 PM
> To: postgis-users at postgis.refractions.net
> Subject: [postgis-users] WKT Raster
> 
> Hi all,
> I have a question concerning the creation of a raster in a plr function. I
create a
> empty raster and set the pixel values individually with update
> queries:
> 
> for(i in 1:nrow(mat_p)) {
>       for(j in 1:ncol(mat_p)) {
> pg.spi.exec(sprintf ("UPDATE nutrients.applications SET raster =
> ST_SetValue(raster,%s, %s, %s,%s) WHERE id = %s ;", 3, j, i, mat_cao[i,j],
> rid))
>       }
> }
> 
> This takes quite a long time..
> Does anyone know an alternative approach to create a WKT- Raster in R
directly
> without setting each pixel value and export it to a Postgis table?
> Or is it possible to write the binary raster somehow?
> Any hints are most welcome,
> 
> Volkmar
> 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users