Street Lighting Inventory

Please could you provide a copy of your street lighting inventory.
In particular I am looking for the following fields for each light:
– Location (lat/lon or easting/northing).
– Lamp type (e.g. LED, SON).
– Lamp power (Wattage or Lumen output).
– Lamp height.
– If the lamp is dimmed or turned off for part of the night.

Any additional fields of data held for each light would be gratefully received, but not required.

Please see the following link to Devon County Council’s street lighting inventory.

Please note that if a column in the spreadsheet says TBC, it is because either the information was never held for this location or we have outstanding works and we do not know yet what the exact details are. More information should become available once the works are completed, but as we plan our works well in advance we do not know when it will become available.

Please note that the all night switch regime would in most cases mean it is dimmed overnight to switch regime D69 which is a variable power switch regime, but we do not hold this information. The data is not complete such that it is taken from a live environment where we have a lot of change taking place. Part night lights switch on at Dusk and off at Dawn. Part night Switch off between 00.30 & 05.30