AASG Wells Data for the EGS Test Site Planning and Analysis Task

AASG Wells Data for the EGS Test Site Planning and Analysis Task
Temperature measurement data obtained from boreholes for the Association of American State Geologists (AASG) geothermal data project. Typically bottomhole temperatures are recorded from log headers, and this information is provided through a borehole temperature observation service for each state. Service includes header records, well logs, temperature measurements, and other information for each borehole. Information presented in Geothermal Prospector was derived from data aggregated from the borehole temperature observations for all states. For each observation, the given well location was recorded and the best available well identifier (name), temperature and depth were chosen. The "Well Name Source," "Temp. Type" and "Depth Type" attributes indicate the field used from the original service. This data was then cleaned and converted to consistent units. The accuracy of the observation's location, name, temperature or depth was note assessed beyond that originally provided by the service.

- AASG bottom hole temperature datasets were downloaded from repository.usgin.org between the dates of May 16th and May 24th, 2013.
- Datasets were cleaned to remove null and non-real entries, and data converted into consistent units across all datasets
- Methodology for selecting best temperature and depth attributes from column headers in AASG BHT Data sets:

Temperature:
CorrectedTemperature - best
MeasuredTemperature - next best
Depth:
DepthOfMeasurement - best
TrueVerticalDepth - next best
DrillerTotalDepth - last option
Well Name/Identifier:
APINo - best
WellName - next best
ObservationURI - last option

The column headers are as follows:
gid = internal unique ID
src_state = the state from which the well was downloaded (note: the low temperature wells in Idaho are coded as "ID_LowTemp", while all other wells are simply the two character state abbreviation)
source_url = the url for the source WFS service or Excel file
temp_c = "best" temperature in Celsius
temp_type = indicates whether temp_c comes from the corrected or measured temperature header column in the source document
depth_m = "best" depth in meters
depth_type = indicates whether depth_m comes from the measured, true vertical, or driller total depth header column in the source document
well_name = "best" well name or ID
name_src = indicates whether well_name came from apino, wellname, or observationuri header column in the source document
lat_wgs84 = latitude in wgs84
lon_wgs84 = longitude in wgs84
state = state in which the point is located
county = county in which the point is located