Great, thank you very much! Volkmar -----Ursprüngliche Nachricht----- Von: [email protected] [mailto:[email protected]] Im Auftrag von Pierre Racine Gesendet: Mittwoch, 5. Oktober 2011 17:34 An: PostGIS Users Discussion Betreff: Re: [postgis-users] WKT Raster
Ticket #1228 http://trac.osgeo.org/postgis/ticket/1228 Pierre > -----Original Message----- > From: [email protected] [mailto:postgis-users- > [email protected]] On Behalf Of Volkmar Herbst privat > Sent: Sunday, October 02, 2011 4:17 PM > To: 'PostGIS Users Discussion' > Subject: Re: [postgis-users] WKT Raster > > 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: [email protected] > [mailto:[email protected]] 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: [email protected] > > [mailto:postgis-users- [email protected]] On Behalf Of > > Volkmar Herbst privat > > Sent: Tuesday, September 27, 2011 3:54 PM > > To: [email protected] > > 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 > > [email protected] > > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
