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

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.

“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.