Since the 1940's, hydrologists have used aquifer tests to estimate the hydrogeologic properties near test wells. Results from these tests are recorded in various files, databases, reports and scientific publications. The U.S. Geological Survey (USGS), Lower Mississippi-Gulf Water Science Center (LMG) is aggregating all aquifer test results from Alabama, Arkansas, Louisiana, Mississippi and Tennessee into a single dataset that is publicly available in a machine-readable format. This dataset contains information and results from 2,245 aquifer tests compiled for aquifers located in the LMG-Hydrogeologic Aquifer Test Dataset - December 2020. Descriptive statistics for the December 2020 dataset are presented in Table 1 (below) and in the Summary_Readme.pdf. Additionally, this dataset contains 6 attribute tables (.txt files) with additional information for various fields, a zip file containing the geospatial data, and the companion attribute table as a .txt file. THE LMG-HYDROGEOLOGIC AQUIFER TEST DATASET – DECEMBER 2020 IS AVAILABLE IN TWO FORMATS: 1) a tab delimited text (.txt) UTF-8 file and 2) an ESRI GIS point shapefile. FIELDS INCLUDED IN THE LMG-HYDROGEOLOGIC AQUIFER TEST DATASET – DECEMBER 2020: [a complete list of field names, their definitions and units are listed in the Summary_Readme.pdf file] Location data: USGS site identification number, local identification name, Public Land Survey System number, latitude, longitude, State and county. Well construction data: Construction date, well depth, Diameter of well, diameter of casing, depth to top of opening (screen) interval, depth to bottom of opening interval and length of the open interval. Aquifer data: Local aquifer name and code, national aquifer name and code, top of aquifer (altitude), bottom of aquifer, and thickness of aquifer. Groundwater test data: Test date, yield/discharge, length of time associated with yield, static water-level in feet below land surface, production water-level in feet below land surface associated with yield, drawdown associated with yield. Hydrogeologic data: Specific capacity, transmissivity, horizontal Conductivity, vertical conductivity, permeability and storage coefficient. Ancillary data: Method of test analysis and data source reference. DESCRIPTIONS OF ATTACHED FILES: Summary_Readme.pdf: a Portable Document Format (PDF) file with field names, definitions and units for the aquifer test dataset and the associated attribute tables. This file also contains summary statistics for aquifer test compiled through December 2020. LMG-HydrogeologicAqfrTestDataset_Dec2020.txt: a tab-delimited, UTF-8 text file of the attribute table associated with the LMG-HydrogeologicTestData_Dec2020 geospatial dataset. AtbtTbl_AqfrCd_Readme.txt: an UTF-8 text file containing information from the National Water Information System: Help System web page about USGS groundwater codes. (accessed December 4, 2019 at https://help.waterdata.usgs.gov/codes-and-parameters) AtbtTbl_FipsGeographyCodes.txt: a tab-delimited, UTF-8 text file of FIPS (Federal Information Processing Standards) codes, uniquely identifying States, counties and county equivalents in the United States. Note: to reduce the size of this file, city codes were removed. (accessed January 8, 2020 at https://www.census.gov/geographies/reference-files/2017/demo/popest/2017-fips.html). AtbtTbl_LocalAqfrCodes.txt: a tab-delimited, UTF-8 text file of eight-character string identifying an aquifer. Codes are defined by the "Catalog of Aquifer Names and Geologic Unit Codes used by the USGS. (accessed December 4, 2019 at https://help.waterdata.usgs.gov/aqfr_cd) AtbtTbl_NatAqfrCodes.txt: a tab-delimited, UTF-8 text file of ten-character strings identifying a National aquifer, or principal aquifer of the United States, that are defined as regionally extensive aquifers or aquifer systems that have the potential to be used as a source of potable water. (accessed December 4, 2019 at

Since the 1940's, commercial, academic and government hydrologists have used aquifer tests to estimate the hydrogeologic properties of an aquifer near test wells. Results from these tests are recorded in various files, databases, reports, and scientific publications. The Lower Mississippi-Gulf (LMG)-Hydrogeologic Test dataset is an attempt to aggregate these dispersed hydrogeologic test results into a single dataset that is publicly available in a machine-readable format. The hydrogeologic values presented in the Mar2022 version of the LMG-Hydrogeologic Test Dataset were estimated by Douglas Carlson, PhD, with the Louisiana Geological Survey and Associate Professor-Research at Louisiana State University. Hydraulic conductivity estimates were made from specific capacity data using a technique developed by Bradbury and Rothschild (1985). Specific capacity values, from well pumping tests, were obtained from the Louisiana Water Well Registration Database. This Child Item contains the Mar2022 version of the LMG-Hydrogeologic Test dataset with information and results from 7527 aquifer tests. Additionally, this dataset contains 6 attribute tables (.txt files) with additional information for various fields, a zip file containing the geospatial data, a companion attribute table as a .txt file and a readme text file with definitions and descriptions of the attributes and attribute tables. The LMG-Hydrogeologic Aquifer Test dataset - Mar2022 is available in 2 formats: 1) a tab delimited text (.txt) UTF-8 file and 2) an ESRI GIS point shapefile. FIELDS INCLUDED IN THE LMG-HYDROGEOLOGIC TEST DATASET – Mar2022: [a complete list of field names, their definitions and units are listed in the Readme.txt file] Location Data: USGS site identification number, Local identification name, Public Land Survey System Number, Latitude, Longitude, State and County. Well Construction Data: Construction date, well depth, Diameter of well, Diameter of casing, Depth to top of opening (screen) interval, Depth to bottom of opening interval and Length of opening interval. Aquifer Data: Local aquifer name and code, National aquifer name and code, Top of aquifer, Bottom of aquifer, and Thickness of aquifer. Groundwater Test Data: Test date, Yield/discharge, Length of time associated with yield, Static water-level, Production water-level associated with yield, Drawdown associated with yield. Hydrogeologic Data: Specific Capacity, Transmissivity, Horizontal Conductivity, Vertical Conductivity, Permeability and Storage Coefficient. Ancillary Data: Method of Test Analysis and Data Source Reference. DESCRIPTIONS OF ATTACHED FILES: LMG_HydrogeologicTestDataset_Mar2022.txt: is a tab delimited, UTF-8 text file of the LMG-Hydrogeologic Test Dataset Mar2022. Readme.txt: is a text (.txt) file with field names, definitions and units for the LMG-Hydrogeologic Test Dataset Mar2022 and associated attribute tables. AtbtTbl_AqfrCd_Readme.txt: Is an UTF-8 text file containing information from the National Water Information System: Help System web page about USGS groundwater Codes. (accessed December 4, 2019 at https://help.waterdata.usgs.gov/codes-and-parameters) AtbtTbl_FipsGeographyCodes.txt: Is a tab delimited, UTF-8 text file of FIPS (Federal Information Processing Standards) codes, uniquely identifying states, counties and county equivalents in the United States. Note: to reduce the size of this file, City Codes were Removed. (accessed January 8, 2020 at https://www.census.gov/geographies/reference-files/2017/demo/popest/2017-fips.html). AtbtTbl_LocalAqfrCodes.txt: Is a tab delimited, UTF-8 text file of eight-character string identifying an aquifer. Codes are defined by the "Catalog of Aquifer Names and Geologic Unit Codes used by the USGS. (accessed December 4, 2019 at https://help.waterdata.usgs.gov/aqfr_cd) AtbtTbl_NatAqfrCodes.txt: Is a tab delimited, UTF-8 text file of ten-character strings identifying a National aquifer, or principal aquifer of the United States, that

Since the 1940's, commercial, academic and government hydrologists have used aquifer tests to estimate the hydrogeologic properties of an aquifer near test wells. Results from these tests are recorded in various files, databases, reports, and scientific publications. The Lower Mississippi-Gulf (LMG)-Hydrogeologic Test dataset is an attempt to aggregate these dispersed hydrogeologic test results into a single dataset that is publicly available in a machine-readable format. The hydrogeologic values presented in the Mar2022 version of the LMG-Hydrogeologic Test Dataset were estimated by Douglas Carlson, PhD, with the Louisiana Geological Survey and Associate Professor-Research at Louisiana State University. Hydraulic conductivity estimates were made from specific capacity data using a technique developed by Bradbury and Rothschild (1985). Specific capacity values, from well pumping tests, were obtained from the Louisiana Water Well Registration Database. This Child Item contains the Mar2022 version of the LMG-Hydrogeologic Test dataset with information and results from 7527 aquifer tests. Additionally, this dataset contains 6 attribute tables (.txt files) with additional information for various fields, a zip file containing the geospatial data, a companion attribute table as a .txt file and a readme text file with definitions and descriptions of the attributes and attribute tables. The LMG-Hydrogeologic Aquifer Test dataset - Mar2022 is available in 2 formats: 1) a tab delimited text (.txt) UTF-8 file and 2) an ESRI GIS point shapefile. FIELDS INCLUDED IN THE LMG-HYDROGEOLOGIC TEST DATASET – Mar2022: [a complete list of field names, their definitions and units are listed in the Readme.txt file] Location Data: USGS site identification number, Local identification name, Public Land Survey System Number, Latitude, Longitude, State and County. Well Construction Data: Construction date, well depth, Diameter of well, Diameter of casing, Depth to top of opening (screen) interval, Depth to bottom of opening interval and Length of opening interval. Aquifer Data: Local aquifer name and code, National aquifer name and code, Top of aquifer, Bottom of aquifer, and Thickness of aquifer. Groundwater Test Data: Test date, Yield/discharge, Length of time associated with yield, Static water-level, Production water-level associated with yield, Drawdown associated with yield. Hydrogeologic Data: Specific Capacity, Transmissivity, Horizontal Conductivity, Vertical Conductivity, Permeability and Storage Coefficient. Ancillary Data: Method of Test Analysis and Data Source Reference. DESCRIPTIONS OF ATTACHED FILES: LMG_HydrogeologicTestDataset_Mar2022.txt: is a tab delimited, UTF-8 text file of the LMG-Hydrogeologic Test Dataset Mar2022. Readme.txt: is a text (.txt) file with field names, definitions and units for the LMG-Hydrogeologic Test Dataset Mar2022 and associated attribute tables. AtbtTbl_AqfrCd_Readme.txt: Is an UTF-8 text file containing information from the National Water Information System: Help System web page about USGS groundwater Codes. (accessed December 4, 2019 at https://help.waterdata.usgs.gov/codes-and-parameters) AtbtTbl_FipsGeographyCodes.txt: Is a tab delimited, UTF-8 text file of FIPS (Federal Information Processing Standards) codes, uniquely identifying states, counties and county equivalents in the United States. Note: to reduce the size of this file, City Codes were Removed. (accessed January 8, 2020 at https://www.census.gov/geographies/reference-files/2017/demo/popest/2017-fips.html). AtbtTbl_LocalAqfrCodes.txt: Is a tab delimited, UTF-8 text file of eight-character string identifying an aquifer. Codes are defined by the "Catalog of Aquifer Names and Geologic Unit Codes used by the USGS. (accessed December 4, 2019 at https://help.waterdata.usgs.gov/aqfr_cd) AtbtTbl_NatAqfrCodes.txt: Is a tab delimited, UTF-8 text file of ten-character strings identifying a National aquifer, or principal aquifer of the United States, that

Short-term aquifer tests were conducted to estimate hydraulic properties in an alluvial aquifer. Tests included eight single-hole pumping and recovery tests and three slug tests (in a single well). These investigations were conducted in the Wet Mountain Valley, in Custer and Fremont Counties, Colorado. The U.S. Geological Survey (USGS) conducted aquifer tests in May, 2019. These aquifer tests inform the conceptual understanding of the valley-fill aquifer and serve as primary inputs to the numerical groundwater-flow model. Testing was completed in cooperation with the Upper Arkansas Water Conservancy District. This data release contains raw data from aquifer tests, water-level and pumping discharge rate measurements, well logs, graphs of the testing data, and plots of analytical solutions.

Short-term aquifer tests were conducted to estimate hydraulic properties in an alluvial aquifer. Tests included eight single-hole pumping and recovery tests and three slug tests (in a single well). These investigations were conducted in the Wet Mountain Valley, in Custer and Fremont Counties, Colorado. The U.S. Geological Survey (USGS) conducted aquifer tests in May, 2019. These aquifer tests inform the conceptual understanding of the valley-fill aquifer and serve as primary inputs to the numerical groundwater-flow model. Testing was completed in cooperation with the Upper Arkansas Water Conservancy District. This data release contains raw data from aquifer tests, water-level and pumping discharge rate measurements, well logs, graphs of the testing data, and plots of analytical solutions.

The USGS collected water level time series data sets using a submersible pressure transducer at FORGE WELL 58B-32 during an aquifer test from February 12 to February 16, 2024. Transmissivity of the pumped aquifer was estimated to be 37,520-55,080 square feet per day using a Theis solution for unconfined aquifers provided by AQTESOLV software. The hydraulic conductivity of the aquifer was then calculated to be 86-126 feet per day using a saturated aquifer thickness of 436 feet.

The USGS collected water level time series data sets using a submersible pressure transducer at FORGE WELL 58B-32 during an aquifer test from February 12 to February 16, 2024. Transmissivity of the pumped aquifer was estimated to be 37,520-55,080 square feet per day using a Theis solution for unconfined aquifers provided by AQTESOLV software. The hydraulic conductivity of the aquifer was then calculated to be 86-126 feet per day using a saturated aquifer thickness of 436 feet.

This point dataset contains estimates of aquifer transmissivity and hydraulic conductivity at selected well locations in the Lost Creek Designated Ground Water Basin, Weld, Adams, and Arapahoe Counties, Colorado. This dataset also contains hydrologic information used to estimate transmissivity from specific capacity at selected well locations. Data were compiled from published reports, consultant reports, and from well-test records on file with the U.S. Geological Survey and Colorado Division of Water Resources. The U.S. Geological Survey prepared this dataset in cooperation with the Colorado Geological Survey and the Lost Creek Ground Water Management District.

This point dataset contains estimates of aquifer transmissivity and hydraulic conductivity at selected well locations in the Lost Creek Designated Ground Water Basin, Weld, Adams, and Arapahoe Counties, Colorado. This dataset also contains hydrologic information used to estimate transmissivity from specific capacity at selected well locations. Data were compiled from published reports, consultant reports, and from well-test records on file with the U.S. Geological Survey and Colorado Division of Water Resources. The U.S. Geological Survey prepared this dataset in cooperation with the Colorado Geological Survey and the Lost Creek Ground Water Management District.

The Wilcox Oil Company Superfund site (hereinafter referred to as “the site”) was formerly an oil refinery in northeast of Bristow in Creek County, Oklahoma. Historical refinery operations contaminated the soil, surface water, streambed sediments, alluvium, and groundwater with refined and stored products at the site. The Wilcox and Lorraine process areas are where the highest concentrations of volatile organic compounds, semivolatile organic compounds, polycyclic aromatic hydrocarbons, and trace elements (including metals) (collectively hereinafter referred to as “contaminants”) were measured in a local shallow perched groundwater system within the alluvium (hereinafter referred to as the “alluvial aquifer”) at the site during previous site assessments. In order to understand the potential migration of contaminants through the soil and groundwater in these areas, the U.S. Geological Survey, in cooperation with the U.S. Environmental Protection Agency, investigated aquifer characteristics of the alluvial aquifer in the Wilcox and Lorraine process areas of the site to (1) document hydraulic conductivity and other aquifer characteristics of the alluvial aquifer that govern contaminant fate and transport, (2) describe the geospatial extent and concentration of the contaminants in the alluvial aquifer in the Wilcox and Lorraine process areas, and (3) describe the geochemical controls pertaining to oxidation and reduction governing the fate and transport and the degradation potential of contaminants in the groundwater. This data release documents the data that were collected and briefly describes how they were used to characterize the hydrogeologic framework, groundwater-flow system, geochemistry, and aquifer hydraulic properties of the shallow groundwater system. Refer to the companion larger work citation (Teeple and others, 2025) for the complete description and data analyses. In November and December 2022, following groundwater monitoring well development and groundwater-quality sampling, slug tests were completed on each of the groundwater monitoring wells installed in 2022 to (1) determine if the wells were in good hydraulic connection with the aquifer and (2) estimate the hydraulic conductivity of the aquifer at each well. This dataset includes the pressure transducer data from the slug tests and the hydraulic conductivity values estimated by using the Bouwer-Rice method of analysis.