enzh-CNfrdeeliwitjakorues

The CTD Database is currently under reconstruction. 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 requires 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.  Original data values should not change, only the format 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 presented in the earlier formats. But when a sensor measurement is data coded "9", data derived for it will change to "NaN" - 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, the list of database-ready csvs will be updated.

 Please note that 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 the 2017 database csvs are available by request (This email address is being protected from spambots. You need JavaScript enabled to view it.) 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 file subset of CTDFinalQC complete archive: datacoded downcast bottle-corrected CTD data with bottle data csv & upcast bottle-corrected CTD data plus bottle data csv.
  • YY-YYMMSS_CTDFinalQC = standard final CTD & CTD+Btl data files available on Cruise Summary pages and Recent CTD Data page. It is also made available here since it includes the database-ready CTD+Btl csvs plus plots, CTD asc & hdr files and metadata. Individual station CTD+Btl.csvs, same database-ready format, are in the csv subdirectory. 
  • Under revision - YYYY_CTDFinalQC: includes all CTD+Btl csvs for the year in two files - upcast+bottle data, downcast+bottle data - these are currently being rebuilt, stay tuned
Year Winter Cruise Spring Cruise Summer Cruise Autumn Cruise
2017  20-1701RL_CTDFinalDB
20-1701RL_CTDFinalQC
     
2016  20-1601RL_CTDFinalDB
20-1601RL_CTDFinalQC
20-1604SH_CTDFinalDB
20-1604SH_CTDFinalQC
20-1607OS_CTDFinalDB
20-1607OS_CTDFinalQC

20-1611SR_CTDFinalDB
20-1611SR_CTDFinalQC

2015  20-1501NH_CTDFinalDB
20-1501NH_CTDFinalQC
20-1504NH_CTDFinalDB
20-1504NH_CTDFinalQC
20-1507OC_CTDFinalDB
20-1507OC_CTDFinalQC
20-1511OC_CTDFinalDB
20-1511OC_CTDFinalQC
2014  20-1402SH_CTDFinalDB
20-1402SH_CTDFinalQC
20-1404OS_CTDFinalDB
20-1404OS_CTDFinalQC
20-1407NH_CTDFinalDB
20-1407NH_CTDFinalQC
20-1411NH_CTDFinalDB
20-1411NH_CTDFinalQC
2013  20-1301SH_CTDFinalDB
20-1301SH_CTDFinalQC
20-1304SH_CTDFinalDB
20-1304SH_CTDFinalQC
20-1307NH_CTDFinalDB
20-1307NH_CTDFinalQC
20-1311NH_CTDFinalDB
20-1311NH_CTDFinalQC
2012  20-1202NH_CTDFinalDB
20-1202NH_CTDFinalQC
20-1203SH_CTDFinalDB
20-1203SH_CTDFinalQC
20-1207OS_CTDFinalDB
20-1207OS_CTDFinalQC
20-1210NH_CTDFinalDB
20-1210NH_CTDFinalQC
2011 20-1101NH_CTDFinalDB
20-1101NH_CTDFinalQC
20-1104SH_CTDFinalDB
20-1104SH_CTDFinalQC
20-1108NH_CTDFinalDB
20-1108NH_CTDFinalQC
20-1110NH_CTDFinalDB
20-1110NH_CTDFinalQC
2010 20-1001NH_CTDFinalDB
20-1001NH_CTDFinalQC
     
2009        
2008        
2007        
2006        
2005        

 

Go to top
DMC Firewall is developed by Dean Marshall Consultancy Ltd