gis.road_graph

Parameters

Name	Type	Mode
_point	geometry	IN
_create	boolean	IN
node_id	integer	TABLE
node_geom	geometry	TABLE
is_created	boolean	TABLE

Definition

BEGIN
    -- Get the closest node less than 0.5 m from the given start or end point of an edge,
    -- or the node with the lowest id if several nodes are at the same distance.
    -- The closest node must be used: when an edge is modified, its start or end point
    -- must stay on its node, even if another node is less than 0.5 m from it
    SELECT n.id, n.geom
    INTO node_id, node_geom
    FROM road_graph.nodes AS n
    WHERE ST_DWithin(n.geom, _point, 0.50)
    ORDER BY n.geom <-> _point, n.id
    LIMIT 1
    ;
    is_created = False;
    IF node_id IS NOT NULL THEN
        RETURN NEXT;
        RETURN;
    END IF;

-- Create the missing node if asked
    IF _create THEN
        -- Declare that the node is the extremity of an edge:
        -- the edges under it will be split, even if their field no_intersection_cutting is True
        -- (for example a new access road arriving in the middle of a highway edge)
        -- The variable is used by the trigger function after_node_insert_or_update
        SET LOCAL road.graph.node.edge.extremity = 'yes';
        WITH new_node AS (
            INSERT INTO road_graph.nodes
            (geom)
            VALUES
            (_point)
            ON CONFLICT ON CONSTRAINT nodes_geom_key DO NOTHING
            RETURNING id
        )
        SELECT new_node.id
        FROM new_node
        INTO node_id
        ;
        SET LOCAL road.graph.node.edge.extremity = 'no';
        node_geom = _point;
        is_created = True;
    END IF;

RETURN NEXT;
    RETURN;
END;

get_or_create_edge_node(_point geometry, _create boolean)

Description

Parameters

Definition