Groundwater monitoring report streamlining techniques - 15305
Compliance with national and state environmental regulations (e.g. RCRA and CERCLA [SuperFund] requires Savannah River Site (SRS) to extensively collect and report groundwater monitoring data, with potential fines for missed reporting deadlines. Large reports, which may contain dozens to hundreds of monitoring stations, are especially challenging to present data in a way that is quick and easy to interpret. Initially analyzing hundreds to thousands of records of data to be summarized in the report can be daunting, and producing maps can be extremely time consuming. Several utilities have been developed at SRS to facilitate production of the regulatory reports which include data tables, charts, maps, and cross-sections. Components of each report are generated in accordance with complex sets of regulatory requirements specific to each site monitored. SRS developed a relational database to incorporate the detailed reporting rules with the groundwater data, and created a set of automation tools to interface with the information and generate the report components. Maps produced with ArcGIS use a technique that can be repeatedly used to display data very quickly and in a consistent form. Cross-sections developed with RockWorks provide a more technical and geological analysis and representation of well and boring data, while allowing for automated data placement. These process improvements have streamlined the repetitive job of creating data tables, charts, maps, and cross-sections. It has also enhanced report quality and consistency by centralizing the information, and has reduced manpower and production time through automated efficiencies. (authors)