Water Information Management System

The Vendor is required to provide a software system to replace the current process of using hand-written readings, spreadsheet logs and reports.
- Operations include water treatment and supply (wholesale and retail), wastewater collection and treatment, reservoir and dam operations, canal and diversion system operations and administrative support.
- The system will need to provide a software application that allows for data entry, customizable dashboards and reporting along with a mobile application that has store-and-forward capabilities to allow data entry from the field.
- The software system will need to replace the current processes of hand-written readings, spreadsheet logs and reports that are generated from spreadsheet logs.
- Implementation and training costs will need to be included. 
- The system must be capable of importing LIMS and SCADA database information from Microsoft SQL servers. 
- An option for continued maintenance support is also required.
- User guide shall be provided that describes the software from an end-user’s point of view. 
- Database design documentation shall also be provided that describes both the logical and physical structure of the system’s database.
- Proposer shall include an annual subscription and maintenance agreement that includes technical support, patches, and upgrades for the software.
- support options available (i.e., phone, email, chat, etc.), support hours of operation, expected response time, and any options for onsite assistance.
- The software will consolidate data from multiple disparate systems into a centralized platform, remove data silos associated with spreadsheet logs, and provide users across the organization with timely access to the data they need.
- Agency utilizes several systems to monitor operations, including SCADA, LIMS, CMMS, and GIS.
- Without integration, these systems operate in isolation, making it challenging to analyze operational data and overall utility performance.
- The software will integrate data from agency current systems, as well as provide tools for manual data entry from field observations. 
- By integrating data from multiple sources, the software will enable streamlined regulatory reporting, operations monitoring, and data-driven facility optimization.
- The software will store all incoming data in a centralized repository, accessible across all system modules. 
- The software will also provide configurable validation rules, allowing users to identify and flag missing, inconsistent, or erroneous data, as well as events that require attention. 
- Additionally, it will include user-friendly tools for configuring calculations, such as pump efficiency, energy consumption, and chemical dosing rates, preparing data for use in regulatory reporting and decision-making.
- The system will provide a structured reporting framework to minimize manual effort, including a library of pre-built and customizable report templates, supporting both tabular and visual (i.e., charts and graphs) formats, tailored to various reporting requirements. Intuitive tools will allow users to map both raw and aggregated data to report fields.
- Users will also be able to access in-progress reports, track updates in real time, and generate reports on demand or on a scheduled basis.
- Configurable dashboards will display operational data, including water quality parameters, energy consumption, equipment performance, and process efficiency.
- Users will be able to overlay and compare data streams from multiple integrated systems to identify trends, detect anomalies, and troubleshoot operational issues.
- The software must integrate with LIMS to make laboratory results readily available for regulatory reporting, and direct comparison with data from other integrated systems.
- The system records sample collection details, stores sample analysis results, and data for regulatory reporting.
- Agency uses ESRI ArcGIS as the primary Geographic Information System (GIS) for managing spatial infrastructure data. 
- The software must integrate with ArcGIS to link operational data from disparate systems to GIS assets, enabling agency staff to visualize real-time metrics like flow rates, pressures, and equipment status on interactive maps, and configure geospatial overlays for event-based analysis.
- A Mandatory Pre-Proposal Meeting Date: July 23, 2025
- Questions/Inquires Deadline: July 30, 2025