Laserfiche WebLink
Appendix A <br />Development of the Phase 2 Task 43.2 Aquifer Properties Data Set <br />1. Duplicate pumping tests reported for the same well were excluded. <br />The tests were identified as being from the same well if they had <br />matching permit number ("permitno°) and suffix ("permitsuf"). The <br />test ("testdate'") with the earliest date was kept unless the more recent <br />test was amulti-well test, where "Storativit~' is not null. If the more <br />recent test contained a value in the "Storativity" field the newer test <br />was kept. (7 tests excluded) <br />2. Duplicate tests reported between Task 37 and HydroBase were <br />excluded. The tests were identified as duplicate if they had matching <br />permit number ("permitno°) and suffix ("permitsuf") and matching <br />test results ("testdate", "trans°, etc.), the Task 37 test was maintained <br />as it was considered to come from nearer the original source (2 tests <br />excluded). <br />3. Multiple Task 37 specific capacity tests for the same well were <br />excluded. The tests were identified as being from the same well if <br />they had matching permit number ("permitno°) and suffix <br />("permitsuf"), unless the suffix differed because it was a replacement <br />well. The earliest test was retained, including replacement well tests <br />taken over original well tests (19 tests excluded). <br />4. Lab samples from impermeable units and/or those reporting <br />vertical K values were excluded. A sample is defined as impermeable <br />('shale') or the results as'vertical k' in the "Comments' field of the <br />Pumping test table. (13 tests excluded) <br />5. Tests from HydroBase that are from wells completed in multiple <br />aquifers were excluded. These tests were identified where <br />"Aquifer2" is not null. (29 tests excluded, 2 additional tests were <br />already excluded as Duplicate Tests). <br />6. Task 37 specific capacity tests that were located outside of the <br />mapped aquifer extent were excluded. This was done because a <br />sands thickness value could not be assigned to these tests since Task <br />42 sand grids are confined to the mapped aquifer extents. A sand <br />thickness was necessary to calculate "K" (12 LTDW tests and 1 TDW <br />test excluded). <br />7. Task 37 specific capacity tests were excluded where a valid sand <br />thickness value could not be calculated due to insufficient well <br />screen information. This is identified where either "tperf" or "bperf" <br />is null or "tperf" _ "bperf" (10 tests excluded). <br />8. Task 37 specific capacity tests were excluded where <br />"well depth"<100 ft. This was done to remove tests that may be <br />biased due to drawing water from unconsolidated deposits or <br />weathered bedrock (16 tests excluded). <br />C. Data Processing: <br />1. "B" values were estimated for all HydroBase pumping tests, which <br />were not excluded as identified in the steps above, where both <br />SPDSS Task 43.2 TM- Final A-2 <br />02/13/06 <br />