Southern Methodist University Department of Geology and Geological Sciences Geothermal Laboratory Geothermal Master File Database System Purpose The compilation of these files was originally for the GSA-DNAG Map Series and is supported by US DOE. There is a CD ROM published in 1989 with the original data base. The files at this web site include all the files from 1989 plus all current data up to December 1996. It will be continued to be updated. If you are aware of data that is not in this data base please let us know and if possible send it to the address below. Software-Hardware Configuration The following files have been generated using Microsoft Excel 5.0. They are saved as *.CSV which can be brought into Excel, or other spreadsheet programs, as comma delimited. Organization The files were originally compiled using a Fortran compiled program designed specifically for the project in the 1980s. For ease of use, we have converted the files into Microsoft Excel 5.0. The following text gives the background on how the data was entered into the original program. The units were in HGU units and a conversion to SI units was done. At the end are the conversion factors between HGU and SI units. Information about the hole is divided into five basic groups. These are as follows: Location Hole location and date of temperature measurement Information/Status Minimum and maximum values of the hole Results Gradient and heat flow results per depth interval Geology Lithologic information of the hole Comments General notes and comments as needed Refer questions and suggestions to: Maria Richards Department of Geology and Geological Sciences 3225 Daniel Ave. 209 Heroy Building Southern Methodist University Dallas, Texas 75275-0395 (214) 768-1975 phone (214) 768-2701 fax mrichard@smu.edu Order for the description of the parameter codes (L)ocation Codes AMS MAP HOLE DATE TS-RN-SEC ST P LAT LONG (I)nformation/Status Codes ELEV DMAX DWAT TSUR TMAX TMIN JOBDATE BHT PAGE BAGE PUB (R)esults Codes RNG1 RNG2 TCU N UNGR COGR UNHF COHF Q HP N AQU 0 (G)eology Code Lithology information (C)omment Code Comment information CODE DESCRIPTIONS (L)ocation Codes AMS MAP AMS Sheet Identification An AMS sheet (1:250,000 scale map) is used to give a consistent map location for the hole. This map scale is the most detailed available for all the U.S., but elsewhere where this scale does not exist a similar type notation should be used. Ex. STEFFORD HILL AMS, ILL. Drill Hole Name This is a local name related to the identification of the hole (i.e., by owner, company, or project). It also is used to identify a hole from a set of holes in the same area. Ex. WIFE-3 Measured Date This is the measured date of the temperature log from which the thermal results were determined. It is in the form MM/DD/YY. Ex. 5/ 6/85 is May 6th, 1985 TS-RN-SEC Township/Range-Section-Sub This is the break-down of the hole location by local map usage (i.e., 15' quad or 7.5' quad). The township, range, section numbers, and their respective compass direction. The section is sub- divided from 1/4 section down to as small as 1/32 of a section. The sub-section divisions are indicated by a combinations of the letters A,B,C,D. This is done using the following pattern: B A C D The location should only be divided down to its most detailed known actual position based on the quad used or surveyed location. If the hole is in the center (or nearly) of the section then no sub-section division is given. This is also true of the hole that is known to be in the section, but there is no knowledge of its exact location. In this type of case, one could put a number in the last position of the sub-section code to refer to a related number in the Comment Data Group. If the township or range number is larger than 2 digits, then the @ symbol of the template indicates that a special symbol can be used to indicate the difference. Instead of a / to separate the township/range specification, an * is used. The full specification of the township/range-sec-sub should then be given in the Comments Data Group. Ex. 2N/15E- 2AAC Ex. 12S*18E-14B 1 This is really 12S/18.5E-14B. The 1 indicates to see note 1 in Comment Group ST State/Country This is a numeric code for the state or foreign country where the hole is located. It follows the alphabetic order of the states for the U.S. Some countries are also included. 01 = Alabama 21 = Maryland 41 = South Carolina 02 = Alaska 22 = Massachusetts 42 = South Dakota 03 = Arizona 23 = Michigan 43 = Tennessee 04 = Arkansas 24 = Minnesota 44 = Texas 05 = California 25 = Mississippi 45 = Utah 06 = Colorado 26 = Missouri 46 = Vermont 07 = Connecticut 27 = Montana 47 = Virginia 08 = Delaware 28 = Nebraska 48 = Washington 09 = District of Columbia 29 = Nevada 49 = West Virginia 10 = Florida 30 = New Hampshire 50 = Wisconsin 11 = Georgia 31 = New Jersey 51 = Wyoming 12 = Hawaii 32 = New Mexico 52 = Canada 13 = Idaho 33 = New York 53 = Costa Rica 14 = Illinois 34 = North Carolina 54 = Egypt 15 = Indiana 35 = North Dakota 55 = Mexico 16 = Iowa 36 = Ohio 56 = Panama 17 = Kansas 37 = Oklahoma 57 = Colombia 18 = Kentucky 38 = Oregon 58 = 19 = Louisiana 39 = Pennsylvania 59 = 20 = Maine 40 = Rhode Island 60 = PH Physiographic Province The physiographic province is a tectonic division of a region and is a two digit code. For the North American Geothermal Map Project, the list of following codes is in use: 01 = ATLANTIC COASTAL PLAINS 39 = SALINIA-W. OF SAN ANDREAS 02 = GULF COASTAL PLAIN 40 = SOUTH CASCADE RNG - EAST WASH 03 = FLORIDA PENN 41 = WESTERN CASCADE RNG - ORE/CAL 05 = SUPERIOR UPLAND 42 = HIGH CASCADE RANGE - ORE/CAL 06 = INTERIOR LOWLANDS 43 = SOUTH CASCADE - WEST WASH 08 = GREAT PLAINS 44 = NORTH CASCADE RANGE - WASH 10 = APPALACHIAN HIGHLANDS 45 = WESTERN-HIGH CAS RNG - ORE/CAL 11 = PIEDMONT PROVINCE 50 = COLUMBIA BASIN 12 = BLUE RIDGE 51 = YAKIMA FOLDS 13 = VALLEY AND RIDGE 52 = PASCO BASIN 14 = APPALACHIAN PLATEAUS 53 = UMATILLA BASIN 15 = NEW ENGLAND PROVINCE 54 = DESCHUTES-UMATILLA PLATEAU 16 = ADIRONDACK PROVINCE 55 = OWYHEE UPLANDS 20 = COLORADO PLATEAU 56 = WESTERN SNAKE RIVER PLAINS 21 = MIDDLE ROCKY MTNS. 57 = EASTERN SNAKE RIVER PLAINS 22 = WYOMING BASIN 58 = CAMAS P. - MT. BENNETT HILLS 23 = SOUTHERN ROCKY MTNS. 59 = YELLOWSTONE/ISLAND PARK 25 = BASIN AND RANGE 62 = CHALLIS SUBDIVISION 26 = HIGH LAVA PLAINS 63 = CENTRAL IDAHO BASIN AND RANGE 30 = COAST RANGE-WILLAPA HILLS 64 = NORTHERN IDAHO BATHOLITH 31 = WILLAMETTE VALLEY-PUGET LOWLANDS 65 = NORTHERN ROCKY MTNS. 32 = KLAMATH MTNS. 66 = SOUTHERN IDAHO BATHOLITH 34 = OLYMPIC MTNS. 67 = WALLOWA-SEVEN DEVILS 36 = SIERRA NEVADA MTNS. 68 = BLUE MOUNTAINS 37 = GREAT VALLEY/CALIFORNIA 85 = ATLANTIC COASTAL 38 = FRANCISCAN-E. OF SAN ANDREAS 86 = ARCTIC COASTAL 87 = GULF COASTAL MARGIN 88 = PACIFIC COASTAL MARGIN 89 = MEXICO INLAND 90 = BAJA CALIFORNIA LAT Latitude The latitude is expressed in decimal degrees North of the equator. Ex. 42.4325 is 42 degrees 25 minutes and 57 seconds LONG Longitude The longitude is expressed in decimal degrees West of the meridian. Ex. 112.1230 is 112 degrees 7 minutes and 22.8 seconds (I)nformation/Status Codes ELEV Collar Elevation Elevation of the surface location of the hole is given in meters above sea level. Ex. 2,100 meters elevation DMAX Measured Depth Measured depth is the total depth in meters of temperature measurement on Measured Date. Ex. 800.5 meters depth DWAT Water Table Depth Measured or inferred water table depth in the hole. Ex. 100 * is approx. 100 meters water table depth. Note: printed as (100.0) TSUR Surface Temperature Calculated or inferred (from least-squares of temp. vs depth) surface temperature of the hole. Unit is ° C. Ex. 27.21 ° C surface temperature TMAX Maximum Hole Temperature Measured maximum temperature of logging in °C. Ex. 100.5 °C maximum temperature TMIN Minimum Hole Temperature Measured minimum temperature of logging in °C. Ex. 7.20 °C minimum temperature JOBDATE Drill Date Date drilling of hole was completed. It is in the form MM/DD/YY. Ex. 1/ 4/78 is Jan 4th, 1978 BHT Bottom Hole Temperature Temperature recorded at bottom of hole in °C. Ex. 30.05 °C bottom temperature PUB Publish Reference Publication code for journal if hole data have been published. The code is composed of 3 parts: (1). Author code This is the first four letters of the major author. If author's name is less than four characters, then the remaining spaces are left blank. (2). Year published code This is the last two digits of the year published. (3). Number of authors on paper If there is only one author then leave blank, if nine or more authors use 9. (4). Sub-Year code If more than one paper was published with identical Author, Year code and number of authors, then use letters starting with A to unique them. Ex. BLAC78 B refers to the second paper published in 1978 by Blackwell. Note: A separate file of references can be accessed using the above code to retrieve the complete journal reference in the masrefcn.doc or masrefcn.txt from the web site. (R)esults Codes RNG1 Depth Beginning Starting depth of the temperature interval in meters RNG2 Depth Ending Ending depth of the temperature interval in meters TCU Average Thermal Conductivity SE Standard Error Laboratory or estimated in situ thermal conductivity measurement for the depth interval RNG1 to RNG2. If estimate is used, then the appropriate symbol should be used above the @ template symbol (i.e., <, >, or *). If a statistical mean method is used, then the standard error (SE) of the mean should be included. The unit (designated TCU) is Watts/meter Kelvin Ex. > 3.5 TCU (greater than 3.5) N Number of Conductivities This is the number of measured values of conductivities used to derive the TCU value. You should use the related number when a statistical mean is calculated or even if only 1 actual value was used for the interval. If an estimate is made from surrounding area or paper log, then no number should be given, but use the related * symbol in the @ template of the TCU value. Ex. 5 is 5 values were used to calculate TCU UNGR Uncorrected Gradient SE Standard Error Calculated or estimated uncorrected thermal gradient measurement for the depth interval RNG1 to RNG2. Uncorrected refers to non-terrain corrected gradient. If an estimate is used, then the appropriate symbol should be used above the @ template symbol (i.e., <, >, or *). If a statistical mean method is used, then the standard error (SE) of the mean should be included. The unit is °C/Km. Ex. 35 > is > 35.0 °C/Km (greater than 35.0) Ex. 35 * is (35.0) °C/Km (estimate) COGR Corrected Gradient SE Standard Error Calculated or estimated corrected thermal gradient measurement for the depth interval RNG1 to RNG2. Corrected refers to terrain corrected gradient. If estimate is used, then the appropriate symbol should be used above the @ template symbol (i.e., <, >, or *). If a statistical mean method is used, then the standard error (SE) of the mean should be included. The unit is °C/Km. Ex. 35 > is > 35.0 °C/Km (greater than 35.0) Ex. 35 2 is 35.0 °C/Km plus/minus 2.0 °C/Km standard error Ex. 35 * is (35.0) °C/Km (estimate) UNHF Uncorrected Heat Flow SE Standard Error Calculated or estimated uncorrected heat flow value for the depth interval RNG1 to RNG2. Uncorrected refers to non-terrain corrected heat flow. If estimate is used, then the appropriate symbol should be used above the @ template symbol (i.e., <, >, or *). If a statistical mean method is used, then the standard error (SE) of the mean should be included. The unit (designated HFU) is micro-cal/square cm-sec. Ex. 21> is > 2.1 HFU (greater than 2.1) Ex. 21 2 is 2.1 HFU plus/minus .20 HFU standard error Ex. 21* is (2.1) HFU (estimate) COHF Corrected Heat Flow SE Standard Error Calculated or estimated corrected heat flow value for the depth interval RNG1 to RNG2. Corrected refers to terrain corrected heat flow. If estimate is used, then the appropriate symbol should be used above the @ template symbol (i.e., <, >, or *). If a statistical mean method is used, then the standard error (SE) of the mean should be included. The unit (designated HFU) is milli-Watts/square meter. Ex. 21> is > 2.1 HFU Ex. 21 2 is 2.1 HFU plus/minus .20 HFU standard error Ex. 21* is (2.1) HFU (estimate) Q Quality of Heat Flow This is a single digit code to indicate the quality (or confidence) of the gradient or heat flow value presented in the interval RNG1 to RNG2. Ex. 1 is high quality heat flow value. Note: This is printed as the symbol A. Table of Quality Code A 01 High Quality Data: Deeper than 100 meters At least a 50 meter linear gradient B 02 Medium Quality Data: Deeper than 50 meters Some problems C 03 Poor Quality Data: Shallow; Isothermal G 04 Geothermal System D 05 Check Again X 06 No Hope HP Heat Production SE Standard Error Calculated value(s) from K,U,Th elements for an interval or for a drill hole (if only first card has a value). The unit (as HGU) is micro-Watts/cubic meter N Number of Heat Productions This is the number of measured values of heat production values used to derive the HGU value. You should use the related number when a statistical mean is calculated or even if only 1 value was used for the interval. If an estimate is made from surrounding area or paper log, then no number should be given, but use the related * symbol in the @ template of the HP value. Ex. 5 indicates 5 values were used to calculate HGU AQU Aquifer Temperature SD Standard Deviation Measured, calculated or inferred from temperature logging. Assumes that the interval RNG1 to RNG2 is part of the aquifer when a number is given. Unit is ° C. 0 Porosity Calculated or inferred conductivity porosity of sample from the interval RNG1 to RNG2. Used to calculate in situ TCU from cuttings measurements. Unit is percentage of 100. (G)eology Code Lithology Information This indicates the lithologies in or around the hole using a maximum of 24 characters.. Ex. Quartz_ _ _ _ _ _Monzonite_ _ _ Comments/Information This parameter indicates general information about the hole, about the corrections that were applied or need to be applied to the thermal values. Generally you have six lines of 79 characters in free format for use. This group is not normally printed or used by tables or statistics program, but only used as reference for evaluation. Conversion Units CGS units SI units 1 HFU = micro-cal/square cm-sec = 41.84 milli-Watts/square meter 1 TCU = milli-cal/cm-sec-° C = 0.4184 Watts/meter Kelvin 1 HGU = 10^(power of -13) cal/cubic cm-sec = 0.4184 micro-Watts/cubic meter