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

Function: st_pixelascentroids

Schema

public

Owner

postgres

Descriptions

args: rast, band=1, exclude_nodata_value=TRUE - Returns the centroid (point geometry) for each pixel of a raster band along with the value, the X and the Y raster coordinates of each pixel. The point geometry is the centroid of the area represented by a pixel.

Options

Definition

CREATE OR REPLACE FUNCTION public.st_pixelascentroids (
 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_Centroid(geom), 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_pixelascentroids(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 the centroid (point geometry) for each pixel of a raster band along with the value, the X and the Y raster coordinates of each pixel. The point geometry is the centroid of the area represented by a pixel.';

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 13/03/2014 13:23