[postgis-users] ST_MapalgebraExpr() function

Mahavir Trivedi mahavir.trivedi at gmail.com
Sun Nov 25 21:11:46 PST 2012


dear

here i attached output file with .


with thanks & regards
Mahavir
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20121126/2ac9b880/attachment.html>
-------------- next part --------------


Query :

select (ST_SummaryStats(rast)).* From demtest 
union all
select (ST_Summarystats(ST_MapAlgebraExpr(rast,'16BUI'::text,'CASE WHEN [rast] BETWEEN 10 and 40 Then [rast] ELSE NULL end'))).* from demtest

OutPut:

"count"    ;     "sum"       ;"         mean     "   ;"          stddev      ";"min";" max "
"4194304";"56886388214";"13562.7718482018";"12416.0718649421";"1"  ;" 65280"
"0";"";"";"";"";""


More information about the postgis-users mailing list