{"accessLevel": "public", "bureauCode": ["010:12"], "contactPoint": {"@type": "vcard:Contact", "fn": "Aaron L. Pugh", "hasEmail": "mailto:apugh@usgs.gov"}, "description": "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.\nThis 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.\nTHE LMG-HYDROGEOLOGIC AQUIFER TEST DATASET \u2013 DECEMBER 2020 IS AVAILABLE IN TWO FORMATS:\n1) a tab delimited text (.txt) UTF-8 file and\n2) an ESRI GIS point shapefile.\nFIELDS INCLUDED IN THE LMG-HYDROGEOLOGIC AQUIFER TEST DATASET \u2013 DECEMBER 2020:\n[a complete list of field names, their definitions and units are listed in the Summary_Readme.pdf file]\nLocation data: USGS site identification number, local identification name, Public Land Survey System number, latitude, longitude, State and county.\nWell 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.\nAquifer data: Local aquifer name and code, national aquifer name and code, top of aquifer (altitude), bottom of aquifer, and thickness of aquifer.\nGroundwater 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.\nHydrogeologic data: Specific capacity, transmissivity, horizontal Conductivity, vertical conductivity, permeability and storage coefficient.\nAncillary data: Method of test analysis and data source reference.\nDESCRIPTIONS OF ATTACHED FILES:\nSummary_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.\nLMG-HydrogeologicAqfrTestDataset_Dec2020.txt: a tab-delimited, UTF-8 text file of the attribute table associated with the LMG-HydrogeologicTestData_Dec2020 geospatial dataset.\nAtbtTbl_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)\nAtbtTbl_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).\nAtbtTbl_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)\nAtbtTbl_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)\nAtbtTbl_TstMthdCodes.txt: a tab-delimited, UTF-8 text file of codes identifying the aquifer test analysis method when reported in the associated reference.\nAtbtTbl_DataRefNo.txt: a tab-delimited, UTF-8 text file of references for the source of the associated aquifer test result.\nCAVEAT:\nSome hydrogeologic test results reported in this dataset have not been through the USGS data review and approval process to receive the Director\u2019s approval. Any such data are considered PROVISIONAL and subject to revision. 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.\nNOTE:\n-- If you have data you would like added to this dataset or have found an error, please contact the USGS so we may incorporate them into the next version of the LMG- Hydrogeologic Aquifer Test dataset.\nTable 1. Summary-descriptive statistics for the LMG-HYDROGEOLOGIC AQUIFER TEST DATASET \u2013 December 2020.\n[USGS, U.S. Geological Survey; NWIS, National Water Information System; n, number of wells]\nUSGS-NWIS NATIONAL \t\t                \t\t\t\t\t\t\t\t\t\tSTANDARD \nAQUIFER\tNAME AND CODE\tn\t\tMAXIMUM\t\tMINIMUM\t\tMEAN\t\tMEDIUM\t\tDEVIATION\nSpecific capacity (gallons per minute per foot)\nAll well data\t\t1733\t\t15000\t\t0.0025\t\t84\t\t8.7\t\t552\nAlluvial aquifers (N100ALLUVL)\t\t21\t\t723\t\t0.98\t\t57\t\t12\t\t161\nMississippi River Valley alluvial aquifer (N100MSRVVL)\t\t185\t\t10000\t\t0.06\t\t265\t\t72\t\t864\nOther aquifers (N9999OTHER)\t\t3\t\t50\t\t1.20\t\t18\t\t2.1\t\t28\nCoastal lowlands aquifer system (S100CSLLWD)\t\t913\t\t15000\t\t0.05\t\t93\t\t12\t\t645\nMississippi embayment aquifer system (S100MSEMBM)\t\t429\t\t641\t\t0.01\t\t13\t\t4\t\t44\nSoutheastern Coastal Plain aquifer system (S100SECSLP)\t\t99\t\t71\t\t0.10\t\t6.2\t\t3.7\t\t8.7\nOzark Plateaus aquifer system (S400OZRKPL)\t\t30\t\t16\t\t0.16\t\t3.6\t\t1.7\t\t4.2\nEdwards-Trinity aquifer system (S500EDRTRN)\t\t0\t\t--\t\t--\t\t--\t\t--\t\t--\nUnknown National aquifer\t\t53\t\t972\t\t0.0025\t\t59\t\t10\t\t151\nTransmissivity (square feet per day)\nAll well data\t\t1549\t\t260678\t\t1.3\t\t12366\t\t5080\t\t20711\nAlluvial aquifers (N100ALLUVL)\t\t26\t\t41700\t\t450\t\t9294\t\t8422\t\t8420\nMississippi River Valley alluvial aquifer (N100MSRVVL)\t\t146\t\t171800\t\t236\t\t31934\t\t24431\t\t28074\nOther aquifers (N9999OTHER)\t\t4\t\t26000\t\t24\t\t8506\t\t4000\t\t11822\nCoastal lowlands aquifer system (S100CSLLWD)\t\t703\t\t260678\t\t1.5\t\t15585\t\t8000\t\t23875\nMississippi embayment aquifer system (S100MSEMBM)\t\t456\t\t36000\t\t1.3\t\t4618\t\t2406\t\t6006\nSoutheastern Coastal Plain aquifer system (S100SECSLP)\t\t114\t\t80000\t\t5.00\t\t3652\t\t1340\t\t8838\nOzark Plateaus aquifer system (S400OZRKPL)\t\t36\t\t4983\t\t42\t\t1056\t\t534\t\t1262\nEdwards-Trinity aquifer system (S500EDRTRN)\t\t1\t\t161\t\t161\t\t161\t\t161\t\t--\nUnknown National aquifer\t\t63\t\t84486\t\t5.9\t\t11103\t\t4345\t\t16908\nHorizontal hydraulic conductivity (feet per day)\nAll well data\t\t749\t\t1077\t\t0.01\t\t72\t\t50\t\t82\nAlluvial aquifers (N100ALLUVL)\t\t6\t\t321\t\t39.88\t\t160\t\t176\t\t106\nMississippi River Valley alluvial aquifer (N100MSRVVL)\t\t46\t\t400\t\t6.88\t\t182\t\t190\t\t134\nOther aquifers (N9999OTHER)\t\t4\t\t269\t\t92.00\t\t183\t\t185\t\t95\nCoastal lowlands aquifer system (S100CSLLWD)\t\t268\t\t1077\t\t1.00\t\t93\t\t81\t\t85\nMississippi embayment aquifer system (S100MSEMBM)\t\t271\t\t370\t\t0.02\t\t54\t\t43\t\t52\nSoutheastern Coastal Plain aquifer system (S100SECSLP)\t\t109\t\t230\t\t0.30\t\t31\t\t14\t\t36\nOzark Plateaus aquifer system (S400OZRKPL)\t\t33\t\t1.9\t\t0.01\t\t0.54\t\t0.31\t\t0.58\nEdwards-Trinity aquifer system (S500EDRTRN)\t\t0\t\t--\t\t--\t\t--\t\t--\t\t--\nUnknown National aquifer\t\t12\t\t267\t\t16.00\t\t104\t54\t\t99\nPermeability (gallons per day per square feet)\nAll well data\t\t497\t\t8375\t\t0.12\t\t736\t\t400\t\t947\nAlluvial aquifers (N100ALLUVL)\t\t12\t\t2400\t\t328\t\t1307\t\t1270\t\t602\nMississippi River Valley alluvial aquifer (N100MSRVVL)\t\t43\t\t7891\t\t110\t\t1926\t\t1785\t\t1174\nOther aquifers (N9999OTHER)\t\t0\t\t--\t\t--\t\t--\t\t--\t\t--\nCoastal lowlands aquifer system (S100CSLLWD)\t\t263\t\t8375\t\t11\t\t796\t\t636\t\t973\nMississippi embayment aquifer system (S100MSEMBM)\t\t165\t\t1300\t\t0.12\t\t235\t\t177\t\t237\nSoutheastern Coastal Plain aquifer system (S100SECSLP)\t\t0\t\t--\t\t--\t\t--\t\t--\t\t--\nOzark Plateaus aquifer system (S400OZRKPL)\t\t0\t\t--\t\t--\t\t--\t\t--\t\t--\nEdwards-Trinity aquifer system (S500EDRTRN)\t\t0\t\t--\t\t--\t\t--\t\t--\t\t--\nUnknown National aquifer\t\t14\t\t4158\t\t201\t\t1390\t\t1204\t\t963\nStorage coefficient (dimensionless)\nAll well data\t\t490\t\t1.62\t\t6.30E-10\t\t0.0083\t\t0.00051\t\t0.081\nAlluvial aquifers (N100ALLUVL)\t\t21\t\t0.08\t\t0.0002\t\t0.0053\t\t0.00054\t\t0.017\nMississippi River Valley alluvial aquifer (N100MSRVVL)\t\t82\t\t0.09\t\t0.0001\t\t0.0081\t\t0.0013\t\t0.016\nOther aquifers (N9999OTHER)\t\t1\t\t0.0006\t\t0.0006\t\t0.0006\t\t0.0006\t\t--\nCoastal lowlands aquifer system (S100CSLLWD)\t\t233\t\t0.72\t\t6.30E-10\t\t0.0054\t\t0.0005\t\t0.048\nMississippi embayment aquifer system (S100MSEMBM)\t\t100\t\t1.62\t\t0.000012\t\t0.0180\t\t0.00027\t\t0.16\nSoutheastern Coastal Plain aquifer system (S100SECSLP)\t\t16\t\t0.006\t\t0.00003\t\t0.0005\t\t0.0002\t\t0.0015\nOzark Plateaus aquifer system (S400OZRKPL)\t\t0\t\t--\t\t--\t\t--\t\t--\t\t--\nEdwards-Trinity aquifer system (S500EDRTRN)\t\t0\t\t--\t\t--\t\t--\t\t--\t\t--\nUnknown National aquifer\t\t37\t\t0.05\t\t0.000078\t\t0.0062\t\t0.00067\t\t0.014\nThis dataset was developed as part of the U.S. Geological Survey, Mississippi Alluvial Plain Regional Water-Availability Study.", "distribution": [{"@type": "dcat:Distribution", "accessURL": "https://doi.org/10.5066/P9Q9SI92", "description": "Landing page for access to the data", "format": "XML", "mediaType": "application/http", "title": "Digital Data"}, {"@type": "dcat:Distribution", "description": "The metadata original format", "downloadURL": "https://data.usgs.gov/datacatalog/metadata/USGS.5ebeb5ea82ce476925e46ba1.xml", "format": "XML", "mediaType": "text/xml", "title": "Original Metadata"}], "identifier": "http://datainventory.doi.gov/id/dataset/USGS_5ebeb5ea82ce476925e46ba1", "keyword": ["Aquifer", "Aquifer Test", "Arkansas", "Conductivity", "Groundwater", "Hydrogeology", "Louisiana", "Lower Mississippi-Gulf", "Mississippi", "Mississippi Alluvial Plain (MAP) Project", "Permeability", "Specific Capacity", "Storage Coefficient", "Transmissivity", "USGS:5ebeb5ea82ce476925e46ba1"], "modified": "2022-01-12T00:00:00Z", "publisher": {"@type": "org:Organization", "name": "U.S. Geological Survey"}, "spatial": "-94.4689, 29.6711, -88.1967, 36.4936", "theme": ["geospatial"], "title": "Hydrogeologic Aquifer Test dataset, Lower Mississipp-Gulf Water Science Center, December 2020"}