Category: Methods
-
Updating CalCOFI Hydrographic Database
How to update the CCDB Hydrographic Database in MySQL In addition to ERDDAP, SIO-CalCOFI has a smaller, queryable, online, hydrographic database. This query form includes bottle-related data only and resides at cappuccino.ucsd.edu. These instructions were composed after multiple attempts to update the large mySQL database table with new data. Create a new CCDB data table…
-
Nutrient Methods
Nutrient Analysis, Nitrate, Nitrite, Silicate, Phosphate and Ammonium SUMMARY: The phytoplankton macro nutrients nitrate, nitrite, silicate, and phosphate in seawater are analyzed using colorimetric assays. Ammonium concentrations are determined using a fluorometric assay. 1. Principle Nutrient analysis is performed on a QuAAtro continuous segmented flow autoanalyzer (SEAL Analytical). A sample of seawater enters…
-
CTD Data Processing Protocol
Please note, the processing methods described use SIO-CalCOFI-developed software (DECODR & BtlVsCTD) to merge and correct Seabird 911+ CTD data with bottle samples. The Seasoft portion of our data processing protocol follow their recommended settings for our 911+ v2 CTD & deck unit. “Sta.csvs” are bottle data collected at each station cast combined with 1m binavg…
-
Line.Sta Algorithms
Corrected Conversion Algorithm for CalCOFI Station Grid And Their Implementation in Several Computer Languages by Edward Weber & Thomas Moorem, NOAA Fisheries, 2013 CalCOFI Report v 54. Link to downloadable code (Java, Perl, Python & R) file presented in the CalCOFI Report vol 54, pages 102-106. Matlab scripts by Robert Thombley, SIO-CalCOFI with Sep2014 error…
-
Bottle Sampling Depths
Bottle Sampling Depths, based on downcast profiles The CalCOFI CTD-rosette is equipped with a Sea-Bird Electronic carousel water sampler (SBE 32), a computer-driven, electro-magnetically-released latch system. The 24 ten-liter plastic (PVC) bottles, equipped with epoxy-coated springs & Viton (non-toxic) O-rings, connect to 24 individual triggers by lanyards which keep the bottle ends open. During the…
-
CTD Setup & Diagnostics
Seabird CTD-Carousel Setup & Deck Unit Diagnostics SIO-CalCOFI’s method of terminating the sea cable uses a custom 4-pin pigtail to terminate a multi-strand conductive wire that allows each individual conductor to be used in any combination. Terminating the sea cable using this technique may be viewed in the CalCOFI Handbook: CTD Termination. Conventional two-pin Seabird…
-
Distance From Shore
Distance = Distance from shore in nautical miles. The CalCOFI database includes a calculated distance-from-shore value used primarily for vertical section plots published in the hydrographic data reports. CalCOFI line coastline intercepts, digitized from Google maps, are tabulated below; the latitudes and longitudes are the origins (zero starting point) for vertical section plots. Line Sta (if…
-
Underway Data Processing
Underway Data Processing Methods 1. Navigate to Underway Data folder and join into a single file, do so using Advanced File Joiner or similar: http://download.cnet.com/Advanced-File-Joiner/3000-2094_4-169639.html a. CalCOFI collects its own data while aboard SIO ships (New Horizon). These are saved in the Events folder of the appropriate cruise. A single file name is similar to: 0901NHMETEV_06012009.csv. Although each…
-
Methods Timeline
CalCOFI Time Series data are over 67 years old. New adopted practices, methods, software and hardware are thoroughly tested to maintain dataset continuity as the program & science evolves. Core measurements are maintained and many new measurements added. CTD temperature sensors, for example, provide data at a much higher resolution than a 20 bottle hydrocast…
-
Satlantic ISUS Operation
Setting up and using the ISUS with Seabird CTD 1). Connect the ISUS Analog Out port to a 6-pin CTD port – we use voltage channel 6 on a universal Y-cable, allowing pH to occupy channel 7. Map that port in Seasave as user-polynomial; under the user-polynomial, enter: A0 = – 7.1168, A1 = 27.155. …