4.1+Field+Results+-+Raw+Data

This page contains raw data collected by the class and provided by the utility.

FIELD DATA TEMPLATES
Water Resources field data (Craig Erdman Oct 23)

FILES PROVIDED BY THE UTILITY
Daily flows for pump station 2010-2011 AutoCADD pump station intake drawings will not be posted. Please see Dr. Whelton. GIS files will not be posted. Please see Dr. Whelton.

[|Field Excursion Photos]

GIS Shapefiles
The following link is to the GIS shapefiles that have been clipped to the Hamilton Creek Inlet Watershed. If you have any questions about the files let me know. [|CE590: Shapefiles]



Topographic maps are on file with Mr. Allen. USGS real-time flow data for gaged tributaries: []

**FIELD ACTIVITY 4 (FINAL FIELD VISIT): October 31, 2011**
WR and ENV teams conducted field activities.

** ENVIRONMENTAL TEAM (Lucas, Erdman, Allen **** ) **
1) Discrete water sampling results, GPS information, and sampling date weather/condition observations.

[|Environmental Discrete Sampling Data] If you need to add anything to the file just send me a copy of the updated file and I will repost with an updated link.

2) Discrete TOC water sampling results. To be added. [Results will not be available until Nov 11 at the earliest due to sample scheduling]

3) Vertical water quality profiling Seabird CTD results [|Sea Bird Raw Data Zip File]

[|10_31_11 SBE-25 Data Compiled and Bin Averaged] This is an excel file I made that bin averages the seabird data. I think this might be helpful for when we are correlating this data to other field sampling days or other descrete sample data we have. The intervals of the bins can be changed. There is a cell at the top of the "bin average results" table in each sheet where you can change the interval and the starting point.

WATER RESOURCES TEAM (Marr, Dulaney, Thomley)
1) Discrete Water Sampling Results

(Compiled by Bennett Dulaney, uploaded by Chris Marr)


 * Note: These measurements were not put in to the WR field note template because there is believed to be an error in the flow calculation cell! This could possibly be the root of why our flow data does not really match USGS results. (Chris Marr, Nov. 7)

2) Vertical profiling YSI CastAway CTD data (Jag Ski) Note that these data do not necessarily need to be used given the capabilities and data acquired using the SeaBird profiler. However, three vertical profiles were obtained along each ADCP transect using the CastAway CTD. Therefore, this data could be considered when determining the spatial variability of heat (temperature) and mass (conductive ions) within the study area. Two files are provided: raw and csv. The raw data can be opened and processed using the YSI CastAway CTD software (see Page 4, Section 2.0). The CSV data have been processed and can be opened in most spreadsheet-type software like MS Excel.

Here is a link to download the CastAway CTD data in CSV format: [|castaway_ctd_csv-Oct312011.zip]

Here is a link to download the CastAway CTD data in raw format: [|castaway_ctd_raw-Oct312011.zip]

3) ADCP Data (Jag Ski) The raw ADCP data files from this survey are combined in the zip file linked below. These files must be opened, processed, then exported (if desired) using RiverSurveyorLive v3.0 (see Page 4, Section 2.0). Each ADCP transect is performed twice. The first pass at each transect will always be south to north. The second pass at each transect will always be north to south. The CTD casts are made on a third pass without collecting ADCP data. Right and left bank are defined as viewed by an observer looking in the direction of flow (downstream). Therefore, positive values of discharge indicate a net eastward flux, whereas a negative value of discharge indicates westward flux. Please see additional notes in the MS Excel file linked below.

Here is a link to download the ADCP files: [|adcp-Oct312011.zip]

Here is a link to download the ADCP notes (created Nov032011): [|ADCP_notes_FASTCE_Oct312011.xlsx]

4) Near-surface water quality data (Jag Ski) Processed near-surface water quality data from the Portable SeaKeeper is provided below as a text file. Headers are provided and define the variable name and unit for each column. A few notes are provided below regarding these variables and units. So you know, these processed data are derived from the truly "raw" data files containing GPS, YSI 6600v2, and Turner C3 data. Position data (GPS) are saved to the raw file once per minute. The Turner data are saved to the raw file two times per minute. The YSI data are saved to the raw file five times per minute. The Turner and GPS data are interpolated to the YSI times so that all data is in a common time. Interpolation is performed using a three-point inverse distance weighting function.

For the purposes of this class, please disregard the fuel, oil, depth, voltage, and salinity measurements. Calibration of CDOM to known standards for comparison with TOC measurements will be performed in the coming weeks.

Here is a link to download the PSK data: [|PSK-Oct312011.txt]

PROJECT NAME: FASTCE - Big Creek Lake SURVEY DATE:: 10/31/11 TIME OUT::::: 13:27:30 TIME IN:::::: 16:08:00 MAX SPEED:::: 28.0 KNOTS

**FIELD ACTIVITY 3: October 24, 2011**
WR and ENV teams conducted field activities.


 * All individual files originally in this section have been moved to the zip folder below**

** ENVIRONMENTAL TEAM (Erdman, Marr, Thomley **** ) **
1) Discrete water sampling results, GPS information, and sampling date weather/condition observations.

2) Discrete TOC water sampling results.
 * Files moved to zip folder**

Notes from the laboratory analyst: "In the first group there were 3 vials that had white tape on them and were full but no IDs. I called labeled them tape A, tape B and tape C. Also there were three vials that were empty. "
 * Files moved to zip folder**

3) Discrete water sampling TN and TP results

4) Vertical water quality profiling Seabird CTD results (4 files posted, note ENV team did two CTD drops at each location)
 * Files moved to zip folder**


 * Files moved to zip folder**

WATER RESOURCES TEAM (Dulaney, Lucas, Allen)
1) Discrete Water Sampling Results Discrete water sampling results and stream gauging results

2) Vertical profiling YSI CastAway CTD data (Jag Ski) Note that these data do not necessarily need to be used given the capabilities and data acquired using the SeaBird profiler. However, three vertical profiles were obtained along each ADCP transect using the CastAway CTD. Therefore, this data could be considered when determining the spatial variability of heat (temperature) and mass (conductive ions) within the study area. Two files are provided: raw and csv. The raw data can be opened and processed using the YSI CastAway CTD software (see Page 4, Section 2.0). The CSV data have been processed and can be opened in most spreadsheet-type software like MS Excel.
 * Files moved to zip folder**


 * Files moved to zip folder**

3) ADCP data (Jag Ski) The raw ADCP data files from this survey are combined in the zip file linked below. These files must be opened, processed, then exported (if desired) using RiverSurveyorLive v3.0 (see Page 4, Section 2.0). Each ADCP transect is performed twice. The first pass at each transect will always be south to north. The second pass at each transect will always be north to south. The CTD casts are made on a third pass without collecting ADCP data. Right and left bank are defined as viewed by an observer looking in the direction of flow (downstream). Therefore, positive values of discharge indicate a net eastward flux, whereas a negative value of discharge indicates westward flux. After processing, it is clear that the net flux at each transect is to the west. Please see additional notes in the MS Excel file linked below.

Note: The following metadata file revised 11/03/2011. This will supersede any previous file having the same name.
 * Files moved to zip folder**


 * Files moved to zip folder**

4) Near-surface water quality data (Jag Ski) Processed near-surface water quality data from the Portable SeaKeeper is provided below as a text file. Headers are provided and define the variable name and unit for each column. A few notes are provided below regarding these variables and units. So you know, these processed data are derived from the truly "raw" data files containing GPS, YSI 6600v2, and Turner C3 data. Position data (GPS) are saved to the raw file once per minute. The Turner data are saved to the raw file two times per minute. The YSI data are saved to the raw file five times per minute. The Turner and GPS data are interpolated to the YSI times so that all data is in a common time. Interpolation is performed using a three-point inverse distance weighting function.

For the purposes of this class, please disregard the fuel, oil, depth, voltage, and salinity measurements. Calibration of CDOM to known standards for comparison with TOC measurements will be performed in the coming weeks.
 * Files moved to zip folder**

PROJECT NAME: FASTCE - Big Creek Lake SURVEY DATE:: 10/24/11 TIME OUT::::: 14:20:30 TIME IN:::::: 16:40:00 MAX SPEED:::: 43.0 KNOTS

**FIELD ACTIVITY 2: October 17, 2011**
Both the environmental and water resources teams conducted field activities.


 * All individual files originally in this section have been moved to the zip folder below**

** ENVIRONMENTAL TEAM (Marr, Thomley, **** Dulaney) **
1) Discrete water sampling results, GPS information, and sampling date weather/condition observations. This file only contains water quality information from the Environmental team. This file however is missing a few results from Environmental Team. Chris Marr should update the file with his recorded data.

2) Discrete water sampling TOC results 3) Discrete water sampling TN and TP results 4) Vertical water quality profiling Seabird CTD results "Here are the four casts from yesterday. Make sure your students soak the CTD for a full minute just below the surface before you lower the CTD."
 * Files moved to zip folder**
 * Files moved to zip folder**
 * Files moved to zip folder**
 * Files moved to zip folder**

WATER RESOURCES TEAM (Lucas, Allen, Erdman)
1) Discrete Water Sampling Results Discrete water sampling results and stream gauging results

2) Vertical profiling YSI CastAway CTD data (Jag Ski) Note that these data do not necessarily need to be used given the capabilities and data acquired using the SeaBird profiler. However, three vertical profiles were obtained along each ADCP transect using the CastAway CTD. Therefore, this data could be considered when determining the spatial variability of heat (temperature) and mass (conductive ions) within the study area. Two files are provided: raw and csv. The raw data can be opened and processed using the YSI CastAway CTD software (see Page 4, Section 2.0). The CSV data have been processed and can be opened in most spreadsheet-type software like MS Excel.
 * Files moved to zip folder**

3) ADCP data (Jag Ski) The raw ADCP data files from this survey are combined in the zip file linked below. These files must be opened, processed, then exported (if desired) using RiverSurveyorLive v3.0 (see Page 4, Section 2.0). Each ADCP transect is performed twice. The first pass at each transect will always be south to north. The second pass at each transect will always be north to south. The CTD casts are made on a third pass without collecting ADCP data. Right and left bank are defined as viewed by an observer looking in the direction of flow (downstream). Therefore, positive values of discharge indicate a net eastward flux, whereas a negative value of discharge indicates westward flux. After processing, it is clear that the net flux at each transect is to the west. Please see additional notes in the MS Excel file linked below.
 * Files moved to zip folder**

Note: The following metadata file updated/uploaded 10/18/2011. This will supersede any previous file having the same name.
 * Files moved to zip folder**

4) Near-surface water quality data (Jag Ski) Processed near-surface water quality data from the Portable SeaKeeper is provided below as a text file. Headers are provided and define the variable name and unit for each column. A few notes are provided below regarding these variables and units. So you know, these processed data are derived from the truly "raw" data files containing GPS, YSI 6600v2, and Turner C3 data. Position data (GPS) are saved to the raw file once per minute. The Turner data are saved to the raw file two times per minute. The YSI data are saved to the raw file five times per minute. The Turner and GPS data are interpolated to the YSI times so that all data is in a common time. Interpolation is performed using a three-point inverse distance weighting function.
 * Files moved to zip folder**

For the purposes of this class, please disregard the fuel, oil, depth, voltage, and salinity measurements. Calibration of CDOM to known standards for comparison with TOC measurements will be performed in the coming weeks.

PROJECT NAME: FASTCE - Big Creek Lake SURVEY DATE:: 10/17/11 TIME OUT::::: 14:20:30 TIME IN:::::: 16:22:00 MAX SPEED:::: 31.0 KNOTS
 * Files moved to zip folder**

**FIELD ACTIVITY 1: October 10, 2011**
Both the environmental and water resources teams conducted field activities.


 * All individual files originally in this section have been moved to the zip folder below**

** ENVIRONMENTAL ( **** Thomley, **** Dulaney, **** Lucas) **
1) Discrete water sampling results, GPS information, and sampling date weather/condition observations. This file contains water quality information from both the Environmental team and also now includes data from the Water Resources team. This file however is missing a few results (1) GPS locations of Water Resources team sampling sites, water depth at Water Resources team sampling sites, water temperature of environmental team 1st sampling site. In the future, Water Resource team should take digital picture of each water sampling site for reporting purposes....not every visit...just once during the project...unless a rainfall event occurs before or during sampling.


 * Files moved to zip Folder**

2) Discrete water sampling lab results One of the vials was completely empty, "DI-3".


 * Files moved to zip folder**

4) Vertical water quality profiling Seabird CTD results (2 files) NOTE: Like all real field studies, unforseen issues can arise with equipment. DISL has informed me that the pH and DO probe malfunctioned so that pH and DO depth information were not recorded. All other data are valid and provided. pH and DO values are reported in the file, but are incorrect.


 * Files moved to zip folder**

WATER RESOURCES (Allen, Erdman, Marr)
2) Vertical profiling YSI CastAway CTD data (Jag Ski) Note that these data do not necessarily need to be used given the capabilities and data acquired using the SeaBird profiler. However, three vertical profiles were obtained along each ADCP transect using the CastAway CTD. Therefore, this data could be considered when determining the spatial variability of heat (temperature) and mass (conductive ions) within the study area. Two files are provided: raw and csv. The raw data can be opened and processed using the YSI CastAway CTD software (see Page 4, Section 2.0). The CSV data have been processed and can be opened in most spreadsheet-type software like MS Excel.


 * Files moved to zip folder**

3) ADCP data (Jag Ski) The raw ADCP data files from this survey are combined in the zip file linked below. These files must be opened, processed, then exported (if desired) using RiverSurveyorLive v3.0 (see Page 4, Section 2.0). Each ADCP transect is performed twice. The first pass at each transect will always be south to north. The second pass at each transect will always be north to south. The CTD casts are made on a third pass without collecting ADCP data. Right and left bank are defined as viewed by an observer looking in the direction of flow (downstream). Therefore, positive values of discharge indicate a net eastward flux, whereas a negative value of discharge indicates westward flux. After processing, it is clear that the net flux at each transect is to the west. Please see additional notes in the MS Excel file linked below.


 * Files moved to zip folder**

Note: The following metadata file updated/uploaded 10/13/2011. This will supersede any previous file having the same name.


 * Files moved to zip folder**

4) Near-surface water quality data (Jag Ski) Processed near-surface water quality data from the Portable SeaKeeper is provided below as a text file. Headers are provided and define the variable name and unit for each column. A few notes are provided below regarding these variables and units. So you know, these processed data are derived from the truly "raw" data files containing GPS, YSI 6600v2, and Turner C3 data. Position data (GPS) are saved to the raw file once per minute. The Turner data are saved to the raw file two times per minute. The YSI data are saved to the raw file five times per minute. The Turner and GPS data are interpolated to the YSI times so that all data is in a common time. Interpolation is performed using a three-point inverse distance weighting function.

For the purposes of this class, please disregard the fuel, oil, depth, voltage, and salinity measurements. Calibration of CDOM to known standards for comparison with TOC measurements will be performed in the coming weeks.

PROJECT NAME: FASTCE - Big Creek Lake SURVEY DATE:: 10/10/11 TIME OUT::::: 14:55:24 TIME IN:::::: 16:44:54 MAX SPEED:::: 30.0 KNOTS


 * Files moved to zip folder**

LON (decimal degrees) - longitude... probably NAD 83 geographic LAT (decimal degrees) - latitude FUEL (relative fluorescence units, RFU) - refined fuel measurements - DISREGARD OIL (RFU) - crude oil measurements - DISREGARD CDOM (RFU) - chromophoric (colored) dissolved organic matter DEPTH (meters) - sensor depth if deployed under water - DISREGARD TEMPC3 (degrees Celsius) - temperature sensor on Turner C3 TEMPYSI (degrees Celsius) - temperature sensor on YSI 6600v2 SPEC. COND. (milliSiemen/cm) - specific conductivity PH ( - ) - pH CHLA (micrograms/liter) - chlorophyll fluorescence TURB (NTU) - turbidity DO (%) - dissolved oxygen saturation... can be above 100% VOLT (VDC) - system voltage - DISREGARD PSU (partial salinity units) - salinity - DISREGARD DEN (kg/m/m) - fluid density