ST_StatsQuantile-PolarDB(PolarDB)-阿里云帮助中心

Calculates the quantiles of each band in a raster object and stores the results in the object's metadata.

Syntax

raster ST_StatsQuantile(raster raster_obj)

Parameter	Description
`raster_obj`	The raster object to calculate quantiles for.

ST_StatsQuantile calculates quantiles for each band in the raster object and stores the results in the object's metadata.

The following example calculates quantiles for the raster object in row id = 1 and writes the results back to the raster column.

UPDATE rat_quantile
SET raster = ST_StatsQuantile(raster)
WHERE id = 1;