Ann Arbor Streetlight Inventory

City-Wide Data Collection Helps Plan for Future Repair and Replacement

The City of Ann Arbor partnered with OHM Advisors to evaluate the condition of its network of more than 2,100 streetlights throughout the city. Our team created a customized rating system to efficiently quantify both the overall condition of the assets, and the condition of the streetlights’ individual components. We utilized Trimble TerraFlex & ESRI’s ArcGIS Online to create a custom data collection form and tracking tool used by our field staff on a tablet. Using these tools, our field team performed an extensive evaluation on nearly 1,500 community streetlights and took over 8,500 photographs of the assets and their internal components.

With data collection complete, we evaluated the ratings of the inventoried assets and rated the remaining, non-inventoried streetlights based on those inventoried nearby. Using data-driven criteria based on industry standards, we calculated the remaining life for the city’s luminaires, poles, foundations and wiring, and provided a comprehensive assessment report that guided the City in its planning for future streetlight repair and replacement.

Project Highlights: GIS, asset management, infrastructure assessment, data collection, streetlight assessment