Data Management and e-Reporting

KimHEC is currently developing a proprietary online web application called DROP – Data Reporting and OPerations. Because data collection plays a critical role in maintaining an effective wastewater pretreatment program, DROP will make it possible to track and analyze the data for our clients more efficiently.

DROP consists of multiple components and is designed to bring those elements together to help effectively manage pretreatment programs. Below is a description of each component currently in production:

  • Contract Laboratory Data: KimHEC works with multiple contract laboratories to generate reports which interface and upload automatically into DROP. These reports include industry data, POTW data, collection system data, and biosolids data.
  • Industrial User Permits: KimHEC enters permit monitoring and permit limits into DROP so that data reported by industrial users can be entered into DROP as well. The data is checked against permit limits and violations are identified.
  • Industrial User Report Templates: the DROP application generates templates which can be downloaded into Excel to facilitate data entry for parameters such as daily flows, field pH readings, and pollutant concentrations for parameters which are not brought in from the contract laboratory data.
  • Mass Loadings and Mass Limits: KimHEC calculates mass loadings as a standard calculation for evaluating results. When an industry has mass limits as part of their permit requirements the analytical results can be compared to the permit limits.
  • Customized queries based on date ranges, monitoring locations, and pollutants: DROP allows functionality of evaluating specific pollutants and easily comparing data across multiple locations (industry locations, domestic background locations, WWTP monitoring locations, etc) and making comparisons of relative concentrations. The queries can also be exported into Excel for further analysis and trending.

KimHEC is working on further developing DROP to be a tool in wastewater and pretreatment program management. Below is a preview of future modules that will be further built out:

  • Sewer and surcharge billing: DROP will distinguish between a permit limit and a surcharge and will generate bills for industrial users for a specified monitoring period.
  • Biosolids tracking and documentation: DROP will take the analytical data which is already stored in DROP and will provide additional functionality to document the daily biosolids generated, the method of disposal, and cumulative loading calculations for metals (historical) and for nutrients (per growing season).
  • Local Limit Evaluations and Mass Balances: DROP will evaluate analytical data to monitor the effectiveness of the pretreatment program. Based on mass balance evaluations, key pollutants of concern will be identified for which additional data collection and consideration is warranted.
  • Historical Trending and Visual Graphics: A key component to the functionality of DROP is to provide visual tools so that all the data being collected can be used to trend historical data and evaluate correlations between multiple monitoring locations.

Components of KimHEC Data Management

 

Laboratory Coordination
Including sample plans, determination of reporting limits, report generation, electronic distribution, analytical methods.

Integrated Data Management
Combine industrial monitoring data with wastewater treatment plant data to evaluate industrial impact on the community’s wastewater treatment plant. Data is also evaluated to determine appropriate monitoring frequencies and to identify pollutants of concern.

Industrial User Reporting Evaluation
Industrial User Reports are evaluated for compliance. Reports can be generated to demonstrate industrial compliance and to identify instances of noncompliance.

NPDES Reporting
KimHEC’s data management system is capable of generating electronic data for upload into electronic reporting for operating permit compliance.