Logan City Council – Validation of Existing Street Light Data & Data Collection of Additional Lights
To validate existing Energex street light data to ensure the spatial location, addressing and textural attributes were correct, and to collect new street light data along roads and in parks and reserves.
Validation of Existing Street Light Data & Data Collection of Additional Lights
Background
Logan, located between Brisbane and the Gold Coast, is the third largest LGA in SE Queensland by population, and is responsible for costs of electricity for over 25,000 street lights. Following recent LGA amalgamations, Logan inherited over 8,000 lights from Gold Coast and Beaudesert Councils
Objectives
To validate existing Energex street light data to ensure the spatial location, addressing and textural attributes were correct, and to collect new street light data along roads and in parks and reserves.
Plus validation of two existing inventory lists of lights and poles as well as separate lists of:
- Lights that do not exist
- New lights
- Lights with incorrect data
- Lights requiring further investigation
Scope of Services
The project involved the validation, mapping and data collection of 27,316 streetlights across 3,715 roads and 1280 reserves throughout the City of Logan.
Project
The following data attributes were collected/verified in the field for each light:
- Pole number and pole material
- Luminaire type, wattage and installation date
- Pole location including street number, road name, suburb, park name and location in park
- Generic light photo and generic cross-arm photo
- Comments as required
Methodology
Project deliverables included:
- The supplied inventory spreadsheets were geocoded using supplied spatial pole datasets. These lights were then verified in the field using AssetMap software.
- Each light was assessed for location and textural attributes. All streetlights were fully attributed and linked to generic photos for luminaire type and cross-arm type.
- Address information was automatically extracted from a series of base data layers supplied by the client.
- Collected streetlight information was compared and analysed against current Council datasets to create colour coded GIS layers depicting validated lights and poles, lights with different attributes, lights that no longer exist and new light
Deliverables
Project deliverables included:
- Spatial MapInfo data in the projection/datum GDA 94/MGA94 Zone 56 compatible with Council’s GIS;
- Colour-coded layers of collected lights;
- Streetlight images including generic light and cross-arm photos.
Street light data was supplied in the following categories:
- Validated lights – existing light information that was correct
- Lights with incorrect inventory – flagging existing light information that was incorrect
- Lights not existing – flagging missing lights that were not found
- Unknown lights – highlighting unknown light types
- New lights collected within road and park reserves
