Add route offset to siri_arrivals [depends on #29, #30] about open-bus HOT 1 CLOSED

-- Add route offset to siri_arrivals (see issue #26)
--Adding offset column
ALTER TABLE siri_arrivals_filtered
ADD route_offset float8;

-- Populate data
with join_result as (SELECT id, ST_LineLocatePoint(shape_line, siri_arrivals_filtered.vehicle_location_point) as line_locate_point_value
FROM siri_arrivals_filtered
JOIN gtfs_trips ON gtfs_trips.trip_id = siri_arrivals_filtered.trip_id_from_gtfs
JOIN gtfs_shape_lines ON gtfs_trips.shape_id = gtfs_shape_lines.shape_id)

update siri_arrivals_filtered
set route_offset = join_result.line_locate_point_value
from join_result
where siri_arrivals_filtered.id = join_result.id

@daphshez , this issue can be also closed. Thanks

from open-bus.