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
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: AnyTrip
Cheers,
Ken
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.
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