Newest fixes and additions:

30 Oct 2014

  • Imported final data from 201311 and 201402 into bottle and cast tables.

22 Sept 2014

  • Imported final data from 201304 and 201307 into bottle and cast tables.

26 Aug 2014

  • Weather Items fixed in the Cast Table.  Erroneous zeros in wet/dry temps and wave height/period fixed.

21 March 2014

  • Fixed Station Names in the Cast Table from Line 66.7 on 201301.

17 Jan 2014

  • Imported data from 201301 into Bottle and Cast tables.

4 Nov 2013

  • Fixed DIC Sample draw errors and added DIC Quality Comment column to Bottle table.

21 Oct 2013

  • Imported data from 201210 into Bottle and Cast tables.  Added Oxy_µmol/Kg field to Bottle Table.

26 Aug 2013

  • Imported data from 201207 into Bottle and Cast tables.

26 June 2013

  • Inserted LTER Bottles that were left out of 200501, 200504, 200507, 200511.  Fixed btl#19 on 200707 76.7 55.0.

 05 June 2013

  • Fixed 20-1202 import errors in Rpt_Data Table and BtlNum & RecInd in Bottle Table for 20-1202
  • Fixed DIC importation errors

 02 Apr 2013

  • Imported DIC data from 2009-01 through 2012-03 into Bottle Table in database
  • Imported final data from 20-1203 in database

19 Mar 2013

  • Re-Imported 20-1108 and 20-1110 to fix UTC Date/Time issues in database
  • Re-Imported 20-1202 to fix UTC Date/Time issues and Prodo lumex problems in database

07 Feb 2013

  • CalCOFI 1301SH preliminary CTD bottle-corrected data files posted
  • CalCOFI 1301SH raw Seabird CTD cast files posted

 

02 Jan 2013

  • CalCOFI 1104 final CTD bottle-corrected data files posted in database
  • CalCOFI 1210NH preliminary CTD data files posted in database

 


13 Oct 2012

  • Added description for Julian date into Categories table
  • Added captain, cruise date data into Cruises table, 5408-1203


 04 Oct 2012

  • CalCOFI 1110NH final hydrographic data imported into database
  • CalCOFI 1202NH final hydrographic data imported into database


15 May 2012

  • CalCOFI 1104NH final hydrographic data imported into database
  • CalCOFI 1108NH final hydrographic data imported into database


17 Apr 2012

  • Missing O2 saturation in hydrographic data added
  • Missing decimal (tenth) value in O2 ml/L added


02 Jun 2011

  • CalCOFI 1011NH final hydrographic data imported into database
  • CalCOFI 1101NH final hydrographic data imported into database
  • Updated the Units Table

03 Jan 2011

  • CalCOFI 1008NH final hydrographic data imported into database
  • CalCOFI 1009SH (10 sta Shimada shakedown cruise; Line 93.3) final hydrographic data imported into database
  • NODC ship code corrections applied to ship table, ship code column, & Cruise_ID; refer to 'work done' table for specifics.

14 Dec 2010

  • CalCOFI 1008NH IEH Hydrographic Data files available
  • Corrected latitude & longitude miscalculations - minutes as decimal degrees were subtracted from degrees instead of added; decimal accuracy increased to 5 decimal places
  • Added final data from CalCOFI 1001NH & 1004MF.
  • CalCOFI 0104JD station dates were off by -24hrs, fixed.
  • Added missing stations 80.100 and 90.100 to 0911NH database.
  • Please refer to Work_Done table in the database for additions, changes & corrections.
  • Added content to Cruise_ID column: YYYY-MM-DD-Project Code-Ship Code
  • Changed ShipName to Ship_Name in Cast table to match the 0-Ships table and establish a relational link
  • Changed the Ship_Code to 4 characters only; UNOLS 2 digit country code + 2 char ship code
  • Fixed 191001 glitch to 201001 in preliminary databas