Anyone have a capture of the TRUST STOMP feed from last years BST->GMT change?

[Peter Wood]

Hey Folks,

Does anyone have a capture of the TRUST feed from the last BST->GMT switch (27 Oct 2024) - specifically between 12am and 3am? 

I suspect I'm caring about very few trains that are actually travelling at that time, but I'd like to get my logic correct.

Given that many of the movement timestamps are sent with the incorrect epoch timestamp (during BST), I'm trying to figure out what logic I'll need to put in place to ensure that I handle the times correctly once the clocks go back. I suspect I'll see time reverse back an hour at 2AM BST back to 1AM GMT and the epoch time becomes a valid epoch stamp - but I'm guessing.

An example for the coming October transition is the 01:05 Waterloo -> Southhampton (1B01/L46931/2025-10-26). I also note that the schedule times appear to be completely from the perspective of timezone the journey started in (at least for BST->UTC), even though the clocks change half way through the journey.

I'd love to get a capture of the actual data from last year, it'd be great to write some tests with real data.

I need to write something on my side to start archiving the feed - but doesn't help me retroactively. :D

Cheers,

Peter.

[Tom Cairns]

Hi Peter

 

On BST -> GMT switches, the TRUST feed just completely stops for the second 0100-0159. Trains generally operate in the timezone that they start in until completion, although there is a level of ambiguity if you have two 1am trains as to which one operates when. Manual reports are then put in where appropriate.

 

This is a full list of messages I can find from the NROD feed for 871B01M127 on 27^th October 2024:

 

{"header":{"msg_type":"0001","msg_queue_timestamp":"1729983933000","source_system_id":"TRUST","original_data_source":"TSIA"},"body":{"train_id":"871B01M127","toc_id":"84","schedule_wtt_id":"1B01M","sched_origin_stanox":"87212","creation_timestamp":"1729987531000","origin_dep_timestamp":"1729991100000","train_uid":"L56607","schedule_start_date":"2024-10-27","schedule_end_date":"2024-10-27","schedule_source":"C","schedule_type":"P","d1266_record_number":"00000","tp_origin_timestamp":"2024-10-27","train_call_type":"AUTOMATIC","train_call_mode":"NORMAL","train_service_code":"24620204"}}

{"header":{"msg_type":"0003","msg_queue_timestamp":"1729987531000","source_system_id":"TRUST","original_data_source":"SMART"},"body":{"train_id":"871B01M127","actual_timestamp":"1729991100000","loc_stanox":"87212","gbtt_timestamp":"1729991100000","planned_timestamp":"1729991100000","planned_event_type":"DEPARTURE","event_type":"DEPARTURE","event_source":"AUTOMATIC","correction_ind":"false","offroute_ind":"false","direction_ind":"DOWN","line_ind":"F","platform":"11","route":"1","train_service_code":"24620204","division_code":"84","toc_id":"84","timetable_variation":"0","variation_status":"ON TIME","next_report_stanox":"87286","next_report_run_time":"1","train_terminated":"false","delay_monitoring_point":"true","reporting_stanox":"87212","auto_expected":"true"}}

{"header":{"msg_type":"0003","msg_queue_timestamp":"1729987654000","source_system_id":"TRUST","original_data_source":"GPS","user_id":"GPSI07"},"body":{"train_id":"871B01M127","actual_timestamp":"1729991220000","loc_stanox":"87286","planned_timestamp":"1729991190000","planned_event_type":"DEPARTURE","event_type":"DEPARTURE","event_source":"MANUAL","correction_ind":"false","offroute_ind":"false","train_service_code":"24620204","division_code":"84","toc_id":"84","timetable_variation":"1","variation_status":"LATE","next_report_stanox":"87214","next_report_run_time":"2","train_terminated":"false","delay_monitoring_point":"false","reporting_stanox":"00000"}}

{"header":{"msg_type":"0003","msg_queue_timestamp":"1729987678000","source_system_id":"TRUST","original_data_source":"SMART"},"body":{"train_id":"871B01M127","actual_timestamp":"1729991280000","loc_stanox":"87214","gbtt_timestamp":"1729991340000","planned_timestamp":"1729991310000","planned_event_type":"ARRIVAL","event_type":"ARRIVAL","event_source":"AUTOMATIC","correction_ind":"false","offroute_ind":"false","direction_ind":"DOWN","platform":" 6","route":"0","train_service_code":"24620204","division_code":"84","toc_id":"84","timetable_variation":"0","variation_status":"ON TIME","next_report_stanox":"87219","next_report_run_time":"1","train_terminated":"false","delay_monitoring_point":"true","reporting_stanox":"87214","auto_expected":"true"}}

{"header":{"msg_type":"0003","msg_queue_timestamp":"1729987899000","source_system_id":"TRUST","original_data_source":"SMART"},"body":{"train_id":"871B01M127","actual_timestamp":"1729991460000","loc_stanox":"87214","gbtt_timestamp":"1729991340000","planned_timestamp":"1729991370000","planned_event_type":"DEPARTURE","event_type":"DEPARTURE","event_source":"AUTOMATIC","correction_ind":"false","offroute_ind":"false","direction_ind":"DOWN","platform":" 6","route":"1","train_service_code":"24620204","division_code":"84","toc_id":"84","timetable_variation":"2","variation_status":"LATE","next_report_stanox":"87219","next_report_run_time":"4","train_terminated":"false","delay_monitoring_point":"true","reporting_stanox":"87214","auto_expected":"true"}}

{"header":{"msg_type":"0003","msg_queue_timestamp":"1729988048000","source_system_id":"TRUST","original_data_source":"SMART"},"body":{"train_id":"871B01M127","actual_timestamp":"1729991640000","loc_stanox":"87219","gbtt_timestamp":"1729991640000","planned_timestamp":"1729991610000","planned_event_type":"ARRIVAL","event_type":"ARRIVAL","event_source":"AUTOMATIC","correction_ind":"false","offroute_ind":"false","direction_ind":"DOWN","platform":" 9","route":"0","train_service_code":"24620204","division_code":"84","toc_id":"84","timetable_variation":"1","variation_status":"LATE","next_report_stanox":"87261","next_report_run_time":"1","train_terminated":"false","delay_monitoring_point":"true","reporting_stanox":"87219","auto_expected":"true"}}

{"header":{"msg_type":"0003","msg_queue_timestamp":"1729988213000","source_system_id":"TRUST","original_data_source":"SMART"},"body":{"train_id":"871B01M127","actual_timestamp":"1729991760000","loc_stanox":"87219","gbtt_timestamp":"1729991700000","planned_timestamp":"1729991700000","planned_event_type":"DEPARTURE","event_type":"DEPARTURE","event_source":"AUTOMATIC","correction_ind":"false","offroute_ind":"false","direction_ind":"DOWN","line_ind":"F","platform":" 9","route":"6","train_service_code":"24620204","division_code":"84","toc_id":"84","timetable_variation":"1","variation_status":"LATE","next_report_stanox":"87261","next_report_run_time":"5","train_terminated":"false","delay_monitoring_point":"true","reporting_stanox":"87219","auto_expected":"true"}}

{"header":{"msg_type":"0003","msg_queue_timestamp":"1729988328000","source_system_id":"TRUST","original_data_source":"SMART"},"body":{"train_id":"871B01M127","actual_timestamp":"1729991880000","loc_stanox":"87250","planned_event_type":"DEPARTURE","event_type":"DEPARTURE","event_source":"AUTOMATIC","correction_ind":"false","offroute_ind":"true","train_service_code":"24620204","division_code":"84","toc_id":"84","timetable_variation":"0","variation_status":"OFF ROUTE","train_terminated":"false","delay_monitoring_point":"false"}}

{"header":{"msg_type":"0003","msg_queue_timestamp":"1729988413000","source_system_id":"TRUST","original_data_source":"SMART"},"body":{"train_id":"871B01M127","actual_timestamp":"1729992000000","loc_stanox":"87261","gbtt_timestamp":"1729992000000","planned_timestamp":"1729992000000","planned_event_type":"ARRIVAL","event_type":"ARRIVAL","event_source":"AUTOMATIC","correction_ind":"false","offroute_ind":"false","direction_ind":"DOWN","platform":" 7","route":"0","train_service_code":"24620204","division_code":"84","toc_id":"84","timetable_variation":"0","variation_status":"ON TIME","next_report_stanox":"87262","next_report_run_time":"1","train_terminated":"false","delay_monitoring_point":"true","reporting_stanox":"87261","auto_expected":"true"}}

{"header":{"msg_type":"0003","msg_queue_timestamp":"1729988545000","source_system_id":"TRUST","original_data_source":"SMART"},"body":{"train_id":"871B01M127","actual_timestamp":"1729992120000","loc_stanox":"87261","gbtt_timestamp":"1729992060000","planned_timestamp":"1729992060000","planned_event_type":"DEPARTURE","event_type":"DEPARTURE","event_source":"AUTOMATIC","correction_ind":"false","offroute_ind":"false","direction_ind":"DOWN","line_ind":"S","platform":" 7","route":"1","train_service_code":"24620204","division_code":"84","toc_id":"84","timetable_variation":"1","variation_status":"LATE","next_report_stanox":"87262","next_report_run_time":"1","train_terminated":"false","delay_monitoring_point":"true","reporting_stanox":"87261","auto_expected":"true"}}

{"header":{"msg_type":"0003","msg_queue_timestamp":"1729988670000","source_system_id":"TRUST","original_data_source":"SMART"},"body":{"train_id":"871B01M127","actual_timestamp":"1729992300000","loc_stanox":"87271","planned_timestamp":"1729992240000","planned_event_type":"ARRIVAL","event_type":"ARRIVAL","event_source":"AUTOMATIC","correction_ind":"false","offroute_ind":"false","route":"0","train_service_code":"24620204","division_code":"84","toc_id":"84","timetable_variation":"1","variation_status":"LATE","next_report_stanox":"87169","next_report_run_time":"1","train_terminated":"false","delay_monitoring_point":"false","reporting_stanox":"00000","auto_expected":"true"}}

{"header":{"msg_type":"0003","msg_queue_timestamp":"1729988702000","source_system_id":"TRUST","original_data_source":"SMART"},"body":{"train_id":"871B01M127","actual_timestamp":"1729992240000","loc_stanox":"87271","planned_timestamp":"1729992240000","planned_event_type":"DEPARTURE","event_type":"DEPARTURE","event_source":"AUTOMATIC","correction_ind":"false","offroute_ind":"false","direction_ind":"DOWN","line_ind":"S","platform":" 3","route":"2","train_service_code":"24620204","division_code":"84","toc_id":"84","timetable_variation":"0","variation_status":"ON TIME","next_report_stanox":"87169","next_report_run_time":"1","train_terminated":"false","delay_monitoring_point":"false","reporting_stanox":"00000","auto_expected":"true"}}

{"header":{"msg_type":"0003","msg_queue_timestamp":"1729988736000","source_system_id":"TRUST","original_data_source":"SMART"},"body":{"train_id":"871B01M127","actual_timestamp":"1729992360000","loc_stanox":"87169","planned_timestamp":"1729992330000","planned_event_type":"ARRIVAL","event_type":"ARRIVAL","event_source":"AUTOMATIC","correction_ind":"false","offroute_ind":"false","route":"0","train_service_code":"24620204","division_code":"84","toc_id":"84","timetable_variation":"1","variation_status":"LATE","next_report_stanox":"87171","next_report_run_time":"1","train_terminated":"false","delay_monitoring_point":"true","reporting_stanox":"87169","auto_expected":"true"}}

{"header":{"msg_type":"0003","msg_queue_timestamp":"1729988757000","source_system_id":"TRUST","original_data_source":"SMART"},"body":{"train_id":"871B01M127","actual_timestamp":"1729992300000","loc_stanox":"87169","planned_timestamp":"1729992330000","planned_event_type":"DEPARTURE","event_type":"DEPARTURE","event_source":"AUTOMATIC","correction_ind":"false","offroute_ind":"false","direction_ind":"DOWN","line_ind":"S","platform":" 3","route":"1","train_service_code":"24620204","division_code":"84","toc_id":"84","timetable_variation":"0","variation_status":"ON TIME","next_report_stanox":"87171","next_report_run_time":"3","train_terminated":"false","delay_monitoring_point":"true","reporting_stanox":"87169","auto_expected":"true"}}

{"header":{"msg_type":"0003","msg_queue_timestamp":"1729988859000","source_system_id":"TRUST","original_data_source":"SMART"},"body":{"train_id":"871B01M127","actual_timestamp":"1729992480000","loc_stanox":"87171","gbtt_timestamp":"1729992540000","planned_timestamp":"1729992510000","planned_event_type":"ARRIVAL","event_type":"ARRIVAL","event_source":"AUTOMATIC","correction_ind":"false","offroute_ind":"false","direction_ind":"DOWN","platform":" 3","route":"0","train_service_code":"24620204","division_code":"84","toc_id":"84","timetable_variation":"0","variation_status":"ON TIME","next_report_stanox":"87177","next_report_run_time":"1","train_terminated":"false","delay_monitoring_point":"true","reporting_stanox":"87171","auto_expected":"true"}}

{"header":{"msg_type":"0003","msg_queue_timestamp":"1729989020000","source_system_id":"TRUST","original_data_source":"SMART"},"body":{"train_id":"871B01M127","actual_timestamp":"1729992600000","loc_stanox":"87171","gbtt_timestamp":"1729992540000","planned_timestamp":"1729992570000","planned_event_type":"DEPARTURE","event_type":"DEPARTURE","event_source":"AUTOMATIC","correction_ind":"false","offroute_ind":"false","direction_ind":"DOWN","platform":" 3","route":"1","train_service_code":"24620204","division_code":"84","toc_id":"84","timetable_variation":"1","variation_status":"LATE","next_report_stanox":"87177","next_report_run_time":"2","train_terminated":"false","delay_monitoring_point":"true","reporting_stanox":"87171","auto_expected":"true"}}

{"header":{"msg_type":"0003","msg_queue_timestamp":"1729989099000","source_system_id":"TRUST","original_data_source":"SMART"},"body":{"train_id":"871B01M127","actual_timestamp":"1729992660000","loc_stanox":"87177","planned_timestamp":"1729992690000","planned_event_type":"DEPARTURE","event_type":"DEPARTURE","event_source":"AUTOMATIC","correction_ind":"false","offroute_ind":"false","direction_ind":"DOWN","line_ind":"S","platform":" 3","route":"1","train_service_code":"24620204","division_code":"84","toc_id":"84","timetable_variation":"0","variation_status":"ON TIME","next_report_stanox":"86005","next_report_run_time":"5","train_terminated":"false","delay_monitoring_point":"false","reporting_stanox":"00000","auto_expected":"true"}}

{"header":{"msg_type":"0003","msg_queue_timestamp":"1729989356000","source_system_id":"TRUST","original_data_source":"SMART"},"body":{"train_id":"871B01M127","actual_timestamp":"1729992960000","loc_stanox":"86005","planned_timestamp":"1729992960000","planned_event_type":"ARRIVAL","event_type":"ARRIVAL","event_source":"AUTOMATIC","correction_ind":"false","offroute_ind":"false","route":"0","train_service_code":"24620204","division_code":"84","toc_id":"84","timetable_variation":"0","variation_status":"ON TIME","next_report_stanox":"86022","next_report_run_time":"1","train_terminated":"false","delay_monitoring_point":"true","reporting_stanox":"86005","auto_expected":"true"}}

{"header":{"msg_type":"0003","msg_queue_timestamp":"1729989381000","source_system_id":"TRUST","original_data_source":"SMART"},"body":{"train_id":"871B01M127","actual_timestamp":"1729992960000","loc_stanox":"86005","planned_timestamp":"1729992960000","planned_event_type":"DEPARTURE","event_type":"DEPARTURE","event_source":"AUTOMATIC","correction_ind":"false","offroute_ind":"false","direction_ind":"DOWN","line_ind":"S","platform":" 3","route":"1","train_service_code":"24620204","division_code":"84","toc_id":"84","timetable_variation":"0","variation_status":"ON TIME","next_report_stanox":"86022","next_report_run_time":"1","train_terminated":"false","delay_monitoring_point":"true","reporting_stanox":"86005","auto_expected":"true"}}

{"header":{"msg_type":"0003","msg_queue_timestamp":"1729989407000","source_system_id":"TRUST","original_data_source":"SMART"},"body":{"train_id":"871B01M127","actual_timestamp":"1729993020000","loc_stanox":"86022","planned_timestamp":"1729993020000","planned_event_type":"ARRIVAL","event_type":"ARRIVAL","event_source":"AUTOMATIC","correction_ind":"false","offroute_ind":"false","route":"0","train_service_code":"24620204","division_code":"84","toc_id":"84","timetable_variation":"0","variation_status":"ON TIME","next_report_stanox":"86031","next_report_run_time":"1","train_terminated":"false","delay_monitoring_point":"false","reporting_stanox":"00000","auto_expected":"true"}}

{"header":{"msg_type":"0003","msg_queue_timestamp":"1729989433000","source_system_id":"TRUST","original_data_source":"SMART"},"body":{"train_id":"871B01M127","actual_timestamp":"1729993020000","loc_stanox":"86022","planned_timestamp":"1729993020000","planned_event_type":"DEPARTURE","event_type":"DEPARTURE","event_source":"AUTOMATIC","correction_ind":"false","offroute_ind":"false","direction_ind":"DOWN","line_ind":"S","platform":" 2","route":"2","train_service_code":"24620204","division_code":"84","toc_id":"84","timetable_variation":"0","variation_status":"ON TIME","next_report_stanox":"86031","next_report_run_time":"4","train_terminated":"false","delay_monitoring_point":"false","reporting_stanox":"00000","auto_expected":"true"}}

{"header":{"msg_type":"0003","msg_queue_timestamp":"1729989629000","source_system_id":"TRUST","original_data_source":"SMART"},"body":{"train_id":"871B01M127","actual_timestamp":"1729993260000","loc_stanox":"86031","gbtt_timestamp":"1729993260000","planned_timestamp":"1729993260000","planned_event_type":"ARRIVAL","event_type":"ARRIVAL","event_source":"AUTOMATIC","correction_ind":"false","offroute_ind":"false","direction_ind":"DOWN","platform":" 5","route":"0","train_service_code":"24620204","division_code":"84","toc_id":"84","timetable_variation":"0","variation_status":"ON TIME","next_report_stanox":"86040","next_report_run_time":"8","train_terminated":"false","delay_monitoring_point":"true","reporting_stanox":"86031","auto_expected":"true"}}

{"header":{"msg_type":"0003","msg_queue_timestamp":"1729990163000","source_system_id":"TRUST","original_data_source":"SMART"},"body":{"train_id":"871B01M127","actual_timestamp":"1729993740000","loc_stanox":"86031","gbtt_timestamp":"1729993740000","planned_timestamp":"1729993770000","planned_event_type":"DEPARTURE","event_type":"DEPARTURE","event_source":"AUTOMATIC","correction_ind":"false","offroute_ind":"false","direction_ind":"DOWN","line_ind":"S","platform":" 5","route":"1","train_service_code":"24620204","division_code":"84","toc_id":"84","timetable_variation":"0","variation_status":"ON TIME","next_report_stanox":"86040","next_report_run_time":"1","train_terminated":"false","delay_monitoring_point":"true","reporting_stanox":"86031","auto_expected":"true"}}

{"header":{"msg_type":"0003","msg_queue_timestamp":"1729990269000","source_system_id":"TRUST","original_data_source":"SMART"},"body":{"train_id":"871B01M127","actual_timestamp":"1729993860000","loc_stanox":"86040","planned_timestamp":"1729993830000","planned_event_type":"DEPARTURE","event_type":"DEPARTURE","event_source":"AUTOMATIC","correction_ind":"false","offroute_ind":"false","direction_ind":"DOWN","line_ind":"S","route":"1","train_service_code":"24620204","division_code":"84","toc_id":"84","timetable_variation":"1","variation_status":"LATE","next_report_stanox":"87043","next_report_run_time":"4","train_terminated":"false","delay_monitoring_point":"false","reporting_stanox":"00000","auto_expected":"true"}}

{"header":{"msg_type":"0003","msg_queue_timestamp":"1729990455000","source_system_id":"TRUST","original_data_source":"SMART"},"body":{"train_id":"871B01M127","actual_timestamp":"1729994040000","loc_stanox":"87043","planned_timestamp":"1729994040000","planned_event_type":"DEPARTURE","event_type":"DEPARTURE","event_source":"AUTOMATIC","correction_ind":"false","offroute_ind":"false","direction_ind":"DOWN","line_ind":"S","route":"1","train_service_code":"24620204","division_code":"84","toc_id":"84","timetable_variation":"0","variation_status":"ON TIME","next_report_stanox":"86042","next_report_run_time":"4","train_terminated":"false","delay_monitoring_point":"false","reporting_stanox":"00000","auto_expected":"true"}}

{"header":{"msg_type":"0003","msg_queue_timestamp":"1729990610000","source_system_id":"TRUST","original_data_source":"SMART"},"body":{"train_id":"871B01M127","actual_timestamp":"1729994280000","loc_stanox":"86042","gbtt_timestamp":"1729994280000","planned_timestamp":"1729994280000","planned_event_type":"ARRIVAL","event_type":"ARRIVAL","event_source":"AUTOMATIC","correction_ind":"false","offroute_ind":"false","direction_ind":"DOWN","line_ind":"S","platform":" 2","route":"0","train_service_code":"24620204","division_code":"84","toc_id":"84","timetable_variation":"0","variation_status":"ON TIME","next_report_stanox":"86045","next_report_run_time":"1","train_terminated":"false","delay_monitoring_point":"true","reporting_stanox":"86042","auto_expected":"true"}}

{"header":{"msg_type":"0003","msg_queue_timestamp":"1729990775000","source_system_id":"TRUST","original_data_source":"SMART"},"body":{"train_id":"871B01M127","actual_timestamp":"1729994340000","loc_stanox":"86042","gbtt_timestamp":"1729994340000","planned_timestamp":"1729994340000","planned_event_type":"DEPARTURE","event_type":"DEPARTURE","event_source":"AUTOMATIC","correction_ind":"false","offroute_ind":"false","direction_ind":"DOWN","line_ind":"S","platform":" 2","route":"1","train_service_code":"24620204","division_code":"84","toc_id":"84","timetable_variation":"0","variation_status":"ON TIME","next_report_stanox":"86045","next_report_run_time":"4","train_terminated":"false","delay_monitoring_point":"true","reporting_stanox":"86042","auto_expected":"true"}}

{"header":{"msg_type":"0003","msg_queue_timestamp":"1730013509000","source_system_id":"TRUST","original_data_source":"SDR","user_id":"#QCTDA10","source_dev_id":"V8PP"},"body":{"train_id":"871B01M127","actual_timestamp":"1729995300000","loc_stanox":"86066","gbtt_timestamp":"1729995360000","planned_timestamp":"1729995330000","planned_event_type":"ARRIVAL","event_type":"ARRIVAL","event_source":"MANUAL","correction_ind":"false","offroute_ind":"false","route":"0","train_service_code":"24620204","division_code":"84","toc_id":"84","timetable_variation":"0","variation_status":"ON TIME","next_report_stanox":"86069","next_report_run_time":"2","train_terminated":"false","delay_monitoring_point":"true","reporting_stanox":"86066","auto_expected":"true"}}

{"header":{"msg_type":"0003","msg_queue_timestamp":"1730013509000","source_system_id":"TRUST","original_data_source":"SDR","user_id":"#QCTDA10","source_dev_id":"V8PP"},"body":{"train_id":"871B01M127","actual_timestamp":"1729995420000","loc_stanox":"86066","gbtt_timestamp":"1729995420000","planned_timestamp":"1729995450000","planned_event_type":"DEPARTURE","event_type":"DEPARTURE","event_source":"MANUAL","correction_ind":"false","offroute_ind":"false","train_service_code":"24620204","division_code":"84","toc_id":"84","timetable_variation":"0","variation_status":"ON TIME","next_report_stanox":"86069","next_report_run_time":"4","train_terminated":"false","delay_monitoring_point":"true","reporting_stanox":"86066","auto_expected":"true"}}

{"header":{"msg_type":"0003","msg_queue_timestamp":"1730013818000","source_system_id":"TRUST","original_data_source":"SDR","user_id":"#QCTDA10","source_dev_id":"V8PP"},"body":{"train_id":"871B01M127","actual_timestamp":"1729996920000","loc_stanox":"86087","gbtt_timestamp":"1729996920000","planned_timestamp":"1729996920000","planned_event_type":"DESTINATION","event_type":"ARRIVAL","event_source":"MANUAL","correction_ind":"false","offroute_ind":"false","route":"0","train_service_code":"24620204","division_code":"84","toc_id":"84","timetable_variation":"0","variation_status":"ON TIME","train_terminated":"true","delay_monitoring_point":"true","reporting_stanox":"86087","auto_expected":"true"}}

{"header":{"msg_type":"0003","msg_queue_timestamp":"1730014967000","source_system_id":"TRUST","original_data_source":"TRUST DA","user_id":"#QCTDA04","source_dev_id":"LYUE"},"body":{"train_id":"871B01M127","actual_timestamp":"1729995660000","loc_stanox":"86069","planned_timestamp":"1729995660000","planned_event_type":"DEPARTURE","event_type":"DEPARTURE","event_source":"MANUAL","correction_ind":"false","offroute_ind":"false","train_service_code":"24620204","division_code":"84","toc_id":"84","timetable_variation":"0","variation_status":"ON TIME","train_terminated":"true","delay_monitoring_point":"true","reporting_stanox":"86069","auto_expected":"true"}}

{"header":{"msg_type":"0003","msg_queue_timestamp":"1730014983000","source_system_id":"TRUST","original_data_source":"TRUST DA","user_id":"#QCTDA04","source_dev_id":"LYUE"},"body":{"train_id":"871B01M127","actual_timestamp":"1729996320000","loc_stanox":"86083","gbtt_timestamp":"1729996380000","planned_timestamp":"1729996350000","planned_event_type":"ARRIVAL","event_type":"ARRIVAL","event_source":"MANUAL","correction_ind":"false","offroute_ind":"false","route":"0","train_service_code":"24620204","division_code":"84","toc_id":"84","timetable_variation":"0","variation_status":"ON TIME","train_terminated":"true","delay_monitoring_point":"true","reporting_stanox":"86083","auto_expected":"true"}}

{"header":{"msg_type":"0003","msg_queue_timestamp":"1730014987000","source_system_id":"TRUST","original_data_source":"TRUST DA","user_id":"#QCTDA04","source_dev_id":"LYUE"},"body":{"train_id":"871B01M127","actual_timestamp":"1729996440000","loc_stanox":"86083","gbtt_timestamp":"1729996440000","planned_timestamp":"1729996440000","planned_event_type":"DEPARTURE","event_type":"DEPARTURE","event_source":"MANUAL","correction_ind":"false","offroute_ind":"false","train_service_code":"24620204","division_code":"84","toc_id":"84","timetable_variation":"0","variation_status":"ON TIME","train_terminated":"true","delay_monitoring_point":"true","reporting_stanox":"86083","auto_expected":"true"}}

 

Tom

 

--
You received this message because you are subscribed to the Google Groups "A gathering place for the Open Rail Data community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openraildata-t...@googlegroups.com.
To view this discussion, visit https://groups.google.com/d/msgid/openraildata-talk/311e00db-6f18-402e-8657-22af7040c35cn%40googlegroups.com.

[Peter Wood]

Hello Tom,

That was amazingly quick, and increadilby insightful - thank you! That's plenty for me to figure out what's going to happen. The 1am train start ambiguity is fun for sure. The capture of the data is wonderful - thank you. 

Do you know what happens at the GMT->BST shift? I'm assuming in that case TRUST doesn't stop, as there's no duplicate times, but we see time leap forward?

Peter.

[Tom Cairns]

Yes, the times just leap forward an hour.

 

Tom

 

To view this discussion, visit https://groups.google.com/d/msgid/openraildata-talk/50aa3e12-7840-4a18-9a40-7b6f60e9eecbn%40googlegroups.com.