The city had the fifth highest expenditure in the UK for tackling climate change