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
Thanks for your help Michael.
Microsoft seem to have done a rather good job of implementing the pivot table in a browser. Should make it easier to answer those awkward "my road is busier than yours" conversations too!
You can move the fields between rows, columns on filters too. Here's a ranked list of the top eastbound roads:
I wonder what happened on that bit of West Green Road between 8th and 10th Jan?
BTW I had to remove the vehicle classification and speed data from the spreadsheet, Excel Online doesn't like it if the file is over 5MB. Could probably do a separate spreadsheet but the I think that data needs normalising first.
I've now received the data for Endymion Road. This was missed in the original survey so one was set up separately and ran from 22 March to 7 April. This is longer than the 7 day survey for all other roads so anyone doing analysis should probably use the same start and end days of the week. The pain is that the Endymion data goes over the Easter period so you can't really compare it with the January data for the other roads as different factors were at work (school holidays for instance)
I've put the files in DropBox and they are
Do Joe and Andrew (and others) want to work their magic?
By 22 March the traffic lights were in place on the bridge, which wasn't the case for the rest of the survey part 1. Oops, in terms of integrated data.
I know. They only useful thing you can really get out of it is what the traffic flows were on the days monitored. It's not comparable to the existing data.
I spotted it was missing when I was sent all the data files and raised this as I thought it might have just been omitted in the upload but unfortunately Endymion was missed out - don't know why, it's a pretty big and in your face road.
MIchael, given the important role of the Arena shopping centre in generating traffic in this area, I am right in thinking that there was no traffic monitor on Williamson Road (the road to the Arena parking)? It's not on your map at least.
This seems like a major deficiency of the traffic study & shouldn't we be pushing for a monitor there in any subsequent monitoring?
It would be extremely interesting to know how much of the current Green lanes traffic (post Wightman closure) is going to or from the Arena, particularly given the Council's plans to re-develop the Arena to mainly housing.
One less - I've found it's very easy to go to the Seven Sisters / Tottenham High Road Tesco and you can get out of the car park in seconds :-)