Identification_Information: Citation: Citation_Information: Originator: John F. Bratton Publication_Date: 2008 Title: Excel Spreadsheet of Piezometer Groundwater Data in the Nauset Marsh Area collected August, 2005 Series_Information: Series_Name: Open-File Report Issue_Identification: 2006-1169 Publication_Information: Publication_Place: Woods Hole Science Center, Woods Hole, MA Publisher: U.S. Geological Survey, Coastal and Marine Geology Program Online_Linkage: http://pubs.usgs.gov/of/2006/1169/data/tables/table6_groundwaterdata.zip Online_Linkage: http://pubs.usgs.gov/of/2006/1169/htmldocs/catalog.htm Larger_Work_Citation: Citation_Information: Originator: VeeAnn A. Cross Originator: John F. Bratton Originator: John Crusius Originator: John A. Colman Originator: Timothy D. McCobb Publication_Date: 2008 Title: Submarine Hydrogeological Data from Cape Cod National Seashore Series_Information: Series_Name: Open-File Report Issue_Identification: 2006-1169 Publication_Information: Publication_Place: Woods Hole Science Center, Woods Hole, MA Publisher: U.S. Geological Survey, Coastal and Marine Geology Program Online_Linkage: http://pubs.usgs.gov/of/2006/1169/ Description: Abstract: In order to test hypotheses about groundwater flow under and into estuaries and the Atlantic Ocean, geophysical surveys, geophysical probing, submarine groundwater sampling, and sediment coring were conducted by U.S. Geological Survey (USGS) scientists at Cape Cod National Seashore (CCNS) from 2004 through 2006. Coastal resource managers at CCNS and elsewhere are concerned about nutrients that are entering coastal waters via submarine groundwater discharge, which are contributing to eutrophication and harmful algal blooms. The research carried out as part of the study described here was designed, in part, to help refine assumptions required by earlier versions of models about the nature of submarine groundwater flow and discharge at CCNS. This study was conducted in four phases, with a variety of field techniques and equipment employed in each phase. Phase 1 consisted of continuous resistivity profiling (CRP) surveys of the entire study area conducted in 2004. Phase 2 consisted of CRP ground-truthing via resistivity probe measurements and submarine groundwater sampling from hydraulically-drive piezometers using a barge in the Salt Pond/Nauset Marsh area in 2005. Phase 3 consisted of supplemental detailed CRP surveys in the Salt Pond/Nauset Marsh area in 2006. Finally, Phase 4 consisted of sediment coring and porewater extraction in the Salt Pond/Nauset Marsh area later in 2006 to supplement the 2005 sampling. Purpose: To provide the analyses of the piezometer groundwater data in an Excel spreadsheet format. Piezometer groundwater was collected at various sites in the Nauset Marsh area. These locations were intended to reoccupy locations where Geoprobe samples were collected, thus the site designations are the same. However, the exact Geoprobe locations were not reoccupied. Time_Period_of_Content: Time_Period_Information: Range_of_Dates/Times: Beginning_Date: 20050822 Ending_Date: 20050825 Currentness_Reference: ground condition Status: Progress: Complete Maintenance_and_Update_Frequency: None planned Spatial_Domain: Bounding_Coordinates: West_Bounding_Coordinate: -69.971643 East_Bounding_Coordinate: -69.962932 North_Bounding_Coordinate: 41.835998 South_Bounding_Coordinate: 41.830668 Keywords: Theme: Theme_Keyword_Thesaurus: General Theme_Keyword: CMGP Theme_Keyword: Coastal and Marine Geology Program Theme_Keyword: ground-water Theme_Keyword: marine resistivity Theme_Keyword: OF 2006-1169 Theme_Keyword: Open-File Report Theme_Keyword: submarine ground-water Theme_Keyword: U.S. Geological Survey Theme_Keyword: USGS Theme_Keyword: Woods Hole Science Center Theme_Keyword: geochemistry Theme_Keyword: WHSC field activity serial number 05035 Theme: Theme_Keyword_Thesaurus: ISO 19115 Topic Category Theme_Keyword: oceans Theme_Keyword: oceans and estuaries Theme_Keyword: oceans and coastal Theme_Keyword: inlandWaters Theme_Keyword: geoscientificInformation Place: Place_Keyword_Thesaurus: General Place_Keyword: Atlantic Ocean Place_Keyword: Cape Cod Place_Keyword: Massachusetts Place_Keyword: North America Place_Keyword: United States Place_Keyword: Salt Pond Place_Keyword: Nauset Marsh Place_Keyword: Cape Cod National Seashore Access_Constraints: None. Use_Constraints: The U.S. Geological Survey must be referenced as the originator of the dataset in any future products or research derived from these data. Point_of_Contact: Contact_Information: Contact_Person_Primary: Contact_Person: John F. Bratton Contact_Organization: U.S. Geological Survey Contact_Address: Address_Type: mailing and physical address Address: 384 Woods Hole Rd. City: Woods Hole State_or_Province: MA Postal_Code: 02543-1598 Contact_Voice_Telephone: (508) 548-8700 x2254 Contact_Facsimile_Telephone: (508) 457-2310 Contact_Electronic_Mail_Address: jbratton@usgs.gov Native_Data_Set_Environment: Microsoft Windows XP Version 5.1 (Build 2600) Service Pack 2; ESRI ArcCatalog 9.2.4.1420 Data_Quality_Information: Completeness_Report: This dataset is complete inasmuch as all the piezometer data collected from the drill sites in this study is represented. Lineage: Process_Step: Process_Description: Piezometer groundwater was collected at various sites in the Nauset Marsh area. These locations were intended to reoccupy locations where Geoprobe samples were collected, thus the site designations are the same. However, the exact Geoprobe locations were not reoccupied. A hydraulic vibratory drilling rig mounted on an all-terrain vehicle and secured to a barge was used to advance piezometers for submarine ground-water sampling. These piezometers consisted of 2.5 cm diameter steel pipe in 3.4 m lengths that were joined by hydraulically crimped couplings. Process_Date: 2005 Process_Contact: Contact_Information: Contact_Person_Primary: Contact_Person: John F. Bratton Contact_Organization: U.S. Geological Survey Contact_Address: Address_Type: mailing and physical address Address: 384 Woods Hole Rd. City: Woods Hole State_or_Province: MA Postal_Code: 02543-1598 Contact_Voice_Telephone: (508) 548-8700 x2254 Contact_Facsimile_Telephone: (508) 457-2310 Contact_Electronic_Mail_Address: jbratton@usgs.gov Process_Step: Process_Description: Water samples were taken general every 305 cm with water quality measurements of temperature, conductivity, dissolved oxygen, pH, and oxidation-reduction potential made using a YSI 650 Multi-Parameter data sonde. In addition, filtered samples were collected for nutrient measurements. Process_Date: 2005 Process_Contact: Contact_Information: Contact_Person_Primary: Contact_Person: John F. Bratton Contact_Organization: U.S. Geological Survey Contact_Address: Address_Type: mailing and physical address Address: 384 Woods Hole Rd. City: Woods Hole State_or_Province: MA Postal_Code: 02543-1598 Contact_Voice_Telephone: (508) 548-8700 x2254 Contact_Facsimile_Telephone: (508) 457-2310 Contact_Electronic_Mail_Address: jbratton@usgs.gov Process_Step: Process_Description: The nutrient samples were analyzed using a Lachat Quickchem Flow Injection Analysis System. The methods used are as follows: N as NH3 (nitrogen as ammonia): method detection limit = 4 micrograms nitrogen per liter; Lachat QuickChem Method 10-107-06-1-C rev. 27Nov01; based on Environmental Protection Agency (EPA) Method 350.1. N as NO3/NO2 (cadmium reduction); method detection limit = 1.7 micrograms nitrogen per liter; Lachat QuikChem Method 31-107-04-1-C rev. 16Sept03; based on Grasshoff, K., Methods of Seawater Analysis, Verlag Chemie, 2nd Ed., 1976. P as PO4 (phosphorus as phosphate); method detection limit 0.1 micrograms phosphorus per liter; Lachat QuikChem Method 10-115-01-1-M rev. 27Aug03; based on EPA Method 365.1. Total dissolved Nitrogen (TDN)/ Total Dissolved Phosphorus (TDP) notes: Samples were prepared by persulfate digestion (following Valderrama, 1981, Marine Chemistry 10:109-122) prior to analysis by Lachat Methods. TDP results with an asterisk indicate TDP < inorganic phosphorous. Values are very close; typically this represents that all of the phosphorus is in the dissolved inorganic state. Process_Date: 20060123 Process_Contact: Contact_Information: Contact_Person_Primary: Contact_Person: Krista Lee Contact_Organization: National Park Service Contact_Position: Physical Scientist Contact_Address: Address_Type: mailing address Address: Cape Cod National Seashore Address: 99 Marconi Site Road City: Wellfleet State_or_Province: Massachusetts Postal_Code: 02667 Contact_Voice_Telephone: (508) 487-3262 x110 Contact_Facsimile_Telephone: (508) 487-7153 Contact_Electronic_Mail_Address: Krista_Lee@nps.gov Process_Step: Process_Description: The information was transferred to an Excel spreadsheet. Process_Date: 2007 Process_Contact: Contact_Information: Contact_Person_Primary: Contact_Person: John F. Bratton Contact_Organization: U.S. Geological Survey Contact_Address: Address_Type: mailing and physical address Address: 384 Woods Hole Rd. City: Woods Hole State_or_Province: MA Postal_Code: 02543-1598 Contact_Voice_Telephone: (508) 548-8700 x2254 Contact_Facsimile_Telephone: (508) 457-2310 Contact_Electronic_Mail_Address: jbratton@usgs.gov Entity_and_Attribute_Information: Overview_Description: Entity_and_Attribute_Overview: This Excel spreadsheet contains the groundwater sample analyses information. Within this spreadsheet are 15 columns of information defined as the following: Sample Location Site name - name assigned to the piezometer location attempting to reoccupy the Geoprobe locations by the same site name. Approx. Water Depth at Time of Sampling (cm) - the approximate water depth at time of sampling measured in centimeters. Depth Below Sediment Surface (cm) - depth below the sediment surface measured in centimeters. Temperature (degC) - temperature in degrees Celsius. Conductivity (mS/m) - conductivity in milli-Siemens per meter. Salinity (ppt) - salinity in parts per thousand. Dissolved Oxygen (% saturation) - dissolved oxygen as percent saturation; how much oxygen is dissolved in the water as a percentage of how much it could hold at that temperature. Dissolved Oxygen (mg/L) - dissolved oxygen measure in milligrams per liter. pH - the measured acidity or alkalinity on the pH scale. Oxidation-Reduction Potential (mV) - oxidation-reduction potential in milli-volts indicating the relative strength of oxidizing compounds in the solution (more positive values) or reducing compounds in the solution (more negative values). N-NH3 - concentration of nitrogen in the reduced form of ammonium measure in micrograms per liter. N-NO3/NO2 - concentration of nitrogen in the oxidized forms of nitrate and nitrite combined measure in micrograms per liter. P-PO4 - concentration of phosphorus in the form of phosphate measured in micrograms per liter. Total Dissolved P (TDP) as PO4 - total dissolved phosphorus; dissolved inorganic and organic phosphorus all chemically converted to inorganic form and measured as phosphorus in micrograms per liter. Total Dissolved N (TDN) as NO3) - total dissolved nitrogen; dissolved inorganic and organic nitrogen all chemically converted to inorganic form and measured as nitrogen in micrograms per liter. In terms of data collection, a hydraulic vibratory drilling rig mounted on an all-terrain vehicle and secured to a barge was used to advance piezometers for submarine ground-water sampling. These piezometers consisted of 2.5 cm diameter steel pipe in 3.4 m lengths that were joined by hydraulically crimped couplings. Water samples were taken generally every 305 cm with water quality measurements of temperature, conductivity, dissolved oxygen, pH and oxidation-reduction potential made using a YSI 650 Multi-Parameter data sonde. In addition, filtered samples were collected for nutrient measurements. Distribution_Information: Distributor: Contact_Information: Contact_Person_Primary: Contact_Person: John F. Bratton Contact_Organization: U.S. Geological Survey Contact_Address: Address_Type: mailing and physical address Address: 384 Woods Hole Rd. City: Woods Hole State_or_Province: MA Postal_Code: 02543-1598 Contact_Voice_Telephone: (508) 548-8700 x2254 Contact_Facsimile_Telephone: (508) 457-2310 Contact_Electronic_Mail_Address: jbratton@usgs.gov Resource_Description: Downloadable Data Distribution_Liability: Neither the U.S. Government, the Department of the Interior, nor the USGS, nor any of their employees, contractors, or subcontractors, make any warranty, express or implied, nor assume any legal liability or responsibility for the accuracy, completeness, or usefulness of any information, apparatus, product, or process disclosed, nor represent that its use would not infringe on privately owned rights. The act of distribution shall not constitute any such warranty, and no responsibility is assumed by the USGS in the use of these data or related materials. Any use of trade, product, or firm names is for descriptive purposes only and does not imply endorsement by the U.S. Government. Standard_Order_Process: Digital_Form: Digital_Transfer_Information: Format_Name: XLS File_Decompression_Technique: WinZip Transfer_Size: 23 KB Fees: None. Technical_Prerequisites: These data are available in Microsoft Excel spreadsheet format. The user must have software capable of reading or importing the Excel formatted data file. Metadata_Reference_Information: Metadata_Date: 20080804 Metadata_Contact: Contact_Information: Contact_Person_Primary: Contact_Person: VeeAnn A. Cross Contact_Organization: U.S. Geological Survey Contact_Position: Marine Geologist Contact_Address: Address_Type: mailing and physical address Address: 384 Woods Hole Rd. City: Woods Hole State_or_Province: MA Postal_Code: 02543-1598 Contact_Voice_Telephone: (508) 548-8700 x2251 Contact_Facsimile_Telephone: (508) 457-2310 Contact_Electronic_Mail_Address: vatnipp@usgs.gov Metadata_Standard_Name: FGDC Content Standards for Digital Geospatial Metadata Metadata_Standard_Version: FGDC-STD-001-1998 Metadata_Time_Convention: local time Metadata_Extensions: Online_Linkage: http://www.esri.com/metadata/esriprof80.html Profile_Name: ESRI Metadata Profile