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

Function: st_quantile

 

 

Schema

public

 

Owner

postgres

 

Descriptions

args: rastertable, rastercolumn, nband=1, exclude_nodata_value=true, quantiles=NULL - Compute quantiles for a raster or raster table coverage in the context of the sample or population. Thus, a value could be examined to be at the rasters 25%, 50%, 75% percentile.

 

Options

Option

Value

Returns

Set of record

Language

sql

Parameters

rastertable text

rastercolumn text

nband integer = 1

exclude_nodata_value boolean = true

quantiles double precision [] = NULL::double precision[]

out quantile double precision

out value double precision

 

Definition

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

COMMENT ON FUNCTION public.st_quantile(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, quantiles double precision [], out quantile double precision, out value double precision)
IS 'args: rastertable, rastercolumn, nband=1, exclude_nodata_value=true, quantiles=NULL - Compute quantiles for a raster or raster table coverage in the context of the sample or population. Thus, a value could be examined to be at the rasters 25%, 50%, 75% percentile.';

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