gis.road_graph

Parameters

Name	Type	Mode
_params	jsonb	IN

Definition

DECLARE
    marker record;
    edge record;
BEGIN
    -- The marker and the edge may have been modified by a previous fix
    SELECT m.*
    INTO marker
    FROM road_graph.markers AS m
    WHERE m.id = (_params->>'marker_id')::integer
    ;
    IF marker.id IS NULL THEN
        RETURN jsonb_build_object(
            'status', 'skipped',
            'message', format('The marker %s does not exist anymore', _params->>'marker_id')
        );
    END IF;
    SELECT e.*
    INTO edge
    FROM road_graph.edges AS e
    WHERE e.id = (_params->>'edge_id')::integer
    AND e.road_code = marker.road_code
    AND ST_DWithin(ST_StartPoint(e.geom), ST_GeomFromEWKT(_params->>'point'), 0.01)
    ;
    IF edge.id IS NULL THEN
        RETURN jsonb_build_object(
            'status', 'skipped',
            'message', format('The edge %s does not start anymore at the given point', _params->>'edge_id')
        );
    END IF;
    IF ST_DWithin(marker.geom, ST_StartPoint(edge.geom), 0.01) THEN
        RETURN jsonb_build_object(
            'status', 'skipped',
            'message', format('The marker %s is already at the start of the road', marker.id)
        );
    END IF;

-- Move the marker to the start of the edge: the triggers calculate again the references of the road
    UPDATE road_graph.markers AS m
    SET geom = ST_StartPoint(edge.geom)
    WHERE m.id = marker.id
    ;

RETURN jsonb_build_object(
        'status', 'success',
        'message', format(
            'The marker %s of the road %s has been moved by %s m to the start of the road',
            marker.code, marker.road_code, round(ST_Distance(marker.geom, ST_StartPoint(edge.geom))::numeric, 2)
        )
    );
END;

fix_graph_move_marker(_params jsonb)

Description

Parameters

Definition