A planned route. Populated daily from the MOT GTFS data by gtfs-etl.
Because the GTFS data may change daily, each route is only relevant for a single day specified in this field.
Unique identifier for this route, together with operator_ref.
Unique identifier for this route, together with line_ref.
A single stop. Populated daily from the MOT GTFS data by gtfs-etl.
Because the GTFS data may change daily, each stop is relevant only for a single day specified in this field.
The GTFS stop code.
Each gtfs_stop can have multiple MOT identifiers, represented in this table. Populated daily from the MOT GTFS data by gtfs-etl.
A planned ride (AKA trip) along a specified route. Populated daily from the MOT GTFS data by gtfs-etl.
The related gtfs_route this ride is a part of.
A unique identifier for this ride as provided by the original MOT GTFS data.
The first gtfs_ride_stop along this ride. Populated from stride-etl-gtfs-update-ride-aggregations.
The last gtfs_ride_stop along this ride. Populated from stride-etl-gtfs-update-ride-aggregations.
The start time of this ride. Populated from stride-etl-gtfs-update-ride-aggregations.
The end time of this ride. Populated from stride-etl-gtfs-update-ride-aggregations.
A planned stop along a gtfs_ride. Populated daily from the MOT GTFS data by gtfs-etl.
The related gtfs_stop.
The related gtfs_ride.
A ride along a siri_route. Populated in near real time from the SIRI data by siri-etl-process-snapshot-new-snapshots-daemon.
The related siri_route.
A unique identifier for this ride as provided by the SIRI data.
The scheduled start time as provided by the SIRI data. Note that this value may change over time but we only show the first value as received from the SIRI real-time data. See this issue for more details.
A unique identifier of the bus or vehicle. This may be the license number but could also be other identifier as provided by the SIRI data.
The first siri_vehicle_location along this ride. Populated by stride-etl-siri-add-ride-durations.
The last siri_vehicle_location along this ride. Populated by stride-etl-siri-add-ride-durations.
The duration of this ride in minutes. Populated by stride-etl-siri-add-ride-durations.
The related gtfs_ride based on journey_ref. Populated by stride-etl-siri-update-rides-gtfs.
The related gtfs_ride based on operator_ref, line_ref and scheduled_start_time. Populated by stride-etl-siri-update-rides-gtfs.
The related gtfs_ride based on best match from either journey_gtfs_ride_id or route_gtfs_ride_id. Populated by stride-etl-siri-update-rides-gtfs.
A siri_stop along a specified siri_ride. Populated in near real time from the SIRI data by siri-etl-process-snapshot-new-snapshots-daemon.
The related siri_stop.
The related siri_ride.
The order of this stop along the ride, first stop is 0.
The related gtfs_stop. Populated via stride-etl-siri-update-ride-stops-gtfs.
The siri vehicle location from this ride which is nearest to the gtfs_stop.lon / gtfs_stop.lat. Populated via stride-etl-siri-update-ride-stops-vehicle-locations.
A SIRI route, populated in near real time from the SIRI data by siri-etl-process-snapshot-new-snapshots-daemon. Multiple rides can occur on a route, these are available in siri_ride and related by siri_ride.siri_route_id.
In combination with the operator_ref - uniquely identifies the route and relates to the GTFS identifiers
In combination with the line_ref - uniquely identifies the route and relates to the GTFS identifiers
A SIRI stop, populated in near real time from the SIRI data by siri-etl-process-snapshot-new-snapshots-daemon.
Corresponds to the GTFS stop code, as received from the SIRI data.
A vehicle location, accurate to within 1 minute, populated in near real time from the SIRI data by siri-etl-process-snapshot-new-snapshots-daemon.
The siri_snapshot which contained this vehicle location.
The siri_ride_stop which is nearest to this vehicle location. This relation can be used to get all relevant details like route / ride / stop relating to this location.
The date/time when this location was recorded according to the MOT SIRI data.
The geographical lon of this vehicle at the recorded time, according to the MOT SIRI data.
The geographical lat of this vehicle at the recorded time, according to the MOT SIRI data.
The bearing of this vehicle at the recorded time, according to the MOT SIRI data.
The velocity of this vehicle at the recorded time, according to the MOT SIRI data.
The distance from journey start of this vehicle at the recorded time, according to the MOT SIRI data.
Distance from the nearest siri_ride_stop according to the GTFS stop location. Populated via stride-etl-siri-update-ride-stops-vehicle-locations.
A SIRI Snapshot which was received from MOT. We get a new snapshot every 1 minute via siri-etl-process-snapshot-new-snapshots-daemon
A string which uniquely identifies the snapshot and the date/time when it was taken. Uses the following format: year/month/day/hours/minutes (e.g. 2022/03/09/11/08).
Describes the ETL status of this snapshot, only snapshots with status "loaded" should be considered ready for usage.
If the ETL processing failed for this snapshot, will contain the error message.
Number of siri_vehicle_locations which were successfully parsed from this SIRI snapshot.
Number of siri_vehicle_locations which failed to be parsed from this SIRI snapshot.
Number of new siri_rides which were added as a result of processing this SIRI snapshot.
Number of new siri_ride_stops which were added as a result of processing this SIRI snapshot.
Number of new siri_routes which were added as a result of processing this SIRI snapshot.
Number of new siri_stops which were added as a result of processing this SIRI snapshot.