ERDDAP > tabledap > Data Access Form

Dataset Title:	SC_Harbor - SCH2025_089_85500
Institution:	Coastal and Marine Hazards and Resources Program, U.S. Geological Survey   (Dataset ID: SC_Harbor_SCH2025_089_85500_nc)
Information:	Summary | License | FGDC | ISO 19115 | Metadata | Background | Files | Make a graph

 

Variable	Optional Constraint #1		Optional Constraint #2		Minimum	Maximum
station_id	!= =~ <= >= = < >		!= =~ <= >= = < >		"SC_Harbor_SCH2025_..."	"SC_Harbor_SCH2025_..."
time (time (UTC), UTC)	!= =~ <= >= = < >		!= =~ <= >= = < >		2025-03-31T23:44:18Z	2025-03-31T23:53:18Z
depth_m (depth below mean sea level, m)	!= =~ <= >= = < >		!= =~ <= >= = < >		-4.31	4.19
z (height relative to sea bed, m)	!= =~ <= >= = < >		!= =~ <= >= = < >		1.31	9.81
latitude (degrees_north)	!= =~ <= >= = < >		!= =~ <= >= = < >		-122.002162	-122.002162
longitude (degrees_east)	!= =~ <= >= = < >		!= =~ <= >= = < >		36.963897	36.963897
AGC_1202 (Average Echo Intensity, counts)	!= =~ <= >= = < >		!= =~ <= >= = < >		64.73373	229.6154
Werr_1201 (Error Velocity, m s-1)	!= =~ <= >= = < >		!= =~ <= >= = < >		-0.1100913	0.1633279
w_1204 (Vertical Velocity, m s-1)	!= =~ <= >= = < >		!= =~ <= >= = < >		-0.1179296	0.08073723
u_1205 (Eastward Velocity, m s-1)	!= =~ <= >= = < >		!= =~ <= >= = < >		-0.2090599	0.4025474
v_1206 (Northward Velocity, m s-1)	!= =~ <= >= = < >		!= =~ <= >= = < >		-0.1032294	0.1216707
e_std (m s-1)	!= =~ <= >= = < >		!= =~ <= >= = < >		0.0196407	0.1330364
w_std (m s-1)	!= =~ <= >= = < >		!= =~ <= >= = < >		0.01408885	0.09729018
u_std (m s-1)	!= =~ <= >= = < >		!= =~ <= >= = < >		0.02331466	0.399414
v_std (m s-1)	!= =~ <= >= = < >		!= =~ <= >= = < >		0.07094886	0.2640216
PGd_1203 (Percent Good Pings, percent)	!= =~ <= >= = < >		!= =~ <= >= = < >		0.07094886	9.96921E36
Tx_1211 (Temperature, Degrees Celsius)	!= =~ <= >= = < >		!= =~ <= >= = < >		13.60607	13.65769
P_1 (Pressure, dBar)	!= =~ <= >= = < >		!= =~ <= >= = < >		0.9536272	0.9580893
pressure_std (dBar)	!= =~ <= >= = < >		!= =~ <= >= = < >		0.01864257	0.01987133
num_pings	!= =~ <= >= = < >		!= =~ <= >= = < >		56	169

 

Server-side Functions

distinct()

orderBy orderByDescending orderByClosest orderByCount orderByLimit orderByMax orderByMin orderByMinMax orderByMean orderBySum (" station_id time depth_m z latitude longitude AGC_1202 Werr_1201 w_1204 u_1205 v_1206 e_std w_std u_std v_std PGd_1203 Tx_1211 P_1 pressure_std num_pings station_id time depth_m z latitude longitude AGC_1202 Werr_1201 w_1204 u_1205 v_1206 e_std w_std u_std v_std PGd_1203 Tx_1211 P_1 pressure_std num_pings station_id time depth_m z latitude longitude AGC_1202 Werr_1201 w_1204 u_1205 v_1206 e_std w_std u_std v_std PGd_1203 Tx_1211 P_1 pressure_std num_pings station_id time depth_m z latitude longitude AGC_1202 Werr_1201 w_1204 u_1205 v_1206 e_std w_std u_std v_std PGd_1203 Tx_1211 P_1 pressure_std num_pings station_id time depth_m z latitude longitude AGC_1202 Werr_1201 w_1204 u_1205 v_1206 e_std w_std u_std v_std PGd_1203 Tx_1211 P_1 pressure_std num_pings ")

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). .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 {
  station_id {
    String actual_range 
"SC_Harbor_SCH2025_089_85500_nc
SC_Harbor_SCH2025_089_85500_nc";
    String cf_role "timeseries_id";
    String ioos_category "Identifier";
    String long_name "Station ID";
  }
  time {
    String _CoordinateAxisType "Time";
    Float64 actual_range 1.74346465826e+9, 1.74346519826e+9;
    String axis "T";
    String calendar "proleptic_gregorian";
    String ioos_category "Time";
    String long_name "time (UTC)";
    String standard_name "time";
    String time_origin "01-JAN-1970 00:00:00";
    String units "seconds since 1970-01-01T00:00:00Z";
  }
  depth_m {
    Float32 actual_range -4.31, 4.19;
    String ioos_category "Other";
    String long_name "depth below mean sea level";
    String positive "down";
    String standard_name "depth";
    String units "m";
  }
  z {
    Float32 actual_range 1.31, 9.81;
    String axis "Z";
    String ioos_category "Other";
    String long_name "height relative to sea bed";
    String positive "up";
    String standard_name "height";
    String units "m";
  }
  latitude {
    String _CoordinateAxisType "Lat";
    Float64 actual_range -122.002162, -122.002162;
    String axis "Y";
    String ioos_category "Location";
    String long_name "Latitude";
    String standard_name "latitude";
    String units "degrees_north";
  }
  longitude {
    String _CoordinateAxisType "Lon";
    Float64 actual_range 36.963897, 36.963897;
    String axis "X";
    String ioos_category "Location";
    String long_name "Longitude";
    String standard_name "longitude";
    String units "degrees_east";
  }
  AGC_1202 {
    Float32 actual_range 64.73373, 229.6154;
    String ioos_category "Other";
    String long_name "Average Echo Intensity";
    Float32 missing_value 1.0e+20;
    String units "counts";
  }
  Werr_1201 {
    Float32 actual_range -0.1100913, 0.1633279;
    String ioos_category "Other";
    String long_name "Error Velocity";
    Float32 missing_value 1.0e+20;
    String units "m s-1";
  }
  w_1204 {
    Float32 actual_range -0.1179296, 0.08073723;
    String ioos_category "Other";
    String long_name "Vertical Velocity";
    Float32 missing_value 1.0e+20;
    String units "m s-1";
  }
  u_1205 {
    Float32 actual_range -0.2090599, 0.4025474;
    String ioos_category "Other";
    String long_name "Eastward Velocity";
    Float32 missing_value 1.0e+20;
    String standard_name "upward_sea_water_velocity";
    String units "m s-1";
  }
  v_1206 {
    Float32 actual_range -0.1032294, 0.1216707;
    String ioos_category "Other";
    String long_name "Northward Velocity";
    Float32 missing_value 1.0e+20;
    String standard_name "eastward_sea_water_velocity";
    String units "m s-1";
  }
  e_std {
    Float32 actual_range 0.0196407, 0.1330364;
    String ioos_category "Other";
    String long_name "Error Velocity Standard Deviation";
    Float32 missing_value 1.0e+20;
    String standard_name "northward_sea_water_velocity";
    String units "m s-1";
  }
  w_std {
    Float32 actual_range 0.01408885, 0.09729018;
    String ioos_category "Other";
    String long_name "Vertical Velocity Standard Deviation";
    Float32 missing_value 1.0e+20;
    String units "m s-1";
  }
  u_std {
    Float32 actual_range 0.02331466, 0.399414;
    String ioos_category "Other";
    String long_name "Eastward Velocity Standard Deviation";
    Float32 missing_value 1.0e+20;
    String units "m s-1";
  }
  v_std {
    Float32 actual_range 0.07094886, 0.2640216;
    String ioos_category "Other";
    String long_name "Northward Velocity Standard Deviation";
    Float32 missing_value 1.0e+20;
    String units "m s-1";
  }
  PGd_1203 {
    Float32 actual_range 0.07094886, 9.96921e+36;
    String ioos_category "Other";
    String long_name "Percent Good Pings";
    String units "percent";
  }
  Tx_1211 {
    Float32 actual_range 13.60607, 13.65769;
    String ioos_category "Other";
    String long_name "Temperature";
    Float32 missing_value 1.0e+20;
    String standard_name "sea_water_temperature";
    String units "Degrees Celsius";
  }
  P_1 {
    Float32 actual_range 0.9536272, 0.9580893;
    String ioos_category "Other";
    String long_name "Pressure";
    Float32 missing_value 1.0e+20;
    String standard_name "sea_water_pressure";
    String units "dBar";
  }
  pressure_std {
    Float32 actual_range 0.01864257, 0.01987133;
    String ioos_category "Other";
    String long_name "Pressure Standard Deviation";
    Float32 missing_value 1.0e+20;
    String units "dBar";
  }
  num_pings {
    Int16 actual_range 56, 169;
    String ioos_category "Other";
  }
 }
  NC_GLOBAL {
    String cdm_data_type "TimeSeries";
    String cdm_timeseries_variables "station_id";
    String Conventions "COARDS, CF-1.6, ACDD-1.3";
    String creator_url "https://www.usgs.gov";
    Float64 DELTA_T 180;
    Float64 Easternmost_Easting 36.963897;
    String experiment_name "SC_Harbor";
    String featureType "TimeSeries";
    String frequency "1200kHz";
    Float64 geospatial_lat_max -122.002162;
    Float64 geospatial_lat_min -122.002162;
    String geospatial_lat_units "degrees_north";
    Float64 geospatial_lon_max 36.963897;
    Float64 geospatial_lon_min 36.963897;
    String geospatial_lon_units "degrees_east";
    String history 
"2025-04-06T16:10:44Z (local files)
2025-04-06T16:10:44Z https://cmgds.marine.usgs.gov/erddap/tabledap/SC_Harbor_SCH2025_089_85500_nc.html";
    String infoUrl "https://cmgds.marine.usgs.gov/ocean-time-series/";
    String inst_type "RD Instruments Workhorse ADCP";
    String institution "Coastal and Marine Hazards and Resources Program, U.S. Geological Survey";
    Float64 instrument_height_above_bottom 0.5;
    Float64 latitude -122.002162;
    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 Location "Santa Cruz Harbor";
    Float64 longitude 36.963897;
    String NCProperties "version=2,netcdf=4.9.4-development,hdf5=1.14.2";
    Float64 Northernmost_Northing -122.002162;
    String Organization "U.S. Geological Survey";
    String Program "Coastal and Marine Hazards and Resources Program";
    String publisher_url "https://www.usgs.gov";
    String Region "Monterey Bay";
    String SciPi "Stephanie Ross, Kurt Rosenberger";
    Float64 serial_number 21185;
    String sourceUrl "(local files)";
    Float64 Southernmost_Northing -122.002162;
    String summary "Unspecified";
    String time_coverage_end "2025-03-31T23:53:18Z";
    String time_coverage_start "2025-03-31T23:44:18Z";
    String title "SC_Harbor - SCH2025_089_85500";
    Float64 WATER_DEPTH 5;
    Float64 Westernmost_Easting 36.963897;
  }
}

 

---

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.