Obtaining CTD data from the WHOI Cruise Database:

  • 2) In the directory, click on ctd/ and then process/.
  • 3) The CTD data from each location is housed in 6 files (.asc, .bt1, .cnv, ..CON, .hdr, .ros). Download the .asc file as a .txt file.
  • 4) In Excel, go to File -> Import... and follow the step-by-step instructions to import each .asc (now a .txt) file.
  • 5) The column header abbreviations are defined in the .hdr file. The latitude and longitude are also found in the .hdr file.

    prDM: Pressure, Digiquartz [db]
    t090C: Temperature [ITS-90, deg C]
    c0S/m: Conductivity [S/m]
    c1S/m: Conductivity, 2 [S/m]
    sbeox0V: Oxygen Voltage, SBE 43
    xmiss: Beam Transmission, Chelsea/Seatech/Wetlab CStar [%]
    flECO-AFL: Fluorescence, Wetlab ECO-AFL/FL [mg/m^3]
    upoly0: Upoly 0, FLNTU turbidity
    density00: Density [density, Kg/m^3]
    density11: Density, 2 [density, Kg/m^3]
    sigma-t00: Density [sigma-t, Kg/m^3 ]
    sigma-t11: Density, 2 [sigma-t, Kg/m^3 ]
    potemp090C: Potential Temperature [ITS-90, deg C]
    potemp190C: Potential Temperature, 2 [ITS-90, deg C]
    sal00: Salinity [PSU]
    sal11: Salinity, 2 [PSU]
    sbeox0PS: Oxygen, SBE 43 [% saturation], WS = 2
    sbeox0Mm/Kg: Oxygen, SBE 43 [umol/Kg], WS = 2
    secS-priS: Salinity Difference, 2 - 1 [PSU]
    T2-T190C: Temperature Difference, 2 - 1 [ITS-90, deg C]
    C2-C1S/m: Conductivity Difference, 2 - 1 [S/m]
    svWM: Sound Velocity [Wilson, m/s]

Obtaining surface data from the WHOI Cruise Database:

  • 1) From the data directory, navigate to the folder underway/.
  • 2) Download the .csv files.
  • 3) In Excel, go to File -> Import... and import as a .csv file.