Digital Geodata Series
DGS99-2 MS Excel Workbook Implementing the NJGS Ground-Water-Recharge Methodology
UPDATED
   dgs99-2.zip
(218 KB)
Abstract
N.J. Geological Survey DGS99-2 includes a Microsoft (MS) Excel Workbook that
can be used to estimate the amount of average annual ground-water recharge
for any land parcel in New Jersey. A user's guide is also provided
as a MS Word (97) document. Ground-water recharge is defined as the
quantity of freshwater derived from precipitation that infiltrates vertically
downward from the land surface to below the root zone. At this point the
water may move laterally to discharge in streams or downward to enter an
aquifer. The workbook is based on N.J. Geological Survey Report GSR-32 (Charles
and others, 1993). The GSR-32 methodology uses calculation factors that are
a function of the site's municipality or HUC14 watershed, soil, and land
use/land cover (LULC). These factors are published in GSR-32 as data appendices
and are reproduced here in a digital format. It is recommended that
DGS99-2 is used only with a working knowledge of the assumptions and procedures
incorporated in GSR-32.
The workbook as been updated (in June 2002) to version 4. Updates include:
* The user may specify the location by either municipality (the option
in the original version) or by HUC14 watershed.
* The user specifies the land use, soil, and location by the use of
pull down pick lists.
* The user may, but is not required to, enter the lot size in acres.
If entered, the program estimates net average annual ground-water recharge
volume in gallons/year.
Reference:
Charles, E.G., Behroozi, Cyrus, Schooley, Jack, and Hoffman, J.L., 1993,
A method for evaluating ground-water-recharge areas in New Jersey:
N.J. Geological Survey Report GSR-32, 95 p.
Sample Image
This image shows the MS Excel Workbook screen display.
|
