Field Header Name

Description

ID

Numeric identification of borehole

Enginr_Co

Name of Engineering Co. participating in the drilling project

Fund_Agency

Name of Funding Agency (e.g. RIDOT, USGS, Town DOT, etc.)

Geotech_Co

Name of Geotechnical Engineering Company(if any) participating in the drilling project

Drill_Co

Name of Drilling Company contracted to drill hole/well.  May be the same as DataSource if original driller’s data sheet is used for data entry.

Project_name

Name of project for which drilling was completed. 

Hole_ID

Identification number/code for boring/well

Town

Name of Town in which drilling site is located. 

Altitude

Elevation of land surface measured in feet above sea level.  Datum is NGVD 1927.

Report_No

Numeric code for report that contains the data record.  For USGS data this should be the Data Report number.  This field may be blank for engineering data or projects for which no report was generated.

Contrct_No

Funding Agency’s contract number

GeofileNo

Geotechnical Company file number for well log/project

DrillfileNo

Drilling Contractor file number for well log/project

Bridge_No

RI DOT bridge number if applicable

Date_Drill

Date hole/well was drilled.  (yyyymmdd)

County

Name of County in which drilling site is located. 

X_coord

state plane X coordinate

Y_coord

state plane Y coordinate

XY_Method

source of XY data (GPS, digitized, map)

XY_Proj

Type of map projection employed

AltitudeMeth

Method used to determined altitude:
estimated (from topographic map); provides +/- 5 ft accuracy
altimeter; provides +/- 1 ft accuracy,
GPS; variable accuracy, generally within +/- 5 ft
surveyed; provides a minimum of 0.1 ft accuracy.

Hole_Type

Well or boring.
A well is generally a permanent structure designed for water withdrawal or monitoring.
A boring is generally an uncased hole that is destroyed upon completion of the drilling investigation.

Log_Type

Type of well/boring log available:
D = driller, G = geologist, GT = geotechnical

Hole_Depth

Total depth drilled in feet below land surface

Scan_Log

Is a scanned log available? 
Yes or No. 

Depth_Bdrk

Depth to bedrock measured in feet below land surface

Depth_Water

Depth to water under non-pumping conditions measured in feet below land surface.  For sites with multiple water levels, a single measurement is provided that reflects the minimum depth to water during the period of record.

Water_Date

Date of water level measurement. (yyyymmdd)

VisualDesc

Is a visual description included on the log?
Yes or No. 

Samp_Type

Type of samples used for visual description:
continuous core, split spoon, auger, cuttings

NumSamples

Number of sample intervals described over the drilled length of the well or boring 

Artif_Fill

Artificial Fill: present or absent

Organ_Soil

Organic Soil: present or absent

BlwCnt<10

Low blow count(<10) zone in subsurface: present or absent. 
NOTE: do not include top of hole.

BlwCnt>100

High blow count (> 100) zone in subsurface: present or absent. 
NOTE: do not include bottom of hole.

Geol_boh

Geologic material encountered at bottom of hole (bedrock, refusal, unconsolidated, stratified, unstratified, unknown)

Top_Fill

Depth to top of fill measured in feet below land surface.

Bot_Fill

Depth to bottom of fill measured in feet below land surface

TopOrgSoil

Depth to top of organic soil measured in feet below land surface.

BotOrgSoil

Depth to bottom of organic soil measured in feet below land surface.

TopLoBCnt

Depth to top of low blow count zone measured in feet below land surface.

BotLoBCnt

Depth to bottom of low blow count zone measured in feet below land surface.

TopHiBCnt

Depth to top of high blow count zone measured in feet below land surface.

BotHiBCnt

Depth to bottom of high blow count zone measured in feet below land surface.

Other_Data

List of other data available:
multiple water levels, hammer blows, geochemical data, etc.

Intrnal-ID

11-digit internal ID using the format 20010122001 (yyyymmdd###).  The last 3-digits correspond to the nth record entered on that day.  For example, the 5^th site entered on February 8, 2001 would be numbered: 20010208005

Entered_By

Last name of person responsible for entering the data into the database.

Date_Enter

Date data were added to the database. (yyyymmdd)

Elev_Bdrk

Elevation of bedrock surface in feet above sea level.  This is a calculated field (Altitude– Depth_Bdrk). 

Elev_Water

Elevation of water level in well, in feet above sea level.  This is a calculated field (Altitude – Depthwater).

State

State where borehole is located

Quadrangle

Map quadrangle where borehole located