Projects
You should email me a couple sentences about the project you choose and your team by Sep 12th. Can can change projects/teams at any time; just drop me an email if/when you do. This page has some ideas, but feel free to come up with something else (perhaps by browsing the data here: http://data-cityofmadison.opendata.arcgis.com/).
Fall of 2019 Projects
- Consolidating Metro Bus Routes: Maximizing the Impact of the BRT while Minimizing Costs - Megan Tabbutt [PDF]
- Reducing Bus Route Redundancy - Jin Woo Lee, John Kitaoka, Hunter Olson [PDF, PPT]
- Vote More - Annie Zheng, Sally Hu, Yuzheng Zhang [PDF, PPT]
- Voter Registration and Turnout - Kristie Bodak, Emma Brostrom, Gunnar Schmitz [PDF, PPT, notebook]
- Eliminating Traffic Deaths in Our City of Madison - Detao Yu, Jing Huang, Boyu Shen [PDF, PPT]
- Vison Zero Madison - Tongkai Yang, Siyuan Ji, Clarence Kuo [PDF, PPT, report]
- State St. Traffic - Songyang Cheng, Mianzhi Huang, Nelson Linscott, Shou Kurosu [PDF, PPT]
- Optimizing State St. Light Patterns - Hanyu Cai [PDF]
- State St. Pedestrian Traffic - Peter Matthews, Aidan Deaven [PDF]
- Police Turnover Rate - Michael Faulkner [PDF]
Past Projects (Spring+Summer of 2019)
- The Big Picture - Jake Kelly and Yuankun Huang [PDF, PPT]
- The City is on Fire - Anna Arpaci-Dusseau [PDF]
- Relationship Between Spending and Weather in Madison - Swaraj Rao and Whitney Long [PDF]
- Going to Work - Jay Jin Woo Lee [PDF, PPT]
- Housing in Madison - Annie Zheng [PDF, PPT]
- Budget Simulation - Xi He, Sally Hu, Christopher Harte, Kyle Wiessinger [PDF, PPT]
- Interagency Relationships in the City of Madison - Langston Nashold, Ellen Wieland, and Zan Zhang [PDF]
- Spend Planning: How Are We Doing? - April Zhong [PDF, PPT]
- Weapons Violations in Madison - Leon Tan [animations+code]
- Crashes in the City of Madison - Zhixin Wang, Yijing Gong, Haowen Hu, Alex Radicia [PDF, git]
Key Projects
Our collaborators in the City of Madison have specifically expressed interest in these projects; thus, doing a good job on one of these projects has a greater chance of having a real impact on decision makers.Streamline Bus Routes. Bus Rapid Transit (BRT) will introduce many new routes/stops (see this report). This new service will decrease the relevence of existing routes, so it may be possible to streamline. This project will involve evaluating/predicting the changing importance of old routes as the new routes come online. Data/Resources:
- proposal [PDF]
- GIS-optimized GTFS files [zip]
- GIS files with proposed BRT routing [zip]
- Stop-level red dot boarding map [zip, pdf, online]
- GTFS schedule data [zip]
- Title 6 docs here and here
- Bus Locations [JSON Realtime, More Data, Historical]
Minimize Traffic Accidents. Can we identify the main causes for accidents (e.g., drinking, specific streets, etc)? And then suggest ways to reduce such accidents?
- proposal [PDF]
- Vision Zero San Francisco [pdf]
- Crash Data [spreadsheet]
State Street Pedestrians. Can we visualize pedestrian and bike patterns around State Street and correlate with traffic patterns? Can traffic cycle timings be better optimized for pedestrians?
Voter Registration and Turnout. What factors affect participation across the city, and how might get out the vote (GOTV) efforts be improved in the future?
- proposal [PDF]
Other Ideas
Data Quality Survey: much of our data is incomplete and ambiguous. Can we develop a systematic way to measure the quality of our data and identify weak points? How useful are reported addresses (as they are formatted) for geo-coding?
SalarySim: a lot of variance across years comes from salary spending changes resulting from hires and retires.
- salary by employee [XLSX]
Ideas from NYU CUSP
Feel free to checkout their capstone projects here.
Resources
Feel free to send me links you think would be generally useful, and I'll post them here:
- Appendix 1: Transit Network Analysis
- Network Analysis of the Tel Aviv Mass Transit Plan
- Innovative GTFS Data Application for Transit Network Analysis Using a Graph-Oriented Method
- A Method to Ascertain Rapid Transit Systems’ throughput Distribution Using Network Analysis
- Machine Learning and Data Science Applications in Industry
- Department of Public Instruction (DPI) portal and FAQ
- Department of Research and Policy (DOR) data
- Department of Corrections (DOC) data
- Department of Children and Families (DCF) data
- Department of Transportation (DOT) improvement program data