ERDDAP > tabledap > Data Access Form

Dataset Title:	SC_Harbor - SC_Harbor_ADCP_7days
Institution:	Coastal and Marine Hazards and Resources Program, U.S. Geological Survey   (Dataset ID: SC_Harbor_SC_Harbor_ADCP_7days_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_SC_Harbo..."	"SC_Harbor_SC_Harbo..."
time (time (UTC), UTC)	!= =~ <= >= = < >		!= =~ <= >= = < >		2026-01-29T00:01:41Z	2026-02-04T05:28:28Z
depth_m (depth below mean sea level, m)	!= =~ <= >= = < >		!= =~ <= >= = < >		-4.56	3.94
z (height relative to sea bed, m)	!= =~ <= >= = < >		!= =~ <= >= = < >		1.31	9.81
latitude (degrees_north)	!= =~ <= >= = < >		!= =~ <= >= = < >		36.9644	36.9644
longitude (degrees_east)	!= =~ <= >= = < >		!= =~ <= >= = < >		-122.00248	-122.00248
AGC_1202 (Average Echo Intensity, counts)	!= =~ <= >= = < >		!= =~ <= >= = < >		58.29438	225.9728
Werr_1201 (Error Velocity, m s-1)	!= =~ <= >= = < >		!= =~ <= >= = < >		-0.1984744	0.1984744
w_1204 (Vertical Velocity, m s-1)	!= =~ <= >= = < >		!= =~ <= >= = < >		-0.2093971	0.2292044
u_1205 (Eastward Velocity, m s-1)	!= =~ <= >= = < >		!= =~ <= >= = < >		-0.7782861	0.6162488
v_1206 (Northward Velocity, m s-1)	!= =~ <= >= = < >		!= =~ <= >= = < >		-0.8139994	0.6388317
e_std (m s-1)	!= =~ <= >= = < >		!= =~ <= >= = < >		0.0	0.1943395
w_std (m s-1)	!= =~ <= >= = < >		!= =~ <= >= = < >		0.0	0.1822134
u_std (m s-1)	!= =~ <= >= = < >		!= =~ <= >= = < >		0.0	0.5900196
v_std (m s-1)	!= =~ <= >= = < >		!= =~ <= >= = < >		0.0	0.6303918
PGd_1203 (Percent Good Pings, percent)	!= =~ <= >= = < >		!= =~ <= >= = < >		0.0	9.96921E36
Tx_1211 (Temperature, Degrees Celsius)	!= =~ <= >= = < >		!= =~ <= >= = < >		14.14	15.52858
P_1 (Pressure, dBar)	!= =~ <= >= = < >		!= =~ <= >= = < >		4.469314	5.973965
pressure_std (dBar)	!= =~ <= >= = < >		!= =~ <= >= = < >		0.01605049	0.08918664
u_dpth (m s-1)	!= =~ <= >= = < >		!= =~ <= >= = < >		-0.03443075	0.03730643
v_dpth (m s-1)	!= =~ <= >= = < >		!= =~ <= >= = < >		-0.03443075	0.03730643
u_srf (E-W Surface Velocity, m s-1)	!= =~ <= >= = < >		!= =~ <= >= = < >		-0.03443075	0.03730643
v_srf (N-S Surface Velocity, m s-1)	!= =~ <= >= = < >		!= =~ <= >= = < >		-0.03443075	0.03730643
u_bot (E-W Bottom Velocity, m s-1)	!= =~ <= >= = < >		!= =~ <= >= = < >		-0.03743929	0.04914189
v_bot (N-S Bottom Velocity, m s-1)	!= =~ <= >= = < >		!= =~ <= >= = < >		-0.03743929	0.04914189
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 u_dpth v_dpth u_srf v_srf u_bot v_bot 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 u_dpth v_dpth u_srf v_srf u_bot v_bot 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 u_dpth v_dpth u_srf v_srf u_bot v_bot 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 u_dpth v_dpth u_srf v_srf u_bot v_bot 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 u_dpth v_dpth u_srf v_srf u_bot v_bot 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_SC_Harbor_ADCP_7days_nc
SC_Harbor_SC_Harbor_ADCP_7days_nc";
    String cf_role "timeseries_id";
    String ioos_category "Identifier";
    String long_name "Station ID";
  }
  time {
    String _CoordinateAxisType "Time";
    Float64 actual_range 1.769644901e+9, 1.77018290847e+9;
    String axis "T";
    String calendar "proleptic_gregorian";
    String FillValue "nan";
    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.56, 3.94;
    String FillValue "nan";
    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 FillValue "nan";
    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 36.9644, 36.9644;
    String axis "Y";
    String FillValue "nan";
    String ioos_category "Location";
    String long_name "Latitude";
    String standard_name "latitude";
    String units "degrees_north";
  }
  longitude {
    String _CoordinateAxisType "Lon";
    Float64 actual_range -122.00248, -122.00248;
    String axis "X";
    String FillValue "nan";
    String ioos_category "Location";
    String long_name "Longitude";
    String standard_name "longitude";
    String units "degrees_east";
  }
  AGC_1202 {
    Float32 actual_range 58.29438, 225.9728;
    String FillValue "nan";
    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.1984744, 0.1984744;
    String FillValue "nan";
    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.2093971, 0.2292044;
    String FillValue "nan";
    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.7782861, 0.6162488;
    String FillValue "nan";
    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.8139994, 0.6388317;
    String FillValue "nan";
    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.0, 0.1943395;
    String FillValue "nan";
    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.0, 0.1822134;
    String FillValue "nan";
    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.0, 0.5900196;
    String FillValue "nan";
    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.0, 0.6303918;
    String FillValue "nan";
    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.0, 9.96921e+36;
    String FillValue "nan";
    String ioos_category "Other";
    String long_name "Percent Good Pings";
    String units "percent";
  }
  Tx_1211 {
    Float32 actual_range 14.14, 15.52858;
    String FillValue "nan";
    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 4.469314, 5.973965;
    String FillValue "nan";
    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.01605049, 0.08918664;
    String FillValue "nan";
    String ioos_category "Other";
    String long_name "Pressure Standard Deviation";
    Float32 missing_value 1.0e+20;
    String units "dBar";
  }
  u_dpth {
    Float32 actual_range -0.03443075, 0.03730643;
    String FillValue "nan";
    String ioos_category "Other";
    String long_name "E-W Depth-averaged Velocity";
    Float32 missing_value 1.0e+20;
    String units "m s-1";
  }
  v_dpth {
    Float32 actual_range -0.03443075, 0.03730643;
    String FillValue "nan";
    String ioos_category "Other";
    String long_name "N-S Depth-averaged Velocity";
    Float32 missing_value 1.0e+20;
    String units "m s-1";
  }
  u_srf {
    Float32 actual_range -0.03443075, 0.03730643;
    String FillValue "nan";
    String ioos_category "Other";
    String long_name "E-W Surface Velocity";
    Float32 missing_value 1.0e+20;
    String units "m s-1";
  }
  v_srf {
    Float32 actual_range -0.03443075, 0.03730643;
    String FillValue "nan";
    String ioos_category "Other";
    String long_name "N-S Surface Velocity";
    Float32 missing_value 1.0e+20;
    String units "m s-1";
  }
  u_bot {
    Float32 actual_range -0.03743929, 0.04914189;
    String FillValue "nan";
    String ioos_category "Other";
    String long_name "E-W Bottom Velocity";
    Float32 missing_value 1.0e+20;
    String units "m s-1";
  }
  v_bot {
    Float32 actual_range -0.03743929, 0.04914189;
    String FillValue "nan";
    String ioos_category "Other";
    String long_name "N-S Bottom Velocity";
    Float32 missing_value 1.0e+20;
    String units "m s-1";
  }
  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 -122.00248;
    String experiment_name "SC_Harbor";
    String featureType "TimeSeries";
    String frequency "1200kHz";
    Float64 geospatial_lat_max 36.9644;
    Float64 geospatial_lat_min 36.9644;
    String geospatial_lat_units "degrees_north";
    Float64 geospatial_lon_max -122.00248;
    Float64 geospatial_lon_min -122.00248;
    String geospatial_lon_units "degrees_east";
    String history 
"2026-02-04T18:09:58Z (local files)
2026-02-04T18:09:58Z https://cmgds.marine.usgs.gov/erddap/tabledap/SC_Harbor_SC_Harbor_ADCP_7days_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 36.9644;
    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 -122.00248;
    Float64 magnetic_declination_applied 12.85;
    String NCProperties "version=2,netcdf=4.9.4-development,hdf5=1.14.2";
    Float64 Northernmost_Northing 36.9644;
    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 15029;
    String sourceUrl "(local files)";
    Float64 Southernmost_Northing 36.9644;
    String summary "Unspecified";
    String time_coverage_end "2026-02-04T05:28:28Z";
    String time_coverage_start "2026-01-29T00:01:41Z";
    String title "SC_Harbor - SC_Harbor_ADCP_7days";
    Float64 WATER_DEPTH 4.75;
    Float64 Westernmost_Easting -122.00248;
  }
}

 

---

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.