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_240_B_Multi_exciter)
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 ?      
   - +  ?
 timeSeries ?      
   - +  ?
 time (UTC) ?          2020-10-01T08:05:43Z    2024-12-22T12:47:59Z
  < slider >
 latitude (degrees_north) ?      
   - +  ?
  < slider >
 longitude (degrees_east) ?      
   - +  ?
  < slider >
 depth2 (cm) ?      
   - +  ?
 wavelength (Wavelength of measurement, nm) ?          375.0    590.0
 fluorescence (1) ?          -4.4333    214.4989184
 fluorescence_qc ?      
   - +  ?
 turbidity (1) ?          0.7987648924696    1526.99062234064
 turbidity_qc (Turbidity Quality Flag) ?      
   - +  ?
 raw_turbidity (1) ?          0.7987648924696    1526.99062234064
 temperature (Water temperature, degree_C) ?          3.56582811488334    27.52676559013
 temperature_qc ?      
   - +  ?
 raw_temperature (degree_C) ?          3.56582811488334    27.52676559013
 pressure (MPa) ?          -0.036722    0.031942036
 pressure_qc (Pressure Quality Flag) ?      
   - +  ?
 raw_pressure (MPa) ?          -0.036722    0.031942036
 
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 "Optical Properties";
    String long_name "Multi-wave length excitation fluorescence photometer";
    String make_model "JFE Advantech/Multi-exciter";
    Int32 missing_value 2147483647;
    String platform "platform";
    String serial_number "ME02";
  }
  timeSeries {
    Int32 _FillValue 2147483647;
    Int32 actual_range 2864, 2864;
    String associated_timeSeries "2863 2866 2867 3429";
    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.601539543e+9, 1.734871679e+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 240.0, 240.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;
  }
  wavelength {
    Float64 actual_range 375.0, 590.0;
    String ioos_category "Optical Properties";
    String long_name "Wavelength of measurement";
    String units "nm";
  }
  fluorescence {
    Float64 _FillValue 9.969209968386869e+36;
    String accuracy "2% of full scale";
    Float64 actual_range -4.4333, 214.4989184;
    String ancillary_variables "platform instrument fluorescence_qc";
    String coverage_content_type "physicalMeasurement";
    String instrument "instrument";
    String ioos_category "Optical Properties";
    String long_name "Fluorescence by frequency, in Relative Fluorescence Units (RFU)";
    String platform "platform";
    Float64 units 1;
  }
  fluorescence_qc {
    Byte _FillValue -127;
    String _Unsigned "false";
    Byte actual_range 0, 0;
    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 "Fluorescence by frequency, in Relative Fluorescence Units (RFU) Quality Flag";
    Byte valid_max 9;
    Byte valid_min 0;
  }
  turbidity {
    Float64 _FillValue 9.969209968386869e+36;
    String accuracy "5 percent full-scale";
    Float64 actual_range 0.7987648924696, 1526.99062234064;
    String ancillary_variables "platform instrument turbidity_qc raw_turbidity";
    String comment "reported as a dimensionless value in Nephelometric Turbidity Units (NTU)";
    String coverage_content_type "physicalMeasurement";
    String emission "850 nm";
    String excitation "880 nm";
    String instrument "instrument";
    String ioos_category "Unknown";
    String led_cwl "850 nm";
    String long_name "Turbidity";
    String mdl "0.05 ntu";
    String platform "platform";
    String source "measurement reported by the instrument";
    String standard_name "sea_water_turbidity";
    String units "1";
    String valid_max_string "1000 ftu";
    String valid_min_string "0 ftu";
    String varname "turbidity";
  }
  turbidity_qc {
    Byte _FillValue -127;
    String _Unsigned "false";
    Byte actual_range 0, 0;
    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 "Turbidity Quality Flag";
    String standard_name "sea_water_turbidity status_flag";
    Byte valid_max 9;
    Byte valid_min 0;
  }
  raw_turbidity {
    Float64 _FillValue 9.969209968386869e+36;
    String accuracy "5 percent full-scale";
    Float64 actual_range 0.7987648924696, 1526.99062234064;
    String ancillary_variables "platform instrument turbidity_qc turbidity";
    Float64 colorBarMaximum 150.0;
    Float64 colorBarMinimum 0.0;
    String comment "reported as a dimensionless value in Nephelometric Turbidity Units (NTU)";
    String coverage_content_type "physicalMeasurement";
    String emission "850 nm";
    String excitation "880 nm";
    String instrument "instrument";
    String ioos_category "Quality";
    String led_cwl "850 nm";
    String long_name "Raw and uncorrected Turbidity prior to qc processing that adjusted data values";
    String mdl "0.05 ntu";
    String platform "platform";
    String source "measurement reported by the instrument";
    String standard_name "sea_water_turbidity";
    String units "1";
    String valid_max_string "1000 ftu";
    String valid_min_string "0 ftu";
    String varname "turbidity";
  }
  temperature {
    Float64 _FillValue 9.969209968386869e+36;
    String accuracy "0.02";
    String accuracy_caveat "between 3 and 31 degrees_C";
    Float64 actual_range 3.56582811488334, 27.52676559013;
    String ancillary_variables "platform instrument temperature_qc raw_temperature";
    Float64 colorBarMaximum 32.0;
    Float64 colorBarMinimum 0.0;
    String coverage_content_type "physicalMeasurement";
    String instrument "instrument";
    String ioos_category "Temperature";
    String long_name "Water temperature";
    String ncei_name "WATER TEMPERATURE";
    String platform "platform";
    String source "measurement reported by the instrument";
    String standard_name "sea_water_temperature";
    String temporal_drift "0.0002 degrees_C/month";
    String units "degree_C";
    Float64 valid_max 45.0;
    Float64 valid_min -5.0;
    String varname "temperature";
  }
  temperature_qc {
    Byte _FillValue -127;
    String _Unsigned "false";
    Byte actual_range 0, 0;
    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 "Water temperature Quality Flag";
    String standard_name "sea_water_temperature status_flag";
    Byte valid_max 9;
    Byte valid_min 0;
  }
  raw_temperature {
    Float64 _FillValue 9.969209968386869e+36;
    String accuracy "0.02";
    String accuracy_caveat "between 3 and 31 degrees_C";
    Float64 actual_range 3.56582811488334, 27.52676559013;
    String ancillary_variables "platform instrument temperature_qc temperature";
    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 Water temperature prior to qc processing that adjusted data values";
    String ncei_name "WATER TEMPERATURE";
    String platform "platform";
    String source "measurement reported by the instrument";
    String standard_name "sea_water_temperature";
    String temporal_drift "0.0002 degrees_C/month";
    String units "degree_C";
    Float64 valid_max 45.0;
    Float64 valid_min -5.0;
    String varname "temperature";
  }
  pressure {
    Float64 _FillValue 9.969209968386869e+36;
    String accuracy "0.3";
    Float64 actual_range -0.036722, 0.031942036;
    String ancillary_variables "platform instrument pressure_qc raw_pressure";
    Float64 colorBarMaximum 5000.0;
    Float64 colorBarMinimum 0.0;
    String coverage_content_type "physicalMeasurement";
    String instrument "instrument";
    String ioos_category "Pressure";
    String long_name "Pressure";
    String platform "platform";
    String standard_name "sea_water_pressure";
    String units "MPa";
    Float64 valid_min 0.0;
    String varname "pressure";
  }
  pressure_qc {
    Byte _FillValue -127;
    String _Unsigned "false";
    Byte actual_range 0, 0;
    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 "Pressure Quality Flag";
    String standard_name "sea_water_pressure status_flag";
    Byte valid_max 9;
    Byte valid_min 0;
  }
  raw_pressure {
    Float64 _FillValue 9.969209968386869e+36;
    String accuracy "0.3";
    Float64 actual_range -0.036722, 0.031942036;
    String ancillary_variables "platform instrument pressure_qc pressure";
    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 Pressure prior to qc processing that adjusted data values";
    String platform "platform";
    String standard_name "sea_water_pressure";
    String units "MPa";
    Float64 valid_min 0.0;
    String varname "pressure";
  }
 }
  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-12-22T11:50:06Z";
    String date_issued "2024-12-22T11:50:06Z";
    String date_metadata_modified "2024-12-22T11:50:06Z";
    String date_modified "2024-12-22T11:50:06Z";
    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-12-22T13:10:06Z (local files)
2024-12-22T13:10:06Z https://data.stccmop.org:/erddap/tabledap/saturn03_240_B_Multi_exciter.html";
    String id "2864";
    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 >  >  > FLUOROMETERS";
    String instrument_vocabulary "GCMD Keyword Version: 8.4.1";
    String keywords "2022-01-01, 2022-02-01, adjusted, assembled, association, center, chemistry, chlorophyll, cmop, coastal, collected, columbia, crs, data, deployed, deployment, depth2, earth, Earth Science > Oceans > Ocean Chemistry > Pigments > Chlorophyll, Earth Science > Oceans > Ocean Optics > Turbidity, Earth Science > Oceans > Ocean Pressure > Water Pressure, Earth Science > Oceans > Ocean Temperature > Water Temperature, east, estuary, excitation, field, flag, fluorescence, fluorescence_qc, frequency, health, identifier, instrument, latitude, length, level, longitude, margin, mean, measurement, msl, multi, multi-wave, nanoos, networked, north, northwest, observation, observing, ocean, oceanographic, oceans, optical, optical properties, optics, oregon, pacific, photometer, pigments, platform, prediction, pressure, pressure_qc, prior, processing, properties, quality, raw, raw_pressure, raw_temperature, raw_turbidity, relative, retrieved, rfu, river, saturn, science, sea, sea_water_pressure, sea_water_pressure status_flag, sea_water_temperature, sea_water_temperature status_flag, sea_water_turbidity, sea_water_turbidity status_flag, seawater, station, status, systems, temperature, temperature_qc, time, timeSeries, turbidity, turbidity_qc, uncorrected, unique, units, university, until, values, water, wave, wavelength, 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 (turbidity, temperature, pressure) 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, fluorescence_qc, turbidity_qc, temperature_qc, pressure_qc";
    String summary "This file contains seawater data (chlorophyll) 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-01 to 2022-02-01 from a JFE Advantech Multi-exciter (Multi-exciter). This instrument was deployed on 2018-04-04 and was ongoing as of 2022-02-05. The instrument depth was 2.4 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 "PT507H42M";
    String time_coverage_end "2024-12-22T12:47:59Z";
    String time_coverage_resolution "PT3M";
    String time_coverage_start "2020-10-01T08:05:43Z";
    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