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

Function: st_valuecount

 

 

Schema

public

 

Owner

postgres

 

Descriptions

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

Option

Value

Returns

Set of record

Language

sql

Parameters

rastertable text

rastercolumn text

searchvalues 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,
 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, 1, TRUE, $3, $4)
$span$
LANGUAGE
'sql'
STABLE
CALLED ON NULL INPUT
SECURITY INVOKER
COST
100 ROWS 1000;

COMMENT ON FUNCTION public.st_valuecount(rastertable text, rastercolumn text, searchvalues double precision [], roundto double precision, out value double precision, out count integer)
IS 'args: rastertable, rastercolumn, 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
Previous topic Chapter index Next topic