To ensure accurate cost estimates an inventory of all lights was conducted using Collector for ArcGIS. Missing lights were added, retired lights were removed and the description of light types was updated. This data was exported for inclusion in the Request For Proposals. Once the project was under way the installation contractor also utilized Collector to track the date each light was modified. The view of the data for field crews was limited to just the attributes they needed to modify.
Project mangers were able to review the data for lights as they were replaced. They could inspect and accept each light as appropriate. A very streamlined webmap application was created to show the public the status of lights as they were completed.
Ease of use - Installation crews received one hour of introductory training. They modified GIS data for over 10,000 streetlights and did not request technical assistance at all throughout the process.
Up-to-the-minute data – Utilizing a platform that is accessible to all stakeholders allowed the data being captured in the field to be accessible to project mangers and citizens immediately.
Centrally tracked data eliminated the situation of data inconsistency that often occurs when multiple copies of data is stored.
A grid showing the scheduled dates for installation showed citizens when to expect work in their neighborhood. The exact installation status of each light displayed the specific progress on each street.
The billing process was very efficient enabling staff to authorize payment on exactly the lights that were installed – per the vendors field data entry.
Speed of system deployment - A sample version of the database was created and accessible to the field crews in less than a week.
Most changes that were requested during the project were able to be accomplished immediately with no disruption to the field crews workflow.
BEFORE & AFTER
Images available on the City's website.