Data Edits & Updates

Newest fixes and additions:

Latest additions, fixes and updates are now here:

Hydrographic Data     |     CTD Data

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