DATA DISCLAIMER This data set was compiled by Indiana University, Indiana Geological Survey, using data believed to be accurate; however, a degree of error is inherent in all data. This product is distributed "AS-IS" without warranties of any kind, either expressed or implied, including but not limited to warranties of suitability to a particular purpose or use. No attempt has been made in either the design or production of these data to define the limits or jurisdiction of any federal, state, or local government. These data are intended for use only at the published scale or smaller and are for reference purposes only. They are not to be construed as a legal document or survey instrument. A detailed on-the-ground survey and historical analysis of a single site may differ from these data. COPYRIGHT 2006, THE TRUSTEES OF INDIANA UNIVERSITY, INDIANA GEOLOGICAL SURVEY, ALL RIGHTS RESERVED The information on these media is proprietary to Indiana University, Indiana Geological Survey. Any copying, adaptation, distribution, public performance, or public display of this information without the express written consent of Indiana University, Indiana Geological Survey is discouraged.
CREDIT It is required that the Indiana Geological Survey be cited in any products generated from this data. The following source citation must be included: GAMMA_RAY_LOGS_IGS_IN:Natural gamma-ray-logs in unconsolidated sediments in Indiana (Indiana Geological Survey, 1:100,000, Point Shapefile), compiled by Ned Bleuer (data compiler), Steve Brown (data compiler, digital compiler), Jennifer Olejnik (data compiler, digital compiler), Marni Dickson (data compiler) Jack Haddan, (data compiler, digital compiler), 2006.
WARRANTY Indiana University, Indiana Geological Survey warrants that the media on which this product is stored will be free from defect in materials and workmanship for ninety (90) days from the date of acquisition. If such a defect is found, return the media to Publication Sales, Indiana Geological Survey, 611 North Walnut Grove, Bloomington, Indiana 47405 2208, and it will be replaced free of charge.
LIMITATION OF WARRANTIES AND LIABILITY Except for the expressed warranty above, the product is provided "AS IS", without any other warranties or conditions, expressed or implied, including, but not limited to, warranties for product quality, or suitability to a particular purpose or use. The risk or liability resulting from the use of this product is assumed by the user. Indiana University, Indiana Geological Survey shares no liability with product users indirect, incidental, special, or consequential damages whatsoever, including, but not limited to, loss of revenue or profit, lost or damaged data or other commercial or economic loss. Indiana University, Indiana Geological Survey is not responsible for claims by a third party. The maximum aggregate liability to the original purchaser shall not exceed the amount paid by you for the product.
These gamma-log data were collected using MLS Widco logging equipment mounted in various types of vehicles. This data was taken as analog through 1993,and also as digital data after 1993. Various scales were used to take the data depending on the conditions of each well location and the environment that each well was located in.
The database was started in 1990 with the entry of information into county-based spreadsheets. The numbering system of the gamma-logs changed from a county-based number such as MA-1 (Marion County 1) to a vehicle-based number system. At that time there were two vans and one was given odd numbers, the other even numbers, and these sequential numbers were preceded by the last two digits of the year followed by a dash. At that time, all unnumbered logs were given a number and the ones from the county-based system retained their old number for reference and were renumbered. Two files were created for each log; an “original” file and a “county” file.
In either 1992 or 1993 the separate county spreadsheets were merged into a single database using Paradox V3.5 software. Fields and general organization were still being refined. In 1997 the database was converted from Paradox to Microsoft Access, which is still used as the database’s software.
In 1993 work was done with the IU Electronics Department to devise a way to collect digital logs. Using laptops in the field, IGS summer field personnel collected the digital logs and entered new data into the database. This field-entered data is added to the main database at the end of each field year.
Location information was plotted on U.S. Geological Survey topographic maps in 1994 and then digitized to obtain UTM coordinates for gamma-logs that had a location. In 1998 field personnel began using GPS units in the field to record UTM coordinates for each location of gamma-log.
After 1998 fields were added and certain location fields were verified including the county and quadrangle. The UTM values were converted to NAD 83 from NAD 27. The database now also includes Mercator projection coordinates. Original elevations are still collected and there are also elevations derived from the digital elevation model (DEM) of the state.
2. A delete query was performed to remove records with the designation SO (samples only). This reduced the number of records by 141 from 4,683 to 4,542.
3. A delete query was performed to remove records with incomplete UTM records. This reduced the number of records by 237 from 4,542 to 4,305 records.
4. A new table showing the following fields, INDEX, the unique IGS identification number, and the checklist fields that make up the paper file inventory, ORIGINAL and COUNTY, were imported from the working database, GLDB.mdb. This table was combined with the columns from the table in step 3, resulting in a new table containing 4,305 records. This new table contained the new columns "original" and "county" from the working database, which were updated from a recent file inventory, and deleted the old fields original and county from the table in the previous step.
5. The table created in the previous step 4 was used to query out records that did not contain either an original or county paper file. This resulted in a new table containing 4,269 records by removing 36 records without paper gamma-logs.
6. A new table was imported from the working database GLDB.mdb containing the 2005 gamma-log data set with 51 records. The data from this table was appended to the table from the previous step 5 containing 4,269 records. This combined data set resulted in 4,320 records.
7. The newest table containing 4,320 records was imported into ESRI ArcView 3.X using SQL connect. The data table was displayed using the "Add Event Theme" command. This was converted into a point shapefile using the "Convert To Shapefile" command. Another shapefile, Indiana_statebdy_24k_igs_p.shp was also brought into the view. Indiana_statebdy_24k_igs_p.shp was selected using the select tool. The "Select By Theme" command was used to select the gamma-log points that intersected the theme Indiana_statebdy_24k_igs_p.shp. These highlighted points were converted into a new shapefile, UNCONSOLIDATED_GAMMA_LOGS_IGS_IN.shp.
8. Unconsolidated_gamma_logs_in.dbf file was copied, pasted and renamed in its directory to 4270_gl.dbf to import into the subset_gldb_redo.mdb database. It was imported into the database and used in the creation of the final data set with limited fields.
9. The table 4270_gl.dbf was queried for fields, "INDEX", "UTM_83X", "UTM_83Y" and the table, LOCATION, from the working database; GLDB.mdb, was queried for the field depth_logged. The depth_logged column was missing 66 values. These were obtained by examination of the paper records and updated in the working database. The identical query was rerun to combine the four final database fields that were used. This also caused another four records to be removed owing to their status changing from having a gamma-log, GL to a SO, samples only file. Two records were also removed becuase of the absence of paper gamma-logs. The final table created had 4,264 records.
10. The shapefile UNCONSOLIDATED_GAMMA_LOGS_IGS_IN.shp's table Unconsolidated_gamma_logs_in.dbf was renamed unconsolidated_gamma_logs_in1.dbf and was replaced with the tbl_fnl_4_col_4264 table exported as a .dbf file from Microsoft Access 2002.The exported table was renamed unconsolidated_gamma_logs_in.dbf. This resulted in a final shapefile UNCONSOLIDATED_GAMMA_LOGS_IGS_IN.shp with 4,264 records and four columns of data.
CREDIT It is required that the Indiana Geological Survey be cited in any products generated from this data. The following source citation must be included: GAMMA_RAY_LOGS_IGS_IN:Natural gamma-ray-logs in unconsolidated sediments in Indiana (Indiana Geological Survey, Point Shapefile), compiled by Ned Bleuer (data compiler), Steve Brown (data compiler, digital compiler), Jennifer Olejnik (data compiler, digital compiler), Marni Dickson (data compiler) Jack Haddan (compiler, digital compiler), 2006.
WARRANTY Indiana University, Indiana Geological Survey warrants that the media on which this product is stored will be free from defect in materials and workmanship for ninety (90) days from the date of acquisition. If such a defect is found, return the media to Publication Sales, Indiana Geological Survey, 611 North Walnut Grove, Bloomington, Indiana 47405 2208, and it will be replaced free of charge.
LIMITATION OF WARRANTIES AND LIABILITY Except for the expressed warranty above, the product is provided "AS IS", without any other warranties or conditions, expressed or implied, including, but not limited to, warranties for product quality, or suitability to a particular purpose or use. The risk or liability resulting from the use of this product is assumed by the user. Indiana University, Indiana Geological Survey shares no liability with product users indirect, incidental, special, or consequential damages whatsoever, including, but not limited to, loss of revenue or profit, lost or damaged data or other commercial or economic loss. Indiana University, Indiana Geological Survey is not responsible for claims by a third party. The maximum aggregate liability to the original purchaser shall not exceed the amount paid by you for the product.