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.
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