GTFS-realtime for NSW trains


#1

Hi there,

Is anyone in the community having GTFS-realtime data for all train lines in NSW (including sub-urban line) for the August 2018? particularly the week between 20 - 26 Aug 2018.

I am doing research on crowding and travel time reliability, so would like to have real time data (or train punctuality data). Currently I am working with GTFS (static) but this has limitations as trains are not always punctual to the timetable.

Thanks,
Chinh


#2

Hi @chinhho,

AnyTrip archives this data and provides it to interested parties as part of our data services offering. However, there is normally a fee for accessing this data.

If you’re interested, you can send me a message or contact us via the contact page: https://anytrip.com.au/contact

Cheers,
Ken


#3

I have all* the GTFS realtime data and GTFS meta data since 2018-11-02:

gtfs=> \d staging_tfnsw_realtime;
                   Table "public.staging_tfnsw_realtime"
    Column         |           Type           | Collation | Nullable | Default 
-----------------------+--------------------------+-----------+----------+---------
 current_stop_sequence | double precision         |           |          | 
 stop_id               | text                     |           |          | 
 current_status        | integer                  |           |          | 
 congestion_level      | integer                  |           |          | 
 occupancy_status      | integer                  |           |          | 
 trip_id               | text                     |           |          | 
 route_id              | text                     |           |          | 
 direction_id          | double precision         |           |          | 
 schedule_relationship | integer                  |           |          | 
 id                    | text                     |           |          | 
 label                 | text                     |           |          | 
 license_plate         | text                     |           |          | 
 latitude              | double precision         |           |          | 
 longitude             | double precision         |           |          | 
 bearing               | double precision         |           |          | 
 odometer              | double precision         |           |          | 
 speed                 | double precision         |           |          | 
 mode                  | text                     |           |          | 
 start_timestamp       | timestamp with time zone |           |          | 
 timestamp             | timestamp with time zone |           |          | 

and table is quite big - 54GB.

  • every know and then some records might be missing (reboots, …).

#4

Thanks @ondrej. Good to know and will ask you if we need it in the future. At the moment, I am after the realtime data in Aug 2017 and Aug 2018. Cheers /Chinh