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

Pierre Racine Pierre.Racine at sbf.ulaval.ca
Fri Jul 23 12:37:22 PDT 2010


If you update your source tree you will get st_setvalue() implemented today!

Have fun and share with us your nice plpgsql functions. I have a page in the wiki where we can put those new functions:

http://trac.osgeo.org/postgis/wiki/WKTRasterUsefulFunctions

Pierre

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 12:46
To: PostGIS Users Discussion
Subject: Re: [postgis-users] How to Construct a raster in pl/pgsql function?

Hello Pierre,

That will do just fine.

Thanks for your help.

George
On Wed, Jul 21, 2010 at 12:42 PM, Pierre Racine <Pierre.Racine at sbf.ulaval.ca<mailto:Pierre.Racine at sbf.ulaval.ca>> wrote:
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.

Pierre

From: postgis-users-bounces at postgis.refractions.net<mailto:postgis-users-bounces at postgis.refractions.net> [mailto: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

--
George R. C. Silva

Desenvolvimento em GIS
http://blog.geoprocessamento.net

_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net<mailto:postgis-users at postgis.refractions.net>
http://postgis.refractions.net/mailman/listinfo/postgis-users



--
George R. C. Silva

Desenvolvimento em GIS
http://blog.geoprocessamento.net
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100723/e8bd6be9/attachment.html>


More information about the postgis-users mailing list