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

Function: st_worldtorastercoord

Schema

public

Owner

albenard

Descriptions

args: rast, pt - Returns the upper left corner as column and row given geometric X and Y (longitude and latitude) or a point geometry expressed in the spatial reference coordinate system of the raster.

Options

Definition

CREATE OR REPLACE FUNCTION public.st_worldtorastercoord (
 rast public.raster,
 pt public.geometry,
 out columnx integer,
 out rowy integer
)
RETURNS record AS
$span$
DECLARE
rx integer;
ry integer;
BEGIN
IF public.ST_geometrytype(pt) != 'ST_Point' THEN
RAISE EXCEPTION 'Attempting to compute raster coordinate with a non-point geometry';
END IF;
IF public.ST_SRID(rast) != public.ST_SRID(pt) THEN
RAISE EXCEPTION 'Raster and geometry do not have the same SRID';
END IF;

SELECT rc.columnx AS x, rc.rowy AS y INTO columnx, rowy FROM public._ST_worldtorastercoord($1, public.ST_x(pt), public.ST_y(pt)) AS rc;
RETURN;
END;
$span$
LANGUAGE 'plpgsql'
IMMUTABLE
RETURNS NULL ON NULL INPUT
SECURITY INVOKER
COST 100;

COMMENT ON FUNCTION public.st_worldtorastercoord(rast public.raster, pt public.geometry, out columnx integer, out rowy integer)
IS 'args: rast, pt - Returns the upper left corner as column and row given geometric X and Y (longitude and latitude) or a point geometry expressed in the spatial reference coordinate system of the raster.';

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