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

Function: st_count

 

 

Schema

public

 

Owner

albenard

 

Descriptions

args: rastertable, rastercolumn, nband=1, exclude_nodata_value=true - Returns the number of pixels in a given band of a raster or raster coverage. If no band is specified defaults to band 1. If exclude_nodata_value is set to true, will only count pixels that are not equal to the nodata value.

 

Options

Option

Value

Returns

bigint

Language

sql

Parameters

rastertable text

rastercolumn text

nband integer = 1

exclude_nodata_value boolean = true

 

Definition

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

COMMENT ON FUNCTION public.st_count(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean)
IS 'args: rastertable, rastercolumn, nband=1, exclude_nodata_value=true - Returns the number of pixels in a given band of a raster or raster coverage. If no band is specified defaults to band 1. If exclude_nodata_value is set to true, will only count pixels that are not equal to the nodata value.';

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