You are here

Home » Water Sample Inventory

Description of Combined Campaign Water Sample Data

Submitted by Charles Seaton on July 23, 2010 - 4:05pm
The table below provides brief descriptions of the source, units and derivation of the data in each column of the "Combined Campaign Water Sample Data" CSV.

Version 1.2 as of April 8, 2011

Version 1.2 of the table, this is the format of the table used as of April 8, 2011. The only change is that latitude and longitude were transposed in version 1.1.

Description
# Name Units Source Description
1. cruise N/A Cruise identifier
2. vessel N/A Vessel used during cruise
3. sampleid N/A Unique identifier assigned to each CMOP water sample
4. wssourcefilename N/A Cruise Spreadsheet Source filename of the spreadsheet used to record cruise and water sample information; used to match water sample id to cast and bottle numbers.
5. casts bottles text Cruise Spreadsheet List of cast:bottle for all bottles & casts making up this water sample
6. num bottles Cruise Spreadsheet Count of the number of bottles used/mixed/identified as associated with/for this water sample.
7. site N/A Cruise Spreadsheet Site, as entered in the wssourcefile.
8. region text
9. samplingdepth m Cruise Spreadsheet Sampling depth, as entered in the wssourcefile.
10. ws notes N/A Cruise Spreadsheet 1st notes column from the wssourcefile. Other notes columns and additional columns are not ingested.
11. bcsourcefilename N/A cdb02:CTD Indicator that the next columns are sourced from the CMOP cast information, for the bottles associated with the water sample.
12. numbottles cdb02:CTD Number of bottles triggered for this water sample.
13. long decimal degrees cdb02:CTD Longitude of the location where the water sample was taken.
14. lat decimal degrees cdb02:CTD Latiitude of the location where the water sample was taken.
15. avg local time yyyy-mm-dd hh:mm PDT/PST cdb02:CTD Date and time (local time, with timezone indicator); averaged across the (very slightly) different times the individual bottles were triggered.
16. year utc yyyy cdb02:CTD The year, in UTC, of when the bottles were triggered.
17. julian time utc cdb02:CTD (Averaged) Julian time, UTC, of when the bottles were triggered.
18. avg bottle depth m cdb02:CTD Depth at which the bottles were triggered; averaged across the (very slightly different) depths of each bottle.
19. cv bottle depth % cdb02:CTD Coefficient of variance of the avg_sampledepth.
20. avg beddepth m cdb02:CTD Average of bed depth measures listed.
21. avg salinity psu cdb02:CTD Salinity, averaged across the bottles included in this sample.
22. cv salinity % cdb02:CTD Coefficient of variance of the avg_salinity.
23. avg temperature C cdb02:CTD Temperature, averaged across the bottles included in this sample.
24. cv temperature % cdb02:CTD Coefficient of variance of the cv_temperature.
25. avg conductivity S/m Conductivity Conductivity, averaged across the bottles included in this sample.
26. avg pressure db Pressure Pressure, averaged across the bottles included in this sample.
27. avg oxygen mg/l Oxygen, SBE 43 Oxygen, averaged across the bottles included in this sample.
28. avg turbidity NTU Turbidity, averaged across the bottles included in this sample.
29. avg fluorescence mg/m^3 Fluorescence, Wetlab ECO-AFL/FL Fluorescence, averaged across the bottles included in this sample.
30. avg nitrate Nitrate, averaged across the bottles included in this sample.
31. avg par q/s*cm^2 PAR/Irradiance, Biospherical/Licor PAR (water), averaged across the bottles included in this sample.
32. avg fluorescein ppb Fluorescein Fluorescence, averaged across the bottles included in this sample. ,
33. avg ph pH pH Ph, averaged across the bottles included in this sample.
34. avg transmiss % Beam Transmission Beam transmission, averaged across the bottles included in this sample.
35. cast dataset Quality measure of cast data. The data table should contain one line per water sample (if all contributing bottles are in the same quality status). If more than one quality status exists, a separate water sample line may be shown for each quality.
36. dna tests N/A DNA Panels DNA test(s) performed and sample identifier given to biological test sample; may be the same as water sample id if no other id has been given. If multiple tests were run, multiple ids may be shown here.
37. dna test notes N/A DNA Panels Notes associated with DNA test(s) performed
38. nutrientssourcefilename N/A Nutrients Source filename of the spreadsheet ingested of nutrient test results.
39. avg po4 micromoles per liter Nutrients Average of PO4 across (any) replicates.
40. cv po4 % Nutrients Coefficient of variance for PO4.
41. avg nn micromoles per liter Nutrients Average of N+N across (any) replicates.
42. cv nn % Nutrients Coefficient of variance fo NN.
43. avg silicate micromoles per liter Nutrients Average of silicate across (any) replicates.
44. cv silicate % Nutrients Coefficient of variance for silicate.
45. avg no2 micromoles per liter Nutrients Average of NO2 across (any) replicates.
46. cv no2 % Nutrients Coefficient of variance for NO2.
47. avg nh4 micromoles per liter Nutrients Average of NH4 across (any) replicates.
48. cv nh4 % Nutrients Coefficient of variance for NH4.
49. nutrients notes N/A Nutrients
50. chlasourcefilename N/A CHLA Source filename of the spreadsheet ingested of Chla test results.
51. avg chl microg/l CHLA Chl, averaged across replicate tests made.
52. cv chl % CHLA Coefficient of variance of avg_chl.
53. avg phaeophytin microg/l CHLA Phaeophytin, averaged across replicate tests made.
54. cv phaeophytin % CHLA Coefficient of variance of avg_phaeophytin.
55. chla notes N/A CHLA
56. docsourcefilename N/A Dissolved Organic Carbon Source filename of the spreadsheet ingested of dissolved organic carbon test results.
57. doc mg/l Dissolved Organic Carbon Dissolved organic carbon. Blanks indicate samples that are in frozen storage and not run
58. dnsourcefilename N/A Dissolved Organic Carbon Source filename of spreadsheet ingested of dissolved nitrogen and phosphorous test results.
59. tdn micromolar Dissolved Organic Carbon Total dissolved nitrogen. Blanks indicate samples that are in frozen storage and not run
60. tdp micromolar Dissolved Organic Carbon Total dissolved phosphorous. Blanks indicate samples that are in frozen storage and not run
61. bpsourcefilename N/A Bacterial Productivity Source filename of spreadsheet ingested of bacterial productivity test results.
62. bp leu picomoles leucine per liter per hour Bacterial Productivity Bacterial incorporation rate of tritiated leucine during 1 hour incubations of untreated water samples
63. bp leu fl picomoles leucine per liter per hour Bacterial Productivity Bacterial incorporation rate of tritiated leucine during 1 hour incubations of water samples that were gently filtered with a 3 micron pore size polycarbonate filter
64. bp micrograms carbon per liter per hour Bacterial Productivity Bacterial carbon production rate in untreated water samples calculated from leucine incorporation rate with a conversion factor of 3.09 kilogram carbon per mole leucine
65. bp fl micrograms carbon per liter per hour Bacterial Productivity Bacterial carbon production rate in water samples that were gently filtered with a 3 micron pore size polycarbonate filter calculated from leucine incorporation rate with a conversion factor of 3.09 kilogram carbon per mole leucine
66. bp notes N/A Bacterial Productivity
67. pocnsourcefilename N/A Particulate Organic Carbon and Particulate Organic Nitrogen Source filename of spreadsheet ingested of particulate organic carbon and particulate organic nitrogen test results.
68. poc microg/l Particulate Organic Carbon and Particulate Organic Nitrogen Particulate organic carbon
69. pon microg/l Particulate Organic Carbon and Particulate Organic Nitrogen Particulate organic nitrogen
70. po13c Delta PDB Particulate Organic Carbon and Particulate Organic Nitrogen del 13C of particulate organic matter, measured on same material as POC
71. po15n Delta Air Particulate Organic Carbon and Particulate Organic Nitrogen del 15N of particulate organic matter, measured on same material as PON
76. flowthrusourcefilename N/A cdb02:tsg Indicator that the next set of columns are sourced from the flowthrough instruments and on-board weather station.
77. ft depth m Depth of flowthrough equipment on the cruise vessel (according to CMOP knowledge of vessel specifications).
78. avg ft local time yyyy-mm-dd hh:mm PST/PDT (Local) date and time of closest flowthrough measurement to each cast bottle triggered. Averaged across the (very slightly different) measurements.
79. ft year utc yyyy Year, taken from date/time of closest flowthrough measurement; calculated from column avg_ft_local_time.
80. ft julian time utc (UTC) Julian time of closest flowthrough measurement, calculated from column avg_ft_local_time.
81. avg ft long decimal degrees Longitude of the flowthrough measurements, averaged across the measurements.
82. avg ft lat decimal degrees Latitude of the flowthrough measurements, averaged across the measurements.
83. avg quality Quality score; 0 = not quality assured. Other scores will be assigned during quality assurance.
84. avg ft conductivity S/m Conductivity Flowthru Conductivity measured by the flowthru; average across closest-time measurement to each bottle trigger time.
85. avg ft salinity psu Salinity Flowthru Salinity measured by the flowthru; average across closest-time measurement to each bottle trigger time.
86. cv ft salinity % Coefficient of variance for avg_ft_salinity.
87. avg ft temp C Temperature measured by the flowthru; average across closest-time measurement to each bottle trigger time.
88. cv ft temp % Coefficient of variance for avg_ft_temp.
89. avg windspeed m/s Wind Speed Windspeed reading from ship-board met station; average across closest-time measurement to each bottle trigger time.
90. avg winddirection degrees (from) Wind Direction Wind direction (heading) from ship-board met station; average across closest-time measurement to each bottle trigger time.
91. avg atmosphericpressure db Barometer Barometric pressure from ship-board met station; average across closest-time measurement to each bottle trigger time.
92. avg atmospherictemp C Air Temperature Air temperature from ship-board met station; average across closest-time measurement to each bottle trigger time.
93. avg depth m average across closest-time measurement to each bottle trigger time.
94. avg cdom voltage V CDOM Fluorescence Voltage CDOM Fluorescence Voltage; average across closest-time measurement to each bottle trigger time.
95. avg longwave radiation W/m^2 Downwelling Longwave Radiation Downwelling Longwave Radiation readings from ship-board met station; average across closest-time measurement to each bottle trigger time.
96. avg shortwave radiation W/m^2 Downwelling Shortwave Radiation Downwelling Shortwave Radiation readings from ship-board met station; average across closest-time measurement to each bottle trigger time.
97. avg ft par q/s*cm^2 PAR PAR (air); average across closest-time measurement to each bottle trigger time.
98. avg chla fluorescence microg/l Chlorophyll Fluorescence Chlorophyll Fluorescence from ship-board met station; average across closest-time measurement to each bottle trigger time.
99. avg ct water temperature C Water Temperature CT water temperature from flow-through; average across closest-time measurement to each bottle trigger time.
100. avg humidity % Relative Humidity Relative humidity from ship-board met station; average across closest-time measurement to each bottle trigger time.
101. avg fl fluores ppb Fluorescein Fluorescence Fluorescein Fluorescence; average across closest-time measurement to each bottle trigger time.
102. climatologysourcefilename N/A Columbia River Climatology Indicator that the next set of columns come from Columbia River Climatology and related sources. Please see: http://www.stccmop.org/datamart/virtualcolumbiariver/simulationdatabases/climatologicalatlas
103. cr flow at bonneville m3/s Columbia River flow at Bonneville Dam Columbia River flow at Bonneville Dam on the date of the water sample, per US Army Corps of Engineers
104. cr residence time days Columbia River Residence Time Columbia River residence time on the date of the water sample, per US Army Corps of Engineers
105. coastal upwelling index 45N m3/s/100m Coastal Upwelling Index at 45N Coastal Upwelling Index at 45N on the date of the water sample, per NOAA
106. coastal upwelling index 48N m3/s/100m Coastal Upwelling Index at 48N Coastal Upwelling Index at 48N on the date of the water sample, per NOAA
107. pacific decadal oscillation in month C Pacific Decadal Oscillation Pacific Decadal Oscillation in the month of the water sample, per U. of Washington
108. Dist from Astoria km Distance from the water sample location to Astoria Tongue Point tide station
109. A Tideheight m Xtide Height of tide at Astoria Tongue Point at the time the water sample was taken
110. A Prev Hightide time Xtide Local time of most recent high tide (at Astoria Tongue Point) before the water sample was taken
111. A Prev Lowtide time Xtide Local time of most recent low tide (at Astoria Tongue Point) before the water sample was taken
112. A Sunrise time Xtide Local time of sunrise (at Astoria Tongue Point) on the day the water sample was taken
113. A Sunset time Xtide Local time of sunset (at Astoria Tongue Point) on the day the water sample was taken
114. A Next Hightide time Xtide Local time of next high tide (at Astoria Tongue Point) after the water sample was taken
115. A Next Lowtide time Xtide Local time of next low tide (at Astoria Tongue Point) after the water sample was taken
116. lagtime time Model * For future use * to contain modeled tide offset from Astoria to actual water sample position

Version 1.1 as of January 21, 2011.

Version 1.1 of the table, this is the format of the table used as of January 21, 2011.

Description
# Name Units Source Description
1. cruise N/A Cruise identifier
2. vessel N/A Vessel used during cruise
3. sampleid N/A Unique identifier assigned to each CMOP water sample
4. wssourcefilename N/A Cruise Spreadsheet Source filename of the spreadsheet used to record cruise and water sample information; used to match water sample id to cast and bottle numbers.
5. casts bottles text Cruise Spreadsheet List of cast:bottle for all bottles & casts making up this water sample
6. num bottles Cruise Spreadsheet Count of the number of bottles used/mixed/identified as associated with/for this water sample.
7. site N/A Cruise Spreadsheet Site, as entered in the wssourcefile.
8. region text
9. samplingdepth m Cruise Spreadsheet Sampling depth, as entered in the wssourcefile.
10. ws notes N/A Cruise Spreadsheet 1st notes column from the wssourcefile. Other notes columns and additional columns are not ingested.
11. bcsourcefilename N/A cdb02:CTD Indicator that the next columns are sourced from the CMOP cast information, for the bottles associated with the water sample.
12. numbottles cdb02:CTD Number of bottles triggered for this water sample.
13. long decimal degrees cdb02:CTD Longitude of the location where the water sample was taken.
14. lat decimal degrees cdb02:CTD Latiitude of the location where the water sample was taken.
15. avg local time yyyy-mm-dd hh:mm PDT/PST cdb02:CTD Date and time (local time, with timezone indicator); averaged across the (very slightly) different times the individual bottles were triggered.
16. year utc yyyy cdb02:CTD The year, in UTC, of when the bottles were triggered.
17. julian time utc cdb02:CTD (Averaged) Julian time, UTC, of when the bottles were triggered.
18. avg bottle depth m cdb02:CTD Depth at which the bottles were triggered; averaged across the (very slightly different) depths of each bottle.
19. cv bottle depth % cdb02:CTD Coefficient of variance of the avg_sampledepth.
20. avg beddepth m cdb02:CTD Average of bed depth measures listed.
21. avg salinity psu cdb02:CTD Salinity, averaged across the bottles included in this sample.
22. cv salinity % cdb02:CTD Coefficient of variance of the avg_salinity.
23. avg temperature C cdb02:CTD Temperature, averaged across the bottles included in this sample.
24. cv temperature % cdb02:CTD Coefficient of variance of the cv_temperature.
25. avg conductivity S/m Conductivity Conductivity, averaged across the bottles included in this sample.
26. avg pressure db Pressure Pressure, averaged across the bottles included in this sample.
27. avg oxygen mg/l Oxygen, SBE 43 Oxygen, averaged across the bottles included in this sample.
28. avg turbidity NTU Turbidity, averaged across the bottles included in this sample.
29. avg fluorescence mg/m^3 Fluorescence, Wetlab ECO-AFL/FL Fluorescence, averaged across the bottles included in this sample.
30. avg nitrate Nitrate, averaged across the bottles included in this sample.
31. avg par q/s*cm^2 PAR/Irradiance, Biospherical/Licor PAR (water), averaged across the bottles included in this sample.
32. avg fluorescein ppb Fluorescein Fluorescence, averaged across the bottles included in this sample. ,
33. avg ph pH pH Ph, averaged across the bottles included in this sample.
34. avg transmiss % Beam Transmission Beam transmission, averaged across the bottles included in this sample.
35. cast dataset Quality measure of cast data. The data table should contain one line per water sample (if all contributing bottles are in the same quality status). If more than one quality status exists, a separate water sample line may be shown for each quality.
36. dna tests N/A DNA Panels DNA test(s) performed and sample identifier given to biological test sample; may be the same as water sample id if no other id has been given. If multiple tests were run, multiple ids may be shown here.
37. dna test notes N/A DNA Panels Notes associated with DNA test(s) performed
38. nutrientssourcefilename N/A Nutrients Source filename of the spreadsheet ingested of nutrient test results.
39. avg po4 micromoles per liter Nutrients Average of PO4 across (any) replicates.
40. cv po4 % Nutrients Coefficient of variance for PO4.
41. avg nn micromoles per liter Nutrients Average of N+N across (any) replicates.
42. cv nn % Nutrients Coefficient of variance fo NN.
43. avg silicate micromoles per liter Nutrients Average of silicate across (any) replicates.
44. cv silicate % Nutrients Coefficient of variance for silicate.
45. avg no2 micromoles per liter Nutrients Average of NO2 across (any) replicates.
46. cv no2 % Nutrients Coefficient of variance for NO2.
47. avg nh4 micromoles per liter Nutrients Average of NH4 across (any) replicates.
48. cv nh4 % Nutrients Coefficient of variance for NH4.
49. nutrients notes N/A Nutrients
50. chlasourcefilename N/A CHLA Source filename of the spreadsheet ingested of Chla test results.
51. avg chl microg/l CHLA Chl, averaged across replicate tests made.
52. cv chl % CHLA Coefficient of variance of avg_chl.
53. avg phaeophytin microg/l CHLA Phaeophytin, averaged across replicate tests made.
54. cv phaeophytin % CHLA Coefficient of variance of avg_phaeophytin.
55. chla notes N/A CHLA
56. docsourcefilename N/A Dissolved Organic Carbon Source filename of the spreadsheet ingested of dissolved organic carbon test results.
57. doc mg/l Dissolved Organic Carbon Dissolved organic carbon. Blanks indicate samples that are in frozen storage and not run
58. dnsourcefilename N/A Dissolved Organic Carbon Source filename of spreadsheet ingested of dissolved nitrogen and phosphorous test results.
59. tdn micromolar Dissolved Organic Carbon Total dissolved nitrogen. Blanks indicate samples that are in frozen storage and not run
60. tdp micromolar Dissolved Organic Carbon Total dissolved phosphorous. Blanks indicate samples that are in frozen storage and not run
61. bpsourcefilename N/A Bacterial Productivity Source filename of spreadsheet ingested of bacterial productivity test results.
62. bp leu picomoles leucine per liter per hour Bacterial Productivity Bacterial incorporation rate of tritiated leucine during 1 hour incubations of untreated water samples
63. bp leu fl picomoles leucine per liter per hour Bacterial Productivity Bacterial incorporation rate of tritiated leucine during 1 hour incubations of water samples that were gently filtered with a 3 micron pore size polycarbonate filter
64. bp micrograms carbon per liter per hour Bacterial Productivity Bacterial carbon production rate in untreated water samples calculated from leucine incorporation rate with a conversion factor of 3.09 kilogram carbon per mole leucine
65. bp fl micrograms carbon per liter per hour Bacterial Productivity Bacterial carbon production rate in water samples that were gently filtered with a 3 micron pore size polycarbonate filter calculated from leucine incorporation rate with a conversion factor of 3.09 kilogram carbon per mole leucine
66. bp notes N/A Bacterial Productivity
67. pocnsourcefilename N/A Particulate Organic Carbon and Particulate Organic Nitrogen Source filename of spreadsheet ingested of particulate organic carbon and particulate organic nitrogen test results.
68. poc microg/l Particulate Organic Carbon and Particulate Organic Nitrogen Particulate organic carbon
69. pon microg/l Particulate Organic Carbon and Particulate Organic Nitrogen Particulate organic nitrogen
70. po13c Delta PDB Particulate Organic Carbon and Particulate Organic Nitrogen del 13C of particulate organic matter, measured on same material as POC
71. po15n Delta Air Particulate Organic Carbon and Particulate Organic Nitrogen del 15N of particulate organic matter, measured on same material as PON
76. flowthrusourcefilename N/A cdb02:tsg Indicator that the next set of columns are sourced from the flowthrough instruments and on-board weather station.
77. ft depth m Depth of flowthrough equipment on the cruise vessel (according to CMOP knowledge of vessel specifications).
78. avg ft local time yyyy-mm-dd hh:mm PST/PDT (Local) date and time of closest flowthrough measurement to each cast bottle triggered. Averaged across the (very slightly different) measurements.
79. ft year utc yyyy Year, taken from date/time of closest flowthrough measurement; calculated from column avg_ft_local_time.
80. ft julian time utc (UTC) Julian time of closest flowthrough measurement, calculated from column avg_ft_local_time.
81. avg ft long decimal degrees Longitude of the flowthrough measurements, averaged across the measurements.
82. avg ft lat decimal degrees Latitude of the flowthrough measurements, averaged across the measurements.
83. avg quality Quality score; 0 = not quality assured. Other scores will be assigned during quality assurance.
84. avg ft conductivity S/m Conductivity Flowthru Conductivity measured by the flowthru; average across closest-time measurement to each bottle trigger time.
85. avg ft salinity psu Salinity Flowthru Salinity measured by the flowthru; average across closest-time measurement to each bottle trigger time.
86. cv ft salinity % Coefficient of variance for avg_ft_salinity.
87. avg ft temp C Temperature measured by the flowthru; average across closest-time measurement to each bottle trigger time.
88. cv ft temp % Coefficient of variance for avg_ft_temp.
89. avg windspeed m/s Wind Speed Windspeed reading from ship-board met station; average across closest-time measurement to each bottle trigger time.
90. avg winddirection degrees (from) Wind Direction Wind direction (heading) from ship-board met station; average across closest-time measurement to each bottle trigger time.
91. avg atmosphericpressure db Barometer Barometric pressure from ship-board met station; average across closest-time measurement to each bottle trigger time.
92. avg atmospherictemp C Air Temperature Air temperature from ship-board met station; average across closest-time measurement to each bottle trigger time.
93. avg depth m average across closest-time measurement to each bottle trigger time.
94. avg cdom voltage V CDOM Fluorescence Voltage CDOM Fluorescence Voltage; average across closest-time measurement to each bottle trigger time.
95. avg longwave radiation W/m^2 Downwelling Longwave Radiation Downwelling Longwave Radiation readings from ship-board met station; average across closest-time measurement to each bottle trigger time.
96. avg shortwave radiation W/m^2 Downwelling Shortwave Radiation Downwelling Shortwave Radiation readings from ship-board met station; average across closest-time measurement to each bottle trigger time.
97. avg ft par q/s*cm^2 PAR PAR (air); average across closest-time measurement to each bottle trigger time.
98. avg chla fluorescence microg/l Chlorophyll Fluorescence Chlorophyll Fluorescence from ship-board met station; average across closest-time measurement to each bottle trigger time.
99. avg ct water temperature C Water Temperature CT water temperature from flow-through; average across closest-time measurement to each bottle trigger time.
100. avg humidity % Relative Humidity Relative humidity from ship-board met station; average across closest-time measurement to each bottle trigger time.
101. avg fl fluores ppb Fluorescein Fluorescence Fluorescein Fluorescence; average across closest-time measurement to each bottle trigger time.
102. climatologysourcefilename N/A Columbia River Climatology Indicator that the next set of columns come from Columbia River Climatology and related sources. Please see: http://www.stccmop.org/datamart/virtualcolumbiariver/simulationdatabases/climatologicalatlas
103. cr flow at bonneville m3/s Columbia River flow at Bonneville Dam Columbia River flow at Bonneville Dam on the date of the water sample, per US Army Corps of Engineers
104. cr residence time days Columbia River Residence Time Columbia River residence time on the date of the water sample, per US Army Corps of Engineers
105. coastal upwelling index 45N m3/s/100m Coastal Upwelling Index at 45N Coastal Upwelling Index at 45N on the date of the water sample, per NOAA
106. coastal upwelling index 48N m3/s/100m Coastal Upwelling Index at 48N Coastal Upwelling Index at 48N on the date of the water sample, per NOAA
107. pacific decadal oscillation in month C Pacific Decadal Oscillation Pacific Decadal Oscillation in the month of the water sample, per U. of Washington
108. Dist from Astoria km Distance from the water sample location to Astoria Tongue Point tide station
109. A Tideheight m Xtide Height of tide at Astoria Tongue Point at the time the water sample was taken
110. A Prev Hightide time Xtide Local time of most recent high tide (at Astoria Tongue Point) before the water sample was taken
111. A Prev Lowtide time Xtide Local time of most recent low tide (at Astoria Tongue Point) before the water sample was taken
112. A Sunrise time Xtide Local time of sunrise (at Astoria Tongue Point) on the day the water sample was taken
113. A Sunset time Xtide Local time of sunset (at Astoria Tongue Point) on the day the water sample was taken
114. A Next Hightide time Xtide Local time of next high tide (at Astoria Tongue Point) after the water sample was taken
115. A Next Lowtide time Xtide Local time of next low tide (at Astoria Tongue Point) after the water sample was taken
116. lagtime time Model * For future use * to contain modeled tide offset from Astoria to actual water sample position

Version 1.0 before January 21, 2011

Version 1.0 of the table, this was the format prior to January 21, 2011

Description
# Name Units Source Description
1. cruise N/A Cruise identifier
2. vessel N/A Vessel used during cruise
3. sampleid N/A Unique identifier assigned to each CMOP water sample
4. wssourcefilename N/A Cruise Spreadsheet Source filename of the spreadsheet used to record cruise and water sample information; used to match water sample id to cast and bottle numbers.
5. num bottles Cruise Spreadsheet Count of the number of bottles used/mixed/identified as associated with/for this water sample.
6. site N/A Cruise Spreadsheet Site, as entered in the wssourcefile.
7. samplingdepth m Cruise Spreadsheet Sampling depth, as entered in the wssourcefile.
8. ws notes N/A Cruise Spreadsheet 1st notes column from the wssourcefile. Other notes columns and additional columns are not ingested.
9. bcsourcefilename N/A cdb02:CTD Indicator that the next columns are sourced from the CMOP cast information, for the bottles associated with the water sample.
10. numbottles cdb02:CTD Number of bottles triggered for this water sample.
11. long decimal degrees cdb02:CTD Longitude of the location where the water sample was taken.
12. lat decimal degrees cdb02:CTD Latiitude of the location where the water sample was taken.
13. avg local time yyyy-mm-dd hh:mm PDT/PST cdb02:CTD Date and time (local time, with timezone indicator); averaged across the (very slightly) different times the individual bottles were triggered.
14. year utc yyyy cdb02:CTD The year, in UTC, of when the bottles were triggered.
15. julian time utc cdb02:CTD (Averaged) Julian time, UTC, of when the bottles were triggered.
16. avg sampledepth m cdb02:CTD Depth at which the bottles were triggered; averaged across the (very slightly different) depths of each bottle.
17. cv sampledepth % cdb02:CTD Coefficient of variance of the avg_sampledepth.
18. avg beddepth m cdb02:CTD Average of bed depth measures listed.
19. avg salinity psu cdb02:CTD Salinity, averaged across the bottles included in this sample.
20. cv salinity % cdb02:CTD Coefficient of variance of the avg_salinity.
21. avg temperature C cdb02:CTD Temperature, averaged across the bottles included in this sample.
22. cv temperature % cdb02:CTD Coefficient of variance of the cv_temperature.
23. avg conductivity S/m Conductivity Conductivity, averaged across the bottles included in this sample.
24. avg pressure db Pressure Pressure, averaged across the bottles included in this sample.
25. avg oxygen mg/l Oxygen, SBE 43 Oxygen, averaged across the bottles included in this sample.
26. avg turbidity NTU Turbidity, averaged across the bottles included in this sample.
27. avg fluorescence mg/m^3 Fluorescence, Wetlab ECO-AFL/FL Fluorescence, averaged across the bottles included in this sample.
28. avg nitrate Nitrate, averaged across the bottles included in this sample.
29. avg par q/s*cm^2 PAR/Irradiance, Biospherical/Licor PAR (water), averaged across the bottles included in this sample.
30. avg fluorescein ppb Fluorescein Fluorescence, averaged across the bottles included in this sample. ,
31. avg ph pH pH Ph, averaged across the bottles included in this sample.
32. avg transmiss % Beam Transmission Beam transmission, averaged across the bottles included in this sample.
33. cast dataset Quality measure of cast data. The data table should contain one line per water sample (if all contributing bottles are in the same quality status). If more than one quality status exists, a separate water sample line may be shown for each quality.
34. nutrientssourcefilename N/A Nutrients Source filename of the spreadsheet ingested of nutrient test results.
35. avg po4 micromoles per liter Nutrients Average of PO4 across (any) replicates.
36. cv po4 % Nutrients Coefficient of variance for PO4.
37. avg nn micromoles per liter Nutrients Average of N+N across (any) replicates.
38. cv nn % Nutrients Coefficient of variance fo NN.
39. avg silicate micromoles per liter Nutrients Average of silicate across (any) replicates.
40. cv silicate % Nutrients Coefficient of variance for silicate.
41. avg no2 micromoles per liter Nutrients Average of NO2 across (any) replicates.
42. cv no2 % Nutrients Coefficient of variance for NO2.
43. avg nh4 micromoles per liter Nutrients Average of NH4 across (any) replicates.
44. cv nh4 % Nutrients Coefficient of variance for NH4.
45. nutrients notes N/A Nutrients
46. chlasourcefilename N/A CHLA Source filename of the spreadsheet ingested of Chla test results.
47. avg chl microg/l CHLA Chl, averaged across replicate tests made.
48. cv chl % CHLA Coefficient of variance of avg_chl.
49. avg phaeophytin microg/l CHLA Phaeophytin, averaged across replicate tests made.
50. cv phaeophytin % CHLA Coefficient of variance of avg_phaeophytin.
51. chla notes N/A CHLA
52. docsourcefilename N/A Dissolved Organic Carbon Source filename of the spreadsheet ingested of dissolved organic carbon test results.
53. doc mg/l Dissolved Organic Carbon Dissolved organic carbon. Blanks indicate samples that are in frozen storage and not run
54. dnsourcefilename N/A Dissolved Organic Carbon Source filename of spreadsheet ingested of dissolved nitrogen and phosphorous test results.
55. tdn micromolar Dissolved Organic Carbon Total dissolved nitrogen. Blanks indicate samples that are in frozen storage and not run
56. tdp micromolar Dissolved Organic Carbon Total dissolved phosphorous. Blanks indicate samples that are in frozen storage and not run
57. bpsourcefilename N/A Bacterial Productivity Source filename of spreadsheet ingested of bacterial productivity test results.
58. bp leu picomoles leucine per liter per hour Bacterial Productivity Bacterial incorporation rate of tritiated leucine during 1 hour incubations of untreated water samples
59. bp leu fl picomoles leucine per liter per hour Bacterial Productivity Bacterial incorporation rate of tritiated leucine during 1 hour incubations of water samples that were gently filtered with a 3 micron pore size polycarbonate filter
60. bp micrograms carbon per liter per hour Bacterial Productivity Bacterial carbon production rate in untreated water samples calculated from leucine incorporation rate with a conversion factor of 3.09 kilogram carbon per mole leucine
61. bp fl micrograms carbon per liter per hour Bacterial Productivity Bacterial carbon production rate in water samples that were gently filtered with a 3 micron pore size polycarbonate filter calculated from leucine incorporation rate with a conversion factor of 3.09 kilogram carbon per mole leucine
62. bp notes N/A Bacterial Productivity
63. pocnsourcefilename N/A Particulate Organic Carbon and Particulate Organic Nitrogen Source filename of spreadsheet ingested of particulate organic carbon and particulate organic nitrogen test results.
64. poc microg/l Particulate Organic Carbon and Particulate Organic Nitrogen Particulate organic carbon
65. pon microg/l Particulate Organic Carbon and Particulate Organic Nitrogen Particulate organic nitrogen
66. po13c Delta PDB Particulate Organic Carbon and Particulate Organic Nitrogen del 13C of particulate organic matter, measured on same material as POC
67. po15n Delta Air Particulate Organic Carbon and Particulate Organic Nitrogen del 15N of particulate organic matter, measured on same material as PON
68. dnapanels N/A DNA Panels Indicator that the next columns list any DNA panels that have been run for these samples.
69. test type N/A DNA Panels Indication of specific DNA test panels that have been run. There may be more than 1 test type shown if multiple tests were run for this sample.
70. bio sampleid N/A DNA Panels Sample identifier given to biological test sample; may be the same as water sample id if no other id has been given. If multiple tests were run, multiple ids may be shown here.
71. test notes N/A DNA Panels
72. flowthrusourcefilename N/A cdb02:tsg Indicator that the next set of columns are sourced from the flowthrough instruments and on-board weather station.
73. ft depth m Depth of flowthrough equipment on the cruise vessel (according to CMOP knowledge of vessel specifications).
74. avg ft local time yyyy-mm-dd hh:mm PST/PDT (Local) date and time of closest flowthrough measurement to each cast bottle triggered. Averaged across the (very slightly different) measurements.
75. ft year utc yyyy Year, taken from date/time of closest flowthrough measurement; calculated from column avg_ft_local_time.
76. ft julian time utc (UTC) Julian time of closest flowthrough measurement, calculated from column avg_ft_local_time.
77. avg ft long decimal degrees Longitude of the flowthrough measurements, averaged across the measurements.
78. avg ft lat decimal degrees Latitude of the flowthrough measurements, averaged across the measurements.
79. avg quality Quality score; 0 = not quality assured. Other scores will be assigned during quality assurance.
80. avg ft conductivity S/m Conductivity Flowthru Conductivity measured by the flowthru; average across closest-time measurement to each bottle trigger time.
81. avg ft salinity psu Salinity Flowthru Salinity measured by the flowthru; average across closest-time measurement to each bottle trigger time.
82. cv ft salinity % Coefficient of variance for avg_ft_salinity.
83. avg ft temp C Temperature measured by the flowthru; average across closest-time measurement to each bottle trigger time.
84. cv ft temp % Coefficient of variance for avg_ft_temp.
85. avg windspeed m/s Wind Speed Windspeed reading from ship-board met station; average across closest-time measurement to each bottle trigger time.
86. avg winddirection degrees (from) Wind Direction Wind direction (heading) from ship-board met station; average across closest-time measurement to each bottle trigger time.
87. avg atmosphericpressure db Barometer Barometric pressure from ship-board met station; average across closest-time measurement to each bottle trigger time.
88. avg atmospherictemp C Air Temperature Air temperature from ship-board met station; average across closest-time measurement to each bottle trigger time.
89. avg depth m average across closest-time measurement to each bottle trigger time.
90. avg cdom voltage V CDOM Fluorescence Voltage CDOM Fluorescence Voltage; average across closest-time measurement to each bottle trigger time.
91. avg longwave radiation W/m^2 Downwelling Longwave Radiation Downwelling Longwave Radiation readings from ship-board met station; average across closest-time measurement to each bottle trigger time.
92. avg shortwave radiation W/m^2 Downwelling Shortwave Radiation Downwelling Shortwave Radiation readings from ship-board met station; average across closest-time measurement to each bottle trigger time.
93. avg ft par q/s*cm^2 PAR PAR (air); average across closest-time measurement to each bottle trigger time.
94. avg chla fluorescence microg/l Chlorophyll Fluorescence Chlorophyll Fluorescence from ship-board met station; average across closest-time measurement to each bottle trigger time.
95. avg ct water temperature C Water Temperature CT water temperature from flow-through; average across closest-time measurement to each bottle trigger time.
96. avg humidity % Relative Humidity Relative humidity from ship-board met station; average across closest-time measurement to each bottle trigger time.
97. avg fl fluores ppb Fluorescein Fluorescence Fluorescein Fluorescence; average across closest-time measurement to each bottle trigger time.
98. climatologysourcefilename N/A Columbia River Climatology Indicator that the next set of columns come from Columbia River Climatology and related sources. Please see: http://www.stccmop.org/datamart/virtualcolumbiariver/simulationdatabases/climatologicalatlas
99. cr flow at bonneville m3/s Columbia River flow at Bonneville Dam Columbia River flow at Bonneville Dam on the date of the water sample, per US Army Corps of Engineers
100. cr residence time days Columbia River Residence Time Columbia River residence time on the date of the water sample, per US Army Corps of Engineers
101. coastal upwelling index 45N m3/s/100m Coastal Upwelling Index at 45N Coastal Upwelling Index at 45N on the date of the water sample, per NOAA
102. coastal upwelling index 48N m3/s/100m Coastal Upwelling Index at 48N Coastal Upwelling Index at 48N on the date of the water sample, per NOAA
103. pacific decadal oscillation in month C Pacific Decadal Oscillation Pacific Decadal Oscillation in the month of the water sample, per U. of Washington
104. Dist from Astoria km Distance from the water sample location to Astoria Tongue Point tide station
105. A Tideheight m Xtide Height of tide at Astoria Tongue Point at the time the water sample was taken
106. A Prev Hightide time Xtide Local time of most recent high tide (at Astoria Tongue Point) before the water sample was taken
107. A Prev Lowtide time Xtide Local time of most recent low tide (at Astoria Tongue Point) before the water sample was taken
108. A Sunrise time Xtide Local time of sunrise (at Astoria Tongue Point) on the day the water sample was taken
109. A Sunset time Xtide Local time of sunset (at Astoria Tongue Point) on the day the water sample was taken
110. A Next Hightide time Xtide Local time of next high tide (at Astoria Tongue Point) after the water sample was taken
111. A Next Lowtide time Xtide Local time of next low tide (at Astoria Tongue Point) after the water sample was taken

Follow Us

Flckr Blog

Member Login