Send the link below via email or IMCopy
Present to your audienceStart remote presentation
- Invited audience members will follow you as you navigate and present
- People invited to a presentation do not need a Prezi account
- This link expires 10 minutes after you close the presentation
- A maximum of 30 users can follow your presentation
- Learn more about this feature in our knowledge base article
Do you really want to delete this prezi?
Neither you, nor the coeditors you shared it with will be able to recover it again.
Make your likes visible on Facebook?
You can change this under Settings & Account at any time.
Tulsa Transit Project
Transcript of Tulsa Transit Project
Why isn't planning a public transit trip as easy as planning a car trip?
In 2005, reached out to Mapquest, Yahoo!, and Google
Only Google responded... Working on a 20% project to put public transit data in Google Maps
Had trouble getting the data
Options were to buy, scrape, or make Freedom of Information Act requests and wait months. Chris Harrelson Software Developer, Google Tulsa Transit Project January
December 2011 Decided to make Tulsa Transit the first project First Hack Day
Tried scraping Tulsa Transit website
Planned a GIS data gathering app Jeremy Luttrell offered official data!
...which eventually got out of the mail server First attempts at reading DBF files into a database Second Hack Day
Jeremy Satterfield gets data out of DBF, into GTFS .txt files
We need schedule data! We get schedule data!
Third Hack Day
We get a valid transit feed!
Clean-up work, disable inactive stops John makes a whole bunch of people motion sick with slide transitions The Data GTFS DBFs Schedules feed.zip stops.dbf pattern.dbf stopsByPattern.dbf nodesByLine.dbf nodesByPattern.dbf 22 = 5 + 17 313 = 64 + 249 291 = 60 + 231 313 = 64 + 249 138 = 41 + 97 5 columns useful useless used Stops and geo-location lines.dbf 97 = 18 + 79 4 columns useful useless used AKA routes stopsByLine.dbf 291 = 61 + 230 5 columns useful useless used Connect Stops to Lines 101_1.txt 101_1.txt 101_1.txt runtimes trips stoptrips + 21 + 21 + 21 agency.txt routes.txt trips.txt calendar.txt stop_times.txt frequencies.txt stops.txt fare_rules.txt fare_
attributes.txt calendar_dates.txt transfers.txt shapes.txt General Transit Feed Specification 3 + 3 required optional agency_name
agency_phone 4 + 5 3 + 5 4 + 0 5 + 0 1 + 4 4 + 1 5 + 4 4 + 6 3 + 1 3 + 0 10 + 0 Demo Time! Check out the code
Enter the virtualenv
Get Transit Data
View the schedule Python Rocks Project Organization Transit data goes in input
GTFS appears in output
Google's Transit Tools in transitfeed-1.2.7
parser.py does everything
analyze_dbf.py Useful built-ins like dict
Functions are object
'with' for safe processing Batteries Included Awesome Libraries dbf_py
webbrowser We used: Google Used: And now, some slides Finish the Project Fix validation warnings
Get more schedule data
Use more of existing data
Get on the web
Design a workflow
Publish and Celebrate Follow Portland Live transit data
Caligator What's Next? Get Local! Oct 7: Tulsa Tech Fest
Oct 7 - 8: Tulsa Hackathon
Nov 12-14: Tulsa Startup Weekend
Aug ? - Next Hack Day
??? - Ignite Tulsa 4
??? - Fab Lab Tulsa Questions? http://prezi.com/glei7vpodnku