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

Function: st_pixelofvalue

 

 

Schema

public

 

Owner

albenard

 

Descriptions

args: rast, nband, search, exclude_nodata_value=true - Get the columnx, rowy coordinates of the pixel whose value equals the search value.

 

Options

Option

Value

Returns

Set of record

Language

sql

Parameters

rast public.raster

nband integer

search double precision

exclude_nodata_value boolean = true

out x integer

out y integer

 

Definition

CREATE OR REPLACE FUNCTION public.st_pixelofvalue (
 rast public.raster,
 nband integer,
 search double precision,
 exclude_nodata_value boolean = true,
 out x integer,
 out y integer
)
RETURNS SETOF record AS
$span$
SELECT
x, y FROM public.ST_pixelofvalue($1, $2, ARRAY[$3], $4)
$span$
LANGUAGE
'sql'
IMMUTABLE
RETURNS NULL ON NULL INPUT
SECURITY INVOKER
COST
100 ROWS 1000;

COMMENT ON FUNCTION public.st_pixelofvalue(rast public.raster, nband integer, search double precision, exclude_nodata_value boolean, out x integer, out y integer)
IS 'args: rast, nband, search, exclude_nodata_value=true - Get the columnx, rowy coordinates of the pixel whose value equals the search value.';

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 26/02/2014 11:51
Previous topic Chapter index Next topic