California Cooperative Oceanic Fisheries Investigations

CalCOFI Hydrographic Data are available as downloadable files in several formats (mdb, xml, csv, sql dump) or a queriable, online database:

• Queriable, abridged*, online version of the 1949-2009 database is available at db.calcofi.net. This is a developmental page and subject to change but all data extracted are from the published CalCOFI Data Reports and final data database. The search form will extract core hydrographic parameters such as temperature, salinity, oxygen, nutrients, and density vs depth, time, lat/lon. Biological parameters include chlorophyll and phaeopigments. The search results will display in tabular form and may be exported-downloaded as doc,xls, csv, & xml files.
  *primary productivity depth data, weather, cruise, ship, and metadata tables are not yet queriable online. Download the database files(s) for all data tables or visit DataZoo's online query page.
  
• 1949-2009 CalCOFI Hydrographic Data Report Database (< click to download the Microsoft Access 2003 version; last update 08Jul2010) includes final hydrographic data from 1949-2009 (0911). All online versions of the database includes final, published data only. A research version with preliminary data is available by request from the CalCOFI data manager.
• CSVs - 1949-2009 Database Cast & Bottle Tables as csvs (< click to download, ver. 08Jul2010)
• XML - 194903 to 200911 Cast and Bottle XML files - Cast and Bottle tables as separate XML files
• SQL - 194903 to 200911 Access to MySQL 'dump' SQL file - complete web version, includes Cast, Bottle, Cruise, Standard Station, Standard Depth, and metadata tables, uncompresses to over 870mb

Newest fixes and additions:

08 Jul 2010

Please refer to the 'Work Done' table in the database or SQL files.

2 Dec 2009

• Added Niskin bottle number column to bottle data table to facilitate matching CTD data to water sample data

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
  

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 current IEH data does not include data collected above line 77.

• 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

  • Relationships Tables - relational database links between tables

Comments - CalCOFI 1949 - 2008 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 12/18/2003