Streamlining CCR Compliance.pdf

Travis Clark, Tetra Tech, Inc.

Description

Streamlining CCR Compliance using a Groundwater Data Management System Authors Mr. Travis Clark - United States - Tetra Tech, Inc. Abstract An electric utility company partnered with Tetra Tech to develop a groundwater data management system (DMS) that streamlines their CCR groundwater monitoring process, automates data collection and storage, and provides a tool to ease tracking and confirm compliance across the utility. The DMS improves data quality by including sample planning tools and electronic data deliverables (EDD), a field data collection application for use at hundreds of locations at more than 15 waste facility sites, data processors to import field data exported from data loggers as well as lithology and well construction data exported from external geotechnical software, and a web-based interface to laboratories for EDD tracking and management. Additional features include immediate, interactive feedback on data uploads that mitigates quality drift and tightens workflows, complete data traceability by maintaining a history of all changes. For analysis and reporting, the DMS includes business intelligence dashboards for understanding analyte criteria exceedances, with reporting and analytics to determine trends and correlations. Additionally, automated, reproducible report tables were developed which save over three weeks of labor annually in report preparation. The utility’s DMS was developed from a core data management system and customized to suit the specific needs of the utility. The core DMS has a flexible design, as addition of new tables or fields to the database are automatically supported by the system software so no code changes are required. This allows the DMS to be easily customized to suit the needs of a particular groundwater monitoring program while minimizing costs. This DMS improved the utility’s ability to track compliance, plan their work, organize their data, prepare reports, and provided easy data access to everyone involved.

 
May 14th, 10:30 AM May 14th, 11:00 AM

Streamlining CCR Compliance.pdf

Grand Rapids, Michigan

Streamlining CCR Compliance using a Groundwater Data Management System Authors Mr. Travis Clark - United States - Tetra Tech, Inc. Abstract An electric utility company partnered with Tetra Tech to develop a groundwater data management system (DMS) that streamlines their CCR groundwater monitoring process, automates data collection and storage, and provides a tool to ease tracking and confirm compliance across the utility. The DMS improves data quality by including sample planning tools and electronic data deliverables (EDD), a field data collection application for use at hundreds of locations at more than 15 waste facility sites, data processors to import field data exported from data loggers as well as lithology and well construction data exported from external geotechnical software, and a web-based interface to laboratories for EDD tracking and management. Additional features include immediate, interactive feedback on data uploads that mitigates quality drift and tightens workflows, complete data traceability by maintaining a history of all changes. For analysis and reporting, the DMS includes business intelligence dashboards for understanding analyte criteria exceedances, with reporting and analytics to determine trends and correlations. Additionally, automated, reproducible report tables were developed which save over three weeks of labor annually in report preparation. The utility’s DMS was developed from a core data management system and customized to suit the specific needs of the utility. The core DMS has a flexible design, as addition of new tables or fields to the database are automatically supported by the system software so no code changes are required. This allows the DMS to be easily customized to suit the needs of a particular groundwater monitoring program while minimizing costs. This DMS improved the utility’s ability to track compliance, plan their work, organize their data, prepare reports, and provided easy data access to everyone involved.