데이터셋 상세
미국
Pesticide datasets from the National Water Quality Laboratory, 2001-2016
This data release includes all pesticide results from selected batches of water samples analyzed by the U.S Geological Survey National Water Quality Laboratory (NWQL). Samples were analyzed using gas chromatography/mass spectrometry (GCMS) or liquid chromatography/mass spectrometry (LCMS) methods. Eight datasets are included in this data release; 1) all environmental and field quality control (QC) results for 11 pesticide compounds from 70 selected batches of GCMS data from schedules 2001, 2003, 2032, and 2033 (Sandstrom and others, 2001; Zaugg and others, 1995) from May 2001-June 2015, 2) all environmental and field QC results for 10 pesticide compounds from 43 selected batches of LCMS data from schedule 2060 (Furlong and others, 2001) from October 2001-July 2015, 3) All available GCMS set blank results from January 2001-May 2016, 4) All available LCMS set blank results from May 2001-August 2015, 5 and 6) All available blind-blank GCMS and LCMS results from the NWQL from 2004 and from the USGS Branch of Quality systems from 2007 through 2012, and 7 and 8) Blind-spike results from the USGS Organic Blind Sample Project from 2001 through 2016 for the 11 GCMS and 10 LCMS compounds that were investigated in the larger work cited in this metadata record. In addition to the pesticide data originally analyzed and published by the NWQL, a reevaluation of the data in the first two datasets listed in this abstract was performed using current 2017 identification practices. NWQL standard operating procedures have evolved over the 15 years encompassed by this study to provide more specific guidance on the application of identification rules for determining detections. In addition, technology advances were implemented at the NWQL that resulted in improvements in method performance and sample analysis over time. In the data reevaluation process, NWQL reevaluated every result from the 70 GCMS batches and 43 LCMS batches of samples using current 2017 operating procedures and consistently applied criteria for the qualitative identification of pesticides as described in the methods documents (Sandstrom and others, 2001; Zaugg and others, 1995; Furlong and others, 2001). This data release supports the following publication: Medalie, L., Sandstrom, M.W., Toccalino, P.L., Foreman, W.T., ReVello, R.C., Bexfield, L.M., and Riskin, M.L., 2019, Use of set blanks in reporting pesticide results at the U.S. Geological Survey National Water Quality Laboratory, 2001–15: U.S. Geological Survey Scientific Investigations Report 2019–5055, 147 p., https://doi.org/10.3133/sir20195055. References: Furlong, E.T., Anderson, B.D., Werner, S.L., Soliven, P.P., Coffey, L.J., and Burkhardt, M.R., 2001, Methods of analysis by the U.S. Geological Survey National Water Quality Laboratory—Determination of pesticides in water by graphitized carbon-based solid-phase extraction and high-performance liquid chromatography/mass spectrometry: U.S. Geological Survey Water-Resources Investigations Report 01–4134, 73 p. [Also available at https://doi.org/10.3133/wri014134.] Sandstrom, M.W., Stroppel, M.E., Foreman, W.T., and Schroeder, M.P., 2001, Methods of analysis by the U.S. Geological Survey National Water Quality Laboratory—Determination of moderate-use pesticides and selected degradates in water by C-18 solid-phase extraction and gas chromatography/mass spectrometry: U.S. Geological Survey Water-Resources Investigations Report 01–4098, 70 p. [Also available at https://nwql.usgs.gov/Public/pubs/WRIR/WRIR-01-4098.pdf.] Zaugg, S.D., Sandstrom, M.W., Smith, S.G., and Fehlberg, K.M., 1995, Methods of analysis by the U.S. Geological Survey National Water Quality Laboratory—Determination of pesticides in water by C–18 solid-phase extraction and capillary-column gas chromatography/mass spectrometry with selected-ion monitoring: U.S. Geological Survey Open-File Report 95–181, 49 p. [Also available at https://doi.org/10.3133/ofr95181.]
데이터 정보
연관 데이터
Pesticide datasets from the National Water Quality Laboratory, 2001-2016
공공데이터포털
This data release includes all pesticide results from selected batches of water samples analyzed by the U.S Geological Survey National Water Quality Laboratory (NWQL). Samples were analyzed using gas chromatography/mass spectrometry (GCMS) or liquid chromatography/mass spectrometry (LCMS) methods. Eight datasets are included in this data release; 1) all environmental and field quality control (QC) results for 11 pesticide compounds from 70 selected batches of GCMS data from schedules 2001, 2003, 2032, and 2033 (Sandstrom and others, 2001; Zaugg and others, 1995) from May 2001-June 2015, 2) all environmental and field QC results for 10 pesticide compounds from 43 selected batches of LCMS data from schedule 2060 (Furlong and others, 2001) from October 2001-July 2015, 3) All available GCMS set blank results from January 2001-May 2016, 4) All available LCMS set blank results from May 2001-August 2015, 5 and 6) All available blind-blank GCMS and LCMS results from the NWQL from 2004 and from the USGS Branch of Quality systems from 2007 through 2012, and 7 and 8) Blind-spike results from the USGS Organic Blind Sample Project from 2001 through 2016 for the 11 GCMS and 10 LCMS compounds that were investigated in the larger work cited in this metadata record. In addition to the pesticide data originally analyzed and published by the NWQL, a reevaluation of the data in the first two datasets listed in this abstract was performed using current 2017 identification practices. NWQL standard operating procedures have evolved over the 15 years encompassed by this study to provide more specific guidance on the application of identification rules for determining detections. In addition, technology advances were implemented at the NWQL that resulted in improvements in method performance and sample analysis over time. In the data reevaluation process, NWQL reevaluated every result from the 70 GCMS batches and 43 LCMS batches of samples using current 2017 operating procedures and consistently applied criteria for the qualitative identification of pesticides as described in the methods documents (Sandstrom and others, 2001; Zaugg and others, 1995; Furlong and others, 2001). This data release supports the following publication: Medalie, L., Sandstrom, M.W., Toccalino, P.L., Foreman, W.T., ReVello, R.C., Bexfield, L.M., and Riskin, M.L., 2019, Use of set blanks in reporting pesticide results at the U.S. Geological Survey National Water Quality Laboratory, 2001–15: U.S. Geological Survey Scientific Investigations Report 2019–5055, 147 p., https://doi.org/10.3133/sir20195055. References: Furlong, E.T., Anderson, B.D., Werner, S.L., Soliven, P.P., Coffey, L.J., and Burkhardt, M.R., 2001, Methods of analysis by the U.S. Geological Survey National Water Quality Laboratory—Determination of pesticides in water by graphitized carbon-based solid-phase extraction and high-performance liquid chromatography/mass spectrometry: U.S. Geological Survey Water-Resources Investigations Report 01–4134, 73 p. [Also available at https://doi.org/10.3133/wri014134.] Sandstrom, M.W., Stroppel, M.E., Foreman, W.T., and Schroeder, M.P., 2001, Methods of analysis by the U.S. Geological Survey National Water Quality Laboratory—Determination of moderate-use pesticides and selected degradates in water by C-18 solid-phase extraction and gas chromatography/mass spectrometry: U.S. Geological Survey Water-Resources Investigations Report 01–4098, 70 p. [Also available at https://nwql.usgs.gov/Public/pubs/WRIR/WRIR-01-4098.pdf.] Zaugg, S.D., Sandstrom, M.W., Smith, S.G., and Fehlberg, K.M., 1995, Methods of analysis by the U.S. Geological Survey National Water Quality Laboratory—Determination of pesticides in water by C–18 solid-phase extraction and capillary-column gas chromatography/mass spectrometry with selected-ion monitoring: U.S. Geological Survey Open-File Report 95–181, 49 p. [Also available at https://doi.org/10.3133/ofr95181.]
Field, laboratory, and third-party data for assessment of the quality of pesticide results reported by the National Water Quality Laboratory for groundwater samples collected by the National Water-Quality Assessment Project, 2013-18
공공데이터포털
This data release includes tables and plots of results for pesticide compounds (pesticides and degradates) analyzed in groundwater samples collected by the USGS National Water-Quality Assessment Project during water years 2013-18 and in associated quality-control samples that are used to assess the quality of the reported pesticide results. All samples were analyzed by the USGS National Water Quality Laboratory (NWQL) using laboratory schedule 2437. The table of groundwater data includes pesticide results as reported by the laboratory, along with results that represent the application of censoring levels at the 90-percent upper confidence limit of the 95th percentile of laboratory blank concentrations determined by water year. The other seven tables included in this data release contain pesticide results for the following types of quality-control samples: field blanks, matrix spikes, and replicates collected at field sites; laboratory blanks and reagent spikes prepared by the NWQL; and third-party blind blanks and blind spikes prepared by the USGS Quality Systems Branch. The table of pesticide results for field matrix spikes includes the paired groundwater results and other fields needed to calculate spike recovery as described in the data processing steps of the metadata file. The table of pesticide results for field replicates includes the paired groundwater results and other fields needed to calculate variability in detection and (or) concentration as described in the data processing steps of the metadata file. Results included in this data release for laboratory reagent spikes are for water year 2018 only; results for laboratory reagent spikes analyzed in water years 2013-15 are available in Shoda and others (2017) and in water years 2016-17 are available in Wieben (2019). Useful graphical representations of data in the tables are provided in various plots that compare detections and concentrations for groundwater and blank samples, compare recovery results for the different spike types, and illustrate variability in replicate-sample results across concentration ranges. Shoda, M.E., Nowell, L.H., Bexfield, L.M., Sandstrom, M.W., Stone, W.W., 2017, Recovery data for surface water, groundwater and lab reagent samples analyzed by the USGS National Water Quality Laboratory schedule 2437, water years 2013-15: U.S. Geological Survey data release, https://doi.org/10.5066/F7QZ28G4. Wieben, C.M., 2019, Pesticide recovery data for surface-water and lab reagent samples analyzed by the USGS National Water Quality Laboratory schedule 2437, water years 2016-17: U.S. Geological Survey data release, https://doi.org/10.5066/P93MWMVF. There are 8 tables included in this data release: Table1_GroundwaterData2013_2018.xlsx -- Pesticide results for groundwater samples collected by the National Water-Quality Assessment Project, 2013-18. This table includes pesticide results as reported by the laboratory, along with results that represent the application of censoring levels at the 90-percent upper confidence limit of the 95th percentile of laboratory blank concentrations determined by water year. Results that were rejected for data analysis for reasons described in the metadata document and in the associated Scientific Investigations Report are flagged. Table2_FieldBlankData2013_2018.xlsx -- Pesticide results for field blanks collected at groundwater sites by the National Water-Quality Assessment Project, 2013-18. Results that were rejected for data analysis for reasons described in the metadata document and in the associated Scientific Investigations Report are flagged. Table3_FieldSpikeData2013_2018.xlsx -- Pesticide results for field matrix spikes collected at groundwater sites by the National Water-Quality Assessment Project, 2013-18. Results of paired groundwater samples are included. Results that were rejected for data analysis for reasons described in the metadata document and in the associated Scientific Investigations Report are flagged.
Field, laboratory, and third-party data for assessment of the quality of pesticide results reported by the National Water Quality Laboratory for groundwater samples collected by the National Water-Quality Assessment Project, 2013-18
공공데이터포털
This data release includes tables and plots of results for pesticide compounds (pesticides and degradates) analyzed in groundwater samples collected by the USGS National Water-Quality Assessment Project during water years 2013-18 and in associated quality-control samples that are used to assess the quality of the reported pesticide results. All samples were analyzed by the USGS National Water Quality Laboratory (NWQL) using laboratory schedule 2437. The table of groundwater data includes pesticide results as reported by the laboratory, along with results that represent the application of censoring levels at the 90-percent upper confidence limit of the 95th percentile of laboratory blank concentrations determined by water year. The other seven tables included in this data release contain pesticide results for the following types of quality-control samples: field blanks, matrix spikes, and replicates collected at field sites; laboratory blanks and reagent spikes prepared by the NWQL; and third-party blind blanks and blind spikes prepared by the USGS Quality Systems Branch. The table of pesticide results for field matrix spikes includes the paired groundwater results and other fields needed to calculate spike recovery as described in the data processing steps of the metadata file. The table of pesticide results for field replicates includes the paired groundwater results and other fields needed to calculate variability in detection and (or) concentration as described in the data processing steps of the metadata file. Results included in this data release for laboratory reagent spikes are for water year 2018 only; results for laboratory reagent spikes analyzed in water years 2013-15 are available in Shoda and others (2017) and in water years 2016-17 are available in Wieben (2019). Useful graphical representations of data in the tables are provided in various plots that compare detections and concentrations for groundwater and blank samples, compare recovery results for the different spike types, and illustrate variability in replicate-sample results across concentration ranges. Shoda, M.E., Nowell, L.H., Bexfield, L.M., Sandstrom, M.W., Stone, W.W., 2017, Recovery data for surface water, groundwater and lab reagent samples analyzed by the USGS National Water Quality Laboratory schedule 2437, water years 2013-15: U.S. Geological Survey data release, https://doi.org/10.5066/F7QZ28G4. Wieben, C.M., 2019, Pesticide recovery data for surface-water and lab reagent samples analyzed by the USGS National Water Quality Laboratory schedule 2437, water years 2016-17: U.S. Geological Survey data release, https://doi.org/10.5066/P93MWMVF. There are 8 tables included in this data release: Table1_GroundwaterData2013_2018.xlsx -- Pesticide results for groundwater samples collected by the National Water-Quality Assessment Project, 2013-18. This table includes pesticide results as reported by the laboratory, along with results that represent the application of censoring levels at the 90-percent upper confidence limit of the 95th percentile of laboratory blank concentrations determined by water year. Results that were rejected for data analysis for reasons described in the metadata document and in the associated Scientific Investigations Report are flagged. Table2_FieldBlankData2013_2018.xlsx -- Pesticide results for field blanks collected at groundwater sites by the National Water-Quality Assessment Project, 2013-18. Results that were rejected for data analysis for reasons described in the metadata document and in the associated Scientific Investigations Report are flagged. Table3_FieldSpikeData2013_2018.xlsx -- Pesticide results for field matrix spikes collected at groundwater sites by the National Water-Quality Assessment Project, 2013-18. Results of paired groundwater samples are included. Results that were rejected for data analysis for reasons described in the metadata document and in the associated Scientific Investigations Report are flagged.
Data Sets for the Report Entitled, "A Field Study of Selected U.S. Geological Survey Analytical Methods for Measuring Pesticides in Filtered Stream Water, June-September 2012"
공공데이터포털
The National Water-Quality Assessment (NAWQA) Program and National Stream Quality Accounting Network (NASQAN) are U.S. Geological Survey (USGS) monitoring programs that measure pesticide concentrations in the Nation’s streams and rivers, herein collectively referred to as streams. The NAWQA Program began monitoring pesticides in 1992 and the NASQAN Program began monitoring pesticides in 1995. The programs were recently merged to form the USGS National Water Quality Network for Rivers and Streams. Water samples are analyzed for pesticides by the USGS National Water Quality Laboratory (NWQL) using methods developed by the NWQL’s Methods Research and Development team. The NWQL extensively used two analytical methods, gas chromatography/mass spectrometry and liquid chromatography/mass spectrometry, to measure pesticides in filtered water samples during 1992–2012 (old method). In October 2012, the monitoring programs began using direct aqueous-injection liquid chromatography tandem mass spectrometry as a new analytical method for pesticides (new method). The change in analytical methods, however, has the potential to inadvertently introduce bias in analysis of datasets that span the change. The data sets provided in this report were used to document performance of the new method in a variety of stream-water matrices and help quantify potential changes in measurement bias or variability that could be attributed to changes in analytical methods (Martin and others, 2016). Users should consult the report by Martin and others (2016) to understand how these data were collected and used. Measured concentrations and calculated recoveries of 281 pesticides and degradates in paired environmental background water samples and matrix spiked water samples collected at 48 stream-water sites from June 11, 2012 to September 6, 2012 are provided in seven tab-delimited ASCII files with relational database (RDB) format header. A tab-delimited ASCII file (DataDictionaryList.txt) listing DataSet attributes and RDB column formats is also included in this data release. Martin, J.D., Norman, J.E., Sandstrom, M.W., and Rose, C.E., 2016, A field study of selected U.S. Geological Survey analytical methods for measuring pesticides in filtered stream water, June-September 2012: U.S. Geological Survey Scientific Investigations Report, 2017-5049
Pesticide concentration and streamflow datasets used to evaluate pesticide trends in the Nation’s rivers and streams, 1992-2012 (input)
공공데이터포털
In 1991, the U.S. Geological Survey (USGS) began a study of more than 50 major river basins across the Nation as part of the National Water-Quality Assessment (NAWQA) project of the National Water-Quality Program. One of the major goals of the NAWQA project is to determine how water-quality conditions change over time. To support that goal, long-term consistent and comparable monitoring has been conducted on streams and rivers throughout the Nation. Outside of the NAWQA project, the USGS also has collected long-term water-quality data to support additional assessments of changing water-quality conditions. These data have been combined to provide insight into how natural features and human activities have contributed to water-quality changes over time in Nation’s streams and rivers. This USGS data release contains all of the input and output files necessary to reproduce the results from the SEAWAVE-Q pesticide models described in the associated U.S. Geological Survey Scientific Investigations Report. Data preparation for input to the model is also fully described in the above mentioned report.
Datasets for Comparison of Surrogate Models to Estimate Pesticide Concentrations at Six U.S. Geological Survey National Water Quality Network Sites During Water Years 2013–2018
공공데이터포털
This data release is comprised of data tables of input variables for seawaveQ and surrogate models used to predict concentrations of select pesticides at six U.S. Geological Survey National Water Quality Network (NWQN) river sites (Fanno Creek at Durham, Oregon; White River at Hazleton, Indiana; Kansas River at DeSoto, Kansas; Little Arkansas River near Sedgwick, Kansas; Missouri River at Hermann, Missouri; Red River of the North at Grand Forks, North Dakota). Each data table includes discrete concentrations of one select pesticide (Atrazine, Azoxystrobin, Bentazon, Bromacil, Imidacloprid, Simazine, or Triclopyr) at one of the NWQN sites; daily mean streamflow; 30-day and 1-day flow anomalies; daily median values of pH and turbidity; daily mean values of dissolved oxygen, specific conductance, and water temperature; and 30-day and 1-day anomalies for pH, turbidity, dissolved oxygen, specific conductance, and water temperature. Two pesticides were modeled at each site with three types of regression models. Also included is a zip file with outputs from seawaveQ model summary. The processes for retrieving and preparing data for regression models followed those outlined in the SEAWAVE-Q R package documentation (Ryberg and Vecchia, 2013; Ryberg and York, 2020). The R package waterData (Ryberg and Vecchia, 2012) was used to import daily mean values for discharge and either daily mean or daily median values for continuous water-quality constituents directly into R depending on what data were available at each site. Pesticide concentration, streamflow, and surrogate data (continuously measured field parameters) were imported from and are available online from the USGS National Water Information System database (USGS, 2020). The waterData package was used to screen for missing daily mean discharge values (no missing values were found for the sites) and to calculate short-term (1 day) and mid-term (30 day) anomalies for flow and short-term anomalies (1 day) for each water-quality variable. A mid-term streamflow anomaly, for instance, is the deviation of concurrent daily streamflow from average conditions for the previous 30 days (Vecchia and others, 2008). Anomalies were calculated as additional potential model variables. Pesticide concentrations for select constituents from each site were pulled into R using the dataRetrieval package (De Cicco and others, 2018). Three of the six sites (Kansas River at DeSoto, Kansas; Missouri River at Hermann, Missouri; and White River at Hazleton, Indiana) pulled pesticide data for WY 2013–17 whereas the other three sites (Fanno Creek at Durham, Oregon; Little Arkansas River near Sedgwick, Kansas; and Red River of the North at Grand Forks, North Dakota) pulled pesticide data for WY 2013–18. Discrete pesticide data were matched with daily mean discharge and daily mean or median water-quality constituents and the associated calculated short-term (1-day) and mid-term (30-day) anomalies from the date of sampling. Pesticide concentrations were estimated using the SEAWAVE-Q (with surrogates) model using 19 combinations of surrogate variables (table 2 in the associated SIR, "Comparison of Surrogate Models to Estimate Pesticide Concentrations at Six U.S. Geological Survey National Water Quality Network Sites During Water Years 2013–18.") at each of 12 site-pesticide combinations (table 3 in the associated SIR). Three measures of model performance—the generalized coefficient of determination (R2), Akaike’s Information Criteria (AIC), and scale—were included in the output and used to select best-fit models (Table 4 of the associated SIR). The three to four best-fit SEAWAVE-Q (with surrogates) models with sample sizes at least five times the number of variables were selected for each site-pesticide combination based on generalized R2 values—the higher, the better. If generalized R2 values were the same, the model with the lower AIC value was used. The standard surrogate regression and base SEAWAVE-Q models were
Pesticide concentration and streamflow datasets used to evaluate pesticide trends in the Nation’s rivers and streams, 1992-2012 (output)
공공데이터포털
In 1991, the U.S. Geological Survey (USGS) began a study of more than 50 major river basins across the Nation as part of the National Water-Quality Assessment (NAWQA) project of the National Water-Quality Program. One of the major goals of the NAWQA project is to determine how water-quality conditions change over time. To support that goal, long-term consistent and comparable monitoring has been conducted on streams and rivers throughout the Nation. Outside of the NAWQA project, the USGS also has collected long-term water-quality data to support additional assessments of changing water-quality conditions. These data have been combined to provide insight into how natural features and human activities have contributed to water-quality changes over time in Nation’s streams and rivers. This USGS data release contains all of the input and output files necessary to reproduce the results from the SEAWAVE-Q pesticide models described in the associated U.S. Geological Survey Scientific Investigations Report. Data preparation for input to the model is also fully described in the above mentioned report.
Pesticide concentration and streamflow datasets used to evaluate pesticide trends in the Nation’s rivers and streams, 1992-2012 (output)
공공데이터포털
In 1991, the U.S. Geological Survey (USGS) began a study of more than 50 major river basins across the Nation as part of the National Water-Quality Assessment (NAWQA) project of the National Water-Quality Program. One of the major goals of the NAWQA project is to determine how water-quality conditions change over time. To support that goal, long-term consistent and comparable monitoring has been conducted on streams and rivers throughout the Nation. Outside of the NAWQA project, the USGS also has collected long-term water-quality data to support additional assessments of changing water-quality conditions. These data have been combined to provide insight into how natural features and human activities have contributed to water-quality changes over time in Nation’s streams and rivers. This USGS data release contains all of the input and output files necessary to reproduce the results from the SEAWAVE-Q pesticide models described in the associated U.S. Geological Survey Scientific Investigations Report. Data preparation for input to the model is also fully described in the above mentioned report.
Nutrient and pesticide data collected from the USGS National Water Quality Network and previous networks, 1963-2017
공공데이터포털
The National Water Quality Network (NWQN) for Rivers and Streams includes 111 surface-water river and stream sites monitored by the U.S. Geological Survey (USGS) National Water Quality Program, National Water-Quality Assessment (NAWQA) Project. The NWQN includes 20 large river coastal sites, 41 large river inland sites, 30 wadeable stream reference sites, 10 wadeable stream urban sites, and 10 wadeable stream agricultural sites. In addition to the 111 NWQN sites, 3 large inland river monitoring sites from the USGS Cooperative Water Program are also included in this annual water-quality reporting Web site to be consistent with previous USGS studies of nutrient transport in the Mississippi-Atchafalaya River Basin. This data release provides streamflow, nutrient, pesticide and sediment data collected and analyzed by NWQN and other historical water-quality networks from 1963-2017. Data from this release are presented at the USGS Tracking Water Quality page: http://cida.usgs.gov/quality/rivers/home.
Nutrient and pesticide data collected from the USGS National Water Quality Network and previous networks, 1963-2017
공공데이터포털
The National Water Quality Network (NWQN) for Rivers and Streams includes 111 surface-water river and stream sites monitored by the U.S. Geological Survey (USGS) National Water Quality Program, National Water-Quality Assessment (NAWQA) Project. The NWQN includes 20 large river coastal sites, 41 large river inland sites, 30 wadeable stream reference sites, 10 wadeable stream urban sites, and 10 wadeable stream agricultural sites. In addition to the 111 NWQN sites, 3 large inland river monitoring sites from the USGS Cooperative Water Program are also included in this annual water-quality reporting Web site to be consistent with previous USGS studies of nutrient transport in the Mississippi-Atchafalaya River Basin. This data release provides streamflow, nutrient, pesticide and sediment data collected and analyzed by NWQN and other historical water-quality networks from 1963-2017. Data from this release are presented at the USGS Tracking Water Quality page: http://cida.usgs.gov/quality/rivers/home.