[postgis-users] How to Construct a raster in pl/pgsql function?

Pierre Racine Pierre.Racine at sbf.ulaval.ca
Wed Jul 21 08:42:23 PDT 2010

Hi George,

Unfortunalely st_setvalue is not yet implemented. You could have created an empty raster (st_makeemptyraster) and set the pixels values with st_setvalue.

The only way to create a raster and set specific pixels value now is to generate the HEX values representing the raster and to cast them to ::raster. You will find the best example of this in regress/ create_rt_band_properties_test.sql in the source tree.


From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of George Silva
Sent: 21 juillet 2010 09:59
To: PostGIS Users Discussion
Subject: [postgis-users] How to Construct a raster in pl/pgsql function?

Hello guys,

I'm trying to write a function to calculate flow direction using SQL, in moving windows of 9x9 pixel size.

How can I write a output raster? What is the way to create a specific raster?


George R. C. Silva

Desenvolvimento em GIS
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100721/286ddb3d/attachment.html>

More information about the postgis-users mailing list