Hydrogeologic Aquifer Test dataset, Lower Mississippi-Gulf Water Science Center, March 2022

Dates

Publication Date: 2023-04-26
Start Date: 1937
End Date: 2020

Citation

Pugh, A.L., and Carlson, D.A., 2023, Hydrogeologic Aquifer Test dataset, Lower Mississippi-Gulf Water Science Center, March 2022: U.S. Geological Survey data release, https://doi.org/10.5066/P99AEEF4.

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 hydrogeologic aquifer test results from Alabama, Arkansas, Louisiana, Mississippi, and Tennessee into a single dataset that is publicly available in a machine-readable format. The hydrogeologic values presented in the Mar2022 edition of the LMG-Hydrogeologic Test Dataset were estimated by Douglas Carlson, PhD, with the Louisiana Geological Survey and Associate Professor-Research [...]

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 hydrogeologic aquifer test results from Alabama, Arkansas, Louisiana, Mississippi, and Tennessee into a single dataset that is publicly available in a machine-readable format.

The hydrogeologic values presented in the Mar2022 edition 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 edition of the LMG-Hydrogeologic Test dataset with information and results from 7527 aquifer tests. Descriptive statistics for the March2022 dataset are presented in Table 1 (below). 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 (hole) depth, Diameter of well (hole), 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_HydrogeologicTestData_Mar2022.txt: is a tab delimited, UTF-8 text file of the LMG-Hydrogeologic Test Data March 2022 edition.
Readme.txt: is a text (.txt) file with field names, definitions, and units for the LMG-Hydrogeologic Test Data Mar2022 edition 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 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: Is a tab delimited, UTF-8 text file of codes identifying the test analysis method when reported in the associated reference.
AtbtTbl_DataRefNo.txt: Is a tab delimited, UTF-8 text file of references for the source of the associated aquifer test result.
LMG_HydrogeologicTestData_Mar2022.zip: Esri vector data storage format (shape) 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.

Table 1. Summary-descriptive statistics for the LMG-HYDROGEOLOGIC TEST DATA Mar2022 edition.

USGS-NWIS NATONAL AQUIFER NAME AND CODE	n	MAXIMUM	MINIMUM	MEAN	MEDIUM	STANDARD DEVIATION
Specific capacity (gallons per minute per foot)
Alluvial aquifers (N100ALLUVL)	224	140	0.03	17.7	11.3	19
Mississippi River Valley alluvial aquifer (N100MSRVVL)	1575	1000	0.07	54.7	38.0	65.7
Other aquifers (N9999OTHER)	481	320	0.20	21.2	6.3	38
Coastal lowlands aquifer system (S100CSLLWD)	2804	1500	0.05	23.3	10.0	7.45
Mississippi embayment aquifer system (S100MSEMBM)	2374	96	0.03	3.9	1.8	7.45
Unknown National aquifer	69	350	0.07	34.3	11.0	59.5
Transmissivity (square feet per day)
Alluvial aquifers (N100ALLUVL)	224	35,330	0.44	2911	2089	4,064
Mississippi River Valley alluvial aquifer (N100MSRVVL)	1575	530,588	2.84	15,669	10,263	24,633
Other aquifers (N9999OTHER)	481	190,304	25.7	10,198	2536	22,827
Coastal lowlands aquifer system (S100CSLLWD)	2804	1,099,201	5.90	14,512	3557	3282
Mississippi embayment aquifer system (S100MSEMBM)	2374	107,648	0.11	1,159	391	3282
Unknown National aquifer	69	702,490	7.16	26,870	3295	96,226
Horizontal hydraulic conductivity (feet per day)
Alluvial aquifers (N100ALLUVL)	224	2,355	0.01	76	47	173
Mississippi River Valley alluvial aquifer (N100MSRVVL)	1575	5,439	0.07	219	134	353
Other aquifers (N9999OTHER)	481	2,274	0.36	196	50	411
Coastal lowlands aquifer system (S100CSLLWD)	2804	6,662	0.05	163	39	63
Mississippi embayment aquifer system (S100MSEMBM)	2374	1477	0.003	21	9	63
Unknown National aquifer	69	6109	0.29	260	32	819

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

Contacts

Point of Contact :: Aaron L Pugh, gs-w-lmg_director@usgs.gov
Originator :: Aaron L Pugh, Douglas A Carlson
Metadata Contact :: Aaron L Pugh
Publisher :: U.S. Geological Survey
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_HydrogeologicTestData_Mar2022.xml Original FGDC Metadata	View	12.57 KB	application/fgdc+xml
AtbtTbl_LocalAqfrCodes.txt “Local aquifer codes”		471.35 KB	text/plain
AtbtTbl_NatAqfrCodes.txt “National aquifer codes”		2.86 KB	text/plain
AtbtTbl_TstMthdCodes.txt “Test methods codes”		830 Bytes	text/plain
LMG_HydrogeologicTestData_Mar2022.jpg “Point locations of aquifer test in the March 2022 dataset.”		2 MB	image/jpeg
LMG_HydrogeologicTestData_Mar2022.txt “Tab delimited text [UTF-8] datafile”		2.67 MB	text/plain
LMG_HydrogeologicTestData_Mar2022.zip “Zipped ESRI Shape files”		1.66 MB	application/zip
AtbtTbl_DataRefNo.txt “Data reference numbers”		235 Bytes	text/plain
Readme.txt “Mar2022 readme text file”		9.41 KB	text/plain
AtbtTbl_AqfrCd_Readme.txt “Aquifer code read me”		3.16 KB	text/plain
AtbtTbl_FipsGeocodes_LA.txt “FIPS geographic codes(LA)”		1.6 KB	text/plain

Extension: LMG_HydrogeologicTestData_Mar2022.zip
LMG_HydrogeologicTestData_Mar2022.sd		2.23 MB

Purpose

The LMG-Hydrogeologic Aquifer Test dataset is an attempt to aggregate dispersed hydrogeologic 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, March 2022

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

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