Gone are the days that councillor Fleury walked through the Rideau river on his way to university following a self imposed desire line. Now there is the Adàwe crossing. And it is hugely popular.
To get a better idea of its success, I took a belated look at the 2016 and 2017 data of the cycling and walking trips on the new bridge. The data is available from the City of Ottawa Open Data repository. (update: after I connected with the city about the suspicious data, it turns out the data the city provides in the spreadsheets is not correct, so I had to modify my blog from here on)
Increased Adàwe Crossing traffic
Usage of the bridge has increased from 2016 to 2017. The total number of pedestrians and cyclists grew by over 12%, which is good to see. The cycling trips grew by 10%, while walking grew by 13%. Note these are not unique users; someone might cross the bridge multiple times. Unless we bring in Chinese style tracking, we will never know the unique visitors.
Over 100 % increase?
Looking to the stats initially though, I was very surprised to see an enormous increase in the 3rd quarter of 2017 for cycling. In the third quarter of 2016 we see 153,360 movements, a year later for the same quarter it has increased to 333,673: an increase of over 100%. I thought that was weird and I asked both my readers and the City of Ottawa where this extraordinary growth came from. I also caught another error which I shared too with the City. Readers informed me there was a double count of walkers and cyclists in the cyclists column, in other words the pedestrians were counted as pedestrians and again as cyclists (blame the intern!). Meanwhile, the City asked where I got my data from (from -ahem- the City!).
If we look at the forth quarter, the rapid growth trend continues. While the pedestrian count was a wee less in the 4th quarter of 2017 compared with the ped count of 2016, cyclists nearly tripled the numbers for that quarter.
Data error on Adàwe?
I had looked to the data a number of times, because sometimes one oversees an error based on assumptions. But I couldn’t really find an obvious data error other than that the daily counts in Q3 and Q4 were often double from the year before. It appeared a very unusual spike. And indeed, as I explained above, there was an error in totalling the data, so here is the data that the City kindly shared with me afterwards. Note Q3 2018 in the graph only runs until today, August 23, 2018 and should run until end of September.
In the first two years after the crossing opened, just over 700,000 bike trips were counted and just under 900,000 pedestrian trips. Those are encouraging numbers that show that this connection is a very welcome addition. IN Q2 and Q3 around 1500 bike trips are counted over the bridge every day, for pedestrians it is around 1500 too. If we look to the entire 2017 year, so including the winter time, cyclists come in at just over 1000 a day and pedestrians at 1300 a day.
Read more about Ottawa’s infrastructure here.