pggeodb.nancy.inra.fr/db_robot - db_robot on pggeodb.nancy.inra.fr

Function: st_valuecount

Schema

public

Owner

postgres

Descriptions

args: rastertable, rastercolumn, nband, searchvalues, 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

Definition

CREATE OR REPLACE FUNCTION public.st_valuecount (
 rastertable text,
 rastercolumn text,
 nband integer,
 searchvalues 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, TRUE, $4, $5)
$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, searchvalues double precision [], roundto double precision, out value double precision, out count integer)
IS 'args: rastertable, rastercolumn, nband, searchvalues, 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 26/02/2014 11:51