enzh-CNfrdeeliwitjakorues

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

Latest Additions & Edits

9 June 2017

  • Imported final data from 2016-04 into bottle and cast tables
  • Imported final data from 2016-07 Zooplankton in the Zooplankton csv

7 Mar 2017

  • Imported 201601 zooplankton data to the zooplankton database csv

3 March 2017

  • Imported final data from 2016-01 into bottle and cast tables
  • Imported final data from 2015-01, 2015-07 and 2015-11 Zooplankton in the Zooplankton csv
  • Dates were corrected from 201107-101207 to match UTC time in the Cast Table
  • Incubation times for primary productivity data were corrected in Prodo_Bottle Table

28 Oct 2016

  • Imported final data from 201511 into bottle and Cast tables

25 Oct 2016

  • Imported 201411 zooplankton data to the zooplankton database csv

23 Sept 2016

  • Imported final data from 201507 into bottle, cast and DIC tables and imported 200808 DIC and TA data into DIC table and csv

19 Aug 2016

  • Imported 201504 and 201604 zooplankton data to the zooplankton database csv

2 Jun 2016

  • Imported final data from 201504 into bottle, cast and DIC tables

7 Dec 2015

  • Fixed Cruise_ID incremental issue from cruises 2012-11 through present in Cast table

20 Oct 2015

  • Imported final data from 201411 and 201501 into bottle, cast and DIC tables

22 July 2015

  • Added pH columns to DICs and Bottle Tables

1 July 2015

  • Added column Oxy_umol/kg to Bottle csv, xml and sql and column Cruise to Cast csv, xml and sql.

9 June 2015

  • Imported final data from 201404 and 201407 into bottle and cast tables.
  • Imported DIC data from 2014-04 and 2014-07 in DIC csv
  • Imported zooplankton data from 2013-11 through 2014-04
  • Fixed 90.45 Prodo in 2010-08.  Had values from station 93.3 26.7 of that cruise.

30 October 2014

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

22 September 2014

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

26 August 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.

  Complete Listing

Go to top
DMC Firewall is a Joomla Security extension!