CalCOFI Data - Personnel Reports

Personnel Reports

Cruise Personnel Reports

For more Personnel Reports see our old site

Last Updated on Tuesday, 20 October 2009 22:00

Cruise Hydrographic Data Reports

We report the data that we collect on our cruises in a Hydrographic Data Report. These reports consist of:

Introductions - Contains the standard procedures, tabulated data descriptions, associated ancillary projects, footnote definitions, and literature cited.

Hydrographic Data Reports - Quarterly tabulated data reports. The 60 year dataset includes temperature, salinity, oxygen and phosphate observations. In 1961, nutrient analysis expanded to include silicate, nitrate and nitrite; in 1973, chlorophyll was added; in 2008, the nutrient analysis expanded to include ammonium.

Primary Productivity Data Reports - Quarterly Tabulated Data Reports. These are a subset of the hydrographic data report containing only stations in which primary productivity experiments were carried out. Includes hydrographic data along with primary productivity data.

Personnel - List of personnel per cruise, cruise dates, ports of call, ship name, and captain's name.

Macrozooplankton Biomass Report - Contains the macrozooplankton biomass, as wet displacement volume, after removal of large (>5 ml) organisms from the starbird side of a 71 cm mouth diameter paired net (bongo net) equipped with 0.505mm plankton mesh; towed obliquely from 210 meters to the surface.

Spatial Pattern Figures - Contains vertical (line 90 only) and horizontal (10 and 200 meters along the standard CalCOFI grid) contour plotted hydrographic data.

Bird Figures - Quartely Avifauna distribution observations over the standard CalCOFI grid.

For combined quarterly CalCOFI Data Reports in pdf, please see our CalCOFI Data Reports web page.

Microsoft Access Database

Microsoft Access Database (mirror) - March 1949 - April 2010 hydrographic bottle data (IEH data + published Data Report data); Microsoft Access format (version 1Sept2010). Table and Column Definitions of the CalCOFI Database.

XML - 194903 to 201004 Cast and Bottle XML files (mirror) - Cast and Bottle tables as separate XML files.

SQL - 194903 to 2001004 Access to MySQL 'dump' SQL file (mirror)- complete web version, includes Cast, Bottle, Cruise, Standard Station, Standard Depth, and metadata tables, uncompresses to over 870mb.

Newest fixes and additions:

1 Sept 2010

Fixed Date issue on 200104. All dates were -1 day off
Added missing stations 80.0 100.0 and 90.0 100.0 to 200911
Added finalized data from cruises 201001 and 201004

23 Mar 2010

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 database

18 Mar 2010

Added Cruise_ID, YYYY-MM-DD-ProjectCode-ShipCode, column to cast table
Changed the Ship_Code column which has historically been Country Code + Institution Code + Ship Code to Country Code + Ship Code because Institution is missing in most of the IEH archives.
Revised the Ship Table: original two char ShipCode is now Ship, ShipCode is new standard country code+ship code
Added 0911 final hydrographic data to the database

17 Dec 2009

Salinity decimal accuracy set to 3 sig figs
Sigma-theta decimal accuracy set to 3 sig figs
Cast_ID Julian Day, Time, Data_Type corrected on several casts
Depth_ID corrected to match Cast_ID corrections
Prodo_Cast table - removed Cast_ID, not needed since Cast_Cnt relation links Cast table Cast_ID

07 Dec 2009

Cruise 198107 changed to 198108 as reported by NMFS ichthyoplankton database
Cruise 199007 changed to 199008 as reported by NMFS ichthyoplankton database
Shipcode edit; removed two spaces between country code and ship code

18 November 2009

Decimal Latitude and Longitude decimal values recalculated to 5 decimal places from Lat_Deg+(Lat_Min/60) and Lon_Deg+(Lon_Min/60).
Updated online versions of database & csvs with recalculated lat & lon columns
Added xml and mysql dump download links.

21 October 2009

Cast_ID column in the Cast Table has been synchronized with the Ship_Code column from the Cast Table. Depth_ID column in the Bottle table has been synchronized with the Ship_Code column from the Cast Table.

14 May 2009

Correction were made to several 0707 bottle data records after comparison plots with CTD profiles identified flyer

1 Jan 2008

CalCOFI Data Reports and IEH ascii files include data above line 76.7 when collected (usually during the winter and spring CalCOFIs)

8 Sep 2006

Cruz_Sta value does not include Ship Code. Current format is CCYYMMLLLLSSSS where CC is century (19 or 20); YYMM is the usual year-month cruise designation (ex 0602); LLLL is Line; SSSS is Sta. Line & Sta format include the "tenths" value ie Lines are not rounded: line 93 is reported as 93.3, line 87 is 86.7. Santa Barbara Basin is 81.8 46.9, not 82 47. These changes were necessary to distinguish SCCOOS stations from standard stations. This change is reflected in the 0602 IEH file. Please note that pre-2008 IEH data does not include data collected above line 76.7. This allows data collected on different ships occupying the same station to link. Some older cruises performed the hydrographic work and biological work on separate ships.
Order_Occ column added to Cast table. This will be backfilled from the zooplankton database since IEH data does not include this value until 2000.

20 Jan 2006

Added a standard station field to the Station_ID table. ST in the Stnd_Sta column flags the current 66 quarterly-sampled stations.
Fixed Cast_Data Table: Cruz_Num & Int_Chl errors fixed. Parsing error combined the fields for several 80s cruises
Metafile Description - definitions and format
Design Notes - comments on establishing a standard format and tables for the 50+ years of data

Comments - CalCOFI 1949 - 2009 IEH-formatted ascii files are sorted by cruise, parsed into two comma-delimited ascii files (cast information; bottle data), combined with CalCOFI Data Report calculated values, then imported into Access 2003. Some common corrections are required: the cruise YYMM designation such as 9801 are extracted from the IEH header. If that field is empty (common in early IEHs) the cruise designation (variable Cruz_Nam) is generated from Year and Month automatically. Any query that uses the cruise designation (Cruz_Nam) may not pull all data collected from early cruises so use date and ship instead. Another note - Gulf of California station latitudes & longitudes generate negative Line.Sta numbers using the CalCOFI Line.Sta from Lat.Lon algorithm. These data are not excluded so the Line & Sta fields are not always numeric but text since a “G” designation is reported in many IEHs for those stations. See design notes for additional info.
JRW 2009

CSV's

For users who need comma-separated value files of CalCOFI hydrographic bottle data and station information (both are used to create the Access database). The CSV's include 1949-201004 published data (version 30Aug2010). Header information can be found on the database definitions webpage.

Hydrographic Bottle data can be found in the Bottle.csv.
Station information and primary productivity data can be found in the cast.csv.

Ascii IEH's

For users who need IEH's which contain CalCOFI hydrographic bottle and station information in ascii format. These are in CalCOFI 128-column data archive format and are available in 2 versions:

observed data (YYMMarch.ieh)
observed data with interpolated standard levels (YYMMt.ieh)

The IEH format was developed as an archive format for the CalCOFI data. Prior to Aug 1995, columns 64-65 contained format alignment characters (Z*). Starting in 2006, the Station Id will report Line & Sta to tenths ie 81.8 46.9 instead of 82 47 or 86.7 100.0 instead of 87 100. This change was made to allow the inclusion of coastal SCCOOS station data with nearby standard station data. (IEH stands for "Is Everybody Happy?" coined by programmer David Newton.)

Combined Cruise Hydrographic Data Reports

For older reports, visit our old site.

0901 Data Report : A compilation of the physical, chemical, and biological data for the Winter 2009 CalCOFI Cruise.

0810 Data Report : A compilation of the physical, chemical, and biological data for the Fall 2008 CalCOFI Cruise.

0808 Data Report : A compilation of the physical, chemical, and biological data for the Summer 2008 CalCOFI Cruise.

0804 Data Report : A compilation of the physical, chemical, and biological data for the Spring 2008 CalCOFI Cruise.

0801 Data Report : A compilation of the physical, chemical, and biological data for the Winter 2008 CalCOFI Cruise.

0711 Data Report : A compilation of the physical, chemical, and biological data for the Fall 2007 CalCOFI Cruise.

0707 Data Report : A compilation of the physical, chemical, and biological data for the Summer 2007 CalCOFI Cruise.

0704 Data Report: A compilation of the physical, chemical, and biological data for the Spring 2007 CalCOFI Cruise.

0701 Data Report: A compilation of the physical, chemical, and biological data for the Winter 2007 CalCOFI Cruise.

0610 Data Report: A compilation of the physical, chemical, and biological data for the Fall 2006 CalCOFI Cruise.

0607 Data Report: A compilation of the physical, chemical, and biological data for the Summer 2006 CalCOFI Cruise.

0604 Data Report: A compilation of the physical, chemical, and biological data for the Spring 2006 CalCOFI Cruise.

0602 Data Report: A compilation of the physical, chemical, and biological data for the Winter 2006 CalCOFI Cruise.

0511 Data Report: A compilation of the physical, chemical, and biological data for the Fall 2005 CalCOFI Cruise.

0507 Data Report: A compilation of the physical, chemical, and biological data for the Summer 2005 CalCOFI Cruise.

0504 Data Report: A compilation of the physical, chemical, and biological data for the Spring 2005 CalCOFI Cruise.

0501 Data Report: A compilation of the physical, chemical, and biological data for the Winter 2005 CalCOFI Cruise.

0411 Data Report: A compilation of the physical, chemical, and biological data for the Fall 2004 CalCOFI Cruise.

0407 Data Report: A compilation of the physical, chemical, and biological data for the Summer 2004 CalCOFI Cruise.

0404 Data Report: A compilation of the physical, chemical, and biological data for the Spring 2004 CalCOFI Cruise.

0401 Data Report: A compilation of the physical, chemical, and biological data for the Winter 2004 CalCOFI Cruise.

0310 Data Report: A compilation of the physical, chemical, and biological data for the Fall 2003 CalCOFI Cruise.

0307 Data Report: A compilation of the physical, chemical, and biological data for the Summer 2003 CalCOFI Cruise.

0304 Data Report: A compilation of the physical, chemical, and biological data for the Spring 2003 CalCOFI Cruise.

0302 Data Report: A compilation of the physical, chemical, and biological data for the Winter 2003 CalCOFI Cruise.

0207 and 0211 Data Report: A Compilation of the physical, chemical, and biological data for the Summer and Fall 2002 CalCOFI Cruise.

0201 and 0204 Data Report: A compilation of the physical, chemical, and biological data for the Winter and Spring 2002 CalCOFI Cruise.

0107 and 0110 Data Report: A compilation of the physical, chemical, and biological data for the Summer and Fall 2001 CalCOFI Cruise.

0101 and 0104 Data Report: A compilation of the physical, chemical, and biological data for the Winter and Spring 2001 CalCOFI Cruise.

0007 and 0010 Data Report: A compilation of the physical, chemical, and biological data for the Summer and Fall 2000 CalCOFI Cruise.

0001 and 0004 Data Report: A compilation of the physical, chemical, and biological data for the Winter and Spring 2000 CalCOFI Cruise.

9908 and 9910 Data Report: A compilation of the physical, chemical, and biological data for the Summer and Fall 1999 CalCOFI Cruise.

9901 and 9904 Data Report: A compilation of the physical, chemical, and biological data for the Winter and Spring 1999 CalCOFI Cruise.

9807 and 9809 Data Report: A compilation of the physical, chemical, and biological data for the Summer and Fall 1998 CalCOFI Cruise.

9802 and 9804 Data Report: A compilation of the physical, chemical, and biological data for the Winter and Spring 1998 CalCOFI Cruise.

9707 and 9709 Data Report: A compilation of the physical, chemical, and biological data for the Summer and Fall 1997 CalCOFI Cruise.

9702 and 9704 Data Report: A compilation of the physical, chemical, and biological data for the Winter and Spring 1997 CalCOFI Cruise.

9608 and 9610 Data Report: A compilation of the physical, chemical, and biological data for the Summer and Fall 1996 CalCOFI Cruise.

9602 and 9604 Data Report: A compilation of the physical, chemical, and biological data for the Winter and Spring 1996 CalCOFI Cruise.