• Address:
  705 Spear Street
  South Burlington, Vermont 05403
  United States of America
  
  Phone: (802) 391-4135
  Email: femc@uvm.edu
  Website: www.uvm.edu/femc

CTD profiles collected in Lake Champlain (Vermont, New York, Quebec) during research and outreach trips on University of Vermont's R/V Melosira between 2012 and 2021.

• dataset_eml_attributelistlabel: file_name

• dataset_eml_attributelistdescription: File name to link the metadata & profile data extracted from each cast's raw data (.CNV) file

• dataset_eml_attributeliststoragetype: text

• dataset_eml_attributelistmeasurementtype: nominal

• dataset_eml_attributelistlabel: sampleID

• dataset_eml_attributelistdescription: Unique sample ID based on the gear type, date, and CTD cast within that date in the format CTD_MMDDYYYY_#. Example: The third cast of the day on October 7, 2015 would have the sampleID CTD_10072015_3.

• dataset_eml_attributeliststoragetype: text

• dataset_eml_attributelistmeasurementtype: nominal

• dataset_eml_attributelistlabel: Year

• dataset_eml_attributelistdescription: Year cast was taken

• dataset_eml_attributeliststoragetype: date

• dataset_eml_attributelistmeasurementtype: datetime
• dataset_eml_attributelistformatstring: YYYY
• dataset_eml_attributelistnumbertype: -1

• dataset_eml_attributelistlabel: Date

• dataset_eml_attributelistdescription: Date the CTD cast was taken

• dataset_eml_attributeliststoragetype: date

• dataset_eml_attributelistmeasurementtype: datetime
• dataset_eml_attributelistformatstring: MM/DD/YY

• dataset_eml_attributelistlabel: Time

• dataset_eml_attributelistdescription: Start time of cast, local time

• dataset_eml_attributeliststoragetype: time

• dataset_eml_attributelistmeasurementtype: datetime
• dataset_eml_attributelistformatstring: hh:mm:ss

• dataset_eml_attributelistlabel: Basin

• dataset_eml_attributelistdescription: Lake Champlain major basin: Main Lake, Malletts Bay, or Inland Sea

• dataset_eml_attributeliststoragetype: text

• dataset_eml_attributelistmeasurementtype: nominal

• dataset_eml_attributelistlabel: Region

• dataset_eml_attributelistdescription: Lake Champlain region based on coordinates and/or field notes: North, Central, or South Main Lake; Inland Sea; Malletts Bay

• dataset_eml_attributeliststoragetype: text

• dataset_eml_attributelistmeasurementtype: nominal

• dataset_eml_attributelistlabel: Major management basin

• dataset_eml_attributelistdescription: Numeric description of major basin in Lake Champlain

• dataset_eml_attributeliststoragetype: text

• dataset_eml_attributelistmeasurementtype: nominal

• dataset_eml_attributelistlabel: Minor management basin

• dataset_eml_attributelistdescription: Numeric description of minor basin (within major basin) in Lake Champlain

• dataset_eml_attributeliststoragetype: text

• dataset_eml_attributelistmeasurementtype: nominal

• dataset_eml_attributelistlabel: Latitude

• dataset_eml_attributelistdescription: Latitude in decimal degrees (WGS84) for CTD cast; reported to 6 decimal places but may have been recorded to as few as 3 decimal places

• dataset_eml_attributeliststoragetype: decimal

• dataset_eml_attributelistmeasurementtype: interval
• dataset_eml_attributelistprecision: 0.001
• Unit: decimal degrees
• dataset_eml_attributelistnumbertype: rational
• dataset_eml_attributelistbounds:
• dataset_eml_attributelistboundsminimum: 44.144
• dataset_eml_attributelistboumdsmaximum: 45.003

• dataset_eml_attributelistlabel: Longitude

• dataset_eml_attributelistdescription: Longitude in decimal degrees (WGS84) for CTD cast; reported to 6 decimal places but may have been recorded to as few as 3 decimal places

• dataset_eml_attributeliststoragetype: decimal

• dataset_eml_attributelistmeasurementtype: ratio
• dataset_eml_attributelistprecision: 0.001
• Unit: decimal degrees
• dataset_eml_attributelistbounds:
• dataset_eml_attributelistboundsminimum: -73.414
• dataset_eml_attributelistboumdsmaximum: -73.054

• dataset_eml_attributelistlabel: Estimated Coordinates

• dataset_eml_attributelistdescription: A value of 1 indicates missing coordinates which were estimated based on site descriptions from R/V Melosira ship logs.

• dataset_eml_attributeliststoragetype: int

• dataset_eml_attributelistmeasurementtype: nominal

• dataset_eml_attributelistlabel: Depth [fresh water, m]

• dataset_eml_attributelistdescription: Depth in meters from the water surface. Measurements taken at negative depths (above water surface) have been removed.

• dataset_eml_attributeliststoragetype: decimal

• dataset_eml_attributelistmeasurementtype: ratio
• dataset_eml_attributelistprecision: 0.001
• Unit: Meters
• dataset_eml_attributelistnumbertype: rational
• dataset_eml_attributelistbounds:
• dataset_eml_attributelistboundsminimum: 0
• dataset_eml_attributelistboumdsmaximum: 122

• dataset_eml_attributelistlabel: Conductivity [mS/cm]

• dataset_eml_attributelistdescription: Conductivity measured in milliSiemens per centimeter

• dataset_eml_attributeliststoragetype: decimal

• dataset_eml_attributelistmeasurementtype: ratio
• dataset_eml_attributelistprecision: 0.000001
• Unit: milliSiemens per centimeter
• dataset_eml_attributelistnumbertype: rational
• dataset_eml_attributelistbounds:
• dataset_eml_attributelistboundsminimum: 0
• dataset_eml_attributelistboumdsmaximum: 0.938

• dataset_eml_attributelistlabel: Descent Rate [m/s]

• dataset_eml_attributelistdescription: Rate CTD descended in water column

• dataset_eml_attributeliststoragetype: decimal

• dataset_eml_attributelistmeasurementtype: ratio
• dataset_eml_attributelistprecision: 0.001
• Unit: meters per second
• dataset_eml_attributelistnumbertype: rational
• dataset_eml_attributelistbounds:
• dataset_eml_attributelistboundsminimum: 0
• dataset_eml_attributelistboumdsmaximum: 1.56

• dataset_eml_attributelistlabel: Time, Elapsed [seconds]

• dataset_eml_attributelistdescription: Time in seconds since start of CTD cast

• dataset_eml_attributeliststoragetype: time

• dataset_eml_attributelistmeasurementtype: ratio
• dataset_eml_attributelistprecision: 0.01
• Unit: Seconds
• dataset_eml_attributelistnumbertype: rational
• dataset_eml_attributelistbounds:
• dataset_eml_attributelistboundsminimum: 0
• dataset_eml_attributelistboumdsmaximum: 901.75

• dataset_eml_attributelistlabel: Salinity, Practical [PSU]

• dataset_eml_attributelistdescription: Salinity

• dataset_eml_attributeliststoragetype: decimal

• dataset_eml_attributelistmeasurementtype: ratio
• dataset_eml_attributelistprecision: 0.0001
• Unit: practical salinity units
• dataset_eml_attributelistnumbertype: rational
• dataset_eml_attributelistbounds:
• dataset_eml_attributelistboundsminimum: 0
• dataset_eml_attributelistboumdsmaximum: 0.74

• dataset_eml_attributelistlabel: Oxygen Saturation, Weiss [mL/L]

• dataset_eml_attributelistdescription: Recorded on SBE 43 Dissolved Oxygen Sensor

• dataset_eml_attributeliststoragetype: decimal

• dataset_eml_attributelistmeasurementtype: ratio
• dataset_eml_attributelistprecision: 0.00001
• Unit: milliliters per liter
• dataset_eml_attributelistnumbertype: rational
• dataset_eml_attributelistbounds:
• dataset_eml_attributelistboundsminimum: 4.23181
• dataset_eml_attributelistboumdsmaximum: 9.71769

• dataset_eml_attributelistlabel: Temperature [ITS-90, deg C]

• dataset_eml_attributelistdescription: Water temperature in degrees Celsius

• dataset_eml_attributeliststoragetype: decimal

• dataset_eml_attributelistmeasurementtype: interval
• dataset_eml_attributelistprecision: 0.0001
• Unit: degrees Celsius
• dataset_eml_attributelistnumbertype: rational
• dataset_eml_attributelistbounds:
• dataset_eml_attributelistboundsminimum: 1.7846
• dataset_eml_attributelistboumdsmaximum: 27.8008

• dataset_eml_attributelistlabel: PAR/Irradiance, Biospherical/Licor

• dataset_eml_attributelistdescription: Measured with LI-193 Spherical Quantum Sensor

• dataset_eml_attributeliststoragetype: decimal

• dataset_eml_attributelistmeasurementtype: ratio
• dataset_eml_attributelistprecision: 0.000001
• dataset_eml_attributelistnumbertype: rational
• dataset_eml_attributelistbounds:
• dataset_eml_attributelistboundsminimum: 0.026739
• dataset_eml_attributelistboumdsmaximum: 4265.1

• dataset_eml_attributelistlabel: Fluorescence, WET Labs WETstar

• dataset_eml_attributeliststoragetype: decimal

• dataset_eml_attributelistmeasurementtype: ratio
• dataset_eml_attributelistprecision: 0.0001
• Unit: mg/m^3
• dataset_eml_attributelistnumbertype: rational
• dataset_eml_attributelistbounds:
• dataset_eml_attributelistboundsminimum: 0
• dataset_eml_attributelistboumdsmaximum: 18.8606

• dataset_eml_attributelistlabel: Scan

• dataset_eml_attributelistdescription: Sequential scan number recorded during each cast, as an index for when each row of data was collected. Only present for some years.

• dataset_eml_attributeliststoragetype: int

• dataset_eml_attributelistmeasurementtype: ratio
• dataset_eml_attributelistnumbertype: integer
• dataset_eml_attributelistbounds:
• dataset_eml_attributelistboundsminimum: 1
• dataset_eml_attributelistboumdsmaximum: 999

• dataset_eml_attributelistlabel: Flag

• dataset_eml_attributelistdescription: Measurements with data outside normal value ranges are flagged with 1.

• dataset_eml_attributeliststoragetype: int

• dataset_eml_attributelistmeasurementtype: nominal

• Collect profile data w/ SeaBird
  • dataset_eml_methoddescription: Deploy SeaBird CTD from ship
  dataset_eml_methodsInstrumentation: SeaBird SBE 19Plusdataset_eml_methodsSoftware: Seaterm and SBEDataProcessing (free download from Seabird website)

• Process data
  • dataset_eml_methoddescription: Process data by creating 1-m depth bins and saving as a .cnv file
  dataset_eml_methodsInstrumentation: SeaBird SBE 19Plusdataset_eml_methodsSoftware: Seaterm and SBEDataProcessing (free download from Seabird website)

• Check & combine data in R
  • dataset_eml_methoddescription: Import .cnv files, extract metadata, check water column data, and save combined, larger dataframes as .csv files
  dataset_eml_methodsSoftware: R with 2 scripts

• Upload data into Access
  • dataset_eml_methoddescription: Import .csv files into two Access tables: metadata (1 row per cast) and water column data (each measurement of the cast)
  dataset_eml_methodsSoftware: Microsoft Access

• Export full dataset into Excel
  • dataset_eml_methoddescription: In Access, we fully join metadata and profile data, where each single measurement is associated with metadata. Export into Excel for easier sharing.
  dataset_eml_methodsSoftware: Microsoft Excel