Hydrogeologic Aquifer Test dataset, Lower Mississippi-Gulf Water Science Center, December 2021

Dates

Publication Date: 2023-04-21
Start Date: 1938
End Date: 2021

Citation

Pugh, A.L., 2023, Hydrogeologic Aquifer Test dataset, Lower Mississippi-Gulf Water Science Center, December 2021: U.S. Geological Survey data release, https://doi.org/10.5066/P9L2XNXU.

Summary

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 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. The LMG-Hydrogeologic Aquifer Test Dataset – December 2021 contains information and results from 690 hydrogeologic aquifer tests. Additionally, this dataset contains 7 attribute tables (.txt files) with information [...]

Summary

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 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.

The LMG-Hydrogeologic Aquifer Test Dataset – December 2021 contains information and results from 690 hydrogeologic aquifer tests. Additionally, this dataset contains 7 attribute tables (.txt files) with 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 – Dec2021 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 – Dec2021:
[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 the open 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 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, data source reference, and notes.

DESCRIPTIONS OF ATTACHED FILES:
Readme.txt: a text file with names, definitions and units for the aquifer test dataset and the associated attribute tables.
LMG_HydrogeologicAqfrTestDataset_Dec2021.txt: a tab-delimited, UTF-8 text file of the attribute table associated with the LMG-HydrogeologicTestData_Dec2021 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 https://water.usgs.gov/ogw/NatlAqCode-reflist.html)
AtbtTbl_TstMthdCodes.txt: a tab-delimited, UTF-8 text file of codes identifying the aquifer test analysis method when reported in the associated reference.
AtbtTbl_DataRefNo.txt: a tab-delimited, UTF-8 text file of references for the source of the associated aquifer test result.
LMG_HydrogeologicTestDataset_Dec2021.zip: Esri vector data storage format (shapefile) files for geographic information system software with well locations attributed with location data, well construction data, aquifer data, groundwater test data, hydrogeologic data, and ancillary data.

NOTE ON DATA SOURCES:
Non-USGS hydrogeologic test results reported in this data set have not been through the USGS review and approval process. Only hydrogeologic test results from USGS publications should be considered to have USGS Director’s approval. All other test results should be considered provisional. Provisional data are released on the condition that neither the USGS nor the United States Government may be held liable for any damages resulting from its use.

NOTE:
If you have aquifer test data estimating the hydrogeologic properties of an aquifer, you would like added to this dataset or have found an error, please contact the USGS so we may incorporate the information into the next version of the LMG hydrogeologic test dataset.

This dataset was developed as part of the U.S. Geological Survey, Mississippi Alluvial Plain Regional Water-Availability Study.

Contacts

Originator :: Aaron L Pugh
Publisher :: U.S. Geological Survey
Point of Contact :: Aaron L Pugh
Metadata Contact :: Aaron L Pugh
Distributor :: U.S. Geological Survey - ScienceBase
USGS Mission Area :: Water Resources
SDC Data Owner :: Lower Mississippi-Gulf Water Science Center

Attached Files

sorting

Metadata First

Recent First

Alphabetical

Click on title to download individual files attached to this item.

LMG_HydrogeologicTestDataset_Dec2021.xml “Metadata for this web page” Original FGDC Metadata	View	11.96 KB	application/fgdc+xml
AtbtTbl_LocalAqfrCodes.txt “Attribute table: local aquifer codes”		471.35 KB	text/plain
AtbtTbl_NatAqfrCodes.txt “Attribute table: national aquifer codes”		2.86 KB	text/plain
AtbtTbl_DataRefNo.txt “Attribute table: data reference numbers”		3.59 KB	text/plain
LMG_HydrogeologicTestData_Dec2021.jpg “Point locations of aquifer test in the Dec2021 dataset.”		2.16 MB	image/jpeg
LMG_HydrogeologicTestDataset_Dec2021.zip “Zipped ESRI Shape files”		1.06 MB	application/zip
AtbtTbl_FipsGeocodes.txt “Attribute table: FIPS geographic codes”		8.4 KB	text/plain
AtbtTbl_AqfrCd_Readme.txt “Attribute table: aquifer codes”		3.17 KB	text/plain
AtbtTbl_TstMthdCodes.txt “Attribute table: test methods codes”		579 Bytes	text/plain
Readme.txt “Readme text file”		8.94 KB	text/plain
LMG_HydrogeologicTestDataset_Dec2021.txt “Tab delimited text [UTF-8] datafile”		207.94 KB	text/plain

Extension: LMG_HydrogeologicAqfrTestData_Dec2021_SD.zip
LMG_HydrogeologicAqfrTestData_Dec2021_SD.sd		3.58 MB

Related External Resources

Type: Citation

Carmichael, J.K., Kingsbury, J.A., Larsen, Daniel, and Schoefernacker, Scott, 2018, Preliminary evaluation of the hydrogeology and groundwater quality of the Mississippi River Valley alluvial aquifer and Memphis aquifer at the Tennessee Valley Authority Allen Power Plants, Memphis, Shelby County, Tennessee: U.S. Geological Survey Open-File Report 2018–1097, 66 p.	https://doi.org/10.3133/ofr20181097
Faye, R.E., and Smith, W.G., 1994, Relations of Borehole Resistivity to the Horizontal Hydraulic Conductivity and Dissolved-Solids Concentration in Water of Clastic Coastal Plain Aquifers in the Southeastern United States: U.S. Geological Survey Water Supply Paper 2414, 33 p.	https://pubs.usgs.gov/wsp/2414/report.pdf
Gillett, B., Raymond, D. E., Moore, J.D., and Tew, B.H., 2000, Hydrology and Vulnerability to Contamination of Major Aquifers in Alabama: Area 13: Geological Survey of Alabama, Report No. C199A, 68 p.	https://www.gsa.state.al.us/Home/DownloadPubDocument/?path=Circulars&fileName=C199A.pdf
Gillett, B., Raymond, D. E., and Moore, J.D., 2004, Hydrology and Vulnerability to Contamination of Major Aquifers in Alabama: Area 11: Geological Survey of Alabama, Report No. C199E, 80 p.	https://www.gsa.state.al.us/Home/DownloadPubDocument/?path=Circulars&fileName=C199E.pdf.
Kopaska-Merkel, D.C., Dean, L.S., and Moore, J.D., 2000, Hydrology and Vulnerability to Contamination of Major Aquifers in Alabama: Area 5: Geological Survey of Alabama, Report No. C199C, 65 p.	https://www.gsa.state.al.us/Home/DownloadPubDocument/?path=Circulars&fileName=C199C.pdf.
Kopaska-Merkel, D.C., Dean, L.S., and Moore, J.D., 2005, Hydrology and Vulnerability to Contamination of Major Aquifers in Alabama: Area 4: Geological Survey of Alabama, Report No. C199D, 94 p.	https://www.gsa.state.al.us/Home/DownloadPubDocument/?path=Circulars&fileName=C199D.pdf.
Kopaska-Merkel, D.C., Dean, L.S., and Moore, J.D., 2008, Hydrology and Vulnerability to Contamination of Major Aquifers in Alabama: Area 2: Geological Survey of Alabama, Report No. C199F, 61 p.	https://www.gsa.state.al.us/Home/DownloadPubDocument/?path=Circulars&fileName=C199F.pdf.
Kuniansky, E.L., and Bellino, J.C., 2016, Tabulated transmissivity and storage properties of the Floridan aquifer system in Florida and parts of Georgia, South Carolina, and Alabama (ver. 1.1, May 2016): U.S. Geological Survey Data Series 669, 37 p.	https://pubs.usgs.gov/ds/669
Meyer, R.R., and Turcan, A.N. Jr., 1955, Geology and Ground Water Resources of the Baton Rouge Area Louisiana: U.S. Geological Survey Water-Supply Paper 1296, 137 p.	https://pubs.usgs.gov/wsp/1296/report.pdf
Pugh, A. L., 2022, Single well slug tests conducted by the Lower Mississippi Gulf - Water Science Center -- 2020: U.S. Geological Survey Data Release.	https://doi.org/10.5066/P9AXRVT7
Raymond, D.E., Gillett, B., and Moore, J.,D., 2000, Hydrology and Vulnerability to Contamination of Major Aquifers in Alabama: Area 10: Geological Survey of Alabama, Report No. C199B, 44 p.	https://www.gsa.state.al.us/Home/DownloadPubDocument/?path=Circulars&fileName=C199B.pdf
Robinson, K.J., Carmichael, J.K., and Ladd, D.E., 1997, Hydrogeologic Framework and Simulation of Ground-Water Flow and Travel Time in the Shallow Aquifer System in the Area of Naval Support Activity Memphis, Millington, Tennessee: U.S. Geological Survey Water-Resources Investigations Report 97-4228, 56 p.	https://pubs.er.usgs.gov/publication/wri974228
U.S. Census Bureau, 2020, 2017 FIPS Codes: US Census Bureau reference files made available to define geographic codes that represent individual geographies, web page accessed January 8, 2020.	https://www.census.gov/geographies/reference-files/2017/demo/popest/2017-fips.html
U.S. Geological Survey, 2019, National Water Information System: Help System: US Geological Survey definitions for codes and parameters, web page accessed December 4, 2019.	https://help.waterdata.usgs.gov/codes-and-parameters
U.S. Geological Survey, 2019, Aquifer Codes (aqfr_cd): US Geological Survey local aquifer codes, web page accessed December 4, 2019.	https://help.waterdata.usgs.gov/aqfr_cd
U.S. Geological Survey, 2019, National Aquifer Code Reference List: US Geological Survey web page accessed December 4, 2019.	https://water.usgs.gov/ogw/NatlAqCode-reflist.html
U.S. Geological Survey, 2019, USGS water data for Arkansas: U.S. Geological Survey National Water Information System database, accessed December 2019.	https://waterdata.usgs.gov/ar/nwis/nwis
U.S. Geological Survey, 2020, USGS water data for Louisiana: U.S. Geological Survey National Water Information System database, accessed February 2020.	https://waterdata.usgs.gov/la/nwis/nwis

Purpose

The purpose of the LMG-Hydrogeologic Aquifer Test dataset is to aggregate dispersed hydrogeologic aquifer test results into a single dataset that is publicly available in a machine readable format.

Hydrogeologic Aquifer Test dataset, Lower Mississippi-Gulf Water Science Center, December 2021

Dates

Citation

Summary

Summary

Contacts

Attached Files

sorting

Metadata First

Recent First

Alphabetical

Purpose

Preview Image

Map

Communities

Associated Items

Tags

Provenance

Additional Information

Identifiers

ArcGIS Service Definition Extension

Item Actions

View Item as ...

Save Item as ...

View Item...

Dates

Citation

Summary

Summary

Contacts

Attached Files sorting Metadata First Recent First Alphabetical

Related External Resources

Purpose

Preview Image

Map

Communities

Associated Items

Tags

Provenance

Additional Information

Identifiers

ArcGIS Service Definition Extension

Item Actions

View Item as ...

Save Item as ...

View Item...

Attached Files

sorting

Metadata First

Recent First

Alphabetical