Water Monitoring, Standards and Pesticide Control (WMSPC) Laboratory Information Management System (LIMS) for BFBM Phase II

Description

Create web-based data management tool that handles all aspects of field and laboratory data management for BFBM. This shall include a station sample scheduling program to organize which monitoring locations are associated with which samplers, web forms to accommodate the various combinations of data entry required by each type of project, database storage solution that is flexible enough to handle all possible projects, simple to use query tools that can search, filter, and query data within the database to retrieve target data subsets of information, ability to export the data out as a .csv or .xlsx file to be used locally for analysis. For known reports and analyses, build a dashboard/switchboard function that automatically generate the canned reports and statistics. A mechanism for the program to easily add parameters and site locations as new projects arise or change from year to year. Customize an output routine of the data into pre-defined file structures that align with what the EPA requires when DEP submits data results annually.

Project Justification

While migrating these MS Access database backends to MS SQL Server would likely solve much of these issues, the bureau would like to move onto a more enterprise-based solution. This would eliminate the reliance on the few staff that understand MS Access programming code and put both DOIT and a Contractor in a better position to assist staff should issues occur.

Attachments

Activity

Mike.Kusmiesz 9 July 2025, 11:56

Received Purchase Order on 7/9/25. Work to begin soon.

Mike.Kusmiesz 7 May 2025, 19:31

SOW has been approved by DOIT/Contractor/Program. It will now be sent out to Resellers to get price estimates.

Mike.Kusmiesz 10 January 2025, 14:17

A SOW has been agreed to by the Program and Carrollton. DOIT reviewed and requested a few minor edits which were accepted by Carrollton. A request to Grace and Reynaldo to get Reseller quotes was made on 1/10/25.