I. Data Set Descriptors A. Title: Hammock groundwater well pressure, temperature and conductivity measurements for PC_i_29_WELL_LOC_9 from 13-May-2011 to 23-Aug-2011 B. Accession Number: HYD-GCES-1401b C. Description 1. Originator(s): Name: Clark Alexander Address: 10 Ocean Science Circle, Skidaway Institute of Oceanography, Savannah, Georgia Postal Code: 31411 Country: USA Email: clark.alexander@skio.usg.edu 2. Abstract: Pressure, temperature and conductivity were measured in a PVC groundwater well at 15 minute intervals using a Schlumberger CTD-Diver from 13-May-2011 to 27-Jun-2011. Data were downloaded from the logger using communications software, then imported into MATLAB for post-processing, quality control and documention. Raw, unvented pressure readings were corrected for atmospheric pressure and sensor height from the bottom of the well to generate corrected pressure readings. These data were collected as part of the Georgia Coastal Ecosystems LTER Intensive Hammock Characterization project (http://gce-lter.marsci.uga.edu/public/app/send_project_eml.asp?id=57), and will be used for groundwater modeling studies at two marsh hammocks on Sapelo Island, Georgia. 3. Study Type: Monitoring 4. Study Themes: Hydrology, Groundwater 5. LTER Core Areas: Inorganic Fluxes 6. Georeferences: geographic coordinates as data columns 7. Submission Date: D. Keywords: pressure, well, groundwater, hammock, hydrostatic II. Research Origin Descriptors A. Overall Project Description 1. Project Title: Georgia Coastal Ecosystems LTER Project 2. Principal Investigators: Name: Merryl Alber Address: Dept. of Marine Sciences, University of Georgia, Athens, Georgia Postal Code: 30602-3636 Country: USA Email: malber@uga.edu Name: Steven C. Pennings Address: Department of Biology and Biochemistry, University of Houston, Houston, Texas Postal Code: 7204-5513 Country: USA Email: spennings@uh.edu 3. Funding Period: 01-May-2000 to 31-Dec-2012 4. Objectives: To investigate the linkages between coastal and distant upland areas in central Georgia mediated by surface and ground water delivery to the coastal zone. This will be addressed by examining the relationship between variability in environmental factors driven by river flow, primarily salinity, and ecosystem processes and structure. 5. Abstract: The Georgia Coastal Ecosystems (GCE) LTER program, located on the central Georgia coast, was established in 2000. The study domain encompasses three adjacent sounds (Altamaha, Doboy, Sapelo) and includes upland (mainland, barrier islands, marsh hammocks), intertidal (fresh, brackish and salt marsh) and submerged (river, estuary, continental shelf) habitats. Patterns and processes in this complex landscape vary spatially within and between sites, and temporally on multiple scales (tidal, diurnal, seasonal, and interannual). Overlain on this spatial and temporal variation are long-term trends caused by climate change, sea level rise, and human alterations of the landscape. These long-term trends are likely to manifest in many ways, including changes in water quality, river discharge, runoff and tidal inundation patterns throughout the estuarine landscape. The overarching goal of the GCE program is to understand the mechanisms by which variation in the quality, source and amount of both fresh and salt water create temporal and spatial variability in estuarine habitats and processes, in order to predict directional changes that will occur in response to long-term shifts in estuarine salinity patterns. 6. Funding Source: NSF OCE 9982133 and OCE-0620959 B. Sub-project Description 1. Site Description a. Geographic Location: PC_i_29 -- Hammock PC_i_29, Sapelo Island, Georgia, USA PC_i_29_WELL_LOC_9 -- Hammock PC_i_29 Well Location 9 Coordinates: PC_i_29 -- NW: 81 16 43.6 W, 31 23 41.1 N NE: 81 16 39.3 W, 31 23 41.1 N SE: 81 16 39.3 W, 31 23 39.5 N SW: 81 16 43.6 W, 31 23 39.5 N PC_i_29_WELL_LOC_9 -- 81 16 43.3 W, 31 23 38.5 N b. Physiographic Region: PC_i_29 -- Back-barrier island PC_i_29_WELL_LOC_9 -- Back-barrier island c. Landform Components: PC_i_29 -- Maritime forest bordered by intertidal salt marsh PC_i_29_WELL_LOC_9 -- Marsh hammock d. Hydrographic Characteristics: PC_i_29 -- Site is subject to 2-3m semi-diurnal tides PC_i_29_WELL_LOC_9 -- Site is subject to 2-3m semi-diurnal tides e. Topographic Attributes: PC_i_29 -- Flat, with elevations ranging from 0-3m above mean low tide PC_i_29_WELL_LOC_9 -- Flat, with elevations ranging from 0-3m above mean low tide f. Geology, Lithology and Soils: PC_i_29 -- Pleistocene sediments PC_i_29_WELL_LOC_9 -- Pleistocene sediments g. Vegetation Communities: PC_i_29 -- unspecified PC_i_29_WELL_LOC_9 -- unspecified h. History of Land Use and Disturbance: i. Climate: Climate summary for Sapelo Island, Georgia, based on NWS data from 1980-2001: Daily-aggregated Values: Mean (sample standard deviation) mean air temperature: 19.78°C (6.98°C) minimum air temperature: 14.64°C (7.54°C) maximum air temperature: 24.62°C (6.78°C) total precipitation: 3.58mm (11.35mm) Yearly-aggregated Values: Mean (sample standard deviation) total precipitation (1981-2000): 1302mm (250mm) 2. Experimental or Sampling Design a. Design Characteristics: Groundwater pressure was measured continously to characterize changes in water table and groundwater flow in two marsh Hammocks on Sapelo Island, Georgia. b. Permanent Plots: none c. Data Collection Duration and Frequency: Pressure was measured continuously and logged at 15 minute intervals by an automated data logger installed in a PVC groundwater well. Beginning of Observations: 13-May-2011 End of Observations: 23-Aug-2011 3. Research Methods a. Field and Laboratory Methods: Method 1: Hammock Selection -- In 2008 we selected two hammocks for detailed study: HN_I_1 is of Holocene origin and is located adjacent to Blackbeard Island to the north of Sapelo Island, Georgia; PC_I_29 is of Pleistocene origin and is located adjacent to the south end of Sapelo Island. These hammocks are of similar size, with similar vegetation zones in the high marsh. We set up transects in each hammock that run from the nearby upland (Blackbeard and Sapelo Islands, respectively), through the marsh, and up and over each hammock to the marsh adjacent to the Sound (Sapelo and Doboy, respectively). Method 2: Well Installation -- On each hammock, groundwater wells were installed along the transects in the locations sampled by vibracore. Wells were placed in sand layers in order to prevent clogging and to allow sampling of a continuously connected groundwater source. In addition to the vibracore stations, two additional lateral wells were installed at HN_I_1 approximately 5 meters to either side of the main transect near well #4 in order to get data on lateral inflow of groundwater. An additional upland well was also installed at this site in order to obtain a true zero salinity end member. The wells range in depth from 41 to 110 cm below a constant zero datum (99 to 232 cm below the surface). At PC_I_29, the two lateral wells are located near well #6. Well depths at this site range between 75 and 168 cm below a zero datum (130 to 247 cm below the surface). Method 3: Pressure Measurements -- Groundwater pressure was measured using a Hach Hydrolab MiniSonde data logger installed in a PVC well, suspended from the top of the well using a metal cable so that the sensor was appoximately 0.25m from the well bottom. Sensors are retrieved and data are downloaded approximately semi-monthly. Method 4: Data Post-processing -- Raw binary data were converted to ASCII text files using Win-Situ software provided with the instrument. Text files were then imported into MATLAB using the GCE Data Toolbox for MATLAB, and integrated with metadata about well location, sensor placement and well elevation. Complete data sets were then quality-controlled using automated QA/QC rules and visual inspection. Method 5: Pressure Correction -- Groundwater pressure data were integrated with meteorological data from the GCE-LTER/SINERR Marsh Landing weather station on Sapelo Island to correct readings for groundwater pressure alone. Atmospheric pressure was converted units of m H2O and subtracted from the raw pressure reading, then the sensor height off the bottom of the well (~0.25m) was subtracted to reference pressure to the well bottom. from a nearby weather station to correct raw pressure readings for atmospheric pressure. b. Instrumentation: Method 1: Pressure Sensor Manufacturer: Schlumberger (Model: CTD-Diver, unvented) Parameter: Pressure (Accuracy: +/- 0.5cm H2O, Range: 0-10m H2O) Parameter: Temperature (Accuracy: +/- 0.10 ºC, Range: 0 to 50ºC) Parameter: Conductivity (Accuracy: +/- 1.0% of reading, Range: 0.01-120 mS/cm) Method 2: none Method 3: none Method 4: none Method 5: Barometric Pressure Sensor Manufacturer: Schlumberger (Model: Baro-Diver) Parameter: Pressure (Accuracy: +/- 0.5cm H2O, Range: 0-10m H2O) Parameter: Temperature (Accuracy: +/- 0.10 ºC, Range: 0 to 50ºC) c. Taxonomy and Systematics: Method 1: none Method 2: none Method 3: none Method 4: none Method 5: none d. Speclies List: e. Permit History: Method 1: none Method 2: none Method 3: none Method 4: none Method 5: none 4. Project Personnel a. Personnel: 1: Clark Alexander 2: Claudia Venherm 3: Kristen Anstead 4: Wade Sheldon b. Affiliations: 1: Skidaway Institute of Oceanography 2: Skidaway Institute of Oceanography 3: University of Georgia Marine Institute, Sapelo Island, Georgia 4: University of Georgia, Athens, Georgia III. Data Set Status and Accessibility A. Status 1. Latest Update: 24-Jun-2015 2. Latest Archive Date: 3. Latest Metadata Update: 24-Jun-2015 4. Data Verification Status: B. Accessibility 1. Storage Location and Medium: Stored at GCE-LTER Data Management Office Dept. of Marine Sciences Univ. of Georgia Athens, GA 30602-3636 USA on media: electronic data download (WWW) or compact disk 2. Contact Person: Name: Wade M. Sheldon, Jr. Position: GCE-LTER Information Manager Address: Dept. of Marine Sciences, University of Georgia, Athens, Georgia Postal Code: 30602-3636 Country: USA Email: gcelter@uga.edu 3. Copyright Restrictions: not copyrighted 4. Restrictions: All publications based on this data set must cite the contributor and Georgia Coastal Ecosystems LTER project, and two copies of the manuscript must be submitted to the GCE-LTER Information Management Office. a. Release Date: Affiliates: , Public: b. Citation: Data provided by the Georgia Coastal Ecosystems Long Term Ecological Research Project, supported by funds from NSF OCE 9982133 c. Disclaimer: The user assumes all responsibility for errors in judgement based on interpretation of data and analyses presented in this data set. 5. Costs: free electronic data download via WWW, distribution on CD may be subject to nominal processing and handling fee IV. Data Structural Descriptors A. Data Set File 1. File Name: HYD-GCES-1401b_PC_i_29_Well_9_SC_may11-aug11_1_0.CSV 2. Size: 9762 records 3. File Format: ASCII text (comma-separated value format) 3a. Delimiters: single comma 4. Header Information: 5 lines of ASCII text 5. Alphanumeric Attributes: upper case 6. Quality Control Flag Codes: I = invalid value, Q = questionable value, X = excise record flag (data collected under unsuitable conditions), E = estimated value based on interpolation 7. Authentication Procedures: not specified 8. Calculations: Pressure(Pa) = Pressure(cm H2O) * 98.0665 Pressure_Corrected: Pressure_Corrected = Pressure - Pressure_Atm Depth: Depth = pressure2depth(Pressure_Corrected,Latitude,'Pa') Salinity: Salinity = spcond2salinity(Specific_Conductance) Water_Level: Water_Level = Sensor_Elevation + Depth_Corrected 9. Processing History: Software version: GCE Data Toolbox Version 3.9.3 (06-Apr-2015) Data structure version: GCE Data Structure 1.1 (29-Mar-2001) Original data files processed: SC_PCi29_Well9_K1778_20110513-20110629_filtered.CSV (4308 records) SC_HNi1_Pressure_F9560_20110627-20110809_filtered.CSV (8423 records) SC_HNi1_Pressure_F9560_20110809-20110824_filtered.CSV (9864 records) SC_HNi1_Pressure_F9560_20110824-20110922_filtered.CSV (2765 records) SC_HNi1_Pressure_F9560_20110922-20111018_filtered.CSV (5249 records) SC_HNi1_Pressure_F9560_20111018-20111115_filtered.CSV (7960 records) SC_HNi1_Pressure_F9560_20111115-20111209_filtered.CSV (10256 records) SC_HNi1_Pressure_F9560_20111209-20120106_filtered.CSV (12946 records) SC_HNi1_Pressure_F9560_20111209-20120106_filtered.CSV (12946 records) SC_HNi1_Pressure_F9560_20120106-20120207_filtered.CSV (16016 records) SC_HNi1_Pressure_20120207-20120402_filtered.CSV (5279 records) SC_HNi1_Pressure_F9560_20120207-20120502_filtered.CSV (8150 records) SC_HNi1_Pressure_F9560_20120502-20120530_filtered.CSV (10841 records) SC_HNi1_Pressure_F9560_20120530-20120628_filtered.CSV (13624 records) SC_HNi1_Pressure_F9560_20120628-20120726_filtered.CSV (16308 records) SC_PCi29_Pressure_F9155_20111207-20120105_filtered.CSV (12762 records) SC_PCi29_Pressure_F9155_20120105-20120206_filtered.CSV (15816 records) SC_PCi29_Pressure_F9155_201120524-20120621_filtered.CSV (13055 records) SC_PCi29_Pressure_F9155_20120621-20120724_filtered.CSV (16218 records) SC_PCi29_Pressure_F9155_20110627-20110808_filtered.CSV (8327 records) SC_PCi29_Pressure_F9155_20110808-20110825_filtered.CSV (9978 records) SC_PCi29_Pressure_F9155_20110825-20110923_filtered.CSV (2762 records) SC_PCi29_Pressure_F9155_20110923-20111019_filtered.CSV (5258 records) SC_PCi29_Pressure_F9155_20111019-20111116_filtered.CSV (7948 records) SC_PCi29_Pressure_F9155_20111116-20111207_filtered.CSV (9975 records) SC_PCi29_Pressure_F9155_20111207-20120105_filtered.CSV (12762 records) SC_PCi29_Pressure_F9155_20111207-20120105_filtered.CSV (12762 records) SC_PCi29_Pressure_F9155_20120105-20120206_filtered.CSV (15816 records) SC_PCi29_Pressure_F9155_201120524-20120621_filtered.CSV (13055 records) SC_PCi29_Pressure_F9155_20120621-20120724_filtered.CSV (16218 records) SC_PCi29_Well9_K1778_20110627-20110808_filtered.CSV (8329 records) SC_HNi1_Pressure_F9560_20110627-20110809_filtered.CSV (8423 records) SC_HNi1_Pressure_F9560_20110809-20110824_filtered.CSV (9864 records) SC_HNi1_Pressure_F9560_20110824-20110922_filtered.CSV (2765 records) SC_HNi1_Pressure_F9560_20110922-20111018_filtered.CSV (5249 records) SC_HNi1_Pressure_F9560_20111018-20111115_filtered.CSV (7960 records) SC_HNi1_Pressure_F9560_20111115-20111209_filtered.CSV (10256 records) SC_HNi1_Pressure_F9560_20111209-20120106_filtered.CSV (12946 records) SC_HNi1_Pressure_F9560_20111209-20120106_filtered.CSV (12946 records) SC_HNi1_Pressure_F9560_20120106-20120207_filtered.CSV (16016 records) SC_HNi1_Pressure_20120207-20120402_filtered.CSV (5279 records) SC_HNi1_Pressure_F9560_20120207-20120502_filtered.CSV (8150 records) SC_HNi1_Pressure_F9560_20120502-20120530_filtered.CSV (10841 records) SC_HNi1_Pressure_F9560_20120530-20120628_filtered.CSV (13624 records) SC_HNi1_Pressure_F9560_20120628-20120726_filtered.CSV (16308 records) SC_PCi29_Pressure_F9155_20111207-20120105_filtered.CSV (12762 records) SC_PCi29_Pressure_F9155_20120105-20120206_filtered.CSV (15816 records) SC_PCi29_Pressure_F9155_201120524-20120621_filtered.CSV (13055 records) SC_PCi29_Pressure_F9155_20120621-20120724_filtered.CSV (16218 records) SC_PCi29_Pressure_F9155_20110627-20110808_filtered.CSV (8327 records) SC_PCi29_Pressure_F9155_20110808-20110825_filtered.CSV (9978 records) SC_PCi29_Pressure_F9155_20110825-20110923_filtered.CSV (2762 records) SC_PCi29_Pressure_F9155_20110923-20111019_filtered.CSV (5258 records) SC_PCi29_Pressure_F9155_20111019-20111116_filtered.CSV (7948 records) SC_PCi29_Pressure_F9155_20111116-20111207_filtered.CSV (9975 records) SC_PCi29_Pressure_F9155_20111207-20120105_filtered.CSV (12762 records) SC_PCi29_Pressure_F9155_20111207-20120105_filtered.CSV (12762 records) SC_PCi29_Pressure_F9155_20120105-20120206_filtered.CSV (15816 records) SC_PCi29_Pressure_F9155_201120524-20120621_filtered.CSV (13055 records) SC_PCi29_Pressure_F9155_20120621-20120724_filtered.CSV (16218 records) SC_PCi29_Well9_K1778_20110808-20110823_filtered.CSV (9765 records) SC_HNi1_Pressure_F9560_20110627-20110809_filtered.CSV (8423 records) SC_HNi1_Pressure_F9560_20110809-20110824_filtered.CSV (9864 records) SC_HNi1_Pressure_F9560_20110824-20110922_filtered.CSV (2765 records) SC_HNi1_Pressure_F9560_20110922-20111018_filtered.CSV (5249 records) SC_HNi1_Pressure_F9560_20111018-20111115_filtered.CSV (7960 records) SC_HNi1_Pressure_F9560_20111115-20111209_filtered.CSV (10256 records) SC_HNi1_Pressure_F9560_20111209-20120106_filtered.CSV (12946 records) SC_HNi1_Pressure_F9560_20111209-20120106_filtered.CSV (12946 records) SC_HNi1_Pressure_F9560_20120106-20120207_filtered.CSV (16016 records) SC_HNi1_Pressure_20120207-20120402_filtered.CSV (5279 records) SC_HNi1_Pressure_F9560_20120207-20120502_filtered.CSV (8150 records) SC_HNi1_Pressure_F9560_20120502-20120530_filtered.CSV (10841 records) SC_HNi1_Pressure_F9560_20120530-20120628_filtered.CSV (13624 records) SC_HNi1_Pressure_F9560_20120628-20120726_filtered.CSV (16308 records) SC_PCi29_Pressure_F9155_20111207-20120105_filtered.CSV (12762 records) SC_PCi29_Pressure_F9155_20120105-20120206_filtered.CSV (15816 records) SC_PCi29_Pressure_F9155_201120524-20120621_filtered.CSV (13055 records) SC_PCi29_Pressure_F9155_20120621-20120724_filtered.CSV (16218 records) SC_PCi29_Pressure_F9155_20110627-20110808_filtered.CSV (8327 records) SC_PCi29_Pressure_F9155_20110808-20110825_filtered.CSV (9978 records) SC_PCi29_Pressure_F9155_20110825-20110923_filtered.CSV (2762 records) SC_PCi29_Pressure_F9155_20110923-20111019_filtered.CSV (5258 records) SC_PCi29_Pressure_F9155_20111019-20111116_filtered.CSV (7948 records) SC_PCi29_Pressure_F9155_20111116-20111207_filtered.CSV (9975 records) SC_PCi29_Pressure_F9155_20111207-20120105_filtered.CSV (12762 records) SC_PCi29_Pressure_F9155_20111207-20120105_filtered.CSV (12762 records) SC_PCi29_Pressure_F9155_20120105-20120206_filtered.CSV (15816 records) SC_PCi29_Pressure_F9155_201120524-20120621_filtered.CSV (13055 records) SC_PCi29_Pressure_F9155_20120621-20120724_filtered.CSV (16218 records) Data processing history: 18-Aug-2012: new GCE Data Structure 1.1 created ('newstruct') 18-Aug-2012: 4308 rows imported from ASCII data file 'SC_PCi29_Well9_K1778_20110513-20110629_filtered.CSV' ('imp_ascii') 18-Aug-2012: data descriptor metadata updated based on the template 'GCE_CTD_Diver' ('meta_template') 18-Aug-2012: data structure validated ('gce_valid') 18-Aug-2012: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 18-Aug-2012: automatically assigned study date metadata descriptors based on the range of date values in date/time columns (add_studydates) 18-Aug-2012: updated 2 metadata fields in the Status, Supplement sections ('imp_schlumberger_sonde') 18-Aug-2012: updated 2 metadata fields in the Dataset, Status sections ('addmeta') 18-Aug-2012: updated 2 metadata fields in the Dataset, Status sections ('addmeta') 18-Aug-2012: calculated calendar date in MATLAB serial day (base 1/1/0000) format from individual date component columns Year, Month, Day, Hour, Minute and Second, added 'Date' column at position 1 ('add_datecol') 18-Aug-2012: added column 'Sensor_Elevation' at position 8 ('addcol') 18-Aug-2012: Q/C flagging criteria applied for column(s) Sensor_Elevation, 'flags' field updated ('dataflag') 18-Aug-2012: added column 'Sensor' at position 8 ('addcol') 18-Aug-2012: added column 'Latitude' at position 8 ('addcol') 18-Aug-2012: Q/C flagging criteria applied for column(s) Latitude, 'flags' field updated ('dataflag') 18-Aug-2012: added column 'Longitude' at position 8 ('addcol') 18-Aug-2012: Q/C flagging criteria applied for column(s) Longitude, 'flags' field updated ('dataflag') 18-Aug-2012: added column 'Location' at position 8 ('addcol') 18-Aug-2012: added column 'Hammock' at position 8 ('addcol') 18-Aug-2012: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 18-Aug-2012: added geographic metadata based on matching values in column Location to location and station names registered in 'geo_locations.mat' ('add_sitemetadata') 18-Aug-2012: updated 9 metadata fields in the Site, Status sections ('add_sitemetadata') 18-Aug-2012: updated title ('newtitle') 18-Aug-2012: updated 2 metadata fields in the Dataset, Status sections ('newtitle') 18-Aug-2012: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 18-Aug-2012: added geographic metadata based on matching values in column Location to location and station names registered in 'geo_locations.mat' ('add_sitemetadata') 18-Aug-2012: updated 9 metadata fields in the Site, Status sections ('add_sitemetadata') 18-Aug-2012: converted units of 'Pressure' column and 2 QA/QC flag criteria parameters from cm H2O to Pa ('unit_convert') 18-Aug-2012: Q/C flagging criteria applied for column(s) Pressure, 'flags' field updated ('dataflag') 18-Aug-2012: performed a left join of columns Year, Month, Day, Hour and Minute on columns Year, Month, Day, Hour and Minute from a second structure, returning column(s) Date, Second, Hammock, Location, Longitude, Latitude, Sensor, Sensor_Elevation, Pressure, Temp_Water and Specific_Conductance from the first structure and column(s) Pressure_Atm from the second structure (4308 rows) ('joindata') 18-Aug-2012: updated title ('newtitle') 18-Aug-2012: updated 2 metadata fields in the Dataset, Status sections ('newtitle') 18-Aug-2012: copied/reordered columns Date, Year, Month, Day, Hour, Minute, Second, Hammock, Location, Longitude, Latitude, Sensor, Sensor_Elevation, Pressure, Pressure_Atm, Temp_Water and Specific_Conductance ('copycols') 18-Aug-2012: calculated column Pressure_Corrected generated by the expression 'Pressure - Pressure_Atm' (add_calcexpr) 18-Aug-2012: updated 2 metadata fields in the Data, Status sections ('addmeta') 18-Aug-2012: added column 'Depth_Corrected' at position 16 ('addcol') 18-Aug-2012: Q/C flagging criteria applied for column(s) Depth_Corrected, 'flags' field updated ('dataflag') 18-Aug-2012: calculated column Depth generated by the expression 'pressure2depth(Pressure_Corrected,Latitude,'Pa')' (add_calcexpr) 18-Aug-2012: updated 2 metadata fields in the Data, Status sections ('addmeta') 18-Aug-2012: calculated column Salinity generated by the expression 'spcond2salinity(Specific_Conductance)' (add_calcexpr) 18-Aug-2012: updated 2 metadata fields in the Data, Status sections ('addmeta') 18-Aug-2012: added column 'Density' at position 22 ('addcol') 18-Aug-2012: Q/C flagging criteria applied for column(s) Density, 'flags' field updated ('dataflag') 18-Aug-2012: calculated column Water_Level generated by the expression 'Sensor_Elevation + Depth_Corrected' (add_calcexpr) 18-Aug-2012: updated 2 metadata fields in the Data, Status sections ('addmeta') 19-Aug-2012: 4021 rows added at the bottom of the data set ('datamerge') 19-Aug-2012: updated 56 metadata fields in the Data, Dataset, Project, Site, Status, Study, Supplement sections ('addmeta') 19-Aug-2012: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 19-Aug-2012: 1437 rows added at the bottom of the data set ('datamerge') 19-Aug-2012: updated 56 metadata fields in the Data, Dataset, Project, Site, Status, Study, Supplement sections ('addmeta') 19-Aug-2012: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 19-Aug-2012: updated title ('newtitle') 19-Aug-2012: updated 2 metadata fields in the Dataset, Status sections ('newtitle') 19-Aug-2012: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 19-Aug-2012: manually edited data set metadata ('ui_editmetadata') 19-Aug-2012: edited data set title in structure and metadata ('ui_editor') 19-Aug-2012: edited structure data ('ui_datagrid'): deleted record(s) 9764, 9765 and 9766 19-Aug-2012: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 19-Aug-2012: QA/QC flags assigned by visual inspection (ui_visualqc); flags set on Temp_Water record(s): 4308, 4309, 4310, 4311, 4312, 4313, 8328, 8331, 8332, 8333, 8334 and 8335; flags set on Salinity record(s): 4308, 8329 and 8330 19-Aug-2012: deleted the following rows with values in any column assigned QA/QC flag(s) X (excise record flag (data collected under unsuitable conditions)): 4308, 4309, 4310, 4311, 4312, 4313, 8328, 8329, 8330, 8331, 8332, 8333, 8334 and 8335. ('cullflags') 19-Aug-2012: inserted 13 new records with date/time values and NaN/null data values (replicating common values in the non-data columns Hammock, Location, Longitude, Latitude and Sensor) to fill in date/time interval gaps in the data series ('fill_date_gaps') 19-Aug-2012: sorted by column Date(ascending) ('sortdata') 19-Aug-2012: deleted existing datetime columns Year, Month, Day, Hour, Minute and Second; updated Year, Month, Day, Hour, Minute and Second datetime columns added after column Date ('add_datepartcols') 19-Aug-2012: updated 2 metadata fields in the Data, Status sections ('ui_interp_missing') 19-Aug-2012: sorted by column Date(ascending) ('sortdata') 19-Aug-2012: replaced 13 missing values in column Sensor_Elevation with estimated values based on 1D interpolation of Sensor_Elevation as a function of Date using the MATLAB 7.13 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 10 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 19-Aug-2012: 13 values in 'Sensor_Elevation' were updated with new values ('update_data'): changed record 4308 from NaN to -0.7130, changed record 4309 from NaN to -0.7130, changed record 4310 from NaN to -0.7130, changed record 4311 from NaN to -0.7130, changed record 4312 from NaN to -0.7130, changed record 4313 from NaN to -0.7130, changed record 8328 from NaN to -0.7130, changed record 8329 from NaN to -0.7130, changed record 8330 from NaN to -0.7130, changed record 8331 from NaN to -0.7130, changed record 8332 from NaN to -0.7130, changed record 8333 from NaN to -0.7130, changed record 8334 from NaN to -0.7130 19-Aug-2012: Q/C flagging criteria applied for column(s) Sensor_Elevation, 'flags' field updated ('dataflag') 19-Aug-2012: replaced 13 missing values in column Pressure with estimated values based on 1D interpolation of Pressure as a function of Date using the MATLAB 7.13 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 10 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 19-Aug-2012: 13 values in 'Pressure' were updated with new values ('update_data'): changed record 4308 from NaN to 107430.0, changed record 4309 from NaN to 107545.9, changed record 4310 from NaN to 107695.0, changed record 4311 from NaN to 107871.1, changed record 4312 from NaN to 108068.2, changed record 4313 from NaN to 108280.1, changed record 8328 from NaN to 110794.8, changed record 8329 from NaN to 110786.2, changed record 8330 from NaN to 110779.3, changed record 8331 from NaN to 110774.1, changed record 8332 from NaN to 110770.4, changed record 8333 from NaN to 110767.9, changed record 8334 from NaN to 110766.5 19-Aug-2012: Q/C flagging criteria applied for column(s) Pressure, 'flags' field updated ('dataflag') 19-Aug-2012: replaced 13 missing values in column Pressure_Corrected with estimated values based on 1D interpolation of Pressure_Corrected as a function of Date using the MATLAB 7.13 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 10 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 19-Aug-2012: 13 values in 'Pressure_Corrected' were updated with new values ('update_data'): changed record 4308 from NaN to 5769, changed record 4309 from NaN to 5888, changed record 4310 from NaN to 6053, changed record 4311 from NaN to 6252, changed record 4312 from NaN to 6474, changed record 4313 from NaN to 6708, changed record 8328 from NaN to 9807, changed record 8329 from NaN to 9808, changed record 8330 from NaN to 9810, changed record 8331 from NaN to 9814, changed record 8332 from NaN to 9819, changed record 8333 from NaN to 9826, changed record 8334 from NaN to 9835 19-Aug-2012: Q/C flagging criteria applied for column(s) Pressure_Corrected, 'flags' field updated ('dataflag') 19-Aug-2012: replaced 13 missing values in column Depth with estimated values based on 1D interpolation of Depth as a function of Date using the MATLAB 7.13 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 10 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 19-Aug-2012: 13 values in 'Depth' were updated with new values ('update_data'): changed record 4308 from NaN to 0.5729, changed record 4309 from NaN to 0.5847, changed record 4310 from NaN to 0.6011, changed record 4311 from NaN to 0.6208, changed record 4312 from NaN to 0.6429, changed record 4313 from NaN to 0.6662, changed record 8328 from NaN to 0.9739, changed record 8329 from NaN to 0.9740, changed record 8330 from NaN to 0.9742, changed record 8331 from NaN to 0.9746, changed record 8332 from NaN to 0.9751, changed record 8333 from NaN to 0.9758, changed record 8334 from NaN to 0.9766 19-Aug-2012: Q/C flagging criteria applied for column(s) Depth, 'flags' field updated ('dataflag') 19-Aug-2012: replaced 13 missing values in column Depth_Corrected with estimated values based on 1D interpolation of Depth_Corrected as a function of Date using the MATLAB 7.13 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 10 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 19-Aug-2012: 13 values in 'Depth_Corrected' were updated with new values ('update_data'): changed record 4308 from NaN to 0.573, changed record 4309 from NaN to 0.585, changed record 4310 from NaN to 0.601, changed record 4311 from NaN to 0.621, changed record 4312 from NaN to 0.643, changed record 4313 from NaN to 0.666, changed record 8328 from NaN to 0.974, changed record 8329 from NaN to 0.974, changed record 8330 from NaN to 0.974, changed record 8331 from NaN to 0.975, changed record 8332 from NaN to 0.975, changed record 8333 from NaN to 0.976, changed record 8334 from NaN to 0.977 19-Aug-2012: Q/C flagging criteria applied for column(s) Depth_Corrected, 'flags' field updated ('dataflag') 19-Aug-2012: replaced 13 missing values in column Water_Level with estimated values based on 1D interpolation of Water_Level as a function of Date using the MATLAB 7.13 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 10 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 19-Aug-2012: 13 values in 'Water_Level' were updated with new values ('update_data'): changed record 4308 from NaN to -0.1401, changed record 4309 from NaN to -0.1283, changed record 4310 from NaN to -0.1119, changed record 4311 from NaN to -0.0922, changed record 4312 from NaN to -0.0701, changed record 4313 from NaN to -0.0468, changed record 8328 from NaN to 0.2609, changed record 8329 from NaN to 0.2610, changed record 8330 from NaN to 0.2612, changed record 8331 from NaN to 0.2616, changed record 8332 from NaN to 0.2621, changed record 8333 from NaN to 0.2628, changed record 8334 from NaN to 0.2636 19-Aug-2012: Q/C flagging criteria applied for column(s) Water_Level, 'flags' field updated ('dataflag') 19-Aug-2012: replaced 13 missing values in column Pressure_Atm with estimated values based on 1D interpolation of Pressure_Atm as a function of Date using the MATLAB 7.13 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 10 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 19-Aug-2012: 13 values in 'Pressure_Atm' were updated with new values ('update_data'): changed record 4308 from NaN to 101641.0, changed record 4309 from NaN to 101628.4, changed record 4310 from NaN to 101611.2, changed record 4311 from NaN to 101592.4, changed record 4312 from NaN to 101575.2, changed record 4313 from NaN to 101562.6, changed record 8328 from NaN to 100996.9, changed record 8329 from NaN to 100991.8, changed record 8330 from NaN to 100983.9, changed record 8331 from NaN to 100973.8, changed record 8332 from NaN to 100961.8, changed record 8333 from NaN to 100948.6, changed record 8334 from NaN to 100934.6 19-Aug-2012: Q/C flagging criteria applied for column(s) Pressure_Atm, 'flags' field updated ('dataflag') 19-Aug-2012: replaced 13 missing values in column Temp_Water with estimated values based on 1D interpolation of Temp_Water as a function of Date using the MATLAB 7.13 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 10 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 19-Aug-2012: 13 values in 'Temp_Water' were updated with new values ('update_data'): changed record 4308 from NaN to 22.43, changed record 4309 from NaN to 22.41, changed record 4310 from NaN to 22.39, changed record 4311 from NaN to 22.37, changed record 4312 from NaN to 22.35, changed record 4313 from NaN to 22.33, changed record 8328 from NaN to 24.62, changed record 8329 from NaN to 24.61, changed record 8330 from NaN to 24.60, changed record 8331 from NaN to 24.59, changed record 8332 from NaN to 24.58, changed record 8333 from NaN to 24.56, changed record 8334 from NaN to 24.54 19-Aug-2012: Q/C flagging criteria applied for column(s) Temp_Water, 'flags' field updated ('dataflag') 19-Aug-2012: replaced 13 missing values in column Specific_Conductance with estimated values based on 1D interpolation of Specific_Conductance as a function of Date using the MATLAB 7.13 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 10 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 19-Aug-2012: 13 values in 'Specific_Conductance' were updated with new values ('update_data'): changed record 4308 from NaN to 45.52, changed record 4309 from NaN to 45.55, changed record 4310 from NaN to 45.59, changed record 4311 from NaN to 45.64, changed record 4312 from NaN to 45.69, changed record 4313 from NaN to 45.76, changed record 8328 from NaN to 48.98, changed record 8329 from NaN to 49.04, changed record 8330 from NaN to 49.12, changed record 8331 from NaN to 49.22, changed record 8332 from NaN to 49.33, changed record 8333 from NaN to 49.43, changed record 8334 from NaN to 49.52 19-Aug-2012: Q/C flagging criteria applied for column(s) Specific_Conductance, 'flags' field updated ('dataflag') 19-Aug-2012: replaced 13 missing values in column Salinity with estimated values based on 1D interpolation of Salinity as a function of Date using the MATLAB 7.13 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 10 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 19-Aug-2012: 13 values in 'Salinity' were updated with new values ('update_data'): changed record 4308 from NaN to 29.458, changed record 4309 from NaN to 29.481, changed record 4310 from NaN to 29.510, changed record 4311 from NaN to 29.544, changed record 4312 from NaN to 29.585, changed record 4313 from NaN to 29.633, changed record 8328 from NaN to 31.975, changed record 8329 from NaN to 32.017, changed record 8330 from NaN to 32.078, changed record 8331 from NaN to 32.151, changed record 8332 from NaN to 32.228, changed record 8333 from NaN to 32.303, changed record 8334 from NaN to 32.367 19-Aug-2012: Q/C flagging criteria applied for column(s) Salinity, 'flags' field updated ('dataflag') 19-Aug-2012: replaced 13 missing values in column Density with estimated values based on 1D interpolation of Density as a function of Date using the MATLAB 7.13 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 10 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 19-Aug-2012: 13 values in 'Density' were updated with new values ('update_data'): changed record 4308 from NaN to 1019.89589, changed record 4309 from NaN to 1019.92027, changed record 4310 from NaN to 1019.94727, changed record 4311 from NaN to 1019.97825, changed record 4312 from NaN to 1020.01454, changed record 4313 from NaN to 1020.05748, changed record 8328 from NaN to 1021.16636, changed record 8329 from NaN to 1021.19773, changed record 8330 from NaN to 1021.24419, changed record 8331 from NaN to 1021.30098, changed record 8332 from NaN to 1021.36334, changed record 8333 from NaN to 1021.42651, changed record 8334 from NaN to 1021.48572 19-Aug-2012: Q/C flagging criteria applied for column(s) Density, 'flags' field updated ('dataflag') 19-Aug-2012: documented flagged and missing values in columns Sensor_Elevation, Pressure, Pressure_Corrected, Depth, Depth_Corrected, Water_Level, Pressure_Atm, Temp_Water, Specific_Conductance, Salinity and Density as data set anomalies in the metadata ('add_anomalies') 24-Jun-2015: renamed column 'Sensor' to 'Sensor_ID' and propagated the change to any dependent Q/C flag criteria ('rename_column') 24-Jun-2015: added column 'Sensor_Model' at position 12 ('addcol') 24-Jun-2015: updated 1 metadata fields in the Dataset sections ('addmeta') 24-Jun-2015: converted dates in column(s) Date to format yyyy-mm-dd HH:MM:SS 24-Jun-2015: flags for columns Sensor_Elevation, Pressure, Pressure_Corrected, Depth, Depth_Corrected, Water_Level, Pressure_Atm, Temp_Water, Specific_Conductance, Salinity and Density converted to data columns, flag codes updated in metadata ('flags2cols') 24-Jun-2015: updated 6 metadata fields in the Data sections ('addmeta') 24-Jun-2015: updated 15 metadata fields in the Status, Data sections to reflect attribute metadata ('updatecols') 24-Jun-2015: parsed and formatted metadata ('listmeta') B. Variable Information 1. Variable Name: column 1. Date column 2. Year column 3. Month column 4. Day column 5. Hour column 6. Minute column 7. Second column 8. Hammock column 9. Location column 10. Longitude column 11. Latitude column 12. Sensor_Model column 13. Sensor_ID column 14. Sensor_Elevation column 15. Flag_Sensor_Elevation column 16. Pressure column 17. Flag_Pressure column 18. Pressure_Corrected column 19. Flag_Pressure_Corrected column 20. Depth column 21. Flag_Depth column 22. Depth_Corrected column 23. Flag_Depth_Corrected column 24. Water_Level column 25. Flag_Water_Level column 26. Pressure_Atm column 27. Flag_Pressure_Atm column 28. Temp_Water column 29. Flag_Temp_Water column 30. Specific_Conductance column 31. Flag_Specific_Conductance column 32. Salinity column 33. Flag_Salinity column 34. Density column 35. Flag_Density 2. Variable Definition: column 1. Calendar date and time of observation column 2. Calendar year column 3. Calendar month column 4. Calendar day column 5. Hours - GMT column 6. Minutes column 7. Seconds column 8. Hammock id where well is installed column 9. Location code of well in the GCE locations database column 10. Geographic longitude in decimal degrees column 11. Geographic latitude in decimal degrees column 12. Groundwater sensor model used for measurements column 13. Sensor ID (serial number) column 14. Absolute elevation of the sensor relative to NAVD88 datum, adjusted for PVC riser height and sensor deployment depth column 15. QA/QC flags for Absolute elevation of the sensor relative to NAVD88 datum, adjusted for PVC riser height and sensor deployment depth (flagging criteria, where "x" is Sensor_Elevation: flag_inlist(Location,"HN_i_1_WELL_LOC_0,HN_i_1_WELL_LOC_1,PC_i_29_WELL_LOC_0")="E", manual) column 16. Groundwater pressure column 17. QA/QC flags for Groundwater pressure (flagging criteria, where "x" is Pressure: x<0="I", x>196133="Q", manual) column 18. Groundwater well pressure corrected for atmospheric pressure using the equation: Pressure - Pressure_Atm column 19. QA/QC flags for Groundwater well pressure corrected for atmospheric pressure using the equation: Pressure - Pressure_Atm (flagging criteria, where "x" is Pressure_Corrected: x<0="I", x>196133="Q", manual) column 20. Water depth calculated from corrected water pressure and latitude using a UNESCO algorithm column 21. QA/QC flags for Water depth calculated from corrected water pressure and latitude using a UNESCO algorithm (flagging criteria, where "x" is Depth: manual) column 22. Water depth calculated from corrected well pressure and geographic latitude using UNESCO algorithms column 23. QA/QC flags for Water depth calculated from corrected well pressure and geographic latitude using UNESCO algorithms (flagging criteria, where "x" is Depth_Corrected: x<0="Q", manual) column 24. Water level relative to NAVD88 datum calculated from sensor elevation and corrected water depth above the sensor column 25. QA/QC flags for Water level relative to NAVD88 datum calculated from sensor elevation and corrected water depth above the sensor (flagging criteria, where "x" is Water_Level: manual) column 26. Atmospheric pressure column 27. QA/QC flags for Atmospheric pressure (flagging criteria, where "x" is Pressure_Atm: x<0="I", x>196133="Q", manual) column 28. Groundwater temperature column 29. QA/QC flags for Groundwater temperature (flagging criteria, where "x" is Temp_Water: x<0="I", x<10="Q", x>40="Q", x>100="I", manual) column 30. Groundwater conductivity column 31. QA/QC flags for Groundwater conductivity (flagging criteria, where "x" is Specific_Conductance: x<0="I", manual) column 32. Water salinity calculated from specific conductance column 33. QA/QC flags for Water salinity calculated from specific conductance (flagging criteria, where "x" is Salinity: manual) column 34. Groundwater density as a function of salinity, temperature and pressure, calculated from Sigma-t (i.e. specific gravity anomaly calculated using 'swstate' in the WHOI Oceans toolbox, based on UNESCO algorithms) as Density = Sigma-t + 1000 column 35. QA/QC flags for Groundwater density as a function of salinity, temperature and pressure, calculated from Sigma-t (i.e. specific gravity anomaly calculated using 'swstate' in the WHOI Oceans toolbox, based on UNESCO algorithms) as Density = Sigma-t + 1000 (flagging criteria, where "x" is Density: x<0="I", manual) 3. Units of Measurement: column 1. yyyy-mm-dd HH:MM:SS - GMT column 2. YYYY column 3. MM column 4. DD column 5. hr column 6. min column 7. sec column 8. none column 9. none column 10. degrees column 11. degrees column 12. none column 13. none column 14. m column 15. none column 16. Pa column 17. none column 18. Pa column 19. none column 20. m column 21. none column 22. m column 23. none column 24. m column 25. none column 26. Pa column 27. none column 28. °C column 29. none column 30. mS/cm column 31. none column 32. PSU column 33. none column 34. kg/m^3 column 35. none 4. Data Type a. Storage Type: column 1. string column 2. integer column 3. integer column 4. integer column 5. integer column 6. integer column 7. floating-point column 8. string column 9. string column 10. floating-point column 11. floating-point column 12. string column 13. string column 14. floating-point column 15. string column 16. floating-point column 17. string column 18. floating-point column 19. string column 20. floating-point column 21. string column 22. floating-point column 23. string column 24. floating-point column 25. string column 26. floating-point column 27. string column 28. floating-point column 29. string column 30. floating-point column 31. string column 32. floating-point column 33. string column 34. floating-point column 35. string b. Variable Codes: Flag_Sensor_Elevation: E = estimated value based on interpolation Flag_Pressure: E = estimated value based on interpolation Flag_Pressure_Corrected: E = estimated value based on interpolation Flag_Depth: E = estimated value based on interpolation Flag_Depth_Corrected: E = estimated value based on interpolation Flag_Water_Level: E = estimated value based on interpolation Flag_Pressure_Atm: E = estimated value based on interpolation Flag_Temp_Water: E = estimated value based on interpolation Flag_Specific_Conductance: E = estimated value based on interpolation Flag_Salinity: E = estimated value based on interpolation Flag_Density: E = estimated value based on interpolation c. Numeric Range: column 1. (none) column 2. 2011 to 2011 column 3. 5 to 8 column 4. 1 to 31 column 5. 0 to 23 column 6. 0 to 45 column 7. 0 to 0 column 8. (none) column 9. (none) column 10. -81.2787 to -81.2787 column 11. 31.394 to 31.394 column 12. (none) column 13. (none) column 14. -0.713 to -0.713 column 15. (none) column 16. 105872.5934 to 119778.4231 column 17. (none) column 18. 4383.5725 to 18622.8284 column 19. (none) column 20. 0.43532 to 1.8494 column 21. (none) column 22. 0.43532 to 1.8494 column 23. (none) column 24. -0.27768 to 1.1364 column 25. (none) column 26. 100302.4162 to 102283.3595 column 27. (none) column 28. 19.15 to 25.17 column 29. (none) column 30. 43.99 to 50.42 column 31. (none) column 32. 28.3566 to 33.0303 column 33. (none) column 34. 1019.5543 to 1023.4552 column 35. (none) d. Missing Value Code: 5. Data Format a. Column Type: column 1. text column 2. numerical column 3. numerical column 4. numerical column 5. numerical column 6. numerical column 7. numerical column 8. text column 9. text column 10. numerical column 11. numerical column 12. text column 13. text column 14. numerical column 15. text column 16. numerical column 17. text column 18. numerical column 19. text column 20. numerical column 21. text column 22. numerical column 23. text column 24. numerical column 25. text column 26. numerical column 27. text column 28. numerical column 29. text column 30. numerical column 31. text column 32. numerical column 33. text column 34. numerical column 35. text b. Number of Columns: 35 c. Decimal Places: column 1. 0 column 2. 0 column 3. 0 column 4. 0 column 5. 0 column 6. 0 column 7. 2 column 8. 0 column 9. 0 column 10. 8 column 11. 8 column 12. 0 column 13. 0 column 14. 4 column 15. 0 column 16. 1 column 17. 0 column 18. 0 column 19. 0 column 20. 4 column 21. 0 column 22. 3 column 23. 0 column 24. 4 column 25. 0 column 26. 1 column 27. 0 column 28. 2 column 29. 0 column 30. 2 column 31. 0 column 32. 3 column 33. 0 column 34. 5 column 35. 0 6. Logical Variable Type: column 1. datetime (none) column 2. datetime (discrete) column 3. datetime (discrete) column 4. datetime (discrete) column 5. datetime (discrete) column 6. datetime (discrete) column 7. datetime (continuous) column 8. nominal (none) column 9. nominal (none) column 10. geographic coordinate (continuous) column 11. geographic coordinate (continuous) column 12. nominal (none) column 13. nominal (none) column 14. calculation (continuous) column 15. coded value (none) column 16. data (continuous) column 17. coded value (none) column 18. calculation (continuous) column 19. coded value (none) column 20. calculation (continuous) column 21. coded value (none) column 22. calculation (continuous) column 23. coded value (none) column 24. calculation (continuous) column 25. coded value (none) column 26. data (continuous) column 27. coded value (none) column 28. data (continuous) column 29. coded value (none) column 30. data (continuous) column 31. coded value (none) column 32. calculation (continuous) column 33. coded value (none) column 34. calculation (continuous) column 35. coded value (none) 7. Flagging Criteria: column 1. none column 2. none column 3. x<1="I";x>12="I" column 4. x<1="I";x>31="I" column 5. x<0="I";x>24="I" column 6. x<0="I";x>60="I" column 7. x<0="I";x>60="I" column 8. none column 9. none column 10. x<-180="I";x>180="I" column 11. x<-90="I";x>90="I" column 12. none column 13. none column 14. flag_inlist(col_Location,"HN_i_1_WELL_LOC_0,HN_i_1_WELL_LOC_1,PC_i_29_WELL_LOC_0")="E";m anually-assigned flags column 15. none column 16. x<0="I";x>196133="Q";manually-assigned flags column 17. none column 18. x<0="I";x>196133="Q";manually-assigned flags column 19. none column 20. manually-assigned flags column 21. none column 22. x<0="Q";manually-assigned flags column 23. none column 24. manually-assigned flags column 25. none column 26. x<0="I";x>196133="Q";manually-assigned flags column 27. none column 28. x<0="I";x<10="Q";x>40="Q";x>100="I";manually-assigned flags column 29. none column 30. x<0="I";manually-assigned flags column 31. none column 32. manually-assigned flags column 33. none column 34. x<0="I";manually-assigned flags column 35. none C. Data Anomalies: Values of 13 records in Sensor_Elevation were flagged as E (estimated value based on interpolation) for dates: 06/27/2011, 08/08/2011. Values of 13 records in Pressure were flagged as E (estimated value based on interpolation) for dates: 06/27/2011, 08/08/2011. Values of 13 records in Pressure_Corrected were flagged as E (estimated value based on interpolation) for dates: 06/27/2011, 08/08/2011. Values of 13 records in Depth were flagged as E (estimated value based on interpolation) for dates: 06/27/2011, 08/08/2011. Values of 13 records in Depth_Corrected were flagged as E (estimated value based on interpolation) for dates: 06/27/2011, 08/08/2011. Values of 13 records in Water_Level were flagged as E (estimated value based on interpolation) for dates: 06/27/2011, 08/08/2011. Values of 13 records in Pressure_Atm were flagged as E (estimated value based on interpolation) for dates: 06/27/2011, 08/08/2011. Values of 13 records in Temp_Water were flagged as E (estimated value based on interpolation) for dates: 06/27/2011, 08/08/2011. Values of 13 records in Specific_Conductance were flagged as E (estimated value based on interpolation) for dates: 06/27/2011, 08/08/2011. Values of 13 records in Salinity were flagged as E (estimated value based on interpolation) for dates: 06/27/2011, 08/08/2011. Values of 13 records in Density were flagged as E (estimated value based on interpolation) for dates: 06/27/2011, 08/08/2011. V. Supplemental Descriptors A. Data Acquisition 1. Data Forms: Digital copies of data logger files are maintained in the GCE-LTER Information Management office and UGA Marine Institute on Sapelo Island. 2. Form Location: GCE-LTER Information Management Office, Dept. of Marine Sciences, University of Georgia, Athens, GA 30602 3. Data Entry Validation: B. Quality Assurance/Quality Control Procedures: QA/QC flags are generated automatically according to domain criteria specified for each data column, then subsequently reviewed and revised as appropriate. Coded flag columns are generated for each data column, listing qualifier flags assigned to the data value on the corresponding row. C. Supplemental Materials: not applicable D. Computer Programs: MATLAB R2009B E. Archival Practices: Data sets and documentation are stored in structured binary (Matlab 6.x files) and delimited ASCII text formats, and archived on magnetic tape and CD at the GCE LTER Information Management Office at the University of Georgia, Athens, Georgia, USA F. Publications: G. History of Data Set Usage 1. Data Request History: 2. Data Set Update History: not updated 3. Review History: none 4. Questions and Comments from Users: Data file for DataLogger. COMPANY: COMP.STATUS: Do DATE: 29/06/2011 TIME: 14:04:15 FILENAME: C:\Documents and Settings\kanstead\Desktop\June2011 Loggers\CSV\pci29_well9_k1778_110629140414_K1778.CSV CREATED BY: SWS Diver-Office 4.0.76.0 [Logger settings] Instrument type = CTD-Diver= 17 Status = Started = 0 Serial number = ..01-K1778 317. Instrument number = = 0 Location = pci29_well9_k1778 Sample period = M15 Sample method = T Number of channels = 3 [Channel 1] Identification = PRESSURE Reference level = 400.0 cm Range = 1750.0 cm Master level = 1750 CMH2O Altitude = 0 m [Channel 2] Identification = TEMPERATURE Reference level = -20.00 °C Range = 100.00 °C [Channel 3] Identification = 2: SPEC.COND. Reference level = 0.00 mS/cm Range = 120.00 mS/cm [Series settings] Serial number = ..01-K1778 317. Instrument number = Location = pci29_well9_k1778 Sample period = 00 00:15:00 0 Sample method = T Start date / time = 00:00:21 13/05/11 End date / time = 00:15:18 27/06/11 [Channel 1 from data header] Identification = PRESSURE Reference level = 400.0 cm Range = 1750.0 cm Master level = 1750 CMH2O Altitude = 0 m [Channel 2 from data header] Identification = TEMPERATURE Reference level = -20.00 °C Range = 100.00 °C [Channel 3 from data header] Identification = 2: SPEC.COND. Reference level = 0.00 mS/cm Range = 120.00 mS/cm