CTD Database

The CTD final data database from 1993-2019 is finished and available to download. (this page was imported from calcofi.org’s old website, now calcofi.com. This will be updated to the current website format soon.)

The three zip files below contain the final bottle-corrected, Seasoft-processed CTD data from CalCOFI cruises from 1993-2019. These have been reprocessed into the current 84-col CTD csv format adopted by CalCOFI using data-quality codes-flags. 2020+ cruise csvs should import into these tables without issue. SIO-CalCOFI uses Microsoft Access as their relational database and that is the format distributed.

Download:

 

Please note – these files are distributed in decade-based databases because MS Access has a 2gb limit on table size. A complete CTD database should be imported into a relational database like MySQL that does not have this limitation. Exporting these individual databases in sql format from MS Access would facilitate the migration to a non-Access database. MS Access does allow linking separate databases so this method could be used to keep these data in MS Access tables for queries.

Archives are below – these are the individual cruise csvs used to create the above database files. For the complete 1993-2019 csv table visit this webpage

The files on this web page are database-import-ready csvs which combine 1m bin-averaged CTD sensor data with rosette bottle data. The addition of data-quality code columns required older (than 2013) archived cruises be reformatted with data code columns added. Currently, the original CTD+bottle data 62-column data files (YY-YYMMSS_CTDFinal.zip) are being reprocessed to insure consistency of the csv format. Data codes (see the CTD Database Index for key) are added to the QC columns to flag bad or questionable CTD sensor data. These data-quality codes may be used to exclude bad or questionable data during queries.  Bad, missing or questionable data values may be changed to -99.0 or NaN, plus the number of columns has increased from 62 to 82 columns.

CTD data archives labeled with “QC” (YY-YYMMSS_FinalQC.zip) or “DB” (YY-YYMMSS_FinalDB.zip) are the latest format. Individual database-ready csvs will be available for each cruise so users can update an existing database on whatever platform they prefer. The addition of these new columns should not change the data values presented in the earlier formats although bad data may be nulled (NaN or -99.0). Additionally, when a sensor primary measurement is data coded “9”, any data derived from it will change to “NaN” or “-99.0” – estimated NO3 from the ISUS sensor, for example. Refer to the CTD Database Index and the CTD.csv with QC Index pages for columns and descriptions. As older CTD data are reprocessed to add the QC columns and data codes, this table listing database-ready csvs will be updated.

Additionally, filenames have or will change to match the current CTD data distribution format. CTD.csvs processed with IEH-formatted bottle data (all cruises prior to 2012) will have an I denoting “IEH” in the filenames before “D.csv” or “U.csv“: e.g. 20-1104SH_093301200_049Id.csv.
Preliminary versions of newer database csvs are available by request (www@calcofi.com) but this page only lists final versions.

Two versions of the CTD final data for each cruise (YY-YY is year, MM is month, SS is ship code):

 

    • YY-YYMMSS_CTDFinalDB = two (all upcasts merged & all downcasts merged) CTD.csvs. Example: 20-1708SR_CTDFinalDB includes the downcast bottle-corrected CTD data csv 20-1708SR_CTDBTL_001-073D & upcast bottle-corrected CTD data csv 20-1708SR_CTDBTL_001-073U. Please note the “001-073” refers to the cast numbers and can be different for each cruise. When different bottle-correction coefficients are applied to specific casts, there will be separate downcast & upcasts csvs for each group. For example, 20-1708SR_CTDBTL_001-025D would be downcast data for casts 001-025 & 20-1708SR_CTDBTL_026-073D is downcast data for casts 026-073.

    • YY-YYMMSS_CTDFinalQC is the complete CTD+Bottle data archive: our standard CTD plus bottle-corrected CTD final data file distributed on Cruise Summary pages and Recent CTD Data page. It is also made available here since it includes the FinalDB csvs plus much more such as plots, CTD asc & hdr files and metadata. The individual station CTD.csvs, in same database-ready format, are in the csvs-plots subdirectory. 

Year Winter Cruise Spring Cruise Summer Cruise Autumn Cruise
2020        
2019 20-1902RL_CTDFinalDB
(CTDFinalQC)
20-1904RL_CTDFinalDB
(CTDFinalQC)
20-1907BH_CTDFinalQC
(CTDFinalDB included)
20-1911OCC_CTDFinalQC
(CTDFinalDB included)
2018 20-1802SH_CTDFinalDB
(CTDFinalQC)
20-1804SH_CTDFinalDB
(CTDFinalQC)
20-1806SR_CTDFinalDB
(CTDFinalQC)
20-1810SR_CTDFinalDB
(CTDFinalQC)
2017  20-1701RL_CTDFinalDB
(CTDFinalQC)
20-1704SH_CTDFinalDB
(CTDFinalQC)
20-1708SR_CTDFinalDB
(CTDFinalQC)
20-1711SR_CTDFinalDB
(CTDFinalQC)
2016  20-1601RL_CTDFinalDB
(CTDFinalQC)
20-1604SH_CTDFinalDB
(CTDFinalQC)
20-1607OS_CTDFinalDB
(CTDFinalQC)
20-1611SR_CTDFinalDB
(CTDFinalQC)
2015  20-1501NH_CTDFinalDB
(CTDFinalQC)
20-1504NH_CTDFinalDB
(CTDFinalQC)
20-1507OC_CTDFinalDB
(CTDFinalQC)
20-1511OC_CTDFinalDB
(CTDFinalQC)
2014  20-1402SH_CTDFinalDB
(CTDFinalQC)
20-1404OS_CTDFinalDB
(CTDFinalQC)
20-1407NH_CTDFinalDB
(CTDFinalQC)
20-1411NH_CTDFinalDB
(CTDFinalQC)
2013  20-1301SH_CTDFinalDB
(CTDFinalQC)
20-1304SH_CTDFinalDB
(CTDFinalQC)
20-1307NH_CTDFinalDB
(CTDFinalQC)
20-1311NH_CTDFinalDB
(CTDFinalQC)
2012  20-1202NH_CTDFinalDB
(CTDFinalQC)
20-1203SH_CTDFinalDB
(CTDFinalQC)
20-1207OS_CTDFinalDB
(CTDFinalQC)
20-1210NH_CTDFinalDB
(CTDFinalQC)
2011  20-1101NH_CTDFinalDB
(CTDFinalQC)
20-1104SH_CTDFinalDB
(CTDFinalQC)
20-1108NH_CTDFinalDB
(CTDFinalQC)
20-1110NH_CTDFinalDB
(CTDFinalQC)
2010  20-1001NH_CTDFinalDB
(CTDFinalQC)
20-1004MF_CTDFinalDB
(CTDFinalQC)
20-1008NH_CTDFinalDB
(CTDFinalQC)
20-1011NH_CTDFinalDB
(CTDFinalQC)
2009 20-0907M2_CTDFinalDB
(CTDFinalQC)
20-0903JD_CTDFinalDB
(CTDFinalQC)
20-0907M2_CTDFinalDB
(CTDFinalQC)
20-0911NH_CTDFinalDB
(CTDFinalQC)
2008 20-0801JD_CTDFinalDB
(CTDFinalQC)
20-0804JD_CTDFinalDB
(CTDFinalQC)
20-0808NH_CTDFinalDB
(CTDFinalQC)
20-0810NH_CTDFinalDB
(CTDFinalQC)
2007 20-0701JD_CTDFinalDB
(CTDFinalQC)
20-0704JD_CTDFinalDB
(CTDFinalQC)
20-0707NH_CTDFinalDB
(CTDFinalQC)
20-0711NH_CTDFinalDB
(CTDFinalQC)
2006 20-0602JD_CTDFinalDB
(CTDFinalQC)
20-0604NH_CTDFinalDB
(CTDFinalQC)
20-0607NH_CTDFinalDB
(CTDFinalQC)  
20-0610RR_CTDFinalDB
(CTDFinalQC)
2005 20-0501NH_CTDFinalDB
(CTDFinalQC)
20-0504NH_CTDFinalDB
(CTDFinalQC)
20-0507NH_CTDFinalDB
(CTDFinalQC)
20-0511NH_CTDFinalDB
(CTDFinalQC)
2004 20-0401JD_CTDFinalDB
(CTDFinalQC)
20-0404NHJD_CTDFinalDB
(CTDFinalQC)
20-0407JD_CTDFinalDB
(CTDFinalQC)
20-0411RR_CTDFinalDB
(CTDFinalQC)
2003 20-0302JD_CTDFinalDB
(CTDFinalQC)
20-0304RR_CTDFinalDB
(CTDFinalQC)
20-0307NH_CTDFinalDB
(CTDFinalQC)
20-0310NH_CTDFinalDB
(CTDFinalQC)
2002 20-0201JD_CTDFinalDB
(CTDFinalQC)
20-0204JD_CTDFinalDB
(CTDFinalQC)
20-0207NH_CTDFinalDB
(CTDFinalQC)
20-0211NH_CTDFinalDB
(CTDFinalQC)
2001     20-0107NH_CTDFinalDB
(CTDFinalQC)
20-0111NH_CTDFinalDB
(CTDFinalQC)