CCTV Storage and Management Solution Software

The vendor is required to provide cctv storage and management solution software to file management and storage, the city is interested in exploring other applications and capabilities of software currently on the market, particularly the ability to organize condition data based on maintenance and rehabilitation needs, as well as to integrate pipe condition data into a GIS format.
- Cctv inspection storage and access
•    Ability to upload and store sewer cctv inspections and data obtained from the city’s annual sewer inspection program as well as cctv work completed on an as needed basis for various city works.
•    The system must be able to effectively store large amounts of data. 
•    The cctv inspection program currently contracts out approximately 90,000 m of sewer mainline cleaning and inspection on an annual basis, plus any additional small-scale projects requested throughout the year. 
•    The server currently used for video and report storage contains inspection data from 2005 to the present, totaling 2.5 tb in size. 
•    Some deliverables from this period may still be reside on external storage devices. 
•    It is crucial that the proposed software can store all existing files in addition to accommodating future years of new inspection files.
•    Ease of access to the stored data and ability to quickly search for a specific asset. 
•    To support broader access for both internal and external users, the system should enable data retrieval through an API and direct link functionality.
- Cctv inspection data management
•    The ability to perform large scale queries on inspection observations (i.e., areas of infiltration, serious structural defects, pipes requiring routine operations and maintenance, etc.), as well as search based on pipe details (i.e. pipe use (storm/sanitary), material, size, street, etc.). 
•    The ability to create, format, and export reports using the inspection data. c) the ability to export microsoft access databases. 
•    The ability to export multimedia datasets.
- Integration with GIS and mapping capabilities
•    Integration of the city’s sewer infrastructure mapping (sanitary and storm mainlines, laterals, access points, etc.) into the software. 
•    The city has standardized on the Esri platform; therefore, the system should be able to fully integrate with Esri applications and enterprise databases. 
•    The ability to link pipe condition determined from the inspections to the specific assets on the map. 
•    The ability to manipulate symbology such as line segment color, to visually indicate condition status (i.e., very good = dark green, good = light green, fair = yellow, poor = orange, very poor = red).
•    The ability to link visual data to specific assets on the map (i.e., inspection photos and shortcuts to the inspection video).

- Questions/Inquires Deadline: November 12, 2025