Hakai ERDDAP
Easier access to scientific data
?    
Brought to you by Hakai

ERDDAP > tabledap > Data Access Form ?

Dataset Title:  Underway Surface Seawater and Marine Boundary Layer Observations Made from the
Alaska Marine Highway System M/V Columbia
Subscribe RSS
Institution:  University of Alaska Southeast, Alaska Coastal Rainforest Center,University of Washington Joint Institute for the Study of the Atmosphere,Hakai Institute,Alaska Department of Transportation   (Dataset ID: HakaiColumbiaFerryResearch)
Information:  Summary ? | License ? | FGDC | Metadata | Background (external link) | Subset | Files | Make a graph
 
Variable ?   Optional
Constraint #1 ?
Optional
Constraint #2 ?
   Minimum ?
   or a List of Values ?
   Maximum ?
 
 vessel_id ?      
   - +  ?
 Type_code ?      
   - +  ?
 time (UTC) ?          2017-10-25T19:30:24Z    2019-10-02T22:49:14Z
  < slider >
 PC_Date (PC Date (ddmmyy)) ?          10118    311217
 PC_time (PC Time (hhmmss)) ?          0    235959
 GPS_date (GPS Date (ddmmyy)) ?          19    311217
 GPS_time (GPS Time (hhmmss)) ?          0    235959
 latitude (degrees_north) ?          48.6215    59.4496
  < slider >
 longitude (degrees_east) ?          -135.7158    -122.511
  < slider >
 equ_temp (degree_Celsius) ?          0.0    26.11
 std_val (Std Val (ppm), ppm) ?          150.0    850.0
 CO2_abs (raw CO2 Absorbance) ?          0.0    0.18
 CO2_ppm (ppm) ?          -3.66    2047.14
 H2O_abs (Raw H2O Channel Absorbance) ?          0.0    0.0
 H2O_ppm (ppm) ?          0.0    0.0
 LICOR_temp_deg_C (degree_Celsius) ?          0.0    51.33
 LICOR_pressure_mbar (LICOR Pressure, mbar) ?          0.0    1032.65
 equ_differential_pressure_mbar (mbar) ?          -26.08    6.7
 H2O_flow (Seawater flow, L/min) ?          0.05    4.11
 LICOR_flow (mL/min) ?          -37.02    665.0
 equ_pump_speed (Equilibrator Pump Speed, rpm) ?          43.0    255.0
 vent_flow (mL/min) ?          -39.18    983.25
 atm_moisture_sensor ?          2.48    9.97
 equil_moisture_sensor ?          9.9    9.97
 drip_sensor ?          0.03    9.97
 cond_temp (degree_Celsius) ?          -0.19    20.94
 dry_box_temp (degree_Celsius) ?          -0.06    30.25
 deck_pressure (mbar) ?          982.15    1034.52
 raw_O2_uM (Raw Oxygen Concentration, uM) ?          0.0    1161.29
 raw_O2_Sat (%) ?          0.0    303.53
 O2_Temp (degree_Celsius) ?          0.0    30.17
 Cal_Phase ?          0.0    45.62
 TCPhase ?          0.0    45.16
 C1RPh ?          0.0    54.09
 C2RPh ?          0.0    9.07
 C1Amp ?          0.0    881.2
 C2Amp ?          0.0    791.8
 Raw_Temp ?          -180.8    709.8
 TSG_T (degree_Celsius) ?          0.0    22.74
 TSG_Conductivity (S/m) ?          0.0    4.92
 TSG_Salinity (PSU) ?          0.94    32.33
 Intake_T (degree_Celsius) ?          0.0    22.38
 calibrated_ATM_xCO2_dry (ppm) ?          378.79    449.87
 calibrated_SW_xCO2_dry (ppm) ?          29.5    1206.34
 ATM_pressure_for_ATM_xCO2 (mbar) ?          982.15    1034.52
 equilibrator_pressure (mbar) ?          981.99    1034.54
 ATM_pCO2_wet (uatm) ?          377.62    453.6
 SW_pCO2_wet_equil_T (uatm) ?          29.5    1198.73
 SW_pCO2_wet_SST (uatm) ?          29.32    1187.1
 O2 (umol/kg) ?          139.72    929.05
 O2sol (umol/kg) ?          209.01    376.08
 delta_O2 (umol/kg) ?          -149.21    624.77
 ATM_fCO2_wet (uatm) ?          376.25    451.88
 SW_fCO2_wet (uatm) ?          29.21    1182.53
 
Server-side Functions ?
 distinct() ?
? ("Hover here to see a list of options. Click on an option to select it.Hover here to see a list of options. Click on an option to select it.Hover here to see a list of options. Click on an option to select it.Hover here to see a list of options. Click on an option to select it.Hover here to see a list of options. Click on an option to select it.")

File type: (more information)

(Documentation / Bypass this form ? )
 
(Please be patient. It may take a while to get the data.)


 

The Dataset Attribute Structure (.das) for this Dataset

Attributes {
 s {
  vessel_id {
    String actual_range 
"ColumbiaFerry
ColumbiaFerry";
    String cf_role "trajectory_id";
    String ioos_category "Location";
  }
  Type_code {
    String _Unsigned "false";
    Byte actual_range 1, 7;
    String description "Equilibrator air sample = 1, Equilibrator drain air sample = 2, atmospheric air sample = 3, gas standard 1 = 4, gas standard 2 = 5, gas standard 3 = 6, gas standard 4 = 7.";
    String long_name "Type code for gas measurement sequence";
  }
  time {
    String _CoordinateAxisType "Time";
    Float64 actual_range 1.508959824e+9, 1.570056554e+9;
    String axis "T";
    String ioos_category "Time";
    String long_name "Date And Time (yyyy-mm-dd Hh:mm:ss)";
    String source_name "Date and time (yyyy-mm-dd hh:mm:ss)";
    String standard_name "time";
    String time_origin "01-JAN-1970 00:00:00";
    String time_precision "1970-01-01T00:00:00Z";
    String units "seconds since 1970-01-01T00:00:00Z";
  }
  PC_Date {
    Int32 actual_range 10118, 311217;
    String long_name "PC Date (ddmmyy)";
  }
  PC_time {
    Int32 actual_range 0, 235959;
    String long_name "PC Time (hhmmss)";
  }
  GPS_date {
    Int32 actual_range 19, 311217;
    String long_name "GPS Date (ddmmyy)";
  }
  GPS_time {
    Int32 actual_range 0, 235959;
    String long_name "GPS Time (hhmmss)";
  }
  latitude {
    String _CoordinateAxisType "Lat";
    Float32 actual_range 48.6215, 59.4496;
    String axis "Y";
    Float64 colorBarMaximum 90.0;
    Float64 colorBarMinimum -90.0;
    String ioos_category "Location";
    String long_name "Latitude";
    String standard_name "latitude";
    String units "degrees_north";
  }
  longitude {
    String _CoordinateAxisType "Lon";
    Float32 actual_range -135.7158, -122.511;
    String axis "X";
    Float64 colorBarMaximum 180.0;
    Float64 colorBarMinimum -180.0;
    String ioos_category "Location";
    String long_name "Longitude";
    String standard_name "longitude";
    String units "degrees_east";
  }
  equ_temp {
    Float32 actual_range 0.0, 26.11;
    String long_name "Equ Temp (deg C)";
    String units "degree_Celsius";
  }
  std_val {
    Float32 _FillValue NaN;
    Float32 actual_range 150.0, 850.0;
    String long_name "Std Val (ppm)";
    String units "ppm";
  }
  CO2_abs {
    Float32 actual_range 0.0, 0.18;
    String long_name "raw CO2 Absorbance";
  }
  CO2_ppm {
    Float32 actual_range -3.66, 2047.14;
    String long_name "Raw CO2 mole Fractions in Dry Air";
    String units "ppm";
  }
  H2O_abs {
    Float32 actual_range 0.0, 0.0;
    String long_name "Raw H2O Channel Absorbance";
  }
  H2O_ppm {
    Float32 actual_range 0.0, 0.0;
    String long_name "Raw H2O Channel Mole Fractions in Dry Air";
    String units "ppm";
  }
  LICOR_temp_deg_C {
    Float32 actual_range 0.0, 51.33;
    String long_name "LICOR Cell Temperature";
    String units "degree_Celsius";
  }
  LICOR_pressure_mbar {
    Float32 actual_range 0.0, 1032.65;
    String long_name "LICOR Pressure";
    String units "mbar";
  }
  equ_differential_pressure_mbar {
    Float32 actual_range -26.08, 6.7;
    Float64 colorBarMaximum 10.0;
    Float64 colorBarMinimum -10.0;
    String long_name "Equilibrator Differential Pressure";
    String units "mbar";
  }
  H2O_flow {
    Float32 actual_range 0.05, 4.11;
    String long_name "Seawater flow";
    String units "L/min";
  }
  LICOR_flow {
    Float32 actual_range -37.02, 665.0;
    String long_name "LICOR Flow";
    String units "mL/min";
  }
  equ_pump_speed {
    Float32 actual_range 43.0, 255.0;
    String long_name "Equilibrator Pump Speed";
    String units "rpm";
  }
  vent_flow {
    Float32 actual_range -39.18, 983.25;
    String long_name "Secondary Equilibrator Vent Flow Meter Reading";
    String units "mL/min";
  }
  atm_moisture_sensor {
    Float32 actual_range 2.48, 9.97;
    String long_name "Moisture Detector Reading for Sensor on Outlet of Atmospheric Sample Line through the Condenser.";
  }
  equil_moisture_sensor {
    Float32 actual_range 9.9, 9.97;
    String long_name "Moisture Detector Reading for Sensor on Outlet of Seawater Sample Line through the Condenser.";
  }
  drip_sensor {
    Float32 actual_range 0.03, 9.97;
    String long_name "Moisture Detector on the Inside Bottom of the Wet Box";
  }
  cond_temp {
    Float32 actual_range -0.19, 20.94;
    String description "Temperature at which condenser is set. Used to aid in removing water vapor from the gas stream.";
    String long_name "Temperature at which Condenser is set";
    String units "degree_Celsius";
  }
  dry_box_temp {
    Float32 actual_range -0.06, 30.25;
    String long_name "Dry Box Temperature";
    String units "degree_Celsius";
  }
  deck_pressure {
    Float32 _FillValue NaN;
    Float32 actual_range 982.15, 1034.52;
    String description "Druck barometer pressure located on the Columbia foredeck";
    String long_name "Deck Pressure";
    String units "mbar";
  }
  raw_O2_uM {
    Float32 actual_range 0.0, 1161.29;
    String description "Raw dissolved oxygen measurement from the Aanderaa 4330F in micro-mole per liter.";
    String long_name "Raw Oxygen Concentration";
    String units "uM";
  }
  raw_O2_Sat {
    Float32 actual_range 0.0, 303.53;
    String description "Raw dissolved oxygen percent saturation from the Aanderaa 4330F.";
    String long_name "Raw O2 Percentage of Saturation";
    String units "%";
  }
  O2_Temp {
    Float32 actual_range 0.0, 30.17;
    String long_name "Oxygen Sensor Temperature";
    String standard_name "temperature_of_sensor_for_oxygen_in_sea_water";
    String units "degree_Celsius";
  }
  Cal_Phase {
    Float32 actual_range 0.0, 45.62;
    String long_name "Calibrated phase from the Aanderaa 4330F";
  }
  TCPhase {
    Float32 actual_range 0.0, 45.16;
    String long_name "Temperature compensated phase from the Aanderaa 4330F";
  }
  C1RPh {
    Float32 actual_range 0.0, 54.09;
    String long_name "Phase measurement with blue excitation light from the Aanderaa 4330F";
  }
  C2RPh {
    Float32 actual_range 0.0, 9.07;
    String long_name "Phase measurement with red excitation light from the Aanderaa 4330F";
  }
  C1Amp {
    Float32 actual_range 0.0, 881.2;
    String long_name "Amplitude measurement with blue excitation light from the Aanderaa 4330F";
  }
  C2Amp {
    Float32 actual_range 0.0, 791.8;
    String long_name "Amplitude measurement with red excitation light from the Aanderaa 4330F";
  }
  Raw_Temp {
    Float32 actual_range -180.8, 709.8;
    String long_name "Voltage from Aanderaa 4330F thermistor bridge";
  }
  TSG_T {
    Float32 _FillValue NaN;
    Float32 actual_range 0.0, 22.74;
    String instrument "SBE 45 MicroTSG";
    String long_name "Sea Water Temperature";
    String standard_name "sea_surface_temperature";
    String units "degree_Celsius";
  }
  TSG_Conductivity {
    Float32 actual_range 0.0, 4.92;
    Float64 colorBarMaximum 40.0;
    Float64 colorBarMinimum 30.0;
    String instrument "SBE 45 MicroTSG";
    String long_name "Sea Water Electrical Conductivity";
    String standard_name "sea_water_electrical_conductivity";
    String units "S/m";
  }
  TSG_Salinity {
    Float32 _FillValue NaN;
    Float32 actual_range 0.94, 32.33;
    Float64 colorBarMaximum 37.0;
    Float64 colorBarMinimum 32.0;
    String instrument "SBE 45 MicroTSG";
    String long_name "Sea Water Practical Salinity";
    String standard_name "sea_water_practical_salinity";
    String units "PSU";
  }
  Intake_T {
    Float32 _FillValue NaN;
    Float32 actual_range 0.0, 22.38;
    String description "Surface temperature in degrees Celsius from the SBE 38 Digital Oceanographic Thermometer.";
    String instrument "SBE 38";
    String long_name "Water Intake Temperature";
    String standard_name "sea_surface_temperature";
    String units "degree_Celsius";
  }
  calibrated_ATM_xCO2_dry {
    Float32 _FillValue NaN;
    Float32 actual_range 378.79, 449.87;
    String long_name "Calibrated Atmospheric CO2 mole Fractions in Dry Air";
    String units "ppm";
  }
  calibrated_SW_xCO2_dry {
    Float32 _FillValue NaN;
    Float32 actual_range 29.5, 1206.34;
    String long_name "Calibrated Seawater CO2 mole Fractions in Dry Air";
    String units "ppm";
  }
  ATM_pressure_for_ATM_xCO2 {
    Float32 _FillValue NaN;
    Float32 actual_range 982.15, 1034.52;
    String long_name "Atmospheric Pressure adjusted for Water Vapor Pressure and Over/Under-Pressurization in the Vessel and used to Compute Atmospheric pCO2";
    String units "mbar";
  }
  equilibrator_pressure {
    Float32 _FillValue NaN;
    Float32 actual_range 981.99, 1034.54;
    String long_name "Pressure of Equilibration\tCorrected for Vapor Pressure and Over/Under-Pressurization in the Equilibrator and Over/Under-Pressurization in the Vessel and used to compute Seawater pCO2";
    String units "mbar";
  }
  ATM_pCO2_wet {
    Float32 _FillValue NaN;
    Float32 actual_range 377.62, 453.6;
    String long_name "Atmospheric partial pressure of carbon dioxide";
    String standard_name "surface_partial_pressure_of_carbon_dioxide_in_air";
    String units "uatm";
  }
  SW_pCO2_wet_equil_T {
    Float32 _FillValue NaN;
    Float32 actual_range 29.5, 1198.73;
    String long_name "Partial pressure of carbon dioxide in Sea Water at Equilibration Temperature";
    String standard_name "surface_partial_pressure_of_carbon_dioxide_in_sea_water";
    String units "uatm";
  }
  SW_pCO2_wet_SST {
    Float32 _FillValue NaN;
    Float32 actual_range 29.32, 1187.1;
    String long_name "Surface Partial Pressure of Carbon Dioxide in Sea Water at Sea Surface Temperature";
    String standard_name "surface_partial_pressure_of_carbon_dioxide_in_sea_water";
    String units "uatm";
  }
  O2 {
    Float32 _FillValue NaN;
    Float32 actual_range 139.72, 929.05;
    String description "Salinity and density corrected dissolved oxygen in micro-mole per kilogram from the Aanderaa 4330F.\tDensity was calculated using temperature and salinity from the SBE 45 MicroTSG Thermosalinograph.";
    String long_name "Dissolved Oxygen Molaire Concentration per kg";
    String standard_name "moles_of_oxygen_per_unit_mass_in_sea_water";
    String units "umol/kg";
  }
  O2sol {
    Float32 _FillValue NaN;
    Float32 actual_range 209.01, 376.08;
    String description "Dissolved oxygen solubility in micro-mole per kilogram calculated using seawater temperature and salinity from the SBE 45 MicroTSG Thermosalinograph with the relationship (equation 8, combined fit) from Garcia and Gordon, 1992.";
    String long_name "Dissolved Oxygen Molaire Concentration per kg at Saturation";
    String units "umol/kg";
  }
  delta_O2 {
    Float32 _FillValue NaN;
    Float32 actual_range -149.21, 624.77;
    String long_name "Dissolved Oxygen Molaire Concentration Difference to Solubility";
    String units "umol/kg";
  }
  ATM_fCO2_wet {
    Float32 _FillValue NaN;
    Float32 actual_range 376.25, 451.88;
    String long_name "Atmospheric CO2 Fugacity in Wet Air";
    String units "uatm";
  }
  SW_fCO2_wet {
    Float32 _FillValue NaN;
    Float32 actual_range 29.21, 1182.53;
    String long_name "Seawater CO2 Fugacity in Wet Air";
    String standard_name "fugacity_of_carbon_dioxide_in_sea_water";
    String units "uatm";
  }
 }
  NC_GLOBAL {
    String cdm_data_type "Trajectory";
    String cdm_trajectory_variables "vessel_id";
    String contributor_contact "wiley.evans at hakai.org";
    String contributor_name "Wiley Evans";
    String contributor_role "Primary Investigator";
    String Conventions "COARDS, CF-1.6, ACDD-1.3";
    String date_created "2017-10-25";
    Float64 Easternmost_Easting -122.511;
    String featureType "Trajectory";
    Float64 geospatial_lat_max 59.4496;
    Float64 geospatial_lat_min 48.6215;
    String geospatial_lat_units "degrees_north";
    Float64 geospatial_lon_max -122.511;
    Float64 geospatial_lon_min -135.7158;
    String geospatial_lon_units "degrees_east";
    String geospatial_vertical_max "2.0";
    String geospatial_vertical_min "2.0";
    String history 
"2022-10-06T16:26:49Z (local files)
2022-10-06T16:26:49Z https://catalogue.hakai.org/erddap/tabledap/HakaiColumbiaFerryResearch.html";
    String infoUrl "https://www.hakai.org";
    String institution "University of Alaska Southeast, Alaska Coastal Rainforest Center,University of Washington Joint Institute for the Study of the Atmosphere,Hakai Institute,Alaska Department of Transportation";
    String instrument "Aanderaa 4330F Oxygen Optode,SBE 38 ,SBE 45,General Oceanics 8050 pCO2 Measuring System with LI-COR LI-840A";
    String keywords "Alaska, Alaska Marine Highway, carbone, Comlumbia Ferry, conductivity, inorganicCarbon, oxygen, partial pressure, pco2, salinity, seaSurfaceSalinity, seaSurfaceTemperature, temperature";
    String license 
"The data may be used and redistributed for free but is not intended
for legal use, since it may contain inaccuracies. Neither the data
Contributor, ERD, NOAA, nor the United States Government, nor any
of their employees or contractors, makes any warranty, express or
implied, including warranties of merchantability and fitness for a
particular purpose, or assumes any legal liability for the accuracy,
completeness, or usefulness, of this information.";
    Float64 Northernmost_Northing 59.4496;
    String platform "ship";
    String platform_vocabulary "https://vocab.nerc.ac.uk/collection/L06/current/";
    String sourceUrl "(local files)";
    Float64 Southernmost_Northing 48.6215;
    String standard_name_vocabulary "CF Standard Name Table v77";
    String subsetVariables "vessel_id,Type_code";
    String summary "Between October 2017 and October 2019, underway surface water measurements were collected from the Alaska Marine Highway System M/V Columbia during 135 service route transits. The service route of the Columbia included the ports of Sitka, Juneau, Haines, Skagway, Wrangell, Petersburg, and Ketchikan in southeast Alaska, and between Ketchikan and Bellingham, WA. The vessel sailed south from Ketchikan every Wednesday, arrived in Bellingham on Friday, returned to Ketchikan on Sunday, and transited between southeast Alaska terminals between Sunday and Wednesday. Measurements of temperature, salinity, dissolved oxygen content, and CO2 partial pressure were made every 2 mins on seawater drawn into the vessel from a ~2 m intake. Seawater was delivered from the intake to analytical equipment on the car deck using a AMT 1/2 HP pump (4295-98). Temperature and salinity data were collected using a Sea-Bird SBE 45 MicroTSG Thermosalinograph, and intake temperature measured using a SBE 38 Digital Oceanographic Thermometer. Dissolved oxygen content was determined using an Aanderaa 4330F that had undergone multipoint calibration at the factory in Norway. CO2 measurements were made using a General Oceanics 8050 (GO8050) pCO2 Measuring System equipped with a LI-COR LI840A non-dispersive infrared detector. All data streams, including GPS information from an antenna and atmospheric pressure from a Vaisala barometer positioned on the foredeck, were captured by the GO8050 control computer. Atmospheric CO2 measurements were also made using the GO8050 on unaltered marine air drawn to the system through an intake located on the foredeck. The CO2 measurement scheme involved the analysis of four gas standards of known CO2 content (150 ppm, 349 ppm, 449 ppm, and 850 ppm; Praxair Distributions Inc), 12 analyses atmospheric CO2, and 240 seawater CO2 measurements in a 8.5 hour period. The atmospheric and seawater CO2 analyses were run in a sequence of 3 atmospheric measurements and 60 seawater measurements that was repeated 4 times between standardization. This project was supported by the Tula Foundation and Alaska Ocean Observing System, and was a collaborative effort between the Hakai Institute, University of Washington Joint Institute for the Study of the Atmosphere and Ocean/NOAA Pacific Marine Environmental Laboratory, State of Alaska Department of Transportation, University of Alaska Southeast Alaska Coastal Rainforest Center, and the Alaska Ocean Observing System.";
    String time_coverage_end "2019-10-02T22:49:14Z";
    String time_coverage_start "2017-10-25T19:30:24Z";
    String title "Underway Surface Seawater and Marine Boundary Layer Observations Made from the Alaska Marine Highway System M/V Columbia";
    Float64 Westernmost_Easting -135.7158;
  }
}

 

Using tabledap to Request Data and Graphs from Tabular Datasets

tabledap lets you request a data subset, a graph, or a map from a tabular dataset (for example, buoy data), via a specially formed URL. tabledap uses the OPeNDAP (external link) Data Access Protocol (DAP) (external link) and its selection constraints (external link).

The URL specifies what you want: the dataset, a description of the graph or the subset of the data, and the file type for the response.

Tabledap request URLs must be in the form
https://coastwatch.pfeg.noaa.gov/erddap/tabledap/datasetID.fileType{?query}
For example,
https://coastwatch.pfeg.noaa.gov/erddap/tabledap/pmelTaoDySst.htmlTable?longitude,latitude,time,station,wmo_platform_code,T_25&time>=2015-05-23T12:00:00Z&time<=2015-05-31T12:00:00Z
Thus, the query is often a comma-separated list of desired variable names, followed by a collection of constraints (e.g., variable<value), each preceded by '&' (which is interpreted as "AND").

For details, see the tabledap Documentation.


 
ERDDAP, Version 2.18
Disclaimers | Privacy Policy | Contact