gis Database

Parameters

Name	Type	Mode
myid	text	IN
starter	boolean	IN

Definition

DECLARE
    locate double precision = 0;
BEGIN
    IF starter THEN
        WITH apploc as (
            SELECT DISTINCT ON(c.idcana) c.idcana, ST_LineLocatePoint(c.geom, a.geom) As dist_to_start, ST_LineLocatePoint(c.geom, a.geom) as loc
            FROM raepa.raepa_apparaep_p a INNER JOIN raepa.raepa_canalaep_l c
            ON ST_DWithin(c.geom, a.geom, 0.05)
            WHERE idcana = myid AND fnappaep = '03'
            ORDER BY c.idcana, dist_to_start
        )
        SELECT loc into locate FROM apploc;

ELSE
        WITH apploc as (
            SELECT DISTINCT ON(c.idcana) c.idcana, 1 - ST_LineLocatePoint(c.geom, a.geom) As dist_to_start, ST_LineLocatePoint(c.geom, a.geom) as loc
            FROM raepa.raepa_apparaep_p a INNER JOIN raepa.raepa_canalaep_l c
            ON ST_DWithin(c.geom, a.geom, 0.05)
            WHERE idcana = myid AND fnappaep = '03'
            ORDER BY c.idcana, dist_to_start
        )
        SELECT loc into locate FROM apploc;
    END IF;
    IF locate = 0 THEN
        locate = 0.05;
    ELSIF locate = 1 THEN
        locate = 0.95;
    END IF;

return locate;
END;

get_vanne_cana

Description

Parameters

Definition