Harringay, Haringey - So Good they Spelt it Twice!
Traffic Survey data
A huge amount of data was gathered during the traffic survey in and around Harringay from 6-12 January 2016. You can find the raw data here.
It is very raw and can be difficult to interpret if you haven't done something like this before but I know there are other number crunchers out there who could have a go.
I've done some top line analysis limited to The Ladder and Green Lanes (attached to this post) but will do more and add it here. It might be useful, if anyone else feels so moved, to post their own analysis and thoughts here too. Also, any questions about the data itself or the questions it raises are welcome.
Things to take into account
- Most roads are one way so there is only one set of data. Roads that are two way are shown with north and south counts
- Green Lanes was monitored at 3 points and Wightman Road at 4
Attachments:
Tags for Forum Posts: harringay traffic study, traffic, wightman bridge, wightman bridge closure
- Attachments:
-
-
What might local traffic look like.pdf, 369 KB -
The Gardens.pdf, 592 KB
-
Replies to This Discussion
-
Permalink Reply by Angela on
-
The rise and rise of online shopping, particularly Amazon and supermarket deliveries, could be a factor for the increase over the last few years.
-
Permalink Reply by Justin Guest on
-
Not too sure about that, most of the deliveries I ever get form internet based shopping come during the day. Supermarket shops, maybe- as that is when most folks may be in to take delivery?
-
Permalink Reply by JoeW on
-
Also a single supermarket van journey probably replaces a handful of car journeys.
Having said that I've been studying the data for my road and detected a sharp rise in traffic just after my wife joined Amazon Prime. Coincidence?
-
-
I haven't had a chance to do any analysis but I quickly stuck all the data together and tidied it up if anyone wants that as a basis to work from. If you're familiar with working with big datasets it should make analysis much quicker (it's about 120,000 lines and 20MB) https://drive.google.com/open?id=0B-EK0H7cjyLkY29DMDV4amNidzg
-
-
Thanks Andrew. I noticed some of the data has a date of 11 Feb which must be a typo somehow as there is no data for 11 Jan for that road.
I produced a couple of charts just to make I'm understanding the data properly. This one shows southbound traffic on Wightman, between Burgoyne and Umfreville I think. Peak traffic is between 7 and 8am. Saturday and Sunday not surprisingly much quieter at that time in the morning but both weekend days actually busier than weekdays in the early afternoon. The chart doesn't show this very well but Sunday is the quietest day overall, about 17% less traffic than other days on average. Saturday is only a few percent quieter overall than weekdays.
Here is northbound traffic at the same point. Peaks between 5 and 6pm.
-
Permalink Reply by Michael Anderson on
-
Before you posted the charts what I was expecting to see was high morning volumes southbound in the morning with lower northbound volumes at the same time and then for that to flip completely in the evening.
Southbound comforms to that.. A big peak in the morning rush hours(s), Also northbound, the coming home from work rush around 5-6 o'clock. But why is southbound still really busy in the evening peak?
Between 5-6 on weekdays the monitoring station was picking up over 1,000 vehicles (combined north and southbound) every 15 minutes passing that particular point
-
-
Maybe it's a sign of the evening economy of Green Lanes? There are a huge number of restaurant seats, with more and more of the restaurants becoming 2,3,4 units wide. There's also a thriving wedding trade. This could all add up to a lot of car movements from Northern suburbs, down Wightman, down a ladder road & then parking in the Gardens if there's no space on the ladder road.
There is presumably also an evening shopping run to the Arena?
-
Permalink Reply by Hugh on
-
It might help us to answer your 'southbound question', Michael, if we were able to compare the graphs for the different measuring points on Wightman.
(Comment edited, I originally read Joe's contribution last night and forgot that his data applied only to the Burgoyne monitoring point when I was commenting this morning. In light of this, off the bat, I have no idea what might explain the odd pattern. Comparing the points may help.)
-
-
I'll see if I can make my spreadsheet available online tonight. I had to reformat the date and time columns in Andrew's original combined dataset, but I now have a pivot table pointing at the entire dataset and very easy to select any road, direction or other variable to produce charts similar to the ones I've posted.
-
-
I was thinking of doing a pivot table but
A. I'm not very good at them
B. I wasn't sure if people would be able to use one without having Excel installed
Can you post it Joe and see if it will work on the device I'm using now (an iPad without Excel)
If it does that would be fantastic.
-
-
Not sure if southbound is still really busy in the evening peak? There is a surprisingly constant southbound flow around 400 vehicles per hour between 10am and 6pm.
Northbound the flow hits 400ph later around 12pm but keeps climbing to 650-800+ph between 5-6pm, doesn't drop below 400ph until after 8pm.
Another puzzle is most weekdays there are 1000 more northbound journeys per day than southbound, at this particular point on Wightman.
© 2024 Created by Hugh.
Powered by
