跳转至
🎉 SedonaDB 0.4.0 已正式发布!🗺️ 新增 Python DataFrame API、R dplyr 接口、Geography 支持及 GPU 加速空间连接。阅读发布博客 →

RS_SummaryStatsAll

Introduction: Returns summary stats struct consisting of count, sum, mean, stddev, min, max for a given band in raster. If band is not specified then it defaults to 1.

Note

If excludeNoDataValue is set true then it will only count pixels with value not equal to the nodata value of the raster. Set excludeNoDataValue to false to get count of all pixels in raster.

Note

If the mentioned band index doesn't exist, this will throw an IllegalArgumentException.

Formats:

RS_SummaryStatsAll(raster: Raster)

RS_SummaryStatsAll(raster: Raster, band: Integer = 1)

RS_SummaryStatsAll(raster: Raster, band: Integer = 1, excludeNoDataValue: Boolean = true)

Return type: Struct<count: Long, sum: Double, mean: Double, stddev: Double, min: Double, max: Double>

Since: v1.5.0

SQL Example

SELECT RS_SummaryStatsAll(RS_MakeEmptyRaster(2, 5, 5, 0, 0, 1, -1, 0, 0, 0), 1, false)

Output:

{25.0, 204.0, 8.16, 9.4678403028357, 0.0, 25.0}

SQL Example

SELECT RS_SummaryStatsAll(RS_MakeEmptyRaster(2, 5, 5, 0, 0, 1, -1, 0, 0, 0), 1)

Output:

{14.0, 204.0, 14.571428571428571, 11.509091348732502, 1.0, 25.0}