[Home] [Master Table of Contents]

[Table of Contents]

SAP Addendum Specific to Field Sampling Plan for Subsurface Soil Boring Activities at AOC-65 and AOC-67 under AETC DO 5084

Section 4 - Data Management Process

A process for collecting and entering data into electronic formats was developed specifically for the soil gas survey planned under this delivery order. The key component of the data collection process is use of a Trimble ProXR/XRS Receiver with the TSC1 Data Logger, and the associated Pathfinder Office Software. The general details of this process are listed below.

  1. A data dictionary will be created in Trimble Pathfinder Software that will include the site identification (siteid), location identification (locid), oxygen (O1) levels, lower explosive limit (Lel), sampling depth (depth), date, time, and remarks.

  2. A preliminary grid of the initial 400 grid locations will be prepared using the CSSA GIS, and the Trimble Receiver will be used to locate and mark the corners of the grid and a few additional benchmarks.

  3. Approximately 15-20 grid points will be laid out daily using stakes prior to starting any soil gas sampling.

  4. The soil gas sample will be collected as described in this SAP and SAP addendum. Data collected in the field (siteid, locid, O1, Lel, depth, and remarks) will be entered directly into the Trimble unit. Date, time, and coordinates are automatically generated by the Trimble unit.

  5. At the conclusion of each day, the data in the Trimble unit will be downloaded into a computer at CSSA utilizing the Trimble software. It may be necessary to correct the locational data using differential calculations during the downloading process.

  6. The mobile laboratory will provide preliminary data to CSSA and Parsons ES on a daily basis (one day following sample collection). The locational data and preliminary data will be merged into a preliminary data file. Following receipt and review of the ERPIMS formatted data from the laboratory, Parsons ES will merge the final data with the locational data into a final data file in Microsoft Access.

  7. Data can be analyzed in ArcView or through other means, to identify portions of the grid that should receive more focus based on the results of the original grid survey. 

  8. An estimated 15-20 samples will be collected on a typical day, so review of soil gas results should be undertaken at least once per week to begin planning for the additional 200 grid points included in the scope of work for this delivery order. The frequency of these reviews will need to increase as the survey nears the completion of the original 400 grid points.