Case Study

How Charlotte County’s Move to Mobile Streamlined Recovery and Reporting

Charlotte County transitioned to OpenGov with big goals to increase efficiency with a mobile workforce and deployed a dozen iPads in the field. Users have picked up the system right away—and they’re easily pulling up real-time data for citizens and commissioners, proving need for asset repairs and new projects.

The Challenge

Charlotte County started using OpenGov, then called Cartegraph, for sign inventory management back in 1997. They tracked work orders in the legacy system, but struggled with a lack of GIS asset data and had the sense that they weren’t using the system to its full ability.

Three years later, the department switched up their process and began building a location-based asset inventory. They’d gradually add traffic signs into the system as they were being fixed. When Hurricane Charley struck in 2004, the county entered most remaining items into the system, totaling 50,000 sign locations with 85,000 signs.

Even with location-based data, however, the system wasn’t efficient—managers found themselves sending paper work orders out with crews and trafficking data through clunky systems. They knew it was time for a different approach.

Continue Reading


Agency Type

Annual Budget
USD 424,778,000.00

Public Works


Asset Management

Customer Results

85,000 signs managed with OpenGov

Streamlined disaster recovery and FEMA reporting

Efficient Work Order Management

The Solution

In the pinch, Town Public Works Director Michael Zarba suggested using OpenGov’s operations management software to get a better handle on asset collection and analysis. The town kicked off its efforts in 2010 with a focus on modern pavement management.

With 212 miles of road in New Milford, Stanton’s team dove immediately into asset collection—inputting valuable data like the length of each road, the OCI, and deterioration curves. They added a custom ADT field to capture traffic counts and calculate impact. It painted a clear picture of New Milford’s roads, which helped prioritize the biggest problem areas.

17% Reduction in Citizen Requests

“Now that we have the data entered, we’re prepared for conversations with council and can make sure we’re selecting the right roads at the right time,” says Stanton. “We use it for crack sealing too. We set a schedule to touch each road when it needs to be done the first time and follow up with additional crack sealing as time passes.”

The team is turning its attention to the town’s stormwater system: collecting assets, scheduling work, and using data to make decisions about materials. “We know corrugated metal pipes last less time than both RCP and HDPE pipes,” explains Stanton. “We’ve started entering all that data into OpenGov and that’s going to benefit the department for years to come.”

The Results

Thanks to the information tracked in OpenGov’s road asset management system software, the town engineer now knows exactly where the money is being spent. With four iPads equipping the highway team, asset entry and task creation has never been easier—and New Milford has the numbers to prove it.

“We have been able to maintain our pavement conditions despite limited funding increases and sporadic capital funding.”

Stanton’s team increased its database of storm inlets from 838 to 3,851 in just two years, and bolstered collections of other assets such as pipes, culverts, and guide rails. All tasks are connected to assets, creating a valuable archive of data for future project planning.

“Our organization has made progress in our asset maintenance program due to OpenGov,” says Stanton. “We have been able to maintain our pavement conditions despite limited funding increases and sporadic capital funding.”

The project came full circle when better asset management translated to happy customers—and in a few short years, Stanton’s team cut down work requests by 17 percent. The biggest benefit, Stanton says, is visualization: Office staff can pinpoint exactly where the problem area is when a citizen request comes in, giving Stanton’s team clear guidance to solve it efficiently.

Thanks to OpenGov’s insight in New Milford, Stanton has anticipated and offset future requests by adding 10,000 proactive tasks to maintain infrastructure. On the road ahead, Stanton has big goals for complete and comprehensive asset management—and the right public works software in place to reach them.

Want to learn more?

Related Case Studies

Learn More
Case Study
How New Milford Reduced Resident Work Requests by 17%
Learn More
Case Study
How This Ohio City Is Leveraging OpenGov and ARCGIS in Unique Ways
Learn More
Case Study
West Virginia is Now One of the Most Transparent States in the U.S.: Here’s Why