header-left
File #: 1345-2023    Version: 1
Type: Ordinance Status: Passed
File created: 4/29/2023 In control: Public Utilities Committee
On agenda: 9/18/2023 Final action: 9/21/2023
Title: To authorize the Director of the Department of Public Utilities to enter into a contract, in accordance with sole source provisions of City Code, with ADS Environmental Services for the purchase of PRISM cloud-based data management software for the Division of Sewerage and Drainage, and to authorize the expenditure of $49,000.00 from the Sewer Operating Sanitary Fund. ($49,000.00)
Attachments: 1. Ord 1345-2023 Financial Coding - PRISM Cloud-Based Data Management Software, 2. Ord 1345-2023 Sole Source - Form - ADS Prism Software, 3. Ord 1345-2023 Sole Source - Vendor Quote - ADS Prism Software - March Update, 4. Columbus, Ohio Sole Source Letter (part 1) - signed

Explanation

 

This legislation authorizes the Director of Public Utilities to enter into a contract with ADS Environmental Services for the purchase of PRISM cloud-based data management software for the Division of Sewerage and Drainage (DOSD). This contract will be established in accordance with the relevant provisions of Chapter 329 of City Code relating to sole source procurement. 

 

The DOSD 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. ADS Environmental Services’ 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’ 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 City will be able to import historic data as well as have the ability to create active locations directly through the PRISM interface by entering GPS coordinates, device IP address, and other required site details.

 

SUPPLIER

 

ADS LLC dba ADS Environmental Services. (FID #80-0355805) (Vendor #010326), Expires February 4, 2024.

 

ADS LLC. does not hold MBE/WBE status.

 

The company is not debarred according to the Excluded Party Listing System of the Federal Government or prohibited from being awarded a contract according to the Auditor of State Unresolved Findings for Recovery Certified Search.

 

FISCAL IMPACT

 

$49,000.00 was budgeted and needed for this expenditure.

 

$48,000.00 was spent in 2022

$0.00 was spent in 2021

 

Title

 

To authorize the Director of the Department of Public Utilities to enter into a contract, in accordance with sole source provisions of City Code, with ADS Environmental Services for the purchase of PRISM cloud-based data management software for the Division of Sewerage and Drainage, and to authorize the expenditure of $49,000.00 from the Sewer Operating Sanitary Fund. ($49,000.00)

 

Body

 

WHEREAS, the Department of Public Utilities has a need to enter into a contract with ADS Environmental Services for the purchase of its PRISM cloud-based data management software; and

 

WHEREAS, the Department of Public Utilities utilized an obsolete desktop program to manage roughly 150 flow meters and 30 Rain Gauges throughout the city that no longer received vendor support; and

 

WHEREAS, In 2022, SSES implemented PRISM to replace the old software. SSES’s Flow Monitoring Group supports flow meters and rain gauges using PRISM; and

 

WHEREAS, ADS Environmental Services’ PRISM software is the only data warehouse platform capable of performing the critical tasks specific to ADS flow meters and rain gauges and thus choosing a different cloud-based data management option would require continued operation of the obsolete software; and

 

WHEREAS,  the software will enable the City to import historic data as well as have the ability to create active locations directly through the PRISM interface by entering GPS coordinates, device IP address, and other required site details; and

 

WHEREAS,  ADS will provide the City with two (2) online training sessions (approximately one hour each) over the course of the contract period. Additional training is available via PRISM online help, online videos, and other available training resources; and

 

WHEREAS, the Department of Public Utilities wishes to enter into a contract, in accordance with the relevant provisions of Chapter 329 of City Code relating to sole source procurement, for a period of one (1) year in effect from the date of contract execution; and

 

WHEREAS, the contract will provide an annual license for up to 25 users and 200 live devices and imposes no hosting or other IT resource requirements on the City; and

 

WHEREAS, the expenditure of $49,000.00, or so much thereof as may be needed, is hereby authorized in Fund 6100, Sewer Operating Sanitary Fund, in object class 03, Services, per the accounting codes in the attachment to this ordinance; and

 

WHEREAS, it has become necessary in the usual daily operation of the Department of Public Utilities, Division of Sewerage and Drainage, to authorize Director of Public Utilities to enter into a contract with ADS Environmental Services for the purchase of its PRISM cloud-based data management software; NOW, THEREFORE

 

BE IT ORDAINED BY THE COUNCIL OF THE CITY OF COLUMBUS:

 

SECTION 1. That the Director of Public Utilities is authorized to enter into a contract with ADS LLC dba ADS Environmental Services, 340 The Bridge Street, Suite 204, Huntsville, AL 35806, for its PRISM cloud-based data management software for a period of one (1) year in accordance with the relevant provisions of Chapter 329 of City Code relating to sole source procurement. 

 

SECTION 2. That the expenditure of $49,000.00, or so much thereof as may be needed, is hereby authorized in Fund 6100, Sewer Operating Sanitary Fund, in object class 03, Services, per the accounting codes in the attachment to this ordinance.

 

SECTION 3. That the funds necessary to carry out the purpose of this ordinance are hereby deemed appropriated and the City Auditor shall establish such accounting codes as necessary.

 

SECTION 4.  That the City Auditor is authorized to make any accounting changes to revise the funding source for all contracts or contract modifications associated with this ordinance.

 

SECTION 5. That this Ordinance shall take effect and be in force from and after the earliest period allowed by law.