Harringay online

Harringay, Haringey - So Good they Spelt it Twice!

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

Views: 2952

Attachments:

Reply to This

Replies to This Discussion

This is a thing of beauty. Thank you so much Joe.

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

  • TSP 12609 Endymion Road ATC location point and classification scheme - this includes a helpful plan that gives the two monitoring locations.  1. east of Venetia Road  2. west of Conningsby Road
  • TSP 12609 Endymion Road ATC site 1 data
  • TSP 12609 Endymion Road ATC site 2 data

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.

Thinking about it a bit more, as well as the lights being in operation
Thursday 24 - day before Easter so lots of people getting away early, going off on holiday etc.
Friday 25 - Monday 28- bank holidays and Easter weekend
Tuesday 29 - bridge closure
So all in all it doesn't really tell us anything about the "real" traffic conditions before works started.

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.

Thanks,

Michael

I agree. The Williamson Road/Green Lanes/Endymion junction seems key to what is happening in GL.

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 :-)

Tottenham Tesco? Traitor!
On the junction, I wonder if it would help matters if they got rid of the traffic island opposite McDonalds as all it seems to do is restrict the road width? Also, moving the northbound bus stop one block further north might help,to stop congestion there.

RSS

Advertising

© 2019   Created by Hugh.   Powered by

Badges  |  Report an Issue  |  Terms of Service