Excel Spreadsheet of Piezometer Groundwater Data in the Nauset Marsh Area collected August, 2005
Metadata also available as - [Questions & Answers] - [Parseable text]
Metadata:
- 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
Generated by mp version 2.8.6 on Mon Aug 04 09:39:00 2008