Police helicopter footage has revealed the extent of Bonfire Night disorder in the city.