pggeodb-preprod.nancy.inra.fr/db_onf_gde - db_onf_gde on pggeodb-preprod.nancy.inra.fr

Function: st_aspect

Schema

public

Owner

postgres

Descriptions

There is no description for function st_aspect

Options

Definition

CREATE OR REPLACE FUNCTION public.st_aspect (
 rast public.raster,
 nband integer,
 customextent public.raster,
 pixeltype text = '32BF'::text,
 units text = 'DEGREES'::text,
 interpolate_nodata boolean = false
)
RETURNS public.raster AS
$span$
DECLARE
_rast raster;
_nband integer;
_pixtype text;
_width integer;
_height integer;
_customextent raster;
_extenttype text;
BEGIN
_customextent := customextent;
IF _customextent IS NULL THEN
_extenttype := 'FIRST';
ELSE
_extenttype := 'CUSTOM';
END IF;

IF interpolate_nodata IS TRUE THEN
_rast := public.ST_MapAlgebra(
ARRAY[ROW(rast, nband)]::rastbandarg[],
'st_invdistweight4ma(double precision[][][], integer[][], text[])'::regprocedure,
pixeltype,
'FIRST', NULL,
1, 1
);
_nband := 1;
_pixtype := NULL;
ELSE
_rast := rast;
_nband := nband;
_pixtype := pixeltype;
END IF;

-- get properties
SELECT width, height INTO _width, _height FROM public.ST_Metadata(_rast);

RETURN public.ST_MapAlgebra(
ARRAY[ROW(_rast, _nband)]::rastbandarg[],
' public._ST_aspect4ma(double precision[][][], integer[][], text[])'::regprocedure,
_pixtype,
_extenttype, _customextent,
1, 1,
_width::text, _height::text,
units::text
);
END;
$span$
LANGUAGE 'plpgsql'
IMMUTABLE
CALLED ON NULL INPUT
SECURITY INVOKER
COST 100;

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