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