June 10, 2016
By Keith Cooke, Local Government Account Executive
Like many other public works agencies, the Public Works Division of the City of Memphis has an enormous breadth of responsibilities, the bulk of which is responding to citizens' complaints, from damaged drain pipes to potholes in streets to missed trash pickups to missing sanitary manhole covers. As a result, over 80 percent of the complaint tickets coming to the city's Oracle E-Biz CRM 311 system are dispatched to Public Works. On average, this translates to about 400 tickets per day.
Division staff faced many challenges in trying to coordinate and manage the work in the most efficient way. One major challenge was the inability to see job locations and analyze other pertinent data, such as infrastructure, ownership, or parcel information. Use of their outdated paper-based system resulted in inefficient workflows, delays, job overlaps, and bottlenecks. Field staff didn't have access to all the information they needed. Consequently, this affected resolution of work orders.
Staff from the Drain Maintenance Department within Public Works requested that the Enterprise GIS Department of Information Services Division work with them to develop an end-to-end solution for tying operational work processes, enabling the management team and field supervisors and crew to have near real-time access to service ticket information. In addition, all relevant location data had to be made available, either out in the field or in the back office, for reporting and dashboard purposes.
As a result of implementing this suite of GIS solutions for drain maintenance, department staff have reduced their ticket closing time by 33 percent from the previous year. The average time for closing service requests dropped from 12 to 8 days. Repairing cavity jobs shrank from nearly a month to just under a week.
Robert Knecht, director of Public Works for the City of Memphis, immediately saw the value of this solution. "The ArcGIS Online apps have provided the ability for my Public Works crews to have access to important and needed information in the field, plus allowing work to be completed in the field using the Collector [for ArcGIS] app, while also making it possible for my management team to have access to that same information using the [Operations] Dashboard [for ArcGIS] tool; all of which have changed the way we work and deliver services to citizens. Using these apps, we have significantly enhanced productivity levels and the efficiency at delivering services, as we are now able to make decisions more quickly based on accurate and timely data. Ultimately, these ArcGIS Online apps are revolutionizing how Memphis Public Works is able to provide services, as increased productivity and accountability, implementing new sustainable practices, and using information in strategic ways have really made a difference in how we are able to operate. Given our success, we're now looking to roll out this capability to all areas of Public Works."
Copyright © [Current Year] Esri. All rights reserved. Esri, the Esri globe logo, esri.com, and ArcGIS are trademarks, service marks, or registered marks of Esri in the United States, the European Community, or certain other jurisdictions. Other companies and products or services mentioned herein may be trademarks, service marks, or registered marks of their respective mark owners.