CRITFC-CMOP CMOP ERDDAP
Columbia River observations and predictions

ERDDAP > tabledap > Data Access Form ?

Dataset Title:  Oceanographic data collected from Saturn Estuary Station 03 by Center for
Coastal Margin Observation and Prediction (CMOP) and assembled by Northwest
Association of Networked Ocean Observation Systems (NANOOS) in the Columbia
River Estuary and North East Pacific Ocean
Subscribe RSS
Institution:  Oregon Health & Science University; Center for Coastal Margin Observation & Prediction   (Dataset ID: saturn03_1300_R_Oxygen)
Information:  Summary ? | License ? | FGDC | ISO 19115 | Metadata | Background (external link) | Subset | Files | Make a graph
 
Variable ?   Optional
Constraint #1 ?
Optional
Constraint #2 ?
   Minimum ?
   or a List of Values ?
   Maximum ?
 
 crs ?      
   - +  ?
 platform (Saturn Estuary Station 03) ?      
   - +  ?
 instrument (Oxygen sensor) ?      
   - +  ?
 timeSeries ?      
   - +  ?
 time (UTC) ?          2016-01-01T08:01:00Z    2024-05-20T09:43:00Z
  < slider >
 latitude (degrees_north) ?      
   - +  ?
  < slider >
 longitude (degrees_east) ?      
   - +  ?
  < slider >
 depth2 (cm) ?      
   - +  ?
 oxygensat (Oxygen saturation, percent) ?          -20.5804213359781    176.485259072584
 oxygensat_qc ?      
   - +  ?
 raw_oxygensat (percent) ?          -20.5804213359781    176.485259072584
 oxygen (Oxygen concentration, ml/l) ?          -1.46280352990466    13.3733636730358
 oxygen_qc ?      
   - +  ?
 raw_oxygen (ml/l) ?          -1.46280352990466    13.3733636730358
 
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 {
  crs {
    Float64 _FillValue 9.969209968386869e+36;
    String epsg_code "EPSG:4326";
    String grid_mapping_name "latitude_longitude";
    Float64 inverse_flattening 298.257223563;
    String ioos_category "Unknown";
    String long_name "CRS";
    Float64 semi_major_axis 6378137.0;
  }
  platform {
    Int32 _FillValue -2147483647;
    String cmop_name "saturn03";
    String ioos_category "Unknown";
    String long_name "Saturn Estuary Station 03";
    Int32 missing_value 2147483647;
    String ncei_code "317F";
    String ncei_name "FIXED PLATFORM, MOORINGS";
  }
  instrument {
    Int32 _FillValue -2147483647;
    String calibration_date "1970-1-1 0:00";
    String calibration_report "calibration date is a dummy value for testing purposes";
    String ioos_category "Dissolved O2";
    String long_name "Oxygen sensor";
    String make_model "Sea-Bird Electronics/SBE 43";
    Int32 missing_value 2147483647;
    String platform "platform";
    String serial_number "SBE2310";
  }
  timeSeries {
    Int32 _FillValue 2147483647;
    Int32 actual_range 2188, 4143;
    String associated_timeSeries "4141 4142 4144";
    String cf_role "timeseries_id";
    String comment "the associated_timeSeries attribute represents other deployment ids with the same instrument over the same time period, e.g. pumped from a different depth, calibration, etc.";
    String ioos_category "Identifier";
    String long_name "Deployment identifier, unique to instrument at a location from when deployed until retrieved from the field";
  }
  time {
    String _CoordinateAxisType "Time";
    Float64 actual_range 1.45163526e+9, 1.71619818e+9;
    String axis "T";
    String calendar "gregorian";
    String comment "Timestamps are added to the data when reaching SATURN01, SATURN03 or SATURN04 or MERTS.  If not originating at one of these stations, the data will have been transmitted over a radio link, introducing a small lag, generally less than 1 second.  Clocks at the SATURN/MERTS stations mentioned are maintained by NTP.";
    String coverage_content_type "coordinate";
    String ioos_category "Time";
    String long_name "Time";
    String standard_name "time";
    String time_origin "01-JAN-1970 00:00:00";
    String units "seconds since 1970-01-01T00:00:00Z";
  }
  latitude {
    String _CoordinateAxisType "Lat";
    Float64 _FillValue 9.969209968386869e+36;
    Float64 actual_range 46.19973, 46.19973;
    String axis "Y";
    Float64 colorBarMaximum 90.0;
    Float64 colorBarMinimum -90.0;
    String comment "Derived either by GPS measurements (for buoys) or by estimation from digital maps (for stations placed on existing structures visible on maps). For buoy stations, there is a watch circle which is different from buoy to buoy, but estimated precision is better than 10m error.";
    String coverage_content_type "coordinate";
    String ioos_category "Location";
    String long_name "Nominal latitude of measurement station";
    String standard_name "latitude";
    String units "degrees_north";
    Float64 valid_max 90.0;
    Float64 valid_min -90.0;
  }
  longitude {
    String _CoordinateAxisType "Lon";
    Float64 _FillValue 9.969209968386869e+36;
    Float64 actual_range -123.94001, -123.94001;
    String axis "X";
    Float64 colorBarMaximum 180.0;
    Float64 colorBarMinimum -180.0;
    String comment "Derived either by GPS measurements (for buoys) or by estimation from digital maps (for stations placed on existing structures visible on maps). For buoy stations, there is a watch circle which is different from buoy to buoy, but estimated precision is better than 10m error.";
    String coverage_content_type "coordinate";
    String ioos_category "Location";
    String long_name "Nominal longitude of measurement station";
    String standard_name "longitude";
    String units "degrees_east";
    Float64 valid_max 180.0;
    Float64 valid_min -180.0;
  }
  depth2 {
    Float64 _FillValue 9.969209968386869e+36;
    Float64 actual_range 1300.0, 1300.0;
    String axis "Z";
    Float64 colorBarMaximum 8000.0;
    Float64 colorBarMinimum -8000.0;
    String colorBarPalette "TopographyDepth";
    String comment "The nominal depth was measured relative to mean sea level.  Sea-level reference was established at a station by using a pressure sensor to generate an approximate depth record over a 1 month period (or longer), and then the local LLW depth is corrected by the LLW depth at Tongue Point relative to National Geodetic Vertical Datum of 1929 (NGVD29) to give a local depth relative to NGVD29.";
    String coverage_content_type "coordinate";
    String ioos_category "Location";
    String long_name "Nominal depth of measurement station";
    String positive "down";
    String standard_name "depth";
    String units "cm";
    Float64 valid_max 8000.0;
    Float64 valid_min -1000.0;
  }
  oxygensat {
    Float64 _FillValue 9.969209968386869e+36;
    String accuracy "2";
    Float64 actual_range -20.5804213359781, 176.485259072584;
    String ancillary_variables "platform instrument oxygensat_qc raw_oxygensat";
    Float64 colorBarMaximum 100.0;
    Float64 colorBarMinimum 0.0;
    String coverage_content_type "physicalMeasurement";
    String instrument "instrument";
    String ioos_category "Dissolved O2";
    String long_name "Oxygen saturation";
    String platform "platform";
    String standard_name "fractional_saturation_of_oxygen_in_sea_water";
    String temporal_drift "0.5";
    String units "percent";
    Float64 valid_max 120.0;
    Float64 valid_min 0.0;
    String varname "oxygensat";
  }
  oxygensat_qc {
    Byte _FillValue -127;
    String _Unsigned "false";
    Byte actual_range 2, 5;
    Float64 colorBarMaximum 10.0;
    Float64 colorBarMinimum 0.0;
    String flag_meanings "no_qc_performed good_data probably_good_data value_chaged bad_data_that_are_potentially_useful bad_data not_used not_used interpolated_value missing_value";
    Byte flag_values 0, 1, 2, 3, 4, 5, 6, 7, 8, 9;
    String ioos_category "Quality";
    String long_name "Oxygen saturation Quality Flag";
    String notes "Data greater than maximum valid value 180.0 preliminarily flagged bad";
    String standard_name "fractional_saturation_of_oxygen_in_sea_water status_flag";
    Byte valid_max 9;
    Byte valid_min 0;
  }
  raw_oxygensat {
    Float64 _FillValue 9.969209968386869e+36;
    String accuracy "2";
    Float64 actual_range -20.5804213359781, 176.485259072584;
    String ancillary_variables "platform instrument oxygensat_qc oxygensat";
    Float64 colorBarMaximum 150.0;
    Float64 colorBarMinimum 0.0;
    String coverage_content_type "physicalMeasurement";
    String instrument "instrument";
    String ioos_category "Quality";
    String long_name "Raw and uncorrected Oxygen saturation prior to qc processing that adjusted data values";
    String platform "platform";
    String standard_name "fractional_saturation_of_oxygen_in_sea_water";
    String temporal_drift "0.5";
    String units "percent";
    Float64 valid_max 120.0;
    Float64 valid_min 0.0;
    String varname "oxygensat";
  }
  oxygen {
    Float64 _FillValue 9.969209968386869e+36;
    String accuracy "greater of 3 or 2%";
    Float64 actual_range -1.46280352990466, 13.3733636730358;
    String ancillary_variables "platform instrument oxygen_qc raw_oxygen";
    Float64 colorBarMaximum 500.0;
    Float64 colorBarMinimum 0.0;
    String coverage_content_type "physicalMeasurement";
    String instrument "instrument";
    String ioos_category "Dissolved O2";
    String long_name "Oxygen concentration";
    String platform "platform";
    String standard_name "mole_concentration_of_dissolved_molecular_oxygen_in_sea_water";
    String temporal_drift "1";
    String units "ml/l";
    Float64 valid_max 450.0;
    Float64 valid_min 0.0;
    String varname "oxygen";
  }
  oxygen_qc {
    Byte _FillValue -127;
    String _Unsigned "false";
    Byte actual_range 0, 5;
    Float64 colorBarMaximum 10.0;
    Float64 colorBarMinimum 0.0;
    String flag_meanings "no_qc_performed good_data probably_good_data value_chaged bad_data_that_are_potentially_useful bad_data not_used not_used interpolated_value missing_value";
    Byte flag_values 0, 1, 2, 3, 4, 5, 6, 7, 8, 9;
    String ioos_category "Quality";
    String long_name "Oxygen concentration Quality Flag";
    String standard_name "mole_concentration_of_dissolved_molecular_oxygen_in_sea_water status_flag";
    Byte valid_max 9;
    Byte valid_min 0;
  }
  raw_oxygen {
    Float64 _FillValue 9.969209968386869e+36;
    String accuracy "greater of 3 or 2%";
    Float64 actual_range -1.46280352990466, 13.3733636730358;
    String ancillary_variables "platform instrument oxygen_qc oxygen";
    Float64 colorBarMaximum 150.0;
    Float64 colorBarMinimum 0.0;
    String coverage_content_type "physicalMeasurement";
    String instrument "instrument";
    String ioos_category "Quality";
    String long_name "Raw and uncorrected Oxygen concentration prior to qc processing that adjusted data values";
    String platform "platform";
    String standard_name "mole_concentration_of_dissolved_molecular_oxygen_in_sea_water";
    String temporal_drift "1";
    String units "ml/l";
    Float64 valid_max 450.0;
    Float64 valid_min 0.0;
    String varname "oxygen";
  }
 }
  NC_GLOBAL {
    String acknowledgement "This deployment supported by NSF through the Science and Technology Center for Coastal Margin Observation and Prediction (STC-CMOP) and by NOAA through the Northwest Association of Networked Ocean Observing Systems (NANOOS)";
    String cdm_data_type "TimeSeries";
    String cdm_timeseries_variables "timeSeries, latitude, longitude";
    String comment "A fixed station operated by the Science and Technology Center for Coastal Margin Observation and Prediction, Institute of Environmental Health, Oregon Health & Science University";
    String contributor_name "Antonio Baptista, Michael Wilkin, Charles Seaton, Sarah Riseman";
    String contributor_role "Principal Investigator, Field Program Manager, Data Manager, Quality Assessment";
    String Conventions "CF-1.6, ACDD-1.3, COARDS";
    String creator_email "seatonc@ohsu.edu";
    String creator_institution "Oregon Health & Science University; Center for Coastal Margin Observation & Prediction";
    String creator_name "Charles Seaton";
    String creator_type "person";
    String creator_url "http://www.stccmop.org/";
    String date_created "2024-05-20T08:47:34Z";
    String date_issued "2024-05-20T08:47:34Z";
    String date_metadata_modified "2024-05-20T08:47:34Z";
    String date_modified "2024-05-20T08:47:34Z";
    Float64 Easternmost_Easting -123.94001;
    String featureType "TimeSeries";
    String geospatial_bounds "POINT(-123.94001 46.19973)";
    String geospatial_bounds_crs "EPSG:4326";
    String geospatial_bounds_vertical_crs "EPSG::6359";
    Float64 geospatial_lat_max 46.19973;
    Float64 geospatial_lat_min 46.19973;
    String geospatial_lat_units "degrees_north";
    Float64 geospatial_lon_max -123.94001;
    Float64 geospatial_lon_min -123.94001;
    String geospatial_lon_units "degrees_east";
    String geospatial_vertical_positive "down";
    String geospatial_vertical_units "cm";
    String grid_mapping_epsg_code "EPSG:4326";
    Float64 grid_mapping_inverse_flattening 298.257223563;
    String grid_mapping_name "latitude_longitude";
    Float64 grid_mapping_semi_major_axis 6378137.0;
    String history 
"File generated from CMOP postgres database using program exportDeployment.py
2024-05-20T09:48:34Z (local files)
2024-05-20T09:48:34Z https://data.stccmop.org:/erddap/tabledap/saturn03_1300_R_Oxygen.html";
    String id "4143";
    String infoUrl "http://www.stccmop.org/";
    String institution "Oregon Health & Science University; Center for Coastal Margin Observation & Prediction";
    String instrument "IN SITU/Laboratory Instruments > Chemical Meters/Analyzers >  >  > OXYGEN ANALYZERS";
    String instrument_vocabulary "GCMD Keyword Version: 8.4.1";
    String keywords "2022-01-24, 2022-02-01, adjusted, assembled, association, center, chemistry, cmop, coastal, collected, columbia, concentration, crs, data, deployed, deployment, depth2, dissolved, dissolved o2, earth, Earth Science > Oceans > Ocean Chemistry > Oxygen, east, estuary, field, flag, fractional, fractional_saturation_of_oxygen_in_sea_water, fractional_saturation_of_oxygen_in_sea_water status_flag, health, identifier, instrument, latitude, level, longitude, margin, mean, mole, mole_concentration_of_dissolved_molecular_oxygen_in_sea_water, mole_concentration_of_dissolved_molecular_oxygen_in_sea_water status_flag, molecular, msl, nanoos, networked, north, northwest, O2, observation, observing, ocean, oceanographic, oceans, oregon, oxygen, oxygen_qc, oxygensat, oxygensat_qc, pacific, platform, prediction, prior, processing, quality, raw, raw_oxygen, raw_oxygensat, retrieved, river, saturation, saturn, science, sea, seawater, sensor, station, status, systems, time, timeSeries, uncorrected, unique, university, until, values, water, when";
    String keywords_vocabulary "GCMD Science Keywords";
    String license "This data may be redistributed and used without restriction.  Data provided as is with no expressed or implied assurance of quality assurance or quality control";
    String naming_authority "org.stccmop.www";
    Float64 Northernmost_Northing 46.19973;
    String platform "In Situ Land-based Platforms > OCEAN PLATFORM/OCEAN STATIONS > COASTAL STATIONS";
    String platform_vocabulary "GCMD Keywords Version 8.4.1";
    String processing_level "Variables (oxygensat, oxygen) have been subject to preliminary quality assessment.";
    String product_version "0.9";
    String program "IOOS,NANOOS,STC-CMOP,NSF STC";
    String project "SATURN";
    String publisher_email "nanoos.dmac@gmail.com";
    String publisher_institution "Northwest Association of Networked Ocean Observing Systems (NANOOS)";
    String publisher_name "NANOOS Data Manager";
    String publisher_type "position";
    String publisher_url "http://www.nanoos.org/";
    String sea_name "Columbia River estuary - Washington/Oregon";
    String source "in-situ observation";
    String sourceUrl "(local files)";
    Float64 Southernmost_Northing 46.19973;
    String standard_name_vocabulary "CF Standard Name Table v32";
    String subsetVariables "crs, platform, instrument, timeSeries, latitude, longitude, depth2, oxygensat_qc, oxygen_qc";
    String summary "This file contains seawater data ( and oxygen saturation) collected at SATURN-03, a fixed station in the Columbia River lower estuary, Oregon, USA by the Center for Coastal Margin Observation and Prediction (CMOP), and assembled by Northwest Association of Networked Ocean Observation Systems (Northwest Association of Networked Ocean Observing Systems (NANOOS)). This file contains data from 2022-01-24 to 2022-02-01 from a Sea-Bird Electronics SBE 43 (Oxygen). This instrument was deployed on 2020-07-27 and was ongoing as of 2022-02-05. The instrument depth was 13.0 m relative to mean sea level (NGVD29), in an overall water depth of approximately 14 m relative to MSL. The measurements reflect a nominal 3.0 minute sampling interval. The mooring used was a pumped system on a fixed mooring, with water pumped from depth to instruments above the water.";
    String testOutOfDate "now-53days";
    String time_coverage_duration "PT456H42M";
    String time_coverage_end "2024-05-20T09:43:00Z";
    String time_coverage_resolution "PT3M";
    String time_coverage_start "2016-01-01T08:01:00Z";
    String title "Oceanographic data collected from Saturn Estuary Station 03 by Center for Coastal Margin Observation and Prediction (CMOP) and assembled by Northwest Association of Networked Ocean Observation Systems (NANOOS) in the Columbia River Estuary and North East Pacific Ocean";
    Float64 Westernmost_Easting -123.94001;
  }
}

 

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.23
Disclaimers | Privacy Policy | Contact