CalCOFI 1m CTD Database 1993-2019

The CalCOFI time-series officially started in 1949. We performed hydrographic bottle casts from 1949 until mid-1993, when we adopted a Seabird 911 CTD with 24 bottle rosette. Since CalCOFI 9308NH, continuous vertical profile data were acquired to 515m bottom depth-permitting. These data are available here in various formats to accomodate the end users. SIO-CalCOFI uses Microsoft Access as their relational database for data processing and quality control. Unfortunately, Microsoft Access has a 2 gigabyte filesize limit so it is necessary to split the upcast & downcast into two MS Access databases. 2024 update: a single upcast+downcast SQL Server Express Database is now available. Bottle data, used to correct the sensor data, are appended at the matching depths. Please refer to the CTD database readme files for column format information or refer to the database index page HERE.

1. Microsoft SQL Server Express - both upcast and downcast in a single relational SQL database
   • 1993-2019 1m CTD Final Data, SQL Server Express Database Backup (as bak, refer to readme in the zip file)
2. Microsoft Access Databases - the upcast and downcast 1m bin-averaged CTD data combined with bottle data, when available. Splitting the upcast and downcast into separate databases is necessary to have Aug 1993 - Dec 2019 data in one table.
   • 1993-2019 1m Upcast & Downcast CTD Final Data Access Databases (two .accdb files zipped)
3. CSVs - exporting the two Access tables into csvs allows end users to import them into any database
   • 1993-2019 1m CTD Final CTD Data Upcast & Downcast CSVs (two .csv files, zipped)
4. SQLs - SQL dump files of the two MS Access tables in SQL format allows end users to import them into any database
   • 1993-2019 1m CTD Final Data SQL (upcast & downcast tables SQL dumped then zip into a single distribution file)
5. Entire time-series hydrographic bottle database from 1949-2021 is available at calcofi.org HERE

Upcast & downcast 1m binavg CTD csv files are generated each cruise. Once certified final ie gone through the SIO-CalCOFI data-quality processing, these data can be imported into the upcast or downcast database tables.

These files can be found in the db_csvs folder of the FinalQC CTD data files available on calcofi.org HERE

CalCOFI CTD Archive 1990-present

CalCOFI CTD Data are available in three zipped filetypes: Cast = raw Seabird cast files; Prelim = Seasoft-processed asc files; may include preliminary bottle-corrected CTD csvs Final = Seasoft-processed asc files with bottle data & bottle-corrected CTD data as CTD.csvs; database-ready upcast & downcast csvs. "FinalQC" files include additional quality-control code columns - latest format is 82-columns. These additional columns were added Nov 2015 but older cruises are being reprocessed so look for "finalQC" for the 82-column updated files.Final CTD data values should not change during the conversion from 65 to 82 columns. But data codes may be added to bad or missing sensor data (datacode '9') and questionable sensor data (datacode '8') in the corresponding "Q" column.

Please note that CTD data from Mar 1990 - 1991 were system & feasibility tests; 1992 CTD casts were performed on daily prodo stations only. The first complete cruise using the CTD-Rosette was August 1993 - CalCOFI 9308NH Another important note: the Windows-version of Seabird's SBE Data Processing Suite will not work on CTD data collected from 1990 to mid-1998. Those data must be processed by the DOS version of Seasoft, which can be successfully run in DOSBox on Windows 7 & 10.

104 Station or 113 Station Pattern Map (Winter & Spring)    |    75 Station Pattern Map (Summer & Fall)

Year

January

February

March

April

May

June

July

August

Sept.

October

Nov.

Dec.

Year

2021

Raw CTD Data Final 1m Binned

Raw CTD Data Prelim 1m Binned

2020

2020

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

2020

2019

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

2019

2018

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

2018

2017

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

2017

2016

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

2016

2015

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

2015

2014

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

2014

2013

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

2013

2012

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

2012

2011

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

2011

2010

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

2010

Year

January

February

March

April

May

June

July

August

Sept.

October

Nov.

Dec.

Year

2009

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

2009

2008

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

2008

2007

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

2007

2006

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

2006

2005

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

2005

2004

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

2004

2003

Raw CTD Data 0302JD Final Im Binned

Raw CTD Data 0304RR Final 1m 0304JD Final 1m

Raw CTD Data Final 1m Binned

Raw CTD Data Final 1m Binned

2003

2002

Raw CTD Data 0201JD Final 1m Binned

Raw CTD Data 0204JD Final 1m Binned

Raw CTD Data 0207NH Final 1m Binned

Raw CTD Data 0211NH Final 1m Binned

2002

2001

Raw CTD Data 0101JD Final 1m Binned

Raw CTD Data 0104JD Final 1m Binned

Raw CTD Data 0107NH Final 1m Binned

Raw CTD Data 0110NH Final 1m Binned

2001

2000

Raw CTD Data 0001NH Final 1m Binned

Raw CTD Data 0004JD Final 1m Binned

Raw CTD Data 0007NH Final 1m Binned

Raw CTD Data 0010NH Final 1m Binned

2000

Year

January

February

March

April

May

June

July

August

Sept.

October

Nov.

Dec.

Year

1999

Raw CTD Data 9901RR Final 1m Binned

Raw CTD Data 9904JD Final 1m Binned

Raw CTD Data 9908NH Final 1m Binned

Raw CTD Data 9910NH Final 1m Binned

1999

1998

Raw CTD Data 9802JD Final 1m Binned

Raw CTD Data 9803SP Final 1m Binned

Raw CTD Data 9804JD Final 1m Binned

Raw CTD Data 9805SP Final 1m Binned

Raw CTD Data 9806SP Final 1m Binned

Raw CTD Data 9807NH Final 1m Binned

Raw CTD Data 9808SP Final 1m Binned

Raw CTD Data  9809NH Final 1m Binned

Raw CTD Data 9810SP Final 1m Binned

Raw CTD Data 9811SP Final 1m Binned

Raw CTD Data 9812SP Final 1m Binned

1998

1997

Raw CTD Data 9702JD Final 1m Binned

Raw CTD Data 9704NH Final 1m Binned

Raw CTD Data 9707JD Final 1m Binned

Raw CTD Data 9709NH Final 1m Binned

Raw CTD Data

1997

1996

Raw CTD Data 9602JD Final 1m Binned

Raw CTD Data 9604JD Final 1m Binned

Raw CTD Data 9608NH Final 1m Binned

Raw CTD Data 9610RR Final 1m Binned

1996

1995

Raw CTD Data 9501JD Final 1m Binned

Raw CTD Data 9504NH Final 1m Binned

Raw CTD Data 9507JD Final 1m Binned

Raw CTD Data 9510NH Final 1m Binned

1995

1994

Raw CTD Data 9401JD Final 1m Binned

Raw CTD Data 9403JD Final 1m Binned

Raw CTD Data 9408NH Final 1m Binned

Raw CTD Data 9410NH Final 1m Binned

1994

1993

Test

Test

Raw CTD Data 9308NH Final 1m Binned

Raw CTD Data 9310NH Final 1m Binned

1993

1992

ProdoCast

Test01

ProdCast

ProdCast Test

1992

1991

Tests

Tests

Tests

Tests

1991

1990

Test

Test

1990

Year

January

February

March

April

May

June

July

August

Sept.

October

Nov.

Dec.

Year

First complete CalCOFI cruise using CTD-Rosette on all stations was 9308NH (Aug 1993). The Seabird 911 CTD was first tested in Mar 1990 (9003JD) but still under development. Niskin, Nansen, & "Wally" (in-house design by Walt Bryant & George Anderson) bottles with reversing thermometers were the primary method of seawater sampling until 9308NH. As confidence in data quality, time-series continuity and relability improved, the CTD-rosette was used for daily primary productivity sample collection casts (6 depths) in 1992: 9202JD, 9208NH, & 9210NH. Some older cruises may not have final data available since they are being reprocessed using the current data-processing methodology for data-format continuity. All raw Raw CTD Data data files are available but processed - either preliminary or final bottle-corrected - will be posted when completed.

Cruise Schedule

2022 Cruises: Tentative Schedule (dates subject to change, check back often)

• CalCOFI 2201RL• 5 - 29 January 2022 (25 DAS)  • CANCELED (COVID)  • FSV Reuben Lasker 
  • San Diego to San Diego • Loading begins 14 Dec 2021 TAMT • Offloading TBD TAMT
• CalCOFI 2204SH• 4 - 28 April (25 DAS)  • FSV Bell M. Shimada  • San Diego to San Francisco
  COVID test TBD • Loading 31 March - 1 April 2022 TAMT • Offloading 28-29 April SF (pier TBD)
• CalCOFI 2207 (ship TBD) • 10 - 25 July requested (16 DAS)  • RV TBD  • San Diego to San Diego
  COVID requirements TBD •  •
• CalCOFI 2211SR• 5 - 20 November (16 DAS)  •  RV Sally Ride • San Diego to San Diego
  COVID requirements TBD • Loading 3 - 4 Nov MarFac • Offloading 21 Nov MarFac

Completed Cruises:

• CalCOFI 2111SR • 31 Oct - 15 Nov 2021 (16 DAS)  •  RV Sally Ride  • San Diego to San Diego
  75 stations completed in 16 days at sea
• CalCOFI 2107SR •  16-31 July 2021 18July - 2 August (16 DAS)  • RV Sally Ride • San Diego to San Diego
  71 stations completed in 16 days at sea.  Cruise delayed 2.5 days due to vessel engineering issues
• CalCOFI 2104SH 2105SH • 4 - 14 May 2021 • FSV Bell M. Shimada
  44 stations completed in 11 days at sea.  Shortened and delayed cruise due to vessel mechanical issues
• CalCOFI 2101RL • 15 January - 5 February 2021  • FSV Reuben Lasker 
  77 stations completed in 22 days at sea
• CalCOFI 2010SR • 11-26 Oct 2020 (Sun-Mon; 16 DAS)  •  RV Sally Ride
  71 stations completed in 13 days at sea
• **ALL-FEMALE PANDEMIC CRUISE 2007SR ARTICLE**
• CalCOFI 2007SR• 13-27 July 2020 (Mon-Mon; 15 DAS)  •  RV Sally Ride
    75 stations completed (9 SCCOOS) in 15 days at sea
• CalCOFI 2005SH  *CANCELED due to COVID-19*
• CalCOFI 2001RL • 04-27 Jan 2020 (Sat-Mon; 24 DAS)  •  FSV Reuben Lasker
    104 stations completed (9 SCCOOS) in 24 days at sea
• CalCOFI 1911OC • 04-19 Nov 2019 (Mon-Tue; 16 DAS)  •  RV Oceanus
  RV Oceanus completed 75 stations (9 SCCOOS) in 16 days at sea
• CalCOFI 1907BH • 11-26 Jul 2019 (Thu-Fri; 16 DAS)  •  RV Bold Horizon
  RV Bold Horizon completed 70 stations (8 SCCOOS) in 16 days at sea
• CalCOFI 1904RL • Leg 1: 02-18 Apr 2019 (Tue-Thu; 17 DAS) •  RV Reuben Lasker
  FSV Reuben Lasker completed 69 stations (8 SCCOOS) in 17 days at sea
• CalCOFI 1901RL 1902RL   • 6-13 Feb 2019 (Wed-Wed; 8 DAS)•  RV Reuben Lasker
  Delayed and abbreviated due to government shutdown(s). The abbreviated winter CalCOFI occupied 29 of 31 scheduled stations, surveying stations on Lines 90 & 80 out to 100; 83 & 87 out to 55, & Santa Barbara Basin (82.47) in the 8 days at sea. No Preliminary Plots this cruise due to lack of spatial coverage.

Read more: Cruise Schedule

Recent Trends

Recent California Current Ecosystem Data Reports from CalCOFI and Affiliates

• State of the California Current: Live Supplement Link
• 2018 Report:
  • State Of The California Current 2017–18: Still Not Quite Normal In The North And Getting Interesting In The South. Andrew R. Thompson, Isaac D. Schroeder, Steven J. Bograd, Elliott L. Hazen, Michael G. Jacox, Andrew Leising, Brian K. Wells, John L. Largier ,Jennifer L. Fisher, Kym Jacobson, Samantha Zeman, Eric P. Bjorkstedt, Roxanne R. Robertson, Francisco P. Chavez, Mati Kahru, Ralf Goericke, Sam Mcclatchie, Clare E. Peabody, Timothy R. Baumgartner, Bertha E. Lavaniegos, Jose Gomez-Valdes, Richard D. Brodeur, Elizabeth A. Daly, Cheryl A. Morgan, Toby D. Auth, Brian J. Burke, John Field, Keith Sakuma, Edward D. Weber, William Watson, Julia Coates, Ryan Schoenbaum, Laura Rogers-Bennett, Robert M. Suryan, Jane Dolliver, Stephanie Loredo, Jeannette E. Zamon, Stephanie R. Schneider, Richard T. Golightly, Pete Warzybok, Jaime Jahncke, Jarrod A. Santora, Sarah Ann Thompson, William Sydeman, Sharon R. Melin

• 2017 Report:
  • State of the California Current 2016-2017: Still Anything but “Normal” in the North. Brian K.Wells, Isaac D. Schroeder, Steven J. Bograd, Elliott L. Hazen, Michael G. Jacox,Andrew Leising, Nathan Mantua, Jarrod A. Santora, Jennifer Fisher,William.T. Peterson, Eric Bjorkstedt, Roxanne R. Robertson, Francisco  P. Chavez, Ralf Goericke, Raphael Kudela, Clarissa Anderson, Bertha E. Lavaniegos, Jose Gomez-Valdes, Richard D. Brodeur, Elizabeth A. Daly, Cheryl A. Morgan, Toby D.Auth, John C. Field, Keith Sakuma, Sam McClatchie, Andrew R.Thompson, Edward D.Weber, William Watson, Robert M. Suryan,  Julia Parrish, Jane Dolliver, Stephanie Loredo, Jessica M. Porquez, Jeannette E. Zamon, Stephanie R. Schneider, Richard T. Golightly, Pete Warzybok, Russell Bradley, Jaime Jahncke, William Sydeman, Sharon R. Melin, John A. Hildebrand, Amanda J. Debich, and Bruce Thayre

  Read more: Recent Trends

El Niño and La Niña

The graphic below is a reproduction from an article in which researchers at SIO are corroborating these predictions with observations. 

El Niño is an abnormal warming phase in the Pacific Ocean Sea Surface Temperature (SST), while the abnormal cooling is known as La Niña - these shifts are part of the El Niño Southern Oscillation or ENSO.  The current ENSO phase is often quantized by a deviation from normally observed SST using the Oceanic Niño Index or ONI. While El Niño and its counterpart cooling phase La Niña are still being researched, the seasonal effects are becoming well understood with long term data sets.

Using the table below from NOAA's Climate Prediction Center in conjunction with the CalCOFI database - can offer information on how the environment has reacted in response to the different phases and intensities of the ENSO. 

Read more: El Niño and La Niña