Database used for the evaluation of data used to identify groundwater sources under the direct influence of surface water in Pennsylvania
공공데이터포털
The U.S. Geological Survey (USGS), in cooperation with the Pennsylvania Department of Environmental Protection (PADEP), conducted an evaluation of data used by the PADEP to identify groundwater sources under the direct influence of surface water (GUDI) in Pennsylvania (Gross and others, 2022). The data used in this evaluation and the processes used to compile them from multiple sources are described and provided herein. Data were compiled primarily but not exclusively from PADEP resources, including (1) source-information for public water-supply systems and Microscopic Particulate Analysis (MPA) results for public water-supply system groundwater sources from the agency’s Pennsylvania Drinking Water Information System (PADWIS) database (Pennsylvania Department of Environmental Protection, 2016), and (2) results associated with MPA testing from the PADEP Bureau of Laboratories (BOL) files and water-quality analyses obtained from the PADEP BOL, Sample Information System (Pennsylvania Department of Environmental Protection, written commun., various dates). Information compiled from sources other than the PADEP includes anthropogenic (land cover and PADEP region) and naturogenic (geologic and physiographic, hydrologic, soil characterization, and topographic) spatial data. Quality control (QC) procedures were applied to the PADWIS database to verify spatial coordinates, verify collection type information, exclude sources not designated as wells, and verify or remove values that were either obvious errors or populated as zero rather than as “no data.” The QC process reduced the original PADWIS dataset to 12,147 public water-supply system wells (hereafter referred to as the PADWIS database). An initial subset of the PADWIS database, termed the PADWIS database subset, was created to include 4,018 public water-supply system community wells that have undergone the Surface Water Identification Protocol (SWIP), a protocol used by the PADEP to classify sources as GUDI or non-GUDI (Gross and others, 2022). A second subset of the PADWIS database, termed the MPA database subset, represents MPA results for 631 community and noncommunity wells and includes water-quality data (alkalinity, chloride, Escherichia coli, fecal coliform, nitrate, pH, sodium, specific conductance, sulfate, total coliform, total dissolved solids, total residue, and turbidity) associated with groundwater-quality samples typically collected concurrently with the MPA sample. The PADWIS database and two subsets (PADWIS database subset and MPA database subset) are compiled in a single data table (DR_2022_Table.xlsx), with the two subsets differentiated using attributes that are defined in the associated metadata table (DR_2022_Metadata_Table_Variables.xlsx). This metadata file (DR_2022_Metadata.xml) describes data resources, data compilation, and QC procedures in greater detail.
Database used for the evaluation of data used to identify groundwater sources under the direct influence of surface water in Pennsylvania
공공데이터포털
The U.S. Geological Survey (USGS), in cooperation with the Pennsylvania Department of Environmental Protection (PADEP), conducted an evaluation of data used by the PADEP to identify groundwater sources under the direct influence of surface water (GUDI) in Pennsylvania (Gross and others, 2022). The data used in this evaluation and the processes used to compile them from multiple sources are described and provided herein. Data were compiled primarily but not exclusively from PADEP resources, including (1) source-information for public water-supply systems and Microscopic Particulate Analysis (MPA) results for public water-supply system groundwater sources from the agency’s Pennsylvania Drinking Water Information System (PADWIS) database (Pennsylvania Department of Environmental Protection, 2016), and (2) results associated with MPA testing from the PADEP Bureau of Laboratories (BOL) files and water-quality analyses obtained from the PADEP BOL, Sample Information System (Pennsylvania Department of Environmental Protection, written commun., various dates). Information compiled from sources other than the PADEP includes anthropogenic (land cover and PADEP region) and naturogenic (geologic and physiographic, hydrologic, soil characterization, and topographic) spatial data. Quality control (QC) procedures were applied to the PADWIS database to verify spatial coordinates, verify collection type information, exclude sources not designated as wells, and verify or remove values that were either obvious errors or populated as zero rather than as “no data.” The QC process reduced the original PADWIS dataset to 12,147 public water-supply system wells (hereafter referred to as the PADWIS database). An initial subset of the PADWIS database, termed the PADWIS database subset, was created to include 4,018 public water-supply system community wells that have undergone the Surface Water Identification Protocol (SWIP), a protocol used by the PADEP to classify sources as GUDI or non-GUDI (Gross and others, 2022). A second subset of the PADWIS database, termed the MPA database subset, represents MPA results for 631 community and noncommunity wells and includes water-quality data (alkalinity, chloride, Escherichia coli, fecal coliform, nitrate, pH, sodium, specific conductance, sulfate, total coliform, total dissolved solids, total residue, and turbidity) associated with groundwater-quality samples typically collected concurrently with the MPA sample. The PADWIS database and two subsets (PADWIS database subset and MPA database subset) are compiled in a single data table (DR_2022_Table.xlsx), with the two subsets differentiated using attributes that are defined in the associated metadata table (DR_2022_Metadata_Table_Variables.xlsx). This metadata file (DR_2022_Metadata.xml) describes data resources, data compilation, and QC procedures in greater detail.
Compilation of data not available in the National Water Information System for domestic wells sampled by the U.S. Geological Survey in Bradford County, Pennsylvania, May-August 2016
공공데이터포털
This dataset contains the lithologic class and topographic position index information and quality-assurance and quality-control data not available in the online National Water Information System for 72 domestic wells sampled by the U.S. Geological Survey in Bradford County, Pennsylvania, May-August 2016. The topographic position index (TPI) for each well location was computed on the basis of a 25-meter digital elevation model (U.S. Geological Survey, 2009) using criteria reported by Llewellyn (2014) to indicate potential classes for topographic setting. The bedrock geologic unit and primary lithology were determined for each well location on the basis of the digital bedrock geologic map of Pennsylvania (Miles and Whitfield, 2001). The quality-assurance and quality-control data (such as blanks or replicates) were collected at a subset of sites to ensure that the data met specific data-quality objectives outlined for the study.
Compilation of data not available in the National Water Information System for domestic wells sampled by the U.S. Geological Survey in Bradford County, Pennsylvania, May-August 2016
공공데이터포털
This dataset contains the lithologic class and topographic position index information and quality-assurance and quality-control data not available in the online National Water Information System for 72 domestic wells sampled by the U.S. Geological Survey in Bradford County, Pennsylvania, May-August 2016. The topographic position index (TPI) for each well location was computed on the basis of a 25-meter digital elevation model (U.S. Geological Survey, 2009) using criteria reported by Llewellyn (2014) to indicate potential classes for topographic setting. The bedrock geologic unit and primary lithology were determined for each well location on the basis of the digital bedrock geologic map of Pennsylvania (Miles and Whitfield, 2001). The quality-assurance and quality-control data (such as blanks or replicates) were collected at a subset of sites to ensure that the data met specific data-quality objectives outlined for the study.
Compiled data for groundwater levels, groundwater withdrawals by wells and quarries, and point-source discharges to streams in the vicinity of Willow Grove and Warminster, Bucks and Montgomery Counties, Pennsylvania, for selected years during 1999-2017
공공데이터포털
This USGS Data Release includes hydrologic data compiled for selected years during the period 1990-2017 to support the development and calibration of a numerical groundwater model used to simulate groundwater flow paths at and near former and currently active military bases in Montgomery and Bucks Counties in southeastern Pennsylvania (Goode and Senior, 2020). The hydrologic data compiled for the study area include: 1) withdrawal (pumping) rates for production and other wells; 2) quarry pumping rates; 3) rates of flow discharged to streams from the National Pollution Discharge Elimination System (NPDES) sources, and 4) measured water levels in wells. The data were compiled from various sources described in the metadata for each type of data, with complete references for data sources listed in (Goode and Senior, 2020). Withdrawal (pumping) and discharge rates in the data release represent annual average rates computed as needed from data compiled from various sources. The principal time periods for compiled data include 1990's, 2010, 2013, 2016, and 2017. Some values are estimated where data were missing or not available.
Compiled data for groundwater levels, groundwater withdrawals by wells and quarries, and point-source discharges to streams in the vicinity of Willow Grove and Warminster, Bucks and Montgomery Counties, Pennsylvania, for selected years during 1999-2017
공공데이터포털
This USGS Data Release includes hydrologic data compiled for selected years during the period 1990-2017 to support the development and calibration of a numerical groundwater model used to simulate groundwater flow paths at and near former and currently active military bases in Montgomery and Bucks Counties in southeastern Pennsylvania (Goode and Senior, 2020). The hydrologic data compiled for the study area include: 1) withdrawal (pumping) rates for production and other wells; 2) quarry pumping rates; 3) rates of flow discharged to streams from the National Pollution Discharge Elimination System (NPDES) sources, and 4) measured water levels in wells. The data were compiled from various sources described in the metadata for each type of data, with complete references for data sources listed in (Goode and Senior, 2020). Withdrawal (pumping) and discharge rates in the data release represent annual average rates computed as needed from data compiled from various sources. The principal time periods for compiled data include 1990's, 2010, 2013, 2016, and 2017. Some values are estimated where data were missing or not available.
Compilation of data not available in the National Water Information System for domestic wells sampled by the U.S. Geological Survey in Clinton County, Pennsylvania, May-September 2017
공공데이터포털
This dataset contains the lithologic class and topographic position index information and quality-assurance and quality-control data not available in the online National Water Information System for 54 domestic wells sampled by the U.S. Geological Survey in Clinton County, Pennsylvania, May-September 2017. The topographic position index (TPI) for each well location was computed on the basis of a 25-meter digital elevation model (U.S. Geological Survey, 2009) using criteria reported by Llewellyn (2014) to indicate potential classes for topographic setting. The bedrock geologic unit and primary lithology were determined for each well location on the basis of the digital bedrock geologic map of Pennsylvania (Miles and Whitfield, 2001). The quality-assurance and quality-control data (such as blanks or replicates) were collected at a subset of sites to ensure that the data met specific data-quality objectives outlined for the study.