Multiple OR or DT?

[Rob Green]

Hi folks,

I'm using timetable reference data to create a flattened view that allows me quickly retrieve all (scheduled) departure and arrival times between two destinations.

This obviously has some challenges with associations, but that's relatively easy to overcome.

What I'm a little confused about is the entries in the reference data that contain multiple OR or DT - as these don't necessarily appear to be split journeys.

How are these meant to be treated?

For example - multiple DT:

  <Journey rid="201803197101618" uid="G01618" trainId="2A04" ssd="2018-03-19" toc="LE">

    <OR tpl="LOWSTFT" act="TB" plat="4" ptd="05:25" wtd="05:25" />

    <PP tpl="OULTBNJ" wtp="05:28" />

    <IP tpl="OULTNBS" act="T " pta="05:31" ptd="05:31" wta="05:30:30" wtd="05:31" />

    <IP tpl="BECCLES" act="T " plat="1" pta="05:40" ptd="05:41" wta="05:40" wtd="05:41" />

    <IP tpl="BRAMPTN" act="R " pta="05:49" ptd="05:49" wta="05:48:30" wtd="05:49" />

    <IP tpl="HALSWTH" act="T " plat="1" pta="05:56" ptd="05:56" wta="05:55:30" wtd="05:56:30" />

    <IP tpl="DARSHAM" act="T " plat="1" pta="06:04" ptd="06:05" wta="06:04" wtd="06:05" />

    <IP tpl="SXMNDHM" act="T " plat="1" pta="06:13" ptd="06:13" wta="06:12:30" wtd="06:13:30" />

    <IP tpl="WCKHMMR" act="T " pta="06:23" ptd="06:23" wta="06:22:30" wtd="06:23:30" />

    <IP tpl="MELTON" act="T " pta="06:30" ptd="06:30" wta="06:29:30" wtd="06:30:30" />

    <IP tpl="WODBDGE" act="T " plat="2" pta="06:35" ptd="06:35" wta="06:34:30" wtd="06:35:30" />

    <OPIP tpl="WSTRFLD" act="OP" plat="1" wta="06:45:30" wtd="06:46" />

    <PP tpl="IPSWBHJ" wtp="06:50" />

    <PP tpl="IPSWESJ" wtp="06:51" />

    <DT tpl="IPSWICH" act="TF" planAct="T " plat="2B" pta="06:53" wta="06:53" />

    <PP tpl="IPSWHJN" can="true" wtp="07:01" />

    <PP tpl="MANNTNJ" can="true" wtp="07:09:30" />

    <PP tpl="MANNTEJ" can="true" wtp="07:10:30" />

    <PP tpl="PRKSGJN" can="true" wtp="07:20:30" />

    <DT tpl="PRKSTON" act="TF" can="true" plat="1" pta="07:27" wta="07:25" />

    <cancelReason>574</cancelReason>

  </Journey>

Or - multiple OR:

  <Journey rid="201803188707039" uid="W07039" trainId="2N76" ssd="2018-03-18" toc="SE">

    <OR tpl="CHRX" act="TB" can="true" ptd="21:48" wtd="21:48" />

    <IP tpl="WLOE" act="T " can="true" plat="A" pta="21:50" ptd="21:51" wta="21:50" wtd="21:51" />

    <PP tpl="EWERSTJ" can="true" wtp="21:53" />

    <OR tpl="LNDNBDE" act="TB" planAct="T " plat="8" ptd="21:57" wtd="21:57" />

    <PP tpl="BLUANCR" wtp="21:59:30" />

    <PP tpl="NWCROSS" wtp="22:02" />

    <PP tpl="NWCRTHJ" wtp="22:03" />

    <PP tpl="LEWIVLJ" wtp="22:04" />

    <IP tpl="LEWISHM" act="T " plat="2" pta="22:06" ptd="22:06" wta="22:05:30" wtd="22:06:30" />

    <PP tpl="PKBGJN" wtp="22:08" />

    <IP tpl="HTHRGRN" act="T " plat="6" pta="22:10" ptd="22:11" wta="22:10" wtd="22:11" />

    <IP tpl="LEEE" act="T " plat="2" pta="22:13" ptd="22:13" wta="22:12:30" wtd="22:13" />

    <IP tpl="MOTNGHM" act="T " plat="2" pta="22:16" ptd="22:16" wta="22:15:30" wtd="22:16" />

    <IP tpl="NWELTHM" act="T " plat="2" pta="22:18" ptd="22:18" wta="22:18" wtd="22:18:30" />

    <IP tpl="SIDCUP" act="T " plat="2" pta="22:21" ptd="22:22" wta="22:21" wtd="22:22" />

    <IP tpl="ALBNYPK" act="T " plat="2" pta="22:24" ptd="22:24" wta="22:23:30" wtd="22:24" />

    <IP tpl="BEXLEY" act="T " plat="2" pta="22:26" ptd="22:26" wta="22:26" wtd="22:26:30" />

    <IP tpl="CRFD" act="T " plat="2" pta="22:29" ptd="22:30" wta="22:29" wtd="22:30" />

    <PP tpl="CRFDSPB" wtp="22:31:30" />

    <PP tpl="DARTFDJ" wtp="22:32:30" />

    <IP tpl="DARTFD" act="T " plat="3" pta="22:34" ptd="22:35" wta="22:34" wtd="22:35:30" />

    <IP tpl="STCR" act="T " plat="2" pta="22:39" ptd="22:39" wta="22:39" wtd="22:39:30" />

    <IP tpl="GNHT" act="T " plat="2" pta="22:41" ptd="22:42" wta="22:41" wtd="22:42" />

    <IP tpl="SWNSCMB" act="T " plat="2" pta="22:45" ptd="22:45" wta="22:44:30" wtd="22:45" />

    <IP tpl="NRTHFLT" act="T " plat="2" pta="22:47" ptd="22:47" wta="22:46:30" wtd="22:47" />

    <PP tpl="SPHEADJ" can="true" wtp="22:48" />

    <DT tpl="GRVSEND" act="TF" pta="22:53" wta="22:53" />

    <DT tpl="GRVSEND" act="TF" can="true" plat="0" pta="22:54" wta="22:54" />

    <cancelReason>820</cancelReason>

  </Journey>

I see these have a cancelReason - which suggests maybe these are related, but I am not sure how to treat them?

Thanks,

Rob.

[WantStuff]

Hi Rob,

The first example shows the the original DT was PRKSTN, but it was cancelled:

<DT tpl="PRKSTON" act="TF" can="true" plat="1" pta="07:27" wta="07:25" />

And IPSWICH has become the replacement DT:

<DT tpl="IPSWICH" act="TF" planAct="T " plat="2B" pta="06:53" wta="06:53" />

act = Activity to be performed

planAct = the Activity that was originally planned

"TB" Train begins (Origin) 

"T" Stops to take up and set down passengers

"TF" Train finishes (Destination) 

It a similar story for the OR records.

Regards,

Martin

[Rob Green]

Thanks for clarifying Martin - much appreciated.

R