CITY COUNCIL AGENDA ITEM
ACTION REQUESTED:
title
Approve the award of Cooperative Procurement 23-023, ESRI Advantage Program - ArcGIS Utility Network Implementation, to ESRI for an amount not to exceed $672,400 over a period of three years
body
DEPARTMENT: Information Technology
SUBMITTED BY: Jacqueline Nguyen, Director
BOARD/COMMISSION REVIEW:
N/A
BACKGROUND:
The City has been using the ESRI geographic information systems (GIS) enterprise platform since 1994 to help manage, analyze, and model wastewater, water, and stormwater utility data. These three utility systems and associated components (manholes, pipes, etc.) are currently modeled in a geographic framework called the ESRI Geometric Network.
As part of ESRI’s shift in technology, the Geometric Network model for utilities that has been a standard for over 20 years is being deprecated and will reach end of support by 2026. It is being replaced with a new framework called the ESRI Utility Network.
In order to maintain operational continuity for GIS utility data management, and to stay aligned with supported technologies, the City must migrate wastewater, water, and stormwater GIS utility data to the new ESRI Utility Network model. This model will become the new standard for GIS utility data management for the next 10-20 years.
DISCUSSION:
In order to migrate the City’s GIS utility data model that tracks water, sewer, and stormwater assets to the new ESRI Utility Network model, the City plans to procure ESRI’s Advantage Program. This program will provide enough consulting and professional service hours to complete this project over the next three years.
The three-year implementation will include the following stages for all utilities:
Year 1
• Data quality review and readiness assessment
• System architecture design
• Implementation planning strategy
• Data mapping and modeling
Year 2
• Utility network data migration
• Utility network test plan
• Internal acceptance testing (IAT)
• User acceptance testing (UAT)
Year 3
• Utility network production implementation
• Final production data migration
• Utility network technical knowledge transfer
• ArcGIS monitor installation
• System performance testing
At the completion of the project, the City will have established a more robust foundation for scalable modeling across utility assets. This new model will increase access to information by staff in the office or the field resulting in increased efficiencies in operations and projects. It will be a complete system for designing and managing solutions for improved workflows and increased analytical capabilities. If the City did not migrate this data to the new model this application and its data would not be supported by the vendor.
Staff has identified an approved cooperative contract through the State of Illinois, Contract CMT1018633 for the procurement of the implementation and support services.
FISCAL IMPACT:
CIP #: CE166 - GEOMETRIC NETWORK UTILITY MIGRATION
Consultation costs to develop the scope of migration of the City’s GIS network are expensed to the account numbers listed below as part of the 2023 Capital Improvement Program. A total of $150,000 is allocated in the budget for these services. The remaining project costs which exceed the original estimate by $372,400 will be
budgeted accordingly during future budget cycles.
|
Account Number |
Fund Description |
Total Budget Amount |
|
16102000-531309 |
Water Capital fund |
$50,000 |
|
16102200-531309 |
Capital Projects Fund |
$1,200,000 |