How can I extract certain data from GTFS data?

148 views
Skip to first unread message

Shervin Ataeian

unread,
Oct 1, 2020, 9:21:41 AM10/1/20
to atl-transit-developers

I am doing a research project and I need 

- average travel times between stops of a bus network

- Max and Min headway

Is it possible to extract these from GTFS data? If yes, how? I can open the data in Excel but I do not know how to extract what I need.

I would appreciate it if someone could help me. Thanks

Jake Swanson

unread,
Oct 2, 2020, 9:18:37 AM10/2/20
to atl-transit-developers
I would unzip and start with the stop_times data. You'll notice IDs in there referencing other tables, and you might be able to branch out to the other tables and start understanding what it means.

That's not much help I bet, but it's what I did pretty much. I tried to document the GTFS zip over at https://medium.com/@jakswa/five-years-of-marta-coding-e522a1ed955

Landon Reed

unread,
Oct 2, 2020, 11:05:01 AM10/2/20
to Jake Swanson, atl-transit-developers
Depending on your experience with programming, there might be some relatively out-of-the-box tools/scripts out there that could help. A quick google search for "GTFS stats" revealed this one: http://simplistic.me/gtfs-stats.html#Route-stats which might be helpful in computing headways. (Full disclosure, I have never used this tool myself, so I have no sense for whether it works/what level of effort is involved.)

---
Landon Reed


--
You received this message because you are subscribed to the Google Groups "atl-transit-developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to atl-transit-devel...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/atl-transit-developers/acbcafac-8cf3-425a-b674-71e4b8eff1f0n%40googlegroups.com.

Shervin Ataeian

unread,
Oct 8, 2020, 9:36:15 PM10/8/20
to atl-transit-developers
Thank you so much for your help.

Actually, I need travel times between certain stops on working days or weekends by hour in a large network (with at least 90 routes). So, it seems that I need GTFS real-time data containing actual arrival and departure time of vehicles at stops so that I can calculate travel times directly. However, I am not sure where I can find this data. I have tried several websites but I do not seem to be able to find any real GTFS real-time data files. The websites just refer to each other and the more I click, the more confused I get. The static data can easily be found but I have had no luck with real-time data. I would really appreciate it if you would help me with this problem.  
Reply all
Reply to author
Forward
0 new messages