Menu
The City’s previous system was a hodgepodge of informal business processes, heavily reliant upon one employee’s “master spreadsheet” which would be shared among engineers who frequently had to figure out whose version of the spreadsheet was the most recent when determining which capital improvement projects to prioritize. This informal system was built atop an asset inventory which was outdated and incomplete.
A GeoCortex app to visualize and share Colorado Spring Sewer-Stormwater assets and Capital Improvement plans among City staff. This app includes tools to guide and automate capital improvement planning, costing, and prioritization. Components of this product included consultation on data schema, ETL, IT system design, product implementation, and training.
The City’s previous system was a hodgepodge of informal business processes, heavily reliant upon one employee’s “master spreadsheet” which would be shared among engineers who frequently had to figure out whose version of the spreadsheet was the most recent when determining which capital improvement projects to prioritize. This informal system was built atop an asset inventory which was outdated and incomplete.
DDS consulted with the City and another contractor to develop an effective schema for existing sewer/stormwater assets and Capital Improvement Planning (CIP) management that gave City engineers the information that they need to understand existing infrastructure needs and prioritize maintenance and development.
After another contractor completed their inventory of existing assets, DDS developed a web application that included tools to guide City engineers through setting up and editing CIP projects and phases, while automating GIS creation related to those projects. The app includes tools to help generate automated cost estimation based upon the expected assets needed for the project, as defined by engineers as drawn on the map or as recorded as non-spatial line-items in a table. Engineers could share these projects with other employees in a team to update CIP data, or as a presentation tool to stakeholders in other organizations such as utilities or construction. The application also provides the ability for users in a higher tier of permissions to update the behavior of its tools through the application interface itself, for example by uploading a new table of asset costs per unit to update the automated costing of a line of a 48” box culvert.
DDS also developed documentation to walk new users through the application tools, after holding meetings with City staff to help train them on application use and see how they interacted with the application. DDS also provided consultation to help City IT staff implement and migrate the app through their development, testing, and production environments.
Copyright © 2022, Digital Data Services, Inc. All Rights Reserved.
Trademarks provided under license from Esri.
Other companies and products mentioned are trademarks of their respective owners.