The vendor is required to provide technical support is required to maintain the database and develop enhancements to the system and complex tools includes monitoring for national pollutant discharge elimination system (NPDES) permits, total maximum daily loads (TMDL), and other environmental special studies.
- To carry out the collection, management, and analysis of extensive datasets, division utilizes a centralized water quality database system equipped with specialized data collection, visualization, analysis, and reporting tools.
- Support for data analysis and reporting tools is also needed to complete compliance analyses, integrate new dashboard functions, conduct trends analyses, and support integration for various standardized data formats.
- Provide as-needed technical support to conduct maintenance and develop enhancements to division water quality database system in order to fulfill ongoing and future reporting requirements for city-led monitoring programs.
- Such support services shall be on an as-needed and as-directed basis.
- Provide technical support for developing, maintaining and troubleshooting the following components of the database system:
• Desktop data manager application
• Web based application
• Mobile (field) application
• Database hosting
• Data servers and connectivity with external databases (e.g. state city’s network servers, laboratory information management systems (LIMS), lake monitoring servers).
• Test environments to test new features and other changes to the system.
• Customizable, robust and user friendly desktop data manager application, web based application, and mobile application.
• Development of dashboards to aid in the visualization of water quality parameters against compliance targets and other performance metrics.
• Development of comprehensive data analysis and reporting tools capable of, but not limited to the following:
1. Exceedance and compliance analyses to assess water quality monitoring data along with various water quality objectives.
2. Trends analysis such as Mann Kendall non-parametric trends test
3. Rolling geometric means calculation and reporting
4. Other tests and analyses that will support the evaluation of water quality data and will streamline the annual reporting process.
• Automate dashboard functions and data analysis and reporting tools.
• Integration of specialized GIS functions and ability to display data on interactive maps.
• Integration of historical data to conduct long-term trends analysis of water quality data.
• Integration of data collection across different platforms/software with the ultimate goal of being able to display real time monitoring data on a web-based interface so that it is readily available to watershed managers.
• Data visualization dashboards
• User-friendly data analysis and reporting tools capable of the aforementioned functions.
• Procure specialized equipment, software, hardware, and other materials to support compatibility with upgraded features to database applications maintaining effective and reliable usability.
• As-needed items such as computers, tablets, cameras, accessories, and other materials needed to perform related work on an urgent basis.
• Provide on-call technical support in a timely manner, maintaining the integrity of the data, continuity of user access to the data, and database functionality.
• Meet with users and support staff on an as-needed basis to discuss issues, desired changes/upgrades, and status updates regarding the database system and applications.
• Provide training to users and support staff; demonstrating how to use database components and any updates and new features added.
- Contract Period/Term: 3 years
- Virtual via Google Meet video teleconference Date: May 08, 2025