gis.road_graph

Parameters

Name	Type	Mode
_edge_id	integer	IN
_use_cache	boolean	IN

Definition

DECLARE
    edge record;
    start_references jsonb;
    end_references jsonb;
    -- timing variables
   _timing1  timestamptz;
   _start_ts timestamptz;
   _end_ts   timestamptz;
   _overhead numeric;     -- in ms
BEGIN
    -- Notice used for big imports
    -- RAISE NOTICE 'get_edge_references - %', _edge_id;

-- timing
    _timing1  := clock_timestamp();
    _start_ts := clock_timestamp();
    _end_ts   := clock_timestamp();
    -- take minimum duration as conservative estimate
    _overhead := 1000 * extract(epoch FROM LEAST(_start_ts - _timing1, _end_ts   - _start_ts));
    _start_ts := clock_timestamp();

-- Get edge
    SELECT INTO edge
        e.*, r.road_type
    FROM road_graph.edges AS e
    JOIN road_graph.roads AS r
        ON e.road_code = r.road_code
    WHERE e.id = _edge_id
    ;
    IF edge IS NULL THEN
        RETURN NULL::json;
    END IF;

-- RAISE NOTICE '% = %' , 'get edge', 1000 * (extract(epoch FROM clock_timestamp() - _start_ts)) - _overhead;

-- Check road code
    IF edge.road_code IS NULL THEN
        RETURN NULL::json;
    END IF;

-- start point
    SELECT INTO start_references
        road_graph.get_reference_from_point(
            ST_StartPoint(edge.geom),
            edge.road_code,
            _use_cache
        ) AS ref
    ;
   -- RAISE NOTICE '% = %' , 'get start point', 1000 * (extract(epoch FROM clock_timestamp() - _start_ts)) - _overhead;

-- end point
    -- we do not use ST_EndPoint for roundabout because this corresponds
    -- also to the ST_STartPoint
    IF edge.road_type = 'roundabout' THEN
        -- Use ST_LineInterpolatePoint(a_linestring, a_fraction);
        SELECT INTO end_references
            road_graph.get_reference_from_point(
                ST_LineInterpolatePoint(edge.geom, 0.99999),
                edge.road_code,
                _use_cache
            ) AS ref
        ;
    ELSE
        -- Use St_EndPoint(geom)
        SELECT INTO end_references
            road_graph.get_reference_from_point(
                ST_EndPoint(edge.geom),
                edge.road_code,
                _use_cache
            ) AS ref
        ;
    END IF;
   -- RAISE NOTICE '% = %' , 'get end references', 1000 * (extract(epoch FROM clock_timestamp() - _start_ts)) - _overhead;

-- Return calculated data
    RETURN json_build_object(
        'start_marker', (start_references->>'marker_code')::text::integer,
        'start_abscissa', (start_references->>'abscissa')::text::real,
        'start_cumulative', (start_references->>'cumulative')::text::real,
        'end_marker', (end_references->>'marker_code')::text::integer,
        'end_abscissa', (end_references->>'abscissa')::text::real,
        'end_cumulative', (end_references->>'cumulative')::text::real
    )
    ;

END;

get_edge_references(_edge_id integer, _use_cache boolean DEFAULT false)

Description

Parameters

Definition