LASAN is soliciting a qualified consultant firm to provide as-needed technical support to conduct maintenance and develop enhancements to WPD’s 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. The following provides more details regarding the services from the qualified consultant: Task 1: Provide technical support for developing, maintaining and troubleshooting the following components of the database system: a. Desktop Data Manager Application b. Web based Application c. Mobile (field) Application d. Database Hosting e. Data Servers and connectivity with external databases (e.g. LA City’s Network servers, Laboratory Information Management Systems (LIMS), lake monitoring servers). f. Other miscellaneous components of the system, not limited to the following: i. Import and exporting data reports in various Electronic Data Deliverables (EDD) formats, such as the California Environmental Data Exchange Network (CEDEN) standardized reporting templates. ii. Data querying (display search data and generate reports). iii. Support in migrating historical data sets. iv. New features that will improve workflow and consistency with monitoring and reporting requirements. Deliverables: ● 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. Task 2: Provide technical support for the expansion of dashboard data visualization, analysis and reporting tools, including but not limited to: a. Development of dashboards to aid in the visualization of water quality parameters against compliance targets and other performance metrics. b. Development of comprehensive data analysis and reporting tools capable of, but not limited to the following: i. Exceedance and compliance analyses to assess water quality monitoring data along with various water quality objectives. ii. Trends analysis such as Mann Kendall non-parametric trends test iii. Rolling geometric means calculation and reporting iv. Other tests and analyses that will support the evaluation of water quality data and will streamline the annual reporting process. c. Automate dashboard functions and data analysis and reporting tools. d. Integration of specialized GIS functions and ability to display data on interactive maps. e. Integration of historical data to conduct long-term trends analysis of water quality data. f. 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.
