The Town of Franklin, MA has an approximate population of 35,000 residents and a full-service Department of Public Works to manage everything from water and waste, to
streets and highways, parks, and everything in between. Like most utilities today, Franklin Public Department of Works (FDPW) is in the process of a digital transformation.
It started some years back with a web-based work order system that was used primarily to log customer complaints and requests. The information was kept in either spreadsheets, on paper or simply through verbal communication. Like most journeys, FDPW realized they needed to change course as they were collecting lots of information, but were not able to leverage the information to streamline daily workflows.
Information driven maintenance
LBCWD uses the new platform for its maintenance programs including hydrant, valves, meters, sample stations, backflow, pumps, water mains, laterals, water leaks and emergency pumps. Work orders get assigned to a field crew who can see the work location on a GIS map and layer in assets that may affect or be affected by the work that needs to be done. The geographical display gives crews a holistic view of the work area so they can see where the water is coming from and where it is going. Crews can update progress in real-time in the field and schedule additional work if needed and move on to the next job.
Having records of past work often helps field crews to resolve issues, so they see the value in record keeping which motivates them to add more data. LBCWD is working on building a strong historical baseline. “The more data we can collect, the better we can plan and predict situations before they become an issue,” said Young.
As more utilities are finding, when they replace one manual process with a technology solution, it accelerates additional advancements. In 2016 LBCWD switched to advanced meter infrastructure (AMI) which ended manual meter reading, but inadvertently lead to ending meter box inspections. The new program is run efficiently through Sedaru tracking the progress of the two-person field crew as they record findings in the field. If needed they can write a ticket for construction in the field if the job is outside of their scope, before moving on to the next box.
Integration with existing software
LBCWD uses Wachs valve machine in support of its valve exercise program. Using an advanced application integration (API), Sedaru now remotely operates the Wachs valve machine, while automating field data collection, eliminating the need for manual data entry to be completed in the office and automatically updating the valve status in real-time.
811/Utility Locates service, or DigAlert as it is known in California, is also integrated into the platform saving LBCWD time by automating the process. When a DigAlert ticket comes in, Sedaru parses the ticket information into the utility’s GIS, digitizes each ticket’s attributes, and presents the location on a map. The program reports all tickets and prioritizes those qualified as an emergency. If a ticket falls within the utility’s service area, the program automatically creates a work order.
Work orders can be automatically assigned based on location or an administrator can assign field personnel based on current location, expertise, or workload, and add any special instructions before sending to the field locator’s mobile device. Assigned tickets can be seen on a map and details can be drilled down in Field Force. The App has a tape measure feature that allows the field crew to determine the distance of the area, record information such as field status, pictures, and comments, and then automatically submit the Positive Response to DigAlert. By digitizing the process, LBCWD also gains an accessible historical record that provides defensibility in the event damage occurs.
Improved visibility into leak monitoring
LBCWD is fortunate to not have a lot of leaks, but the old way of tracking on paper meant repair work was sometimes missed. The new platform allows work crews to monitor leaks when they are on-site, and instantly add or mark a change in a leak. Young said, “Layering of information helps us to track and repair leaks when we are next in the area before it becomes a bigger issue.”
Actionable data
Having data on all assets organized both visually and in detail in one place, makes it easy to use. For example, in a redevelopment situation, LBCWD can look at a map and see what assets will be affected when a building gets torn down and rebuilt. The new build may require a different pressure zone, or a larger house may need a bigger meter etc. If a new development is going in, LBCWD can quickly see if there is water to the lot or if system improvements need to be made.
The more information that is gathered into the operational management system the more likely it is to become valuable throughout the utility. “Recording maintenance helps us budget for capital planning. As we build strong historical baselines, we expect to be able to be more proactive and plan for new challenges such as extreme weather events and measuring the benefit of new technologies and infrastructure improvements.”
Recording maintenance helps us budget for capital planning. As we build strong historical baselines, we expect to be able to be more proactive and plan for new challenges such as extreme weather events and measuring the benefit of new technologies and infrastructure improvements.
Impressive technology adoption by the whole team
“Staff are building trust in the data stored in the management platform and so they are using it on a more frequent basis,” said Young. “Having a user-friendly experience for field crews to enter information is more appealing than scratching an instruction on a napkin or making a note on the back of a sheet and then remembering what to do with it when you get back to the office. That said, we are asking our workforce to do things differently and there are times when an iPad is hard to see in the sun, and it needs to be handled with care, which is not always easy to do in the rain or mud. So, we are asking people to do the best they can, and we are really pleased with the results.”
Overall, the benefits of having real-time data in the field help crews to understand how decisions are being made, and how they can find efficiency. As water utilities are being asked to do more with less, these efficiencies, wherever realized, are helpful and crews know it.