Static files from ETL / processing tasks stored in S3.
Record of downloaded GTFS data from MOT per day. Task and processing status relating to this day's GTFS data.
If the GTFS data was processed using a different date then in the date field, this is the date used.
Record of processing tasks status relating to GTFS data.
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]].
Deprecated: The related gtfs_ride based on journey_ref. Populated by [[stride-etl-siri-update-rides-gtfs]].
Deprecated: 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 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. pending: The snapshot was received from MOT but was not loaded yet. loading: The snapshot is currently being loaded. loaded: The snapshot was successfully loaded. error: An error occured during snapshot loading / processing. deleted: The snapshot was manually deleted to allow reloading.
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.