Page Comparison

id

DatedVehicleJourney.Id

trip_update.trip.trip_id

If plannedscheduled, then VehicleJourney.Id
ELSE
If unplanned unscheduled and route_id and direction_id is missing, then DatedVehicleJourney.Id

trip_update.trip.route_id

Line.Gid

trip_update.trip.direction_id

DirectionOfLine.DirectionCode → direction_id

• EVEN → 0

• ODD → 1

trip_update.trip.start_time

DatedVehicleJourney.TimetabledStartDateTime

trip_update.trip.start_date

DatedVehicleJourney.TimetabledStartDateTime

trip_update.trip.schedule_relationship

If DatedVehicleJourney.VehicleJourneyState exists and is canceled, then CANCELED
ELSE
If a vehicle journey exists, then SCHEDULED, else ADDED

trip_update.vehicle.id

MonitoredVehicleJourney.IsAssignedToVehicleGid

trip_update.stop_time_update.stop_id

StopPoint.Gid

trip_update.stop_time_update.stop_sequence

Departure.JourneyPatternSequenceNumber
OR
Arrival.JourneyPatternSequenceNumber

trip_update.stop_time_update.arrival.delay

Based on predicted arrival time and planned scheduled arrival time

trip_update.stop_time_update.arrival.time

Arrival.ObservedDateTime or Arrival.TargetDateTime
OR
if arrival is after departure (unless last stop), then:
Departure.ObservedDateTime or Departure.TargetDateTime

trip_update.stop_time_update.arrival.uncertainty

0 if Arrival.ObservedDateTime is set and is after the used departure time (or is at last stop)

trip_update.stop_time_update.arrival.schedule_relationship

SKIPPED if Arrival.ArrivalState is set to canceled, else omitted

trip_update.stop_time_update.departure.delay

Based on predicted departure time and planned scheduled departure time

trip_update.stop_time_update.departure.time

Departure.ObservedDateTime or Departure.TargetDateTime
OR
if last stop then:
Arrival.ObservedDateTime or Arrival.TargetDateTime

trip_update.stop_time_update.departure.uncertainty

0 if Departure.ObservedDateTime is set

trip_update.stop_time_update.departure.schedule_relationship

SKIPPED if Departure.DepartureState is set to canceled, else omitted

trip_update.timestamp

Departure.Timestamp
OR
Arrival.Timestamp

The latest timestamp overall in the list of departures and arrivals in the current trip update