[postgis-users] ST_SummaryStat on nodata raster

[Bborie Park]

File a ticket.  Besides the count, all the other fields should be NULL.

-bborie

On 06/16/2012 08:55 PM, Pierre Racine wrote:
> Hi,
> 
> Seems to me that when computing summary stats on a null raster (having only nodata values and the count of significant pixel is 0), then the sum, the mean, the stddev, the min and the max should be null. However this:
> 
> SELECT ST_SummaryStats(ST_AddBand(ST_MakeEmptyRaster(10, 10, 0, 0, 1, 1, 0, 0, 4326), '16BSI'::text, 0, 0));
> 
> returns that:
> 
> "(0,0,0,-1,0,0)"
> 
> Confusing... If zero pixel were taken into account in the stats, then there should be no results for the other metrics. If I fetch only the min, the max, or the average, how do I know there are actually not significant?
> 
> Pierre
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 

-- 
Bborie Park
Programmer
Center for Vectorborne Diseases
UC Davis
530-752-8380
bkpark at ucdavis.edu