ERDDAP > tabledap > Data Access Form

Dataset Title:	St. Clair River at Port Huron, MI - 04159130
Institution:	United States Geological Survey   (Dataset ID: obs_628)
Information:	Summary | License | FGDC | ISO 19115 | Metadata | Background | Files | Make a graph

 

Variable	Optional Constraint #1		Optional Constraint #2		Minimum	Maximum
time (UTC)	!= =~ <= >= = < >		!= =~ <= >= = < >		2024-11-07T21:00:00Z	2025-08-15T17:00:00Z
longitude (degrees_east)	!= =~ <= >= = < >		!= =~ <= >= = < >		-82.42463684082031	-82.42463684082031
latitude (degrees_north)	!= =~ <= >= = < >		!= =~ <= >= = < >		42.98697280883789	42.98697280883789
sea_water_temperature (K)	!= =~ <= >= = < >		!= =~ <= >= = < >
sea_water_temperature_aggregate_test	!= =~ <= >= = < >		!= =~ <= >= = < >
sea_water_temperature_flat_line_test	!= =~ <= >= = < >		!= =~ <= >= = < >
sea_water_temperature_gross_range_test	!= =~ <= >= = < >		!= =~ <= >= = < >
sea_water_temperature_rate_of_change_test	!= =~ <= >= = < >		!= =~ <= >= = < >
sea_water_temperature_spike_test	!= =~ <= >= = < >		!= =~ <= >= = < >
water_volume_transport_in_river_channel (m³/s)	!= =~ <= >= = < >		!= =~ <= >= = < >		3907.72802734375	7249.11865234375
water_volume_transport_in_river_channel_aggregate_test	!= =~ <= >= = < >		!= =~ <= >= = < >		2	2
water_volume_transport_in_river_channel_flat_line_test	!= =~ <= >= = < >		!= =~ <= >= = < >		2	2
water_volume_transport_in_river_channel_gross_range_test	!= =~ <= >= = < >		!= =~ <= >= = < >		2	2
water_volume_transport_in_river_channel_rate_of_change_test	!= =~ <= >= = < >		!= =~ <= >= = < >		2	2
water_volume_transport_in_river_channel_spike_test	!= =~ <= >= = < >		!= =~ <= >= = < >		2	2
platform	!= =~ <= >= = < >		!= =~ <= >= = < >

 

Server-side Functions

distinct()

orderBy orderByDescending orderByClosest orderByCount orderByLimit orderByMax orderByMin orderByMinMax orderByMean orderBySum (" time longitude latitude sea_water_temperature sea_water_temperature_aggregate_test sea_water_temperature_flat_line_test sea_water_temperature_gross_range_test sea_water_temperature_rate_of_change_test sea_water_temperature_spike_test water_volume_transport_in_river_channel water_volume_transport_in_river_channel_aggregate_test water_volume_transport_in_river_channel_flat_line_test water_volume_transport_in_river_channel_gross_range_test water_volume_transport_in_river_channel_rate_of_change_test water_volume_transport_in_river_channel_spike_test platform time longitude latitude sea_water_temperature sea_water_temperature_aggregate_test sea_water_temperature_flat_line_test sea_water_temperature_gross_range_test sea_water_temperature_rate_of_change_test sea_water_temperature_spike_test water_volume_transport_in_river_channel water_volume_transport_in_river_channel_aggregate_test water_volume_transport_in_river_channel_flat_line_test water_volume_transport_in_river_channel_gross_range_test water_volume_transport_in_river_channel_rate_of_change_test water_volume_transport_in_river_channel_spike_test platform time longitude latitude sea_water_temperature sea_water_temperature_aggregate_test sea_water_temperature_flat_line_test sea_water_temperature_gross_range_test sea_water_temperature_rate_of_change_test sea_water_temperature_spike_test water_volume_transport_in_river_channel water_volume_transport_in_river_channel_aggregate_test water_volume_transport_in_river_channel_flat_line_test water_volume_transport_in_river_channel_gross_range_test water_volume_transport_in_river_channel_rate_of_change_test water_volume_transport_in_river_channel_spike_test platform time longitude latitude sea_water_temperature sea_water_temperature_aggregate_test sea_water_temperature_flat_line_test sea_water_temperature_gross_range_test sea_water_temperature_rate_of_change_test sea_water_temperature_spike_test water_volume_transport_in_river_channel water_volume_transport_in_river_channel_aggregate_test water_volume_transport_in_river_channel_flat_line_test water_volume_transport_in_river_channel_gross_range_test water_volume_transport_in_river_channel_rate_of_change_test water_volume_transport_in_river_channel_spike_test platform time longitude latitude sea_water_temperature sea_water_temperature_aggregate_test sea_water_temperature_flat_line_test sea_water_temperature_gross_range_test sea_water_temperature_rate_of_change_test sea_water_temperature_spike_test water_volume_transport_in_river_channel water_volume_transport_in_river_channel_aggregate_test water_volume_transport_in_river_channel_flat_line_test water_volume_transport_in_river_channel_gross_range_test water_volume_transport_in_river_channel_rate_of_change_test water_volume_transport_in_river_channel_spike_test platform ")

File type: (more information) .asc - View OPeNDAP-style ISO-8859-1 comma-separated text. .croissant - Download the dataset croissant schema. .csv - Download a ISO-8859-1 comma-separated text table (line 1: names; line 2: units; ISO 8601 times). .csv0 - Download a ISO-8859-1 .csv file without column names or units. Times are ISO 8601 strings. .csvp - Download a ISO-8859-1 .csv file with line 1: name (units). Times are ISO 8601 strings. .das - View the dataset's metadata via an ISO-8859-1 OPeNDAP Dataset Attribute Structure (DAS). .dataTable - A JSON file formatted for use with the Google Visualization client library (Google Charts). .dds - View the dataset's structure via an ISO-8859-1 OPeNDAP Dataset Descriptor Structure (DDS). .dods - OPeNDAP clients use this to download the data in the DODS binary format. .esriCsv - Download a ISO_8859_1 .csv file for ESRI's ArcGIS 9.x and below (separate date and time columns). .fgdc - View the dataset's UTF-8 FGDC .xml metadata. .geoJson - Download longitude,latitude,otherColumns data as a UTF-8 GeoJSON .json file. .htmlTable - View a UTF-8 .html web page with the data in a table. Times are ISO 8601 strings. .iso19115 - View the dataset's ISO 19115/19139 UTF-8 .xml metadata using the version default for this server. .iso19115_2 - View the dataset's ISO 19115-2/19139 UTF-8 .xml metadata. .iso19115_3_2016 - View the dataset's ISO 19115-3:2016 UTF-8 .xml metadata. .iso19139_2007 - View the dataset's ISO 19139:2007 UTF-8 .xml metadata. .itx - Download an ISO-8859-1 Igor Text File. Each response column becomes a wave. .json - View a table-like UTF-8 JSON file (missing value = 'null'; times are ISO 8601 strings). .jsonlCSV - View a UTF-8 JSON Lines CSV file without column names (mv = 'null'; times are ISO 8601 strings). .jsonlCSV1 - View a UTF-8 JSON Lines CSV file with column names on line 1 (mv = 'null'; times are ISO 8601 strings). .jsonlKVP - View a UTF-8 JSON Lines file with Key:Value pairs (missing value = 'null'; times are ISO 8601 strings). .mat - Download a MATLAB binary file. .nc - Download a flat, table-like, NetCDF-3 binary file with COARDS/CF/ACDD metadata. .ncCF - Download a NetCDF-3 CF Discrete Sampling Geometries file (Contiguous Ragged Array). .ncCFHeader - View the UTF-8 header (the metadata) for the .ncCF file. .ncCFMA - Download a NetCDF-3 CF Discrete Sampling Geometries file (Multidimensional Array). .ncCFMAHeader - View the UTF-8 header (the metadata) for the .ncCFMA file. .ncHeader - View the UTF-8 header (the metadata) for the NetCDF-3 .nc file. .nccsv - Download a NetCDF-3-like 7-bit ASCII NCCSV .csv file with COARDS/CF/ACDD metadata. .nccsvMetadata - View the dataset's metadata as the top half of a 7-bit ASCII NCCSV .csv file. .ncoJson - Download a UTF-8 NCO lvl=2 JSON file with COARDS/CF/ACDD metadata. .odvTxt - Download longitude,latitude,time,otherColumns as an ISO-8859-1 ODV Generic Spreadsheet File (.txt). .parquet - Download as a parquet file. Metadata contains column names ("column_names") and units ("column_units"). .parquetWMeta - Download as a parquet file with detailed metadata. .tsv - Download a ISO-8859-1 tab-separated text table (line 1: names; line 2: units; ISO 8601 times). .tsv0 - Download a ISO-8859-1 .tsv file without column names or units. Times are ISO 8601 strings. .tsvp - Download a ISO-8859-1 .tsv file with line 1: name (units). Times are ISO 8601 strings. .wav - Download a .wav audio file. All columns must be numeric and of the same type. .xhtml - View a UTF-8 XHTML (XML) file with the data in a table. Times are ISO 8601 strings. .kml - View a .kml file, suitable for Google Earth. .largePdf - View a large .pdf image file with a graph or map. .largePng - View a large .png image file with a graph or map. .pdf - View a standard, medium-sized .pdf image file with a graph or map. .png - View a standard, medium-sized .png image file with a graph or map. .smallPdf - View a small .pdf image file with a graph or map. .smallPng - View a small .png image file with a graph or map. .transparentPng - View a .png image file (just the data, without axes, landmask, or legend).

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

 

---

The Dataset Attribute Structure (.das) for this Dataset

Attributes {
 s {
  time {
    UInt32 _ChunkSizes 512;
    String _CoordinateAxisType "Time";
    Float64 actual_range 1.7310132e+9, 1.7552772e+9;
    String axis "T";
    String calendar "gregorian";
    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";
  }
  longitude {
    UInt32 _ChunkSizes 512;
    String _CoordinateAxisType "Lon";
    Float64 _FillValue -9999.0;
    Float64 actual_range -82.42463684082031, -82.42463684082031;
    String axis "X";
    String comment "Longitude given by data provider for this platform dataset";
    String ioos_category "Location";
    String long_name "Longitude";
    Float64 missing_value -9999.0;
    String standard_name "longitude";
    String units "degrees_east";
    Float64 valid_max 180.0;
    Float64 valid_min -180.0;
  }
  latitude {
    UInt32 _ChunkSizes 512;
    String _CoordinateAxisType "Lat";
    Float64 _FillValue -9999.0;
    Float64 actual_range 42.98697280883789, 42.98697280883789;
    String axis "Y";
    String comment "Latitude given by data provider for this platform dataset";
    String ioos_category "Location";
    String long_name "Latitude";
    Float64 missing_value -9999.0;
    String standard_name "latitude";
    String units "degrees_north";
    Float64 valid_max 90.0;
    Float64 valid_min -90.0;
  }
  sea_water_temperature {
    String ancillary_variables "sea_water_temperature_flat_line_test sea_water_temperature_gross_range_test sea_water_temperature_rate_of_change_test sea_water_temperature_spike_test sea_water_temperature_aggregate_test";
    String ioos_category "Temperature";
    String long_name "Water temp at depth";
    Float64 missing_value -9999.900390625;
    String platform "platform";
    String standard_name "sea_water_temperature";
    String units "K";
  }
  sea_water_temperature_aggregate_test {
    String _Unsigned "false";
    String flag_meanings "GOOD NOT_EVALUATED SUSPECT BAD MISSING";
    Byte flag_values 1, 2, 3, 4, 9;
    String ioos_category "Quality";
    String standard_name "sea_water_temperature_aggregate_test";
    Byte valid_max 9;
    Byte valid_min 1;
  }
  sea_water_temperature_flat_line_test {
    String _Unsigned "false";
    String flag_meanings "GOOD NOT_EVALUATED SUSPECT BAD MISSING";
    Byte flag_values 1, 2, 3, 4, 9;
    String ioos_category "Quality";
    String standard_name "sea_water_temperature_flat_line_test";
    Byte valid_max 9;
    Byte valid_min 1;
  }
  sea_water_temperature_gross_range_test {
    String _Unsigned "false";
    String flag_meanings "GOOD NOT_EVALUATED SUSPECT BAD MISSING";
    Byte flag_values 1, 2, 3, 4, 9;
    String ioos_category "Quality";
    String standard_name "sea_water_temperature_gross_range_test";
    Byte valid_max 9;
    Byte valid_min 1;
  }
  sea_water_temperature_rate_of_change_test {
    String _Unsigned "false";
    String flag_meanings "GOOD NOT_EVALUATED SUSPECT BAD MISSING";
    Byte flag_values 1, 2, 3, 4, 9;
    String ioos_category "Quality";
    String standard_name "sea_water_temperature_rate_of_change_test";
    Byte valid_max 9;
    Byte valid_min 1;
  }
  sea_water_temperature_spike_test {
    String _Unsigned "false";
    String flag_meanings "GOOD NOT_EVALUATED SUSPECT BAD MISSING";
    Byte flag_values 1, 2, 3, 4, 9;
    String ioos_category "Quality";
    String standard_name "sea_water_temperature_spike_test";
    Byte valid_max 9;
    Byte valid_min 1;
  }
  water_volume_transport_in_river_channel {
    UInt32 _ChunkSizes 1, 1;
    Float64 _FillValue -9999.9;
    Float64 actual_range 3907.72802734375, 7249.11865234375;
    String ancillary_variables "water_volume_transport_in_river_channel_flat_line_test water_volume_transport_in_river_channel_gross_range_test water_volume_transport_in_river_channel_rate_of_change_test water_volume_transport_in_river_channel_spike_test water_volume_transport_in_river_channel_aggregate_test";
    String axis "T";
    String comment "River discharge is the volumetric rate of water flow of a stream or river or pipe. The measure of flow through a cross-sectional area per unit time. (IOOS) ";
    String coordinates "time lat lon z";
    String coverage_content_type "physicalMeasurement";
    String instrument "instrument0";
    String ioos_category "Unknown";
    String long_name "River discharge";
    Float64 missing_value -9999.900390625;
    String platform "platform";
    String standard_name "water_volume_transport_in_river_channel";
    String units "m³/s";
  }
  water_volume_transport_in_river_channel_aggregate_test {
    UInt32 _ChunkSizes 1, 1;
    Byte _FillValue 9;
    String _Unsigned "false";
    Byte actual_range 2, 2;
    String axis "T";
    String coordinates "time lat lon z";
    String flag_meanings "GOOD NOT_EVALUATED SUSPECT BAD MISSING";
    Byte flag_values 1, 2, 3, 4, 9;
    String instrument "instrument0";
    String ioos_category "Quality";
    String long_name "aggregate_quality_flag";
    Byte missing_value 9;
    String platform "MI04159130";
    String standard_name "water_volume_transport_in_river_channel_aggregate_test";
    Byte valid_max 9;
    Byte valid_min 1;
  }
  water_volume_transport_in_river_channel_flat_line_test {
    UInt32 _ChunkSizes 1, 1;
    Byte _FillValue 9;
    String _Unsigned "false";
    Byte actual_range 2, 2;
    String axis "T";
    String coordinates "time lat lon z";
    String flag_meanings "GOOD NOT_EVALUATED SUSPECT BAD MISSING";
    Byte flag_values 1, 2, 3, 4, 9;
    String instrument "instrument0";
    String ioos_category "Quality";
    String long_name "flat_line_test_quality_flag";
    Byte missing_value 9;
    String platform "MI04159130";
    String standard_name "water_volume_transport_in_river_channel_flat_line_test";
    Byte valid_max 9;
    Byte valid_min 1;
  }
  water_volume_transport_in_river_channel_gross_range_test {
    UInt32 _ChunkSizes 1, 1;
    Byte _FillValue 9;
    String _Unsigned "false";
    Byte actual_range 2, 2;
    String axis "T";
    String coordinates "time lat lon z";
    String flag_meanings "GOOD NOT_EVALUATED SUSPECT BAD MISSING";
    Byte flag_values 1, 2, 3, 4, 9;
    String instrument "instrument0";
    String ioos_category "Quality";
    String long_name "gross_range_test_quality_flag";
    Byte missing_value 9;
    String platform "MI04159130";
    String standard_name "water_volume_transport_in_river_channel_gross_range_test";
    Byte valid_max 9;
    Byte valid_min 1;
  }
  water_volume_transport_in_river_channel_rate_of_change_test {
    UInt32 _ChunkSizes 1, 1;
    Byte _FillValue 9;
    String _Unsigned "false";
    Byte actual_range 2, 2;
    String axis "T";
    String coordinates "time lat lon z";
    String flag_meanings "GOOD NOT_EVALUATED SUSPECT BAD MISSING";
    Byte flag_values 1, 2, 3, 4, 9;
    String instrument "instrument0";
    String ioos_category "Quality";
    String long_name "rate_of_change_test_quality_flag";
    Byte missing_value 9;
    String platform "MI04159130";
    String standard_name "water_volume_transport_in_river_channel_rate_of_change_test";
    Byte valid_max 9;
    Byte valid_min 1;
  }
  water_volume_transport_in_river_channel_spike_test {
    UInt32 _ChunkSizes 1, 1;
    Byte _FillValue 9;
    String _Unsigned "false";
    Byte actual_range 2, 2;
    String axis "T";
    String coordinates "time lat lon z";
    String flag_meanings "GOOD NOT_EVALUATED SUSPECT BAD MISSING";
    Byte flag_values 1, 2, 3, 4, 9;
    String instrument "instrument0";
    String ioos_category "Quality";
    String long_name "spike_test_quality_flag";
    Byte missing_value 9;
    String platform "MI04159130";
    String standard_name "water_volume_transport_in_river_channel_spike_test";
    Byte valid_max 9;
    Byte valid_min 1;
  }
  platform {
    String _Unsigned "false";
    String cf_role "timeseries_id";
    String ioos_category "Other";
  }
 }
  NC_GLOBAL {
    String acknowledgement "Thanks to Mathew Biddle, Tim Boyer, and the NCEI NetCDF working group for guidance";
    String cdm_data_type "TimeSeries";
    String cdm_timeseries_variables "platform,longitude,latitude";
    String comment "These data were automatically archived by GLOS' Seagull Platform. Contact GLOS with questions or concerns.";
    String contributor_name "United States Geological Survey";
    String contributor_role "Ocean Observing System Contributor";
    String Conventions "CF-1.10, ACDD-1.3";
    String creator_country "USA";
    String creator_institution "United States Geological Survey";
    String creator_sector "gov_federal";
    String creator_type "institution";
    String creator_url "https://www.usgs.gov/";
    String date_created "2026-09-10T23:48:43.376641Z";
    String date_issued "2026-09-10T23:48:43.376686Z";
    String date_metadata_modified "2026-09-10T23:48:43.376682Z";
    String date_modified "2026-09-10T23:48:43.376677Z";
    Float64 Easternmost_Easting -82.42463684082031;
    String featureType "TimeSeries";
    String geospatial_bounds "POINT (-82.424637 42.986974)";
    String geospatial_bounds_crs "EPSG:4326";
    String geospatial_bounds_vertical_crs "EPSG:5829";
    Float64 geospatial_lat_max 42.98697280883789;
    Float64 geospatial_lat_min 42.98697280883789;
    String geospatial_lat_units "degrees_north";
    Float64 geospatial_lon_max -82.42463684082031;
    Float64 geospatial_lon_min -82.42463684082031;
    String geospatial_lon_units "degrees_east";
    String geospatial_vertical_max "406";
    String geospatial_vertical_min "0";
    String geospatial_vertical_positive "down";
    String geospatial_vertical_units "m";
    String gts_ingest "False";
    String history 
"These data were automatically archived by GLOS' Seagull Platform. Corrections to data may periodically occur. Contact GLOS with questions or concerns.
2026-09-11T18:47:29Z (local files)
2026-09-11T18:47:29Z https://seagull-erddap.glos.org/erddap/tabledap/obs_628.html";
    String id "MI04159130";
    String infoUrl "https://waterdata.usgs.gov/monitoring-location/04159130/";
    String institution "United States Geological Survey";
    String instrument "various";
    String instrument_vocabulary "None specified";
    String keywords "Earth Science > Oceans > Ocean Temperature > Water Temperature";
    String keywords_vocabulary "GCMD Earth Science Keywords. Version 15.6";
    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, GLOS, 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.";
    String metadata_link "https://www.ncei.noaa.gov/data/oceans/ncei/formats/netcdf/v2.0/";
    String naming_authority "gov.noaa.ncei";
    String ncei_template_version "NCEI_NetCDF_TimeSeries_Orthogonal_Template_v2.0";
    Float64 Northernmost_Northing 42.98697280883789;
    String platform "MI04159130";
    String platform_name "St. Clair River at Port Huron, MI";
    String platform_type "fixed";
    String platform_vocabulary "None specified";
    String processing_level "Not Applicable";
    String product_version "v1";
    String program "NCEI-IOOS-GLOS Data Pipeline";
    String project "NCEI-IOOS-GLOS Data Pipeline";
    String publisher_country "USA";
    String publisher_email "info@glos.org";
    String publisher_institution "GLOS";
    String publisher_name "GLOS Cyberinfrastructure Engineer";
    String publisher_type "position";
    String publisher_url "https://glos.org";
    String references "https://www.ncei.noaa.gov/data/oceans/ncei/formats/netcdf/v2.0/";
    String sea_name "Great Lakes";
    String source "GLOS Seagull";
    String sourceUrl "(local files)";
    Float64 Southernmost_Northing 42.98697280883789;
    String standard_name_vocabulary "CF Standard Name Table v77";
    String summary "Monitoring location 04159130 is associated with the St. Clair River at Port Huron, MI. Current conditions of Discharge and Gage height are available. Water data back to 1969 are available online.  <a href='https://waterdata.usgs.gov/monitoring-location/04159130/'>Click here for historical data.</a> Data displayed for this dataset on GLOS Seagull are streamed from <a href='https://gldw.org/vdab/apps/GreatLakes'>Great Lakes Data Watershed</a>";
    String time_coverage_duration "PT1M";
    String time_coverage_end "2025-08-15T17:00:00Z";
    String time_coverage_resolution "PT15M";
    String time_coverage_start "2024-11-07T21:00:00Z";
    String title "St. Clair River at Port Huron, MI - 04159130";
    String uuid "TBD";
    Float64 Westernmost_Easting -82.42463684082031;
    String wmo_platform_code "NA";
  }
}

 

---

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 Data Access Protocol (DAP) and its selection constraints.

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.

• (easy) You can get data by using the dataset's Data Access Form or Subset form. They make the URL for you.
• (easy) You can make a graph or map by using the dataset's Make A Graph form. It makes the URL for you.
• (not hard) You can bypass the forms and get the data or make a graph or map by generating the URL by hand or with a computer program or script.

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