The Transport Planning Service (TPS) Team at Ealing Council commissioned Hup Initiatives to analyse ‘free-form’ feedback from 3x questions included in a recent public consultation exercise (part of plans to develop medium and long-term improvements to cycle infrastructure in the borough).
The 3 questions were:
- What prevents you from Cycling, or Cycling more confidently?
- Are there any existing routes which need improving?
- Where would you like to Cycle?
The Process:
Consultants at Hup Initiatives led on the following:
- Developed an initial Matrix/ ‘List of Headings’ to tabulate comments against (for the 3x questions).
- Establish a list of typical issues/ suggestions that constitute: a Quick, Short-Term, or Longer -Term scheme/ issue.
- Reviewed each comment, tabulating and listing according to content. Comments provided alongside mapped pin drops to help with future data filtering and hot spot identification.
- All comments/ suggestion identified as either: Quick Win, Short-Term or Long-Term will also be prioritized (e.g. 1 to 3) with improvements to safety and usability being a major focus.
- The identification of ‘Hot Spot’ schemes.
Outcomes:
The creation of a Master Spreadsheet that very easily (with the use of basic filter functions) identified/ prioritised schemes and/or initiatives for Quick, Short & Long-Term improvements to cycling in the borough