Schema
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
Option | Value |
---|---|
Returns |
Set of record |
Language |
sql |
Parameters |
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 |
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 ST_Centroid(geom), val, x, y FROM _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 |