[postgis-users] How compute the stats from a raster table.

Pierre Racine Pierre.Racine at sbf.ulaval.ca
Fri Mar 16 06:52:38 PDT 2012


> I guess it could be useful to define an aggregate taking "SummaryStats" type in
> input so you could do something like:
> 
> SELECT (ST_SummaryStatsAgg(ST_SummaryStats(xx))).* FROM myrast;

Try this:

http://trac.osgeo.org/postgis/browser/trunk/raster/scripts/plpgsql/st_summarystatsagg.sql

...exactly like strk wrote it.

Pierre



More information about the postgis-users mailing list