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

Function: st_valuecount

 

 

Schema

public

 

Owner

postgres

 

Descriptions

args: rast, nband, exclude_nodata_value, searchvalue, roundto=0 - 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

integer

Language

sql

Parameters

rast public.raster

nband integer

exclude_nodata_value boolean

searchvalue double precision

roundto double precision = 0

 

Definition

CREATE OR REPLACE FUNCTION public.st_valuecount (
 rast public.raster,
 nband integer,
 exclude_nodata_value boolean,
 searchvalue double precision,
 roundto double precision = 0
)
RETURNS integer AS
$span$
SELECT
(_st_valuecount($1, $2, $3, ARRAY[$4]::double precision[], $5)).count
$span$
LANGUAGE
'sql'
IMMUTABLE
RETURNS NULL ON NULL INPUT
SECURITY INVOKER
COST
100;

COMMENT ON FUNCTION public.st_valuecount(rast public.raster, nband integer, exclude_nodata_value boolean, searchvalue double precision, roundto double precision)
IS 'args: rast, nband, exclude_nodata_value, searchvalue, roundto=0 - 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