Gilbert, Arizona, one of the fastest-growing communities in the United States, has embarked on an ambitious journey to become the "City of the Future". This mission is driven by innovative solutions that anticipate change and create a sustainable future for its residents. A pivotal step in this journey was partnering with SDG Group to implement a Data Governance Strategy, engineer a centralized data technology stack, and support data visualization creation as part of their Performance Management initiative.
In this article, we are proud to highlight a portion of Gilbert’s larger success story by showcasing their “Graffiti and Potholes” dashboard. Fill out the form below to access the full success story:
The Gilbert Public Works Department is committed to maintaining a clean, visually appealing environment and ensuring safe, quality roads. To achieve these goals, the department addresses two critical areas: graffiti removal and pothole repairs.
Graffiti Removal: The goal is to remove 90% of graffiti reported by residents through the Gilbert 311 system. Challenges include:
Accessibility Issues: Certain graffiti locations, such as those under bridges, may be unreachable.
Duplicate Reports: Multiple reports for the same graffiti can complicate tracking and resolution.
Pothole Repairs: The goal is to repair 90% of potholes reported by residents through Gilbert 311. Challenges include:
Data Quality: Variations in reporting and tracking potholes can lead to discrepancies, such as a single pothole requiring multiple repairs or multiple potholes being reported as one.
Road Condition Assessment: Potholes are one aspect of road condition. The department uses a Pavement Condition Index (PCI), ranging from 0 to 100, to assess road quality. Roads with a PCI of 40 or below are scheduled for reconstruction rather than simple repair.
The dashboard developed by SDG Group provides real-time data and insights into the Public Works Department’s operations. These dashboards enable the department and the public alike to:
Monitor Graffiti Removal: Track the number of graffiti removal requests and completion rates.
Visualize Graffiti Clean Up Requests: Access an interactive map to see the completed graffiti clean up requests.
Track Pothole Repairs: Analyze pothole repair requests, completion rates, and assess the overall condition of road segments using the PCI.
The implementation of this dashboard not only supports the town’s efforts to maintain clean streets and safe roads, but also exemplifies a commitment to transparency and continuous improvement. As Gilbert continues to grow, these data-driven initiatives ensure that the town can effectively meet the needs of its residents, fostering a safer and more appealing community.