[TxC] Night Tube on Thursdays & Waterloo & City Sunday eve

Since last week, which coincides with the 2.4 migration, we have started noticing some oddities in the TxC data:

  • Night Tube trips on all Night Tube lines on Thursday
  • Missing Night Tube trips between 1AM and 3AM in the night Saturday to Sunday
  • Weird Waterloo and City line trips Sunday eve (so technically Monday) between 00:00 and 00:30.

Is this a data error or a change in the schema which means we are not reading the data correctly?

More concretely: it looks like the schedules for Night Tube and Night Buses are shifted forwards by one day. Not sure how this has happened, but this is the case.

For Night Tube, they are shifted between Thursday and Saturday:
:x: Thursday has the Friday schedule - trips start 4am ish + late at night trips (for overnight Tube) - INCORRECT
:white_check_mark: Friday has the Friday schedule - trips start 4am ish + late at night trips (for overnight Tube) - CORRECT
:x: Saturday has something that looks like a Sunday schedule - early am trips + end around midnight INCORRECT
:white_check_mark: Sunday: also has a Sunday schedule (as expected) - but fewer trips than on Saturday - early am trips + end around midnight CORRECT

For Night buses, they are shifted entirely between Thursday and Sunday:

  • Thursday has the Friday schedule
  • Friday has the Saturday schedule
  • Saturday has the Sunday schedule
  • Sunday has the Monday schedule

Re Waterloo and City line, im not sure what is up with it

hi @ndjik

The way that post-midnight services display in TxC 2.4 has now changed. In 2.1, this was allocated to the exact day that the service runs. i.e. a service at 00:30 on a Friday night would show as being on Saturday. In 2.4, there is a DepartureDayShift field that when present will show the post-midnight journey as being in the early hours of the following day. In this case, the Saturday will now show as Friday with the

Examples of the same journey on the Victoria line are shown below:

2.1:

		<VehicleJourney>
			<PrivateCode>tfl-1-VIC-_-y05-420261-434-T6</PrivateCode>
			<Operational>
				<VehicleType>
					<VehicleTypeCode>UT</VehicleTypeCode>
					<Description>Underground Train</Description>
				</VehicleType>
			</Operational>
			<OperatingProfile>
				<RegularDayType>
					<DaysOfWeek>
						<Saturday />
					</DaysOfWeek>
				</RegularDayType>
				<SpecialDaysOperation>
					<DaysOfNonOperation>
						<DateRange>
							<StartDate>2024-07-06</StartDate>
							<EndDate>2024-07-06</EndDate>
						</DateRange>
					</DaysOfNonOperation>
				</SpecialDaysOperation>
				<BankHolidayOperation>
					<DaysOfNonOperation>
						<LateSummerBankHolidayNotScotland />
					</DaysOfNonOperation>
				</BankHolidayOperation>
			</OperatingProfile>
			<VehicleJourneyCode>VJ_1-VIC-_-y05-420261-434-T6</VehicleJourneyCode>
			<ServiceRef>1-VIC-_-y05-420261</ServiceRef>
			<LineRef>1-VIC-_-y05-420261</LineRef>
			<JourneyPatternRef>JP_1-VIC-_-y05-420261-89-O-2</JourneyPatternRef>
			<DepartureTime>02:07:00</DepartureTime>
		</VehicleJourney>

2.4:

<VehicleJourney>
			<PrivateCode>tfl-1-VIC-_-y05-420261-434-T6</PrivateCode>
			<Operational>
				<VehicleType>
					<VehicleTypeCode>UT</VehicleTypeCode>
					<Description>Underground Train</Description>
				</VehicleType>
			</Operational>
			<OperatingProfile>
				<RegularDayType>
					<DaysOfWeek>
						<Friday />
					</DaysOfWeek>
				</RegularDayType>
				<BankHolidayOperation>
					<DaysOfNonOperation>
						<AllBankHolidays />
					</DaysOfNonOperation>
				</BankHolidayOperation>
			</OperatingProfile>
			<VehicleJourneyCode>VJ_1-VIC-_-y05-420261-434-T6</VehicleJourneyCode>
			<ServiceRef>1-VIC-_-y05-420261</ServiceRef>
			<LineRef>1-VIC-_-y05-420261</LineRef>
			<JourneyPatternRef>JP_1-VIC-_-y05-420261-89-O-2</JourneyPatternRef>
			<DepartureTime>02:07:00</DepartureTime>
			<DepartureDayShift>1</DepartureDayShift>
		</VehicleJourney>

This field can apply to any TxC file produced as most services across the modes have journeys that occur at the end of a day after midnight.

In the case of night tube, services that start before 03:00 will appear on the previous day with <DepartureDayShift>1</DepartureDayShift> and those after 03:00 will not have DepartureDayShift set.

Hope that clears things up.

Many thanks,
James

1 Like

Hi @jamesevans , thank you. Yes this would explain why we are seeing this ‘shift’. Has anything else of the sorts changed?
e.g. service exception, service periods, holiday v standard schedule, overnight schedules
I took a look at the schema for 2.4, but it’s 290 pages long so it’s difficult to understand what is new in comparison with 2.1
Cheers,
Nick

Hi @jamesevans , would you be able to share more on that if anything else has changed?
Cheers, Nick

@jamesevans for example we noticed the use of AnnotatedStopPointRef for replacement services, those are the types of updates we are interested in :slight_smile: cc @SarahLS