Sheffield City Council spending data

Update 6th Feb 2018: The data for the missing months is now available and has been incorporated into the linked Google Fusion sheet.

The law says that local government should publish a list of payments to suppliers over £500 (and recommends publishing payments over £250). I remember looking at Sheffield’s data some time ago and giving up because the quality was so poor. Well, this time I’ve persevered and I’ve published a much more usable data set.

An example of how this data could be useful, it’s possible to check to see how much money Sheffield Council has paid to Carillion, what is was for, and verify their statement that all the council contracts with Carillion are complete.

Payments to Carillion by Sheffield City Council – All payments over £250
(Some data missing)

Much of the data is missing, and much of it is inconsistently formatted (notably dates, which are in any format from Excel integers, to mm/dd/yy hh:mm:ss to d/m/yy), this makes it REALLY difficult to use the data without investing a significant amount of time.

At the moment, the data for the following months is missing Nov-15, Apr-16, Jul-16, Aug-16, Oct-16, Dec-16, Feb-17, Apr-17, May-17, Jul-17, Aug-17, Sep-17, Oct-17, Nov-17, Dec-17.

I’ve gone through the data, cleaned it up, and combined all the monthly files into one.

The scripts I used are in this GIT repository.

The final data is published in this Google Fusion Sheet and can be downloaded as a spreadsheet easily.

A quick summary of the data as it stands

Monthly value of payments made by Sheffield City Council over £250
You can see that a considerable amount of recent data is missing

Largest suppliers to Sheffield City Council – All payments over £250
Some data is missing


No more Sheffield Highways Cabinet Member Decision Sessions. No more Sheffield City Region Transport Committee.

Sheffield City Council Highways Cabinet Member Decision Session

A little while ago, the Sheffield City Council Highways Cabinet Member Decision Session meetings were cancelled. This wasn’t announced, the final meeting didn’t include any mention that there would be no more, just cancelled.

When a friend wondered when the next one would be, he was told.

Highway Cabinet Member Decision Sessions will no longer meet at the request of the Cabinet Member. Decisions will be taken by the Individual Cabinet Member as previously and future decisions will be advertised here

Representations on any issue can be made direct to the Cabinet Member who is Councillor Jack Scott who can be contacted as outlined here

The Sheffield council meetings provided significant information about the decision making process about transport decisions in the city, and the opportunity for members of the public and media to listen to council officers explain their proposals, read the reports(which I think will still be available), ask questions at the meeting and see decisions being made. Now, the decisions are put on a list on the website, no meeting, no discussion (unless in private, “Representations on any issue can be made direct to the Cabinet Member”).
Sheffield City Region Combined Authority Transport Committee

Now, it turns out that the Sheffield City Region (Combined Authority) Transport Committee has been cancelled too. This is the body who are in charge of HUGE devolution transport spend.

When asked, the authority said:

The Combined Authority is currently reviewing its Governance arrangements and this includes the Transport element of its remit. All transport related issues which require necessary approvals will be considered through the Combined Authority until such time these new arrangements are adopted.

This is the organisation who’ve been given control over very significant amounts of devolution investment and they are the recipients of the Integrated Transport Block funding for the whole of South Yorkshire. The final meeting (in May) didn’t discuss that there would be no more meetings. The subsequent full Combined Authority meetings (June and July) haven’t had any items regarding transport that would normally be discussed at the Transport Committee, no transport project programme updates and no budget/spend monitoring. I also can’t find and mention of the Transport Committee being cancelled in any minutes or agendas anywhere.

What’s going on!?

Byelaws and fining people for leaving vehicle engines running unnecessarily

Sheffield City Council has a consultation open at the moment about giving fines to people who leave vehicle engines running when not driving (idling). I fully support this, and everyone should respond positively to the consultation.

However, I’m confused about one aspect of the consultation, byelaws.

This consultation asks your views on whether Sheffield City Council should introduce and enforce new byelaws … for “no vehicle idling”

…if Sheffield City Council were to undertake enforcement and issue fines we would need to progress a local byelaw

Does Sheffield City Council need a byelaw to give fines to people who leave engines idling? I don’t think so.

The example used in the consultation is Westminster, where they recently passed an Experimental Traffic Regulation Order to enforce this.

The Order will prohibit engine idling by waiting vehicles, with certain exceptions, to facilitate civil enforcement of the contravention

Not a byelaw, but an experimental traffic regulation order. It’s not clear to me exactly how this offence can be enforced by a TRO, I can’t figure out the relevent laws, they’re too confusing. However, sometimes, traffic enforcement in London is very different to the rest of the country and the laws are different. I’ve emailed Westminster to ask but haven’t heard back.

Elsewhere (and in London?) the The Road Traffic (Vehicle Emissions) (Fixed Penalty) (England) Regulations 2002, and before that, the The Road Traffic (Vehicle Emissions) (Fixed Penalty) Regulations 1997 could be used. To do that, the local authority has to apply for permission, train some people, and they’re good to go. No TRO, no byelaw, that’s it.

Examples of authorities who’ve done this include, OldhamIslington(2006), Brent(2006), Reading(2016), Kensington & Chelsea (2005), Winchester (2004), North Lincolnshire (2009), and Westminster (2015, before the recent TRO).

So, where did the idea of a byelaw come from? I suspect directly from recent NICE guidelines.

Consider taking action to reduce emissions within the clean air zone. For instance: Introducing fuel-efficient driving initiatives including: Bylaws and other action to support ‘no vehicle idling’ areas

Where did NICE they get this idea that byelaws are required to enforce this in England? I don’t know!

Looking at the DCLG advice for creating byelaws, I don’t believe that a byelaw is allowed to be created for this purpose. They’re very clear that

A byelaw cannot be made where alternative legislative measures already exist that could be used to address the problem.

So, what’s going on? Is this just a case of sloppy terminology in the consultation? Or a more fundamental misunderstand of the law?

I hope Sheffield Council don’t try to create a byelaw covering engine idling. I don’t think it would be legal given other powers they already have and it’s a long, arduous (and probably expensive) process to create new ones. 

Sheffield Council should apply to the Secretary of State for Transport (as other local authorities have done), and start enforcing this law ASAP. Nice and simple. No byelaw needed.

Sheffield still keeping consultations hidden, under wraps, and suppressing responses – Adding pedestrian crossing phases to a crossroads

I’ve written before about consultations in Sheffield, how they’re not advertised, hidden away, and hard to respond to. This is another example. This time it’s about a new pedestrian crossing in Crookesmoor at the junction of Barber Road, Crookes Valley Road and Crookesmoor Road (map).

Consultation about a new crossing at Barber Road / Crookes Valley Road / Crookesmoor Road in Sheffield

Consultation about a new crossing at Barber Road / Crookes Valley Road / Crookesmoor Road in Sheffield

If you think pedestrian crossings and cycle lanes are a good thing, or a bad thing, then you can reply to the consultation, if you receive this letter.

If you search for it in the press, you won’t find anything.

If you search for it on the council’s website, you won’t find anything.

If you search for it on the council’s consultation portal, you won’t find anything.

You have to be on a special email list, or live on one of the houses near the junction to hear about this, then you’ll get a letter.

This was the very first thing I ever contacted Sheffield council about, 9 years ago, in 2008. I crossed this junction daily on foot, I was fed up with there only being traffic lights for cars and no pedestrian crossing phases. I would want to know about this consultation, I would want to reply to it in support, but the only way I know about it was because CycleSheffield are on one of those email lists and wrote about it on their Facebook page.

Why is everything so hard in Sheffield?

A traffic count on Tonbridge High Street, 13,600 vehicles per day

Tonbridge High Street 1st March 2017

I did a quick traffic count on Tonbridge High Street a few days ago.

It showed that at about 17:00, there are about 1,360 motor vehicles per hour using the road.

Using the rule of thumb, 10x hourly peak traffic = day traffic, that gives 13,600 motor vehicles a day using Tonbridge High Street.

Putting this into perspective for cycling,

  • London Cycle Design Standards give a critical failure to any street where total volume of motor traffic is > 1,000 vehicles/hour at peak and cyclists are not separated. Green is <200 vehicles per hour at peak.
  • The Welsh Active Travel Guidance gives a critical failure to any street where total volume of traffic is > 10,000 vehicles per day, and cyclists are not separated. Green, is 2,500 vehicles per day.
  • The UK LTN2/08 says that for > 10,000 vehicles per day, cycle lanes or tracks are required.

So, Tonbridge High Street is not a place where many people would find it comfortable to cycle.

(My data is available here – Tonbridge High Street Traffic Count 1st March 2017)

A masterclass from Sheffield City Council in suppressing consultation responses by making it difficult to respond

Sheffield Council are “consulting” on a major public realm redevelopment (Knowledge Gateway) in the City Centre, they’ve made it very difficult to respond by hiding the details of how to respond in a pdf, in a zip file, under the business section, of the local tourist information website.

This is how the council have advertised the ‘consultation’:

Official Sheffield Council consultation portal.

Sheffield Council: Published a press release about the scheme on official press release page.

  • No way of participating is provided other than attending an exhibition.
  • Doesn’t include any drawings or detail.
  • Doesn’t link to any drawings or detail.
  • Doesn’t list a consultation closing date.
  • Provided a link to the Sheffield City Region website with the exact same information.
  • Hold an exhibition in the city centre during working hours and for 2 Saturday mornings

There will be public and trader consultations over the next few weeks. Exhibitions featuring the proposals will be held at Sheffield Hallam’s Sheffield Institute of Arts (the former head post office) café from Monday 13 February to Saturday 18 February 2017 (9am – 6pm, weekdays; 9am to 4PM) and then at the Site Gallery cafe, Paternoster Row from Tuesday 21 to Saturday 25 February 2017, (10am – 6pm weekdays; Saturday, 10am – 1pm.)

Sheffield City Region: Published a news item on their website.

  • Everything above applies, no further information! Straight copy paste.

Welcome to Sheffield (tourist information website)

  • Created a page under the ‘Developments in Sheffield’ page, under the ‘Business Sheffield’ section for the consultation.
  • Includes a link to a zip file labelled ‘Download The Knowledge Gateway Exhibition Materials’
  • Include 8 PDFs in the zip file, some of which are layout drawings, some of which are exhibition panels.
  • In the final pdf, include details on how to respond to the consultation including the closing date.
  • Include an email address and postal address for responses.
  • Don’t publish a comments form. Copies were only available at the city centre exhibition.

Hidden on a tourist information website, under the business section, within a zip file, in a pdf.

A masterclass in suppressing consultation responses by making it difficult to respond.

Sustainable Travel Access Fund for 2017 to 2020 – links to all bid documents

Access Fund for Sustainable Travel

Yesterday the government announced the winners of the £60m Sustainable Travel Access Fund for 2017 to 2020. The fund details are here along with the criteria and application form.

Thousands more people will be encouraged to cycle and walk to work thanks to a £64 million government investment, Transport Minister Andrew Jones announced today (26 January 2017).

The funding will support local projects over 3 years from 2017 to 2020 and form part of a wider government package of more than £300 million to boost walking and cycling during the current parliament.

There were 28 winning authorities. I’ve collated links to each of the bids. 25 were awarded funding from the Sustainable Travel Access Fund, and 3 were awarded funding from the Cycling and Walking to Work fund. Where I’ve not been able to find the bid, I’ve submitted Freedom of Information requests which are also linked.

A spreadsheet with this data is here. (incidentally, the data behind the DfT cycling funding map is available on this Google Fusion Table here).

Sustainable Travel Access Fund 2017-2020

Local Authority Scheme value (£m)
Blackpool Council – Consortium bid with Buckinghamshire CC, Hertfordshire CC, North East CA, Stoke on Trent CC, West Sussex CC, Hampshire CC, Leicester CC, North Lincolnshire Council and Surrey CC 7.498
Brighton and Hove Council 1.485
Bristol City Council (West of England) 6.901
Devon County Council 1.5
East Riding of Yorkshire Council 0.682
East Sussex County Council 1.2
Herefordshire County Council – Unable to find FOI Sent 1.5
Isle of Wight Council 1.35
Kent County Council 1.452
Lancashire County Council – Joint bid with Blackburn with Darwen Borough Council 1.94
Leicester City Council and Leicestershire County Council – Unable to find FOI Sent 3.195
Lincolnshire County Council 0.975
Luton Borough Council (joint bid with Bedford Borough Council and Central Bedfordshire Council) 2.128
Norfolk County Council – Unable to find FOI Sent 1.488
North East Lincolnshire Council 1.388
North Yorkshire County Council 0.974
Nottingham City Council – joint bid with Derby City Council and Nottinghamshire County Council – Unable to find FOI Sent 2.735
Nottinghamshire County Council 0.845
Plymouth City Council – Unable to find FOI Sent 1.497
Sheffield City Region Combined Authority – Unable to find FOI Sent 7.5
Slough Borough Council – Unable to find FOI Sent 1.5
Southampton City Council (joint bid with Hampshire County Council) 2.294
Southend-on-Sea Borough Council joint bid with –Thurrock Council and Essex County CouncilUnable to find FOI Sent 3.322
Tees Valley Combined Authority 3.323
York, City of – Unable to find FOI Sent 1.312

Cycling & Walking to Work Fund

Local Authority Scheme value (£m)
Greater Manchester Combined Authority 1.5
Liverpool City Region – Unable to find FOI Sent 0.77
West Yorkshire Combined Authority 1.5

How often do people cycle in Tonbridge?

In this post I’m going to look at levels of cycling in Tonbridge.

I grew up in Tonbridge, moved to Sheffield when I was younger, and now I’m back in Tonbridge. Things in a small town of 40k people work a little differently to things in a city of half a million!

Getting to work (census 2011)

Of the approximately 17k people who travel to work each day (it’s that low, of the approx 40k people, 27k people are aged 16-74 and of those only about 20k are ‘economically active’).

Driving = 56% (9850 people), Car Passenger = 5%, Train = 20%, Walk = 14%, Bus = 2%,  Cycling = 2% (365 people).

Some of the people who get the train to work will cycle to the train station and that isn’t included above, likewise for people driving to the train station.

Across Tonbridge there isn’t much variation. There are no high pockets of people cycling to work.

Breaking it down by distance

For the 5,300 people (31%) who work within Tonbridge itself, the distribution of travel to work mode is:

Driving = 46% (2467 people), Car Passenger = 6%, Train = 1%, Walk = 36%, Bus = 3%,  Cycling = 5% (260 people).

And in Tonbridge, 1897 people work very close to where they live (the same MSOA), the distribution of travel to work mode is:

Driving = 31% (590 people), Car Passenger = 3%, Train = 2%, Walk = 59%, Bus = 1%,  Cycling = 4% (68 people).

To put this into perspective, Tonbridge is divided into 5 MSOA areas, most intra MSOA journeys will be less than 1km, but 31% of them are still driven and only 4% are cycled.

Modal Share All Journeys Journeys within Tonbridge Journeys in same MSOA
Driving 56% 46% 31%
Car Passenger 5% 6% 3%
Train 20% 1% 2%
Walk 14% 36% 59%
Bus 2% 3% 1%
Cycling 2% 5% 4%

Traffic Counts

There are 5 Department for Transport traffic count points on key routes around Tonbridge.

The Estimated Annual average daily flows data shows just 451 bikes counted in 2015.

3 have a modal share of about 0.5%, 1 at 1.2% and 1 at 0.09%.

Tonbridge DfT Traffic Count Data for 2015

How often do people cycle?

The Active People Survey has data on cycling participation for Tonbridge and Malling Borough (which is significantly bigger than just Tonbridge).

It shows that in Tonbridge and Malling, only 2.9% of people cycle at least once per week for utility journeys, rising to 4.8% at least once per month.

Utility Cycling Tonbridge and Malling Kent South East
At least once per month 2014/15 4.8% 3.8% 7.5%
At least once per week 2014/15 2.9% 2.4% 5.2%
At least three times per week 2014/15 2.1% 1.2% 2.8%
At least five times per week 2014/15 0.6% 0.6% 1.6%
All Cycling Tonbridge and Malling Kent South East
At least once per month 2014/15 15.1% 13.5% 16.8%
At least once per week 2014/15 8.3% 7.9% 10.6%
At least three times per week 2014/15 3.8% 3.0% 4.9%
At least five times per week 2014/15 2.6% 1.8% 2.8%

Travel to School

Kent’s 2016 bid for the ‘Access Fund for Sustainable Travel’ included journey to school modal share. The data is from surveys that school fill in. It shows a 3.1% cycling modal share, which has been fairly constant from 2013 to 2016, about 40% by car, and just under 50% by foot.

mode 2013 2014 2015 2016
82 surveys 173 surveys 160 surveys 99 surveys
other 1.3% 1.1% 1.5% 0.3%
car share 3.7% 4.4% 4.0% 3.5%
car (alone) 42.6% 41.9% 40.9% 35.1%
rail 0.1% 0.1% 0.1% 0.2%
public bus 1.2%
school bus 0.7%
bus (all types) 1.4% 2.4% 1.5%
cycle 3.2% 3.2% 3.3% 3.1%
scoot/skate 4.2%
park & walk 11.8%
walk 47.7% 46.9% 48.7% 39.9%

(source, page 4)


In the next blog post, I’m going to take a look at the streets of Tonbridge and see how cycle friendly they are. With these cycling rates, the results probably won’t be surprising.

Sustainable Transport Money (£450,000) on Road Widening: Doncaster’s Herten Way 2 Way Scheme

The Sheffield City Region Sustainable Transport Exemplar Programme is funding car parks and cycle lanes where parking is allowed. Previously the Local Sustainable Transport Fund paid to widen a trunk road roundabout. The latest questionable scheme is in Doncaster and is widening a road to convert it from 1 way to 2 way with the aim of alleviating motor traffic congestion and encouraging new retail shops to be built.

The proposed scheme will convert Herten Way into a two way road which will help to alleviate traffic congestion issues with ASDA in particular but also make an existing piece of development land more attractive for investment as access will be greatly improved.

From the Scheme brief document


The schemes general arrangement drawing is available here.

The original design included an unsegregated shared use footway/cycleway, however even that was dropped from the design before the scheme was built. The shared use footway was the token sustainable transport part of this scheme, but even that minimal cycling facility was never built.

Following consultation with the Council’s cycling Transport Planners it has been decided that the length of footway along Herten Way will not be shared with cyclists at this time. Tactile provision will be amended accordingly. At such time as further development occurs in the area the cycling facilities will be reconsidered.

From the Road Safety Audit

A new toucan crossing was built, at a cost of probably no more than £100,000 (guestimated), but the signals were required to facilitate the new turning movement at the junction because traffic is now 2 way, the junction was previously unsignalled.

Questions must be asked about the governance of the Sheffield City Region Sustainable Transport Exemplar Programme given some of the schemes that it is funding. This scheme cost £450,000 in total. Funds like these should go to creating well designed cycle infrastructure, not shared use pavements, not road widening, and not converting 1 way roads to 2 way at an out of town retail park.

The road safety audit provides a good insight into how the scheme has been designed.

The raised plateaux is intended as an aid to pedestrians crossing the carriageway rather than a traffic calming feature such as a road hump. As such the approach and exit ramps will be installed with a shallow gradient <1:20. The ramp areas will also be treated with red coloured surfacing and a set of warning triangles which the Designers feels would be sufficient warning to approaching drivers and would highlight the presence of pedestrians.

This is the freedom of information request where this information is from.

What WE do makes a difference. Why Sheffield Council needs to be more air aware.

How do you effectively persuade people to choose a more sustainable mode of transportation?

Is it by telling them what do to? Or are their choices influenced by our streets, our public spaces and bigger structural issues?

When we live in a country designed around the car, are people really free to make their own choices?

For the past few months Sheffield Council has been running a campaign under the title ‘Air Aware, What You Do Makes a Difference’ (Twitter, Website).

We want to help make everyone in Sheffield more air aware so that you can make choices which help to protect you and your loved ones.

I think that what the council do makes a much bigger difference, the council needs to be more air aware so that their choices help protect the people of Sheffield.

Putting the emphasis on changing individual behaviours through a campaign like this is a distraction and a waste of time. This is why I’ve created a series of new images with the strap line ‘What we do makes a difference’, we being Sheffield Council.










These are the original images.