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

Function: st_valuecount

 

 

Schema

public

 

Owner

postgres

 

Descriptions

args: rastertable, rastercolumn, nband=1, exclude_nodata_value=true, searchvalues=NULL, roundto=0, OUT value, OUT count - Returns a set of records containing a pixel band value and count of the number of pixels in a given band of a raster (or a raster coverage) that have a given set of values. If no band is specified defaults to band 1. By default nodata value pixels are not counted. and all other values in the pixel are output and pixel band values are rounded to the nearest integer.

 

Options

Option

Value

Returns

Set of record

Language

sql

Parameters

rastertable text

rastercolumn text

nband integer = 1

exclude_nodata_value boolean = true

searchvalues double precision [] = NULL::double precision[]

roundto double precision = 0

out value double precision

out count integer

 

Definition

CREATE OR REPLACE FUNCTION public.st_valuecount (
 rastertable text,
 rastercolumn text,
 nband integer = 1,
 exclude_nodata_value boolean = true,
 searchvalues double precision [] = NULL::double precision[],
 roundto double precision = 0,
 out value double precision,
 out count integer
)
RETURNS SETOF record AS
$span$
SELECT value
, count FROM public._ST_valuecount($1, $2, $3, $4, $5, $6)
$span$
LANGUAGE
'sql'
STABLE
CALLED ON NULL INPUT
SECURITY INVOKER
COST
100 ROWS 1000;

COMMENT ON FUNCTION public.st_valuecount(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, searchvalues double precision [], roundto double precision, out value double precision, out count integer)
IS 'args: rastertable, rastercolumn, nband=1, exclude_nodata_value=true, searchvalues=NULL, roundto=0, OUT value, OUT count - Returns a set of records containing a pixel band value and count of the number of pixels in a given band of a raster (or a raster coverage) that have a given set of values. If no band is specified defaults to band 1. By default nodata value pixels are not counted. and all other values in the pixel are output and pixel band values are rounded to the nearest integer.';

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 13/03/2014 13:23
Previous topic Chapter index Next topic