ST_Raster.buildStats

Definition

The ST_Raster.buildStats function calculates image statistics of an ST_Raster object.

Syntax

Oracle

buildStats () RETURN ST_RASTER

buildStats (level IN NUMBER) RETURN ST_RASTER

PostgreSQL

buildStats (raster IN ST_RASTER) RETURN ST_RASTER

buildStats (raster IN ST_RASTER, 
            level IN INT) RETURN ST_RASTER

SQL Server

buildStats (level IN NUMBER) RETURN ST_RASTER

Returns

ST_Raster

Parameters

Parameter

Description

level

Specifies a pyramid level on which to build statistics; by default, statistics are built on the base level.

raster

The ST_Raster object for which image statistics will be updated

Example

In this example, image statistics for each ST_Raster object in the image column of the comm table are calculated.

Oracle

UPDATE COMM c
SET image = c.image.buildStats();

PostgreSQL

UPDATE comm 
SET image = buildStats(image);

SQL Server

UPDATE comm 
SET image = image.buildStats(NULL);
6/19/2015