I was wondering if it is possible to call PostgreSQL stored functions from GeoServer?

I tried to use GeoServer's WPS to do map algebra, but found that the operations it offered was somewhat limited to things such as gs:AddCoverages. This makes me wonder if it is possible to use PostgreSQL/PostGIS functions and stored functions directly to do arbitrary algebra, e.g.:

SELECT ST_MapAlgebra(t1.rast,t2.rast
        ,'([rast1]+0.001)/([rast2]+0.001)') AS rast
FROM img1 t1, img2 t2;

I googled around, and didn't find much, except a related post here about using stored procedure of Microsoft SQL server.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.