Logan City Council – Validation of Existing Street Light Data & Data Capture of Additional Lights
To validate existing Energex street light data to ensure the spatial location, addressing and textural attributes were correct, and to capture new street light data along roads and in parks and reserves.
Validation of Existing Street Light Data & Data Capture of Additional Lights
BackgroundLogan, 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.
ObjectiveTo validate existing Energex street light data to ensure the spatial location, addressing and textural attributes were correct, and to capture 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 ServicesThe project involved the validation, mapping and data collection of 27,316 streetlights across 3,715 roads and 1280 reserves throughout the City of Logan.
ProjectThe following data attributes were captured/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
MethodologyProject 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.
- Captured 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 lights
DeliverablesProject 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 captured within road and park reserves
We have an extensive list of case studies and Client Testimonials.