EP 1110-1-27
27 Jan 00
b. Well data file features. Each well requires a comprehensive file of all data pertaining to its
ongoing maintenance and performance history as well as the initial data pertaining to its construction,
well performance, pump performance, water chemistry, and biological environment described above.
Establishing this record system for each well should be done at the onset of the project. Since such data
will periodically be manipulated and analyzed, a format for the records should be established that is
compatible with the methods used for analysis. Consistency will save time and frustration, and improve
accuracy.
c. File records purpose and format issues. Correct and relevant field data recording is essential
for data to be of any value. How this is done can be project specific. HTRW projects, which are under
regulatory supervision, by nature have in place systems to acquire, store, manage and report data sets. The
data management system in place for the project in question can be adapted to provide the same activities
for maintenance planning. Format issues include:
Successful maintenance monitoring programs have been run using entirely physical paper
files in the water supply field.
Spreadsheet organization of data provides a tabular display of various data, permits plugging
data into formulas to perform routine calculations such as those for specific capacity and
motor efficiency, and permits rapid charting of data trends.
Database systems permit cross-comparison of parameters to ascertain cause-effect
relationships (e.g., changes in hydrocarbon concentration vs. head loss in pumping systems).
Storage and availability issues include:
Copies of the spreadsheets should be kept on-site at the well field in individual log books for
each well.
Essential well data (depth, diameter, pump type, and identification) should be marked at the
well.
Accessible inventories of physical file components such as video tapes should be maintained
so that people reviewing files may know what data are available. Chapter 8 provides
checklists, and other chapter topics indicate data needs. These should be reviewed.
d. Types of records needed. Essential information includes:
(1) Physical locations and as-built descriptions of the wells and their equipment. The physical
geographic location of each well should include reference to fixed landmarks as well as precise
geographical coordinates such as provided by a geographical positioning system (GPS) for use in plotting
using geographical information systems (GIS).
(2) As-built diagram of the well's construction, with any modifications over time.
(3) Lithologic log of the well as constructed, well drilling and construction logs, and any other
logging data (caliper, gamma-gamma, etc.). Logs must be completely labeled with dates, depths, and
borehole site identification. Copies of interpretation reports should be included in the file.
(4) Records of pumping tests and geophysical structure, borehole flow meter, etc., tests of the
completed well over time.
2-18