pggeodb.nancy.inra.fr/db_robot - db_robot on pggeodb.nancy.inra.fr
Previous topic Chapter index Next topic

Function: st_summarystats

 

 

Schema

public

 

Owner

postgres

 

Descriptions

args: rastertable, rastercolumn, nband=1, exclude_nodata_value=true - Returns summarystats consisting of count, sum, mean, stddev, min, max for a given raster band of a raster or raster coverage. Band 1 is assumed is no band is specified.

 

Options

Option

Value

Returns

public.summarystats

Language

sql

Parameters

rastertable text

rastercolumn text

nband integer = 1

exclude_nodata_value boolean = true

 

Definition

CREATE OR REPLACE FUNCTION public.st_summarystats (
 rastertable text,
 rastercolumn text,
 nband integer = 1,
 exclude_nodata_value boolean = true
)
RETURNS public.summarystats AS
$span$
SELECT public
._ST_summarystats($1, $2, $3, $4, 1)
$span$
LANGUAGE
'sql'
STABLE
RETURNS NULL ON NULL INPUT
SECURITY INVOKER
COST
100;

COMMENT ON FUNCTION public.st_summarystats(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean)
IS 'args: rastertable, rastercolumn, nband=1, exclude_nodata_value=true - Returns summarystats consisting of count, sum, mean, stddev, min, max for a given raster band of a raster or raster coverage. Band 1 is assumed is no band is specified.';

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 26/02/2014 11:51
Previous topic Chapter index Next topic