SACRAMENTO, CA – Geographic Technologies Group (GTG), a leading Esri partner specializing in GIS solutions for government agencies, has delivered a groundbreaking Capital Improvement Program (CIP) dashboard for the City of Fairfield, California. The solution has modernized internal operations, eliminated redundant workflows, and dramatically improved public access to real-time project data.
The City of Fairfield faced a familiar challenge: departments such as Finance and Public Works were maintaining separate project reports—often duplicative and inconsistent. This manual process created inefficiencies, delayed updates, and limited transparency.
GTG’s experts stepped in to design a fully integrated platform connecting Fairfield’s existing EasyCIP system (built on Knack) with Esri’s ArcGIS Online ecosystem. The team implemented an automated extract, transform, and load (ETL) workflow using ArcGIS API for Python and ArcGIS Notebooks, effectively eliminating manual data entry.
Key results of the implementation include:
- 80+ staff hours saved per month across 10+ departments
- Real-time dashboards and map-based visualizations for internal and public use
- Automated, standardized CIP reports replacing manual processes
- A user-friendly public portal that invites community engagement
“This was exactly the type of complex, multi-departmental challenge that GTG excels at solving,” said Principal Curtis Hinton. “By connecting systems and removing data silos, we created a solution that delivers operational efficiency while fostering public trust through transparency.”
The project’s architecture features single-point data entry, fully automated reporting, and seamless integration with ArcGIS Dashboards and ArcGIS Hub, allowing city staff and residents alike to monitor progress on capital improvement projects across Fairfield.
Empowering Staff, Engaging the Community
The impact of GTG’s solution was immediate. “Before GTG’s solution, we had to chase project teams for updates,” said Jasmin Acuna, Senior GIS Analyst at the City of Fairfield. “Now, project managers understand their role in maintaining accurate data. If something’s not showing up in the dashboard, they notify us. GTG delivered a system that staff instantly embraced.”
The public-facing CIP portal has also become a powerful tool for community engagement. Residents now have access to interactive dashboards that provide visibility into ongoing and upcoming projects, helping them stay informed and involved in local infrastructure developments.
“The response from the community has been overwhelmingly positive,” Acuna added. “It’s sparking real conversations around capital projects and city spending.”
A Scalable Model for Modern Local Government
Beyond Fairfield, the success of this project serves as a replicable model for other cities and counties seeking to modernize their capital planning processes. GTG’s flexible, department-centered approach combined with deep technical ArcGIS knowledge positions them as a strategic partner for digital government transformation.
“GTG didn’t just deliver a dashboard—they delivered a strategic shift in how we work and communicate,” said Acuna. “The system’s ease of use helps everyone—from department heads to residents—understand what’s happening and why.”
About Geographic Technologies Group (GTG)
Geographic Technologies Group is an Esri Gold Partner dedicated to helping local governments harness the power of GIS. With more than 2,000 projects delivered nationwide, GTG specializes in custom ArcGIS implementations that improve operational efficiency, drive decision-making, and foster stronger citizen engagement.
About the City of Fairfield
Located in Solano County, the City of Fairfield is known for its innovative approach to public service and transparency. The city’s investment in technology continues to set a high bar for forward-thinking governance across California.
