Do you have an interest in a new, comprehensive dataset of cycling infrastructure in the city? If so, we need your help!
We are currently developing a Cycling Infrastructure Database. This is a ground breaking database that contains every single cycle infrastructure asset within Greater London, including assets on and off-carriageway. The assets we have surveyed are - cycle parking, signals, signage, traffic calming measures, restricted points (eg steps), advanced stop lines, crossings, cycle lanes/tracks and restricted routes (eg pedestrian only routes).
The CID is a Mayoral priority project led by Will Norman, the Cycling and Walking Commissioner, working with TfL’s City Planning Active Travel team, Data and Spatial Analysis and Technology and Data teams.
The database will not only provide us with accurate information on cycling infrastructure in the city to aid our maintenance and planning teams but will also provide a data feed which we plan to publish as open data later this year.
How did we collect the data? To do this, we divided Greater London into 25 data packages for surveying purposes and the data collection was completed in May 2018. The data is currently being validated and, in parallel to this, the network assignment stage, where assets are assigned to the ITN and Open Street Map road networks, is in progress.
The screenshots below show the visualisation of some of the asset types we have collected and we’ve also attached the schema for you to take a look at. We want to know which of the assets and which attributes we are collecting would be of most use to you in developing new and innovative products. This will help us to understand which elements should be exposed in the Unified API and inform our technical design. Please post your thoughts below. We look forward to hearing from you!
Appendix X - CID Database Schema.xlsx (42.1 KB)