gis.road_graph

Parameters

Name	Type	Mode
_params	jsonb	IN

Definition

DECLARE
    -- Maximum distance between the edges and the crossing point
    tolerance real = 0.50;
    cut_point geometry;
    marked_ids integer[];
BEGIN
    cut_point = ST_GeomFromEWKT(_params->>'point');
    IF cut_point IS NULL THEN
        RETURN jsonb_build_object('status', 'error', 'message', 'The parameter point is missing');
    END IF;

-- Set no_intersection_cutting to True for the given edge, or for all the given edges,
    -- if they still pass by the crossing point
    WITH marked AS (
        UPDATE road_graph.edges AS e
        SET no_intersection_cutting = True
        WHERE ST_DWithin(e.geom, cut_point, tolerance)
        AND NOT Coalesce(e.no_intersection_cutting, False)
        AND (
            CASE
                WHEN _params ? 'edge_id' THEN e.id = (_params->>'edge_id')::integer
                ELSE e.id IN (SELECT jsonb_array_elements_text(_params->'edge_ids')::integer)
            END
        )
        RETURNING e.id
    )
    SELECT array_agg(m.id ORDER BY m.id)
    INTO marked_ids
    FROM marked AS m
    ;

IF marked_ids IS NULL THEN
        RETURN jsonb_build_object('status', 'skipped', 'message', 'No edge to mark at this point');
    END IF;

RETURN jsonb_build_object(
        'status', 'success',
        'message', format(
            'The field no_intersection_cutting has been set to True for the edges %s',
            array_to_string(marked_ids, ', ')
        )
    );
END;

fix_graph_mark_as_bridge(_params jsonb)

Description

Parameters

Definition