Hackpads are smart collaborative documents. .
339 days ago
Unfiled. Edited by Lauren Renaud , Hemank Lamba 339 days ago
Eric Boerer of BikePGH led the group, whose task was to provide answers to research questions using the crash data and other datasets. The key research questions are posted in a separate google doc, as well as copied below. If you are interested in taking the lead in answering these questions, please share details on how you'll approach the question, describe any additional help you'll need with data or analysis, and let others know how you plan to continue work on the research.
Results (add link where others can see your work)
Lauren R Factors of Interest
  • Infrastructure
  • Do patterns emerge based off of the type of street or intersection?
  • Which streets have the most bicycle crashes? Pedestrian crashes?
  • Are there common features of these streets?
  • What percentage of crashes happen at intersections?
  • Do intersections that allow drivers to turn right on red increase frequency of crashes?
  • Do mid-block crosswalks help or hurt?
  • Do stop bars and crosswalks exist in problem areas?
  • Are people parking on the sidewalk near problem areas?
  • Does the installation of bike or ped infrastructure make a street safer for bikes? Peds? All users?
Response variables:
  • Was there a change in crash frequency after a change in infrastructure or design?
  • What percent of all traffic crashes, injuries and fatalities are pedestrians and/or bicyclists?
  • How do 311 complaints (potholes, speeding, etc) line up with crash data?
  • Are the neighborhoods with a larger concentration of households without a vehicle located near bicycle infrastructure/transit access?
  • What is the rate of bicycle crashes compared to the number of bike commuters (via ACS data)? 
  • Can we quantify the cost to residents? Estimate hospital, job loss, property costs?
  • ***What are the costs of crashes, fatalities, and injuries to the City?***
  • Quantify {healthcare, fixed infrastructure, city operations (ie. police, fire, ems, etc)} dollar costs of:
  • Cycling crashes 
  • Pedestrian crashes
  • All crashes
  • Can see if costs go down after infrastructure intervention
  • and compare these to costs and benefits of cycling & walking
  • Sample studies:
  • (similar studies conducted in Barcelona [Rojas-Rueda et al., 2011] 
  • Do the Health Benefits of Cycling Outweigh the Risks? Johan de Hartog et al., 2010 (Copenhagen)
  • commerce, property value, (approximated/surveyed) quality of life
  • What are the highest risk factors for crashes?
  • What role does speed or aggressive driving play in crashes?
  • What are the predominant causes of pedestrian crashes?
  • To what frequency is the Port Authority or other transit operator involved?
  • How many crashes involved City-owned (non-police) vehicles?
  • What role do alcohol/drugs play?
  • What role does age play?
  • What role does distraction play?
  • What role does surface condition play?
  • Does lighting/illumination play a role in pedestrian crashes?
  • Accuracy
  • Spatial, injury/fatality, categorization, biases/limitations?
  • How are “serious injuries” determined?
  • Do fatalities align with or contradict media reports?
  • Can we see all years of data on one map?
  • @ToolsGroup: put better filters onto a map, including one to facilitate displaying individual & multiple years
  • Do the police follow up after the incident, ie once victims leave the scene?
  • Are the public/private databases tracking this able to communicate and adjust?
  • Do some Police Zones report a higher frequency of serious injuries than others?
  • New data requests:
  • What factor indicates crash resulted in an ambulance ride?
  • How is fault determined?
Social Issues
  • Public/affordable housing in area [Median income or percent below poverty line]?
  • How can we prioritize infrastructure in these areas? Can we base it on the furnished safety data?
  • Geographic: 
  • Community Development Block Grant (CDBG) area
  • Transit access
  • Car ownership/access
  • Are the neighborhoods with a larger concentration of households without a vehicle located near bicycle infrastructure/transit access?
  • What percent of crashes were in school zones?
  • Sidewalks present?
Hemank L Github Repository for customizing data for yourself
406 days ago
Unfiled. Edited by Steve Cotter 406 days ago
How to participate: Check out the repository. To follow along, you'll need PostgreSQL with the the PostGIS extension to see how I'm trying to wrangle PennDOT State Road data and Allegheny County crashes together. Then check out the HTML and JS files to see how the visualizations are put together using Leaflet and D3. Here are some of the maps I've put together: 2014 crashes, an animation of 2014 crashes by time of day, Annual Average Daily Traffic, Daily Vehicle Miles Traveled, and Road Segments and Crashes 2010 - 2014 (still clunky).
Repository/github link: https://github.com/spcotter/crashes
448 days ago
495 days ago
Unfiled. Edited by rmg44@pitt.edu 495 days ago
This group led by Bob Gradeck of Pitt is working to develop a user guide for the crash data. User guides contain details about a dataset, and can be used to help others working with crash data in Pennsylvania. Typical features of a data user guide include a description of how the information is created, examples of how the information is used, and an assessment of what is (or isn't) included in the data. The Regional Data Center has developed user guides for property assessment and 311 data, and this is the first group effort to create a user guide. 
We're open to help from anyone that wants to learn more about this data, and you can make an important contribution to our work even if you're just getting started with data. We'll definitely benefit from contributors with good interviewing and writing skills.
Bob will set-up group interviews with police officers at the City and a few other jurisdictions responsible for collecting the data, along with interviews with the State Department of Transportation's crash data experts.  If anyone knows a police officer that might be willing to talk about their experience with reporting crashes, please contact Bob and he'll set up an interview. The participants at the meeting will be invited to participate in these conversations, and if you're interested in being part of the interview, please complete the volunteer form.
 Bob will also post the interview calendar on this hackpad. If you want to help with the interviews, it wouldn't hurt to become familiar with the crash data by working with it, and reviewing documents like the data dictionary and primer shared with us by the state. We also hope participants will play a predominant role in recording interview notes and drafting the user guide.
495 days ago
Unfiled. Edited by rmg44@pitt.edu 495 days ago
interview questions 
rmg44@pitt.edu Please add your crash data questions here. We'll use these as an interview script.
About the Data
  • Why does this data exist? Is there a mandate or requirement for this data?
  • What type of crashes must be reported?
  • Is there any type of crash that is reported where reporting is not required?
  • Is there a national data collection standard for this data? 
Data Collection Process
  • How (in general) is the data on a crash collected? 
  • Who collects the data?
  • What tools are used to report crash data? 
  • Is software or paper used? 
  • Do tools and processes differ across communities?
  • How quickly following a crash is the data entered?
  • How long do crashes take to report? 
  • Do some types of reports take longer than others?
  • Is it possible to edit reports?
  • Does crash data sync with hospitalization or emergency room and police report data? (e.g. DUI status or an injury becoming a fatality). 
  • Is any information in the report optional?
  • Who is able to file a report (e.g. school, transit police)?
  • Can someone report a crash occurring outside their jurisdiction?
Location data
  • What location information is recorded with the initial report?
  • How are coordinates assigned to the data? 
  • How are locations represented if the crash does not occur at an exact point but over a longer distance?
Quality Control/Assurance
  • How is data reported to the state?
  • What does the quality control process look like at the local and state level?
  • Who applies the codes to the data?
  • What are some of the most-common data entry errors and how are they discovered and collected?
  • Has the structure or format of this data changed over time?
  • Where there changes over time in reporting processes, quality control processes, regulations, and systems?
  • Is training offered to those creating a crash report? 
  • Who provides these? 
  • Are refresher courses available?
Data uses
  • How do the police use the data?
  • Who is this data shared with? 
  • How has this data been used? 
  • How does the insurance industry use this data?
  • What do the police want to know about the data (how can we help answer their questions)?
  • How could this data be used?
  • When did the data become electronically available?
  • What improvements would police/PennDOT make to the data collection process?
Members (62)
Hemank Lamba Tom McFarlin Melinda A monk.e@pitt.edu connorsb@gmail.com tutte@carnegielibrary.org wlevine@gmail.com eleanor.newman@alleghenycounty.us ersriji@gmail.com david.walker@pitt.edu justine.galbraith@gmail.com rolon.josh@gmail.com greenwaltt@carnegielibrary.org matthewskatherinej@gmail.com jill.diskin@gmail.com joanne.foerster@alleghenycounty.us ctracey2@gmail.com humank462@gmail.com eviljamie@gmail.com aaron.hayes89@gmail.com

Create a New Collection


Move XXX to XXX

XXX will be invited to the XXX on XXX.


Contact Support

Please check out our How-to Guide and FAQ first to see if your question is already answered! :)

If you have a feature request, please add it to this pad. Thanks!

Log in