Case Study

Maple Grove, MN Using OpenGov and ArcGIS to Build Data With Integrity

Recognized as the Second Best City in America, Maple Grove, MN, is a community that citizens take pride in. To help maintain its strong status and good condition, city leaders invested in OpenGov. Learn how they're leveraging the software to help prioritize maintenance projects and ensure the preservation of infrastructure assets.

The Challenge

Maple Grove had a large amount of streetlight assets on different repair timelines. Without a central database, it was difficult to track the condition and work history of those assets.

The city was also working with a variety of materials on its streetlights. Some poles were aluminum; others steel. The height and width of the poles varied, and there were differences in the spread of bolts. The department sought a way to standardize and stock the materials to expedite repairs and keep assets in prime condition for citizens.


Agency Type

Annual Budget

Public Works


Asset Management

Customer Results

Well-oiled data machine

Improved communication between public works and engineering departments

5500+ resident requests entered into database

The Solution

The public works department went to work with OpenGov’s mobile technology. Government GIS Analyst Heather Albrecht and a handful of interns began the process of verifying the location of every streetlight, relying on Esri maps in OpenGov. They conducted inspections to confirm details and conditions, gradually illuminating their ArcGIS map with 4,000 tiny dots marking each streetlight in the city.

“We were able to complete the inspection of all city-owned streetlights in half the summer, with the help of two interns.”

This asset collection brought to light a clear picture of which streetlights needed attention, where to direct the engineering department, and how to allocate resources. The streetlight inventory and condition survey was a significant project, but Heather’s team was able to finish the task smoothly—and in a fraction of the time they expected.

“We were able to complete the inspection of all city-owned streetlights in half the summer, with the help of two interns,” says Heather.

The team measured and collected data to account for the full range of poles on the field—detailed information not easily found filed away at the office. This allowed them to develop a “universal street pole” and order greater quantities to stock for when repairs were needed.

The power and precision of Maple Grove’s local government GIS data was key. Through the survey project, the team was able to build a complete and accurate streetlight inventory—and share that information across previously disparate systems. The comprehensive web map linked assets to a variety of data sets, all in one accessible system.

“You’re looking at information in many different media, all accessible in OpenGov,” says Heather. “OpenGov pulls together fragmented pieces of info, building data with integrity.”

The Results

After fresh inspections and data collection, the team had an OCI on every streetlight and a live condition of every pole in the field. With everything in one place, thousands of assets and their conditions were one click away—and it was easy to see what work needed to be done first.

“Putting the power of the data entry into the hands of the people who actually know what’s out there has been really helpful to us.”

“OpenGov has helped the communication between the public works and engineering departments,” says Tim Brandon, street department lead for the public works department. “This project gave us a really good picture of what we have out there—and helped us direct the engineering department to the areas we needed to focus on.”

Now, repairs are a year-round endeavor. The department’s workforce triples in the summer, running queries and using ArcGIS mapping functions in OpenGov to reveal trouble spots. This shows the team where to prioritize replacements and perform upgrades in the fall. It’s a well-oiled machine, thanks to the data they now have at their fingertips.

“Our use of OpenGov has streamlined the workflow,” says Tim. “The widespread use of technology in the field has made our staff more efficient.”

“Putting the power of the data entry into the hands of the people who actually know what’s out there has been really helpful to us,” adds Heather. “Being able to track all of the activities done to that asset and costs associated with them is really valuable. It helps us analyze and prioritize—just like we did with the streetlights.”

Now, the department is two years and over 5,500 civilian requests into its use of OpenGov, and the database of assets is growing every day. They are expanding their operations management system to include a comprehensive tree inventory and municipal storm sewer compliance program among other projects—and with the integration between OpenGov and ArcGIS, they say the possibilities for future efficiencies and long-term benefits for citizens are endless.

Related Case Studies

Learn More
Case Study
How Boulder County, CO Makes Budgeting Fun While Increasing Efficiency
Learn More
Case Study
How the City of Claremore, OK Promotes Growth for Faster Economic Development
Learn More
Case Study
Open for Business: How the Village of Bolingbrook Digitized its Front Door With OpenGov Permitting & Licensing