gis.road_graph

Parameters

Name	Type	Mode
_params	jsonb	IN

Definition

DECLARE
    issue_edge_ids integer[];
    road_codes text[];
    check_options jsonb;
    reversed_ids integer[];
    reversed_edge_id integer;
BEGIN
    -- Edges given by the issue
    SELECT array_agg(x::integer)
    INTO issue_edge_ids
    FROM jsonb_array_elements_text(_params->'edge_ids') AS x
    ;
    IF issue_edge_ids IS NULL THEN
        RETURN jsonb_build_object(
            'status', 'error',
            'message', 'The parameter edge_ids is needed'
        );
    END IF;

-- Options of the check G05 set by the administrator, to find the reversed edges like the check
    SELECT g.default_options
    INTO check_options
    FROM "road_graph".glossary_graph_check AS g
    WHERE g.code = 'G05'
    ;

-- The edges still in the opposite direction of their road:
    -- the edges may have been reversed, split or merged by a previous fix
    SELECT array_agg(DISTINCT e.road_code)
    INTO road_codes
    FROM road_graph.edges AS e
    WHERE e.id = ANY(issue_edge_ids)
    ;
    SELECT array_agg(DISTINCT x ORDER BY x)
    INTO reversed_ids
    FROM road_graph.check_graph_reversed_edges(road_codes, check_options) AS i,
    unnest(i.edge_ids) AS x
    WHERE x = ANY(issue_edge_ids)
    ;
    IF reversed_ids IS NULL THEN
        RETURN jsonb_build_object(
            'status', 'skipped',
            'message', format(
                'The edges %s are not in the opposite direction of their road anymore',
                array_to_string(issue_edge_ids, ', ')
            )
        );
    END IF;

-- Reverse the edges one by one: the triggers swap the start and end nodes of each edge,
    -- and calculate again its previous and next edges and the references of its road
    FOREACH reversed_edge_id IN ARRAY reversed_ids LOOP
        UPDATE road_graph.edges AS e
        SET geom = ST_Reverse(e.geom)
        WHERE e.id = reversed_edge_id
        ;
    END LOOP;

-- Check the edges are now in the direction of their road.
    -- If not, the exception cancels the changes of this fix (see fix_graph_issue)
    IF EXISTS (
        SELECT 1
        FROM road_graph.check_graph_reversed_edges(road_codes, check_options) AS i
        WHERE i.edge_ids && reversed_ids
    ) THEN
        RAISE EXCEPTION 'The edges % are still in the opposite direction of their road after being reversed',
            array_to_string(reversed_ids, ', ');
    END IF;

RETURN jsonb_build_object(
        'status', 'success',
        'message', format('The edges %s have been reversed', array_to_string(reversed_ids, ', '))
    );
END;

fix_graph_reverse_edges(_params jsonb)

Description

Parameters

Definition