ERDDAP > tabledap > Data Access Form

Dataset Title:	42370 - Holstein - Green Canyon 645
Institution:	Felimon Gayanilo   (Dataset ID: ism-gcoos-wmo_42370)
Information:	Summary | License | FGDC | ISO 19115 | Metadata | Background | Make a graph

 

Variable	Optional Constraint #1		Optional Constraint #2		Minimum	Maximum
time (UTC)	!= =~ <= >= = < >		!= =~ <= >= = < >		2023-02-17T10:19:00Z	2024-12-22T08:58:00Z
latitude (degrees_north)	!= =~ <= >= = < >		!= =~ <= >= = < >		27.322	27.322
longitude (degrees_east)	!= =~ <= >= = < >		!= =~ <= >= = < >		-90.536	-90.536
z (Altitude, m)	!= =~ <= >= = < >		!= =~ <= >= = < >		-1315.0	-61.06
sea_water_speed (Current Speed, m.s-1)	!= =~ <= >= = < >		!= =~ <= >= = < >		0.0	18.4381
sea_water_speed_qc_agg	!= =~ <= >= = < >		!= =~ <= >= = < >		1	4
sea_water_speed_qc_tests	!= =~ <= >= = < >		!= =~ <= >= = < >
upward_sea_water_velocity (m.s-1)	!= =~ <= >= = < >		!= =~ <= >= = < >		-10.011000000000001	6.653
upward_sea_water_velocity_qc_agg	!= =~ <= >= = < >		!= =~ <= >= = < >		1	4
upward_sea_water_velocity_qc_tests	!= =~ <= >= = < >		!= =~ <= >= = < >
sea_surface_temperature (degree_Celsius)	!= =~ <= >= = < >		!= =~ <= >= = < >		0.0	655.35
sea_surface_temperature_qc_agg	!= =~ <= >= = < >		!= =~ <= >= = < >		1	4
sea_surface_temperature_qc_tests	!= =~ <= >= = < >		!= =~ <= >= = < >
station	!= =~ <= >= = < >		!= =~ <= >= = < >

 

Server-side Functions

distinct()

orderBy orderByDescending orderByClosest orderByCount orderByLimit orderByMax orderByMin orderByMinMax orderByMean orderBySum (" time latitude longitude z sea_water_speed sea_water_speed_qc_agg sea_water_speed_qc_tests upward_sea_water_velocity upward_sea_water_velocity_qc_agg upward_sea_water_velocity_qc_tests sea_surface_temperature sea_surface_temperature_qc_agg sea_surface_temperature_qc_tests station time latitude longitude z sea_water_speed sea_water_speed_qc_agg sea_water_speed_qc_tests upward_sea_water_velocity upward_sea_water_velocity_qc_agg upward_sea_water_velocity_qc_tests sea_surface_temperature sea_surface_temperature_qc_agg sea_surface_temperature_qc_tests station time latitude longitude z sea_water_speed sea_water_speed_qc_agg sea_water_speed_qc_tests upward_sea_water_velocity upward_sea_water_velocity_qc_agg upward_sea_water_velocity_qc_tests sea_surface_temperature sea_surface_temperature_qc_agg sea_surface_temperature_qc_tests station time latitude longitude z sea_water_speed sea_water_speed_qc_agg sea_water_speed_qc_tests upward_sea_water_velocity upward_sea_water_velocity_qc_agg upward_sea_water_velocity_qc_tests sea_surface_temperature sea_surface_temperature_qc_agg sea_surface_temperature_qc_tests station time latitude longitude z sea_water_speed sea_water_speed_qc_agg sea_water_speed_qc_tests upward_sea_water_velocity upward_sea_water_velocity_qc_agg upward_sea_water_velocity_qc_tests sea_surface_temperature sea_surface_temperature_qc_agg sea_surface_temperature_qc_tests station ")

File type: (more information) .asc - View OPeNDAP-style ISO-8859-1 comma-separated text. .csv - Download a ISO-8859-1 comma-separated text table (line 1: names; line 2: units; ISO 8601 times). .csvp - Download a ISO-8859-1 .csv file with line 1: name (units). Times are ISO 8601 strings. .csv0 - Download a ISO-8859-1 .csv file without column names or units. Times are ISO 8601 strings. .dataTable - A JSON file formatted for use with the Google Visualization client library (Google Charts). .das - View the dataset's metadata via an ISO-8859-1 OPeNDAP Dataset Attribute Structure (DAS). .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. .graph - View a Make A Graph web page. .help - View a web page with a description of tabledap. .html - View an OPeNDAP-style HTML Data Access Form. .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-2/19139 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). .jsonlCSV1 - View a UTF-8 JSON Lines CSV file with column names on line 1 (mv = '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). .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. .ncHeader - View the UTF-8 header (the metadata) for the NetCDF-3 .nc file. .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. .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. .subset - View an HTML form which uses faceted search to simplify picking subsets of the data. .tsv - Download a ISO-8859-1 tab-separated text table (line 1: names; line 2: units; ISO 8601 times). .tsvp - Download a ISO-8859-1 .tsv file with line 1: name (units). Times are ISO 8601 strings. .tsv0 - Download a ISO-8859-1 .tsv file without column names or 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. .smallPdf - View a small .pdf image file with a graph or map. .pdf - View a standard, medium-sized .pdf image file with a graph or map. .largePdf - View a large .pdf image file with a graph or map. .smallPng - View a small .png image file with a graph or map. .png - View a standard, medium-sized .png image file with a graph or map. .largePng - View a large .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.67662914e+9, 1.73485788e+9;
    String axis "T";
    String calendar "gregorian";
    String cf_role "profile_id";
    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 NaN;
    Float64 actual_range 27.322, 27.322;
    String axis "Y";
    String ioos_category "Location";
    String long_name "Latitude";
    String standard_name "latitude";
    String units "degrees_north";
  }
  longitude {
    String _CoordinateAxisType "Lon";
    Float64 _FillValue NaN;
    Float64 actual_range -90.536, -90.536;
    String axis "X";
    String ioos_category "Location";
    String long_name "Longitude";
    String standard_name "longitude";
    String units "degrees_east";
  }
  z {
    UInt32 _ChunkSizes 512;
    String _CoordinateAxisType "Height";
    String _CoordinateZisPositive "up";
    Float64 _FillValue NaN;
    Float64 actual_range -1315.0, -61.06;
    String axis "Z";
    String ioos_category "Location";
    String long_name "Altitude";
    String positive "up";
    String standard_name "altitude";
    String units "m";
  }
  sea_water_speed {
    UInt32 _ChunkSizes 512;
    Float64 _FillValue -9999.0;
    Float64 actual_range 0.0, 18.4381;
    String ancillary_variables "sea_water_speed_qc_agg sea_water_speed_qc_tests";
    String id "1095671";
    String ioos_category "Other";
    String long_name "Current Speed";
    Float64 missing_value -9999.0;
    String platform "station";
    String short_name "sea_water_speed";
    String standard_name "sea_water_speed";
    String standard_name_url "http://mmisw.org/ont/cf/parameter/sea_water_speed";
    String units "m.s-1";
  }
  sea_water_speed_qc_agg {
    UInt32 _ChunkSizes 4096;
    Int32 _FillValue -127;
    Int32 actual_range 1, 4;
    String flag_meanings "PASS NOT_EVALUATED SUSPECT FAIL MISSING";
    Int32 flag_values 1, 2, 3, 4, 9;
    String ioos_category "Other";
    String long_name "Current Speed QARTOD Aggregate Quality Flag";
    Int32 missing_value -127;
    String short_name "sea_water_speed_qc_agg";
    String standard_name "aggregate_quality_flag";
  }
  sea_water_speed_qc_tests {
    UInt32 _ChunkSizes 512;
    Float64 _FillValue 0;
    String comment "11-character string with results of individual QARTOD tests. 1: Gap Test, 2: Syntax Test, 3: Location Test, 4: Gross Range Test, 5: Climatology Test, 6: Spike Test, 7: Rate of Change Test, 8: Flat-line Test, 9: Multi-variate Test, 10: Attenuated Signal Test, 11: Neighbor Test";
    String flag_meanings "PASS NOT_EVALUATED SUSPECT FAIL MISSING";
    Int32 flag_values 1, 2, 3, 4, 9;
    String ioos_category "Other";
    String long_name "Current Speed QARTOD Individual Tests";
    String short_name "sea_water_speed_qc_tests";
    String standard_name "quality_flag";
  }
  upward_sea_water_velocity {
    UInt32 _ChunkSizes 512;
    Float64 _FillValue -9999.0;
    Float64 actual_range -10.011000000000001, 6.653;
    String ancillary_variables "upward_sea_water_velocity_qc_agg upward_sea_water_velocity_qc_tests";
    String id "1095672";
    String ioos_category "Other";
    String long_name "Upward Sea Water Velocity";
    Float64 missing_value -9999.0;
    String platform "station";
    String short_name "upward_sea_water_velocity";
    String standard_name "upward_sea_water_velocity";
    String standard_name_url "http://mmisw.org/ont/cf/parameter/upward_sea_water_velocity";
    String units "m.s-1";
  }
  upward_sea_water_velocity_qc_agg {
    UInt32 _ChunkSizes 4096;
    Int32 _FillValue -127;
    Int32 actual_range 1, 4;
    String flag_meanings "PASS NOT_EVALUATED SUSPECT FAIL MISSING";
    Int32 flag_values 1, 2, 3, 4, 9;
    String ioos_category "Other";
    String long_name "Upward Sea Water Velocity QARTOD Aggregate Quality Flag";
    Int32 missing_value -127;
    String short_name "upward_sea_water_velocity_qc_agg";
    String standard_name "aggregate_quality_flag";
  }
  upward_sea_water_velocity_qc_tests {
    UInt32 _ChunkSizes 512;
    Float64 _FillValue 0;
    String comment "11-character string with results of individual QARTOD tests. 1: Gap Test, 2: Syntax Test, 3: Location Test, 4: Gross Range Test, 5: Climatology Test, 6: Spike Test, 7: Rate of Change Test, 8: Flat-line Test, 9: Multi-variate Test, 10: Attenuated Signal Test, 11: Neighbor Test";
    String flag_meanings "PASS NOT_EVALUATED SUSPECT FAIL MISSING";
    Int32 flag_values 1, 2, 3, 4, 9;
    String ioos_category "Other";
    String long_name "Upward Sea Water Velocity QARTOD Individual Tests";
    String short_name "upward_sea_water_velocity_qc_tests";
    String standard_name "quality_flag";
  }
  sea_surface_temperature {
    UInt32 _ChunkSizes 512;
    Float64 _FillValue -9999.0;
    Float64 actual_range 0.0, 655.35;
    String ancillary_variables "sea_surface_temperature_qc_agg sea_surface_temperature_qc_tests";
    String id "1095669";
    String ioos_category "Other";
    String long_name "Sea Surface Temperature";
    Float64 missing_value -9999.0;
    String platform "station";
    String short_name "sea_surface_temperature";
    String standard_name "sea_surface_temperature";
    String standard_name_url "http://mmisw.org/ont/cf/parameter/sea_surface_temperature";
    String units "degree_Celsius";
  }
  sea_surface_temperature_qc_agg {
    UInt32 _ChunkSizes 4096;
    Int32 _FillValue -127;
    Int32 actual_range 1, 4;
    String flag_meanings "PASS NOT_EVALUATED SUSPECT FAIL MISSING";
    Int32 flag_values 1, 2, 3, 4, 9;
    String ioos_category "Other";
    String long_name "Sea Surface Temperature QARTOD Aggregate Quality Flag";
    Int32 missing_value -127;
    String short_name "sea_surface_temperature_qc_agg";
    String standard_name "aggregate_quality_flag";
  }
  sea_surface_temperature_qc_tests {
    UInt32 _ChunkSizes 512;
    Float64 _FillValue 0;
    String comment "11-character string with results of individual QARTOD tests. 1: Gap Test, 2: Syntax Test, 3: Location Test, 4: Gross Range Test, 5: Climatology Test, 6: Spike Test, 7: Rate of Change Test, 8: Flat-line Test, 9: Multi-variate Test, 10: Attenuated Signal Test, 11: Neighbor Test";
    String flag_meanings "PASS NOT_EVALUATED SUSPECT FAIL MISSING";
    Int32 flag_values 1, 2, 3, 4, 9;
    String ioos_category "Other";
    String long_name "Sea Surface Temperature QARTOD Individual Tests";
    String short_name "sea_surface_temperature_qc_tests";
    String standard_name "quality_flag";
  }
  station {
    String cf_role "timeseries_id";
    String ioos_category "Identifier";
    String ioos_code "urn:ioos:station:com.axiomdatascience:123110";
    String long_name "42370 - Holstein - Green Canyon 645";
    String short_name "ism-gcoos-wmo_42370";
    String type "fixed";
  }
 }
  NC_GLOBAL {
    String cdm_altitude_proxy "z";
    String cdm_data_type "TimeSeriesProfile";
    String cdm_profile_variables "time";
    String cdm_timeseries_variables "station,longitude,latitude";
    String contributor_email ",None,feedback@axiomdatascience.com";
    String contributor_name "World Meteorological Organization (WMO),Anadarko Petroleum Corporation,Axiom Data Science";
    String contributor_role "contributor,contributor,processor";
    String contributor_role_vocabulary "NERC";
    String contributor_url "https://wmo.int/,http://www.anadarko.com/,https://www.axiomdatascience.com";
    String Conventions "IOOS-1.2, CF-1.6, ACDD-1.3, NCCSV-1.2";
    String creator_country "USA";
    String creator_email "felimon.gayanilo@tamucc.edu";
    String creator_institution "Felimon Gayanilo";
    String creator_name "Felimon Gayanilo";
    String creator_sector "academic";
    String creator_type "institution";
    String creator_url "http://orcid.org/0000-0003-0520-5737";
    String defaultDataQuery "sea_surface_temperature_qc_agg,sea_water_speed,sea_surface_temperature,z,time,sea_water_speed_qc_agg,upward_sea_water_velocity,upward_sea_water_velocity_qc_agg&time>=max(time)-3days";
    Float64 Easternmost_Easting -90.536;
    String featureType "TimeSeriesProfile";
    Float64 geospatial_lat_max 27.322;
    Float64 geospatial_lat_min 27.322;
    String geospatial_lat_units "degrees_north";
    Float64 geospatial_lon_max -90.536;
    Float64 geospatial_lon_min -90.536;
    String geospatial_lon_units "degrees_east";
    Float64 geospatial_vertical_max -61.06;
    Float64 geospatial_vertical_min -1315.0;
    String geospatial_vertical_positive "up";
    String geospatial_vertical_units "m";
    String history 
"Downloaded from Gulf of Mexico Coastal Ocean Observing System (GCOOS) at https://erddap.gcoos.org/erddap/tabledap/wmo_42370
2024-12-22T14:34:40Z https://erddap.gcoos.org/erddap/tabledap/wmo_42370
2024-12-22T14:34:40Z http://erddap.sensors.ioos.us/erddap/tabledap/ism-gcoos-wmo_42370.html";
    Int32 id 123110;
    String infoUrl "https://sensors.ioos.us/#metadata/123110/station";
    String institution "Felimon Gayanilo";
    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.";
    String naming_authority "com.axiomdatascience";
    Float64 Northernmost_Northing 27.322;
    String platform "fixed";
    String platform_name "42370 - Holstein - Green Canyon 645";
    String platform_vocabulary "http://mmisw.org/ont/ioos/platform";
    String processing_level "Level 2";
    String publisher_country "USA";
    String publisher_email "None";
    String publisher_institution "Gulf of Mexico Coastal Ocean Observing System (GCOOS)";
    String publisher_name "Gulf of Mexico Coastal Ocean Observing System (GCOOS)";
    String publisher_sector "ioos_ra";
    String publisher_type "institution";
    String publisher_url "http://gcoos.org/";
    String references "https://erddap.gcoos.org/erddap/tabledap/wmo_42370,https://erddap.gcoos.org/erddap/tabledap/wmo_42370,";
    String sourceUrl "https://erddap.gcoos.org/erddap/tabledap/wmo_42370";
    Float64 Southernmost_Northing 27.322;
    String standard_name_vocabulary "CF Standard Name Table v72";
    String station_id "123110";
    String summary "Timeseries data from '42370 - Holstein - Green Canyon 645' (ism-gcoos-wmo_42370)";
    String time_coverage_end "2024-12-22T08:58:00Z";
    String time_coverage_start "2023-02-17T10:19:00Z";
    String title "42370 - Holstein - Green Canyon 645";
    Float64 Westernmost_Easting -90.536;
    String wmo_platform_code "42370";
  }
}

 

---

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