trip.trip_id

VehicleJourney.Id

If a scheduled journey exists, then trip_id is used for identification, else route_id and direction_id is used.

trip.route_id

Line.Gid

trip.direction_id

DirectionOfLine.DirectionCode → direction_id

• EVEN → 0

• ODD → 1

trip.start_time

DatedVehicleJourney.TimetabledStartDateTime

Is only included if a trip is unscheduled.

trip.start_date

DatedVehicleJourney.TimetabledStartDateTime

Is only included if a trip is unscheduled.

trip.schedule_relationship

If vehicle journey exists, then SCHEDULED, else ADDED.

position.latitude

Position.Northing

position.longitude

Position.Easting

position.bearing

Position.Heading

position.speed

Position.Speed

vehicle.id

Position.Vehicle

timestamp

Position.Timestamp

occupancy_status

APCRDA.PassengerLoadReport.OnboardCount for current occupancy
Vehicle.CapacitySeatingsCount and Vehicle.CapacityStandingsCount for capacity

Mapped to the OccupancyStatus enum as described below:
EMPTY = 0 passengers on board
MANY_SEATS_AVAILABLE = More than 50% of seats available
FEW_SEATS_AVAILABLE = Less than 50% but more than 10% of seats available
STANDING_ROOM_ONLY = Less than 10% of seats available
CRUSHED_STANDING_ROOM_ONLY = Less than 20% standing room available
FULL = No standing room available