Hi all,
Thanks a lot for the prompt responses.
Phil has solved my problem. They all have an actual_timestamp, but
none of them have a planned_timestamp. All of them are off-route,
which explains it.
Given that this occurs with such a huge frequency, am I right to
assume that off-route can include, for example, trains returning to
the depot etc.?
Thanks a lot, and all the best,
Neil
{"header":{"msg_type":"0003","source_dev_id":"","user_id":"","original_data_source":"SMART","msg_queue_timestamp":"1432308224000","source_system_id":"TRUST"},"body":{"event_type":"ARRIVAL","gbtt_timestamp":"","original_loc_stanox":"","planned_timestamp":"","timetable_variation":"0","original_loc_timestamp":"","current_train_id":"","delay_monitoring_point":"false","next_report_run_time":"","reporting_stanox":"","actual_timestamp":"1432311840000","correction_ind":"false","event_source":"AUTOMATIC","train_file_address":null,"platform":"","division_code":"88","train_terminated":"false","train_id":"533J05MR22","offroute_ind":"true","variation_status":"OFF
ROUTE","train_service_code":"21788001","toc_id":"88","loc_stanox":"54297","auto_expected":"","direction_ind":"","route":"","planned_event_type":"ARRIVAL","next_report_stanox":"","line_ind":""}}
{"header":{"msg_type":"0003","source_dev_id":"","user_id":"","original_data_source":"SMART","msg_queue_timestamp":"1432308225000","source_system_id":"TRUST"},"body":{"event_type":"DEPARTURE","gbtt_timestamp":"","original_loc_stanox":"","planned_timestamp":"","timetable_variation":"0","original_loc_timestamp":"","current_train_id":"","delay_monitoring_point":"false","next_report_run_time":"","reporting_stanox":"","actual_timestamp":"1432311780000","correction_ind":"false","event_source":"AUTOMATIC","train_file_address":null,"platform":"","division_code":"80","train_terminated":"false","train_id":"882R50MS22","offroute_ind":"true","variation_status":"OFF
ROUTE","train_service_code":"24605000","toc_id":"80","loc_stanox":"88409","auto_expected":"","direction_ind":"","route":"","planned_event_type":"DEPARTURE","next_report_stanox":"","line_ind":""}}
{"header":{"msg_type":"0003","source_dev_id":"","user_id":"","original_data_source":"SMART","msg_queue_timestamp":"1432308243000","source_system_id":"TRUST"},"body":{"event_type":"DEPARTURE","gbtt_timestamp":"","original_loc_stanox":"","planned_timestamp":"","timetable_variation":"0","original_loc_timestamp":"","current_train_id":"","delay_monitoring_point":"false","next_report_run_time":"","reporting_stanox":"","actual_timestamp":"1432311780000","correction_ind":"false","event_source":"AUTOMATIC","train_file_address":null,"platform":"","division_code":"84","train_terminated":"false","train_id":"871L49MS22","offroute_ind":"true","variation_status":"OFF
ROUTE","train_service_code":"24623104","toc_id":"84","loc_stanox":"87214","auto_expected":"","direction_ind":"","route":"","planned_event_type":"DEPARTURE","next_report_stanox":"","line_ind":""}}
{"header":{"msg_type":"0003","source_dev_id":"","user_id":"","original_data_source":"SMART","msg_queue_timestamp":"1432308309000","source_system_id":"TRUST"},"body":{"event_type":"ARRIVAL","gbtt_timestamp":"","original_loc_stanox":"","planned_timestamp":"","timetable_variation":"0","original_loc_timestamp":"","current_train_id":"","delay_monitoring_point":"false","next_report_run_time":"","reporting_stanox":"","actual_timestamp":"1432311960000","correction_ind":"false","event_source":"AUTOMATIC","train_file_address":null,"platform":"","division_code":"21","train_terminated":"false","train_id":"521K66MS22","offroute_ind":"true","variation_status":"OFF
ROUTE","train_service_code":"25943001","toc_id":"21","loc_stanox":"50401","auto_expected":"","direction_ind":"","route":"","planned_event_type":"ARRIVAL","next_report_stanox":"","line_ind":""}}
{"header":{"msg_type":"0003","source_dev_id":"","user_id":"","original_data_source":"SMART","msg_queue_timestamp":"1432308325000","source_system_id":"TRUST"},"body":{"event_type":"ARRIVAL","gbtt_timestamp":"","original_loc_stanox":"","planned_timestamp":"","timetable_variation":"0","original_loc_timestamp":"","current_train_id":"","delay_monitoring_point":"false","next_report_run_time":"","reporting_stanox":"","actual_timestamp":"1432311960000","correction_ind":"false","event_source":"AUTOMATIC","train_file_address":null,"platform":"","division_code":"25","train_terminated":"false","train_id":"731Z402S22","offroute_ind":"true","variation_status":"OFF
ROUTE","train_service_code":"25516005","toc_id":"25","loc_stanox":"73770","auto_expected":"","direction_ind":"","route":"","planned_event_type":"ARRIVAL","next_report_stanox":"","line_ind":""}}
{"header":{"msg_type":"0003","source_dev_id":"","user_id":"","original_data_source":"SMART","msg_queue_timestamp":"1432308329000","source_system_id":"TRUST"},"body":{"event_type":"ARRIVAL","gbtt_timestamp":"","original_loc_stanox":"","planned_timestamp":"","timetable_variation":"0","original_loc_timestamp":"","current_train_id":"","delay_monitoring_point":"false","next_report_run_time":"","reporting_stanox":"","actual_timestamp":"1432311900000","correction_ind":"false","event_source":"AUTOMATIC","train_file_address":null,"platform":"","division_code":"84","train_terminated":"false","train_id":"871W73MS22","offroute_ind":"true","variation_status":"OFF
ROUTE","train_service_code":"24620204","toc_id":"84","loc_stanox":"86005","auto_expected":"","direction_ind":"","route":"","planned_event_type":"ARRIVAL","next_report_stanox":"","line_ind":""}}
{"header":{"msg_type":"0003","source_dev_id":"","user_id":"","original_data_source":"SMART","msg_queue_timestamp":"1432308333000","source_system_id":"TRUST"},"body":{"event_type":"DEPARTURE","gbtt_timestamp":"","original_loc_stanox":"","planned_timestamp":"","timetable_variation":"0","original_loc_timestamp":"","current_train_id":"","delay_monitoring_point":"false","next_report_run_time":"","reporting_stanox":"","actual_timestamp":"1432311900000","correction_ind":"false","event_source":"AUTOMATIC","train_file_address":null,"platform":"","division_code":"21","train_terminated":"false","train_id":"521K66MS22","offroute_ind":"true","variation_status":"OFF
ROUTE","train_service_code":"25943001","toc_id":"21","loc_stanox":"50401","auto_expected":"","direction_ind":"","route":"","planned_event_type":"DEPARTURE","next_report_stanox":"","line_ind":""}}
{"header":{"msg_type":"0003","source_dev_id":"","user_id":"","original_data_source":"SMART","msg_queue_timestamp":"1432308343000","source_system_id":"TRUST"},"body":{"event_type":"DEPARTURE","gbtt_timestamp":"","original_loc_stanox":"","planned_timestamp":"","timetable_variation":"0","original_loc_timestamp":"","current_train_id":"","delay_monitoring_point":"false","next_report_run_time":"","reporting_stanox":"","actual_timestamp":"1432311900000","correction_ind":"false","event_source":"AUTOMATIC","train_file_address":null,"platform":"","division_code":"61","train_terminated":"false","train_id":"541D20MR22","offroute_ind":"true","variation_status":"OFF
ROUTE","train_service_code":"21702001","toc_id":"61","loc_stanox":"45013","auto_expected":"","direction_ind":"","route":"","planned_event_type":"DEPARTURE","next_report_stanox":"","line_ind":""}}
{"header":{"msg_type":"0003","source_dev_id":"","user_id":"","original_data_source":"SMART","msg_queue_timestamp":"1432308344000","source_system_id":"TRUST"},"body":{"event_type":"ARRIVAL","gbtt_timestamp":"","original_loc_stanox":"","planned_timestamp":"","timetable_variation":"0","original_loc_timestamp":"","current_train_id":"","delay_monitoring_point":"false","next_report_run_time":"","reporting_stanox":"","actual_timestamp":"1432311900000","correction_ind":"false","event_source":"AUTOMATIC","train_file_address":null,"platform":"","division_code":"82","train_terminated":"false","train_id":"872L44MS22","offroute_ind":"true","variation_status":"OFF
ROUTE","train_service_code":"24610000","toc_id":"82","loc_stanox":"87203","auto_expected":"","direction_ind":"","route":"","planned_event_type":"ARRIVAL","next_report_stanox":"","line_ind":""}}
{"header":{"msg_type":"0003","source_dev_id":"","user_id":"","original_data_source":"SMART","msg_queue_timestamp":"1432308350000","source_system_id":"TRUST"},"body":{"event_type":"ARRIVAL","gbtt_timestamp":"","original_loc_stanox":"","planned_timestamp":"","timetable_variation":"0","original_loc_timestamp":"","current_train_id":"","delay_monitoring_point":"false","next_report_run_time":"","reporting_stanox":"","actual_timestamp":"1432311900000","correction_ind":"false","event_source":"AUTOMATIC","train_file_address":null,"platform":"","division_code":"82","train_terminated":"false","train_id":"871A27MQ22","offroute_ind":"true","variation_status":"OFF
ROUTE","train_service_code":"24663004","toc_id":"82","loc_stanox":"87203","auto_expected":"","direction_ind":"","route":"","planned_event_type":"ARRIVAL","next_report_stanox":"","line_ind":""}}
{"header":{"msg_type":"0003","source_dev_id":"","user_id":"","original_data_source":"SMART","msg_queue_timestamp":"1432308354000","source_system_id":"TRUST"},"body":{"event_type":"DEPARTURE","gbtt_timestamp":"","original_loc_stanox":"","planned_timestamp":"","timetable_variation":"0","original_loc_timestamp":"","current_train_id":"","delay_monitoring_point":"false","next_report_run_time":"","reporting_stanox":"","actual_timestamp":"1432311900000","correction_ind":"false","event_source":"AUTOMATIC","train_file_address":null,"platform":"","division_code":"84","train_terminated":"false","train_id":"871W73MS22","offroute_ind":"true","variation_status":"OFF
ROUTE","train_service_code":"24620204","toc_id":"84","loc_stanox":"86005","auto_expected":"","direction_ind":"","route":"","planned_event_type":"DEPARTURE","next_report_stanox":"","line_ind":""}}
{"header":{"msg_type":"0003","source_dev_id":"","user_id":"","original_data_source":"SMART","msg_queue_timestamp":"1432308355000","source_system_id":"TRUST"},"body":{"event_type":"DEPARTURE","gbtt_timestamp":"","original_loc_stanox":"","planned_timestamp":"","timetable_variation":"0","original_loc_timestamp":"","current_train_id":"","delay_monitoring_point":"false","next_report_run_time":"","reporting_stanox":"","actual_timestamp":"1432311900000","correction_ind":"false","event_source":"AUTOMATIC","train_file_address":null,"platform":"","division_code":"25","train_terminated":"false","train_id":"731Z402S22","offroute_ind":"true","variation_status":"OFF
ROUTE","train_service_code":"25516005","toc_id":"25","loc_stanox":"73770","auto_expected":"","direction_ind":"","route":"","planned_event_type":"DEPARTURE","next_report_stanox":"","line_ind":""}}
{"header":{"msg_type":"0003","source_dev_id":"","user_id":"","original_data_source":"SMART","msg_queue_timestamp":"1432308356000","source_system_id":"TRUST"},"body":{"event_type":"DEPARTURE","gbtt_timestamp":"","original_loc_stanox":"","planned_timestamp":"","timetable_variation":"0","original_loc_timestamp":"","current_train_id":"","delay_monitoring_point":"false","next_report_run_time":"","reporting_stanox":"","actual_timestamp":"1432311960000","correction_ind":"false","event_source":"AUTOMATIC","train_file_address":null,"platform":"","division_code":"80","train_terminated":"false","train_id":"881H02MS22","offroute_ind":"true","variation_status":"OFF
ROUTE","train_service_code":"24602000","toc_id":"80","loc_stanox":"88409","auto_expected":"","direction_ind":"","route":"","planned_event_type":"DEPARTURE","next_report_stanox":"","line_ind":""}}