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

Dates

Publication Date: 2022-01-12
Start Date: 1938
End Date: 2020

Citation

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

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. This dataset contains information and results from 2,245 aquifer tests compiled for aquifers located in Arkansas, Louisiana, and Mississippi. Descriptive statistics for the December 2020 dataset are presented [...]

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.

This dataset contains information and results from 2,245 aquifer tests compiled for aquifers located in Arkansas, Louisiana, and Mississippi. Descriptive statistics for the December 2020 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 – 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 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 (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:
Readme.txt: a text file with names, definitions and units for the aquifer test dataset and the associated attribute tables.
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 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_Dec2020.zip: Esri vector data storage format 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.

CAVEAT:
Some hydrogeologic test results reported in this dataset have not been through the USGS data review and approval process to receive the Director’s approval. Only hydrogeologic test results from USGS publications should be considered to have USGS Director’s approval. All other test results should be considered provisional. Each hydrogeologic test listed in this dataset is attributed with a reference number (ref_no) allowing users to lookup the original reference for tests using the attached file “AtbtTbl_DataRefNo.txt”. 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 data you would like added to this dataset or have found an error, please contact the USGS so we may incorporate the changes into the next version of the LMG hydrogeologic test dataset.

Table 1. Summary-descriptive statistics of aquifer test data in the LMG-HYDROGEOLOGIC AQUIFER TEST DATASET – December 2020.
[USGS, U.S. Geological Survey; NWIS, National Water Information System; n, number of wells]
USGS-NWIS NATONAL AQUIFER NAME AND CODE	n	MAXIMUM	MINIMUM	MEAN	MEDIUM	STANDARD DEVIATION
USGS-NWIS NATONAL AQUIFER NAME AND CODE	n	MAXIMUM	MINIMUM	MEAN	MEDIUM	STANDARD DEVIATION
Specific capacity (gallons per minute per foot)
All well data	1733	15000	0.0025	84	8.7	552
Alluvial aquifers (N100ALLUVL)	21	723	0.98	57	12	161
Mississippi River Valley alluvial aquifer (N100MSRVVL)	185	10000	0.06	265	72	864
Other aquifers (N9999OTHER)	3	50	1.20	18	2.1	28
Coastal lowlands aquifer system (S100CSLLWD)	913	15000	0.05	93	12	645
Mississippi embayment aquifer system (S100MSEMBM)	429	641	0.01	13	4	44
Southeastern Coastal Plain aquifer system (S100SECSLP)	99	71	0.10	6.2	3.7	8.7
Ozark Plateaus aquifer system (S400OZRKPL)	30	16	0.16	3.6	1.7	4.2
Edwards-Trinity aquifer system (S500EDRTRN)	0	--	--	--	--	--
Unknown National aquifer	53	972	0.0025	59	10	151
Transmissivity (square feet per day)
All well data	1549	260678	1.3	12366	5080	20711
Alluvial aquifers (N100ALLUVL)	26	41700	450	9294	8422	8420
Mississippi River Valley alluvial aquifer (N100MSRVVL)	146	171800	236	31934	24431	28074
Other aquifers (N9999OTHER)	4	26000	24	8506	4000	11822
Coastal lowlands aquifer system (S100CSLLWD)	703	260678	1.5	15585	8000	23875
Mississippi embayment aquifer system (S100MSEMBM)	456	36000	1.3	4618	2406	6006
Southeastern Coastal Plain aquifer system (S100SECSLP)	114	80000	5.00	3652	1340	8838
Ozark Plateaus aquifer system (S400OZRKPL)	36	4983	42	1056	534	1262
Edwards-Trinity aquifer system (S500EDRTRN)	1	161	161	161	161	--
Unknown National aquifer	63	84486	5.9	11103	4345	16908
Horizontal hydraulic conductivity (feet per day)
All well data	749	1077	0.01	72	50	82
Alluvial aquifers (N100ALLUVL)	6	321	39.88	160	176	106
Mississippi River Valley alluvial aquifer (N100MSRVVL)	46	400	6.88	182	190	134
Other aquifers (N9999OTHER)	4	269	92.00	183	185	95
Coastal lowlands aquifer system (S100CSLLWD)	268	1077	1.00	93	81	85
Mississippi embayment aquifer system (S100MSEMBM)	271	370	0.02	54	43	52
Southeastern Coastal Plain aquifer system (S100SECSLP)	109	230	0.30	31	14	36
Ozark Plateaus aquifer system (S400OZRKPL)	33	1.9	0.01	0.54	0.31	0.58
Edwards-Trinity aquifer system (S500EDRTRN)	0	--	--	--	--	--
Unknown National aquifer	12	267	16.00	104	54	99
Permeability (gallons per day per square feet)
All well data	497	8375	0.12	736	400	947
Alluvial aquifers (N100ALLUVL)	12	2400	328	1307	1270	602
Mississippi River Valley alluvial aquifer (N100MSRVVL)	43	7891	110	1926	1785	1174
Other aquifers (N9999OTHER)	0	--	--	--	--	--
Coastal lowlands aquifer system (S100CSLLWD)	263	8375	11	796	636	973
Mississippi embayment aquifer system (S100MSEMBM)	165	1300	0.12	235	177	237
Southeastern Coastal Plain aquifer system (S100SECSLP)	0	--	--	--	--	--
Ozark Plateaus aquifer system (S400OZRKPL)	0	--	--	--	--	--
Edwards-Trinity aquifer system (S500EDRTRN)	0	--	--	--	--	--
Unknown National aquifer	14	4158	201	1390	1204	963
Storage coefficient (dimensionless)
All well data	490	1.62	6.30E-10	0.0083	0.00051	0.081
Alluvial aquifers (N100ALLUVL)	21	0.08	0.0002	0.0053	0.00054	0.017
Mississippi River Valley alluvial aquifer (N100MSRVVL)	82	0.09	0.0001	0.0081	0.0013	0.016
Other aquifers (N9999OTHER)	1	0.0006	0.0006	0.0006	0.0006	--
Coastal lowlands aquifer system (S100CSLLWD)	233	0.72	6.30E-10	0.0054	0.0005	0.048
Mississippi embayment aquifer system (S100MSEMBM)	100	1.62	0.000012	0.0180	0.00027	0.16
Southeastern Coastal Plain aquifer system (S100SECSLP)	16	0.006	0.00003	0.0005	0.0002	0.0015
Ozark Plateaus aquifer system (S400OZRKPL)	0	--	--	--	--	--
Edwards-Trinity aquifer system (S500EDRTRN)	0	--	--	--	--	--
Unknown National aquifer	37	0.05	0.000078	0.0062	0.00067	0.014

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
Originator :: Aaron L Pugh
Metadata Contact :: Aaron L Pugh
Publisher :: U.S. Geological Survey
USGS Mission Area :: Water Resources
SDC Data Owner :: Lower Mississippi-Gulf Water Science Center
Distributor :: U.S. Geological Survey - ScienceBase

Attached Files

sorting

Metadata First

Recent First

Alphabetical

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

LMG-HydrogeologicAquiferTestDataset_Dec2020.xml Original FGDC Metadata	View	17.04 KB	application/fgdc+xml
AtbtTbl_AqfrCd_Readme.txt “Attribute table: aquifer code read me”		4.34 KB	text/plain
AtbtTbl_FipsGeocodes.txt “Attribute table: FIPS geographic codes”		71.07 KB	text/plain
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_TstMthdCodes.txt “Attribute table: test methods codes”		578 Bytes	text/plain
Map_LMG-HydrogeologicAqfrTestDataset-Dec2020.jpg		2.46 MB	image/jpeg
LMG-HydrogeologicAqfrTestData_Dec2020.zip “Zipped ESRI GIS point shapefile”		1.25 MB	application/zip
LMG-HydrogeologicAqfrTestData_Dec2020.txt “Tab delimited text [UTF-8] datafile”		654.25 KB	text/plain
Readme.txt “Readme text file”		8.62 KB	text/plain
AtbtTbl_DataRefNo.txt “Attribute table: data reference numbers ”		3.61 KB	text/plain

Extension: LMG_HydrogeologicTestDataset_Dec2020.zip
LMG_HydrogeologicTestDataset_Dec2020.sd		2.08 MB

Related External Resources

Type: Citation

Albin, D.R., Hines, M.S., and Stephens J.W., Water resources of Jackson and Independence Counties, Arkansas, Contributions to the Hydrology of the United States: U.S. Geological Survey Water Supply Paper 1839-G, 29 p.	https://pubs.er.usgs.gov/publication/wsp1839G
Bedinger, M. S., and Reed, J. E., 1961,Geology and Ground-Water Resources of Desha and Lincoln Counties, Arkansas: Arkansas Geological and Conservation Commission, Water Resources Circular No. 6, 129 p.	https://www.geology.arkansas.gov/publication/water_circulars/WRC-6-water-resources-circular.html
Broom,M.E., and Lyford, F.P., 1982, Alluvial Aquifer of the Cache and St. Francis River Basins, Northeastern, Arkansas: Arkansas Geological Commission, Water Resources Circular No. 13, 48 p.	https://www.geology.arkansas.gov/publication/water_circulars/WRC-13-water-resources-circular.html
Counts, H.B., 1957, Ground-Water Resources of Parts of Lonoke, Prairie, and White Counties, Arkansas: Arkansas Geologic and Conservation Commission, Water Resources Circular No. 5, 65 p.	https://www.geology.arkansas.gov/publication/water_circulars/WRC-5-water-resources-circular.html
Halberg, H.N., and Reed, J.E., 1964, Ground-water resources of eastern Arkansas in the vicinity of U.S. Highway 70: U.S. Geological Survey Water-Supply Paper 1779-V, 38 p.	https://pubs.er.usgs.gov/publication/wsp1779V
Onellion, F.E., and Criner, J.H. Jr., 1955, Ground-Water Resources of Chicot County, Arkansas: Arkansas Geologic and Conservation Commission, Water Resources Circular No. 3, 32 p.	https://www.geology.arkansas.gov/publication/water_circulars/WRC-3-water-resources-circular.html
Onellion, F.E., 1956, Geology and Ground-Water Resources of Drew County, Arkansas: Arkansas Geologic and Conservation Commission, Water Resources Circular No. 4, 43 p.	https://www.geology.arkansas.gov/publication/water_circulars/WRC-4-water-resources-circular.html
Plebuch, R.O. 1961, Fresh-Water Aquifers of Crittenden County, Arkansas: Arkansas Geological and Conservation Commission, Water Resources Circular No. 8, 65 p.	https://www.geology.arkansas.gov/publication/water_circulars/WRC-8-water-resources-circular.html
Pugh, A.L., 2008, Summary of aquifer test data for Arkansas -- 1940-2006: U.S. Geological Survey Scientific Investigations Report 2008-5149, 33 p.	https://pubs.usgs.gov/sir/2008/5149/
Slack, L.J., and Darden, D., 1991. Summary of aquifer tests in Mississippi, June 1942 through May 1988, U.S. Geological Survey Water Resources Investigation Report 90-4155, 40 p.	https://pubs.er.usgs.gov/publication/wri904155
Tyling, R.W., 1960, Ground-Water Potential of Mississippi County, Arkansas: Arkansas Geological and Conservation Commission, Water Resources Circular No. 7, 87 p.	https://www.geology.arkansas.gov/publication/water_circulars/WRC-7-water-resources-circular.html
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 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, December 2020

Dates

Citation

Summary

Summary

Contacts

Attached Files

sorting

Metadata First

Recent First

Alphabetical

Purpose

Preview Image

Map

Spatial Services

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

Spatial Services

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