Explanation
BACKGROUND
This legislation authorizes the Director of Columbus Water and Power to enter into a contract with ADS Environmental Services, LLC. for the continued usage of PRISM cloud-based data management software for the Division of Water Reclamation (DOWR). This contract will be established in accordance with the relevant provisions of Chapter 329 of City Code relating to sole source procurement.
The DOWR Sewer System Engineering Section’s (SSES) Flow Monitoring Group supports roughly 150 flow meters and 30 rain gauges through an obsolete desktop program that no longer receives vendor support. Previous software program was increasingly difficult to run and frequently crashed. In 2022, SSES implemented PRISM with ADS Environmental Services’ LLC. PRISM software will serve as a more efficient and accessible way to store, monitor, and utilize flow data. The contract will provide the City with an annual license for up to 25 users and 200 live devices and ADS’ cloud-based software imposes no hosting or other IT resource requirements on the City. ADS will also provide two online training sessions over the course of the contract, in addition to other resources available through online help or prior training videos.
PRISM is the only data warehouse platform capable of performing the critical tasks specific to ADS flow meters and rain gauges. Several of these tasks require proprietary access to and knowledge of ADS Environmental Services’ LLC. hardware. Additionally, PRISM can auto poll all the flow meters, which will allow SSES to completely abandon the obsolete software. No other platform can communicate with the meters so choosing a different cloud-based data management option would also require continued operation of the obsolete software.
In addition to its proprietary advantages, PRISM provides mapping, storage, exporting, dashboard, reporting, and data editing tools that allow for the scrubbing of raw flow data to provide meaningful insights. The Ci...
Click here for full text