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

Function: st_pixelaspoints

Schema

public

Owner

albenard

Descriptions

args: rast, band=1, exclude_nodata_value=TRUE - Returns a point geometry for each pixel of a raster band along with the value, the X and the Y raster coordinates of each pixel. The coordinates of the point geometry are of the pixels upper-left corner.

Options

Definition

CREATE OR REPLACE FUNCTION public.st_pixelaspoints (
 rast public.raster,
 band integer = 1,
 exclude_nodata_value boolean = true,
 out geom public.geometry,
 out val double precision,
 out x integer,
 out y integer
)
RETURNS SETOF record AS
$span$
SELECT public.ST_PointN(  public.ST_ExteriorRing(geom), 1), val, x, y FROM public._ST_pixelaspolygons($1, $2, NULL, NULL, $3)
$span$
LANGUAGE 'sql'
IMMUTABLE
RETURNS NULL ON NULL INPUT
SECURITY INVOKER
COST 100 ROWS 1000;

COMMENT ON FUNCTION public.st_pixelaspoints(rast public.raster, band integer, exclude_nodata_value boolean, out geom public.geometry, out val double precision, out x integer, out y integer)
IS 'args: rast, band=1, exclude_nodata_value=TRUE - Returns a point geometry for each pixel of a raster band along with the value, the X and the Y raster coordinates of each pixel. The coordinates of the point geometry are of the pixels upper-left corner.';

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