Easier access to scientific data
Brought to you by CalCOFI
|
CalCOFI ERDDAP
Easier access to scientific data |
|
Brought to you by CalCOFI |
| Dataset Title: | CalCOFI CTD Measurements (full)
|
| Institution: | CalCOFI (Dataset ID: calcofi_ctd_measurement) |
| Information: | Summary
| License
| FGDC
| ISO 19115
| Metadata
| Background
| Subset
| Make a graph
|
Attributes {
s {
ctd_cast_uuid {
String comment "FK to ctd_cast.ctd_cast_uuid";
String ioos_category "Identifier";
String long_name "CTD Cast UUID";
}
time {
String _CoordinateAxisType "Time";
Float64 actual_range 8.85554065e+8, 1.76979114e+9;
String axis "T";
String comment "UTC timestamp parsed from date_time_utc string";
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 actual_range 29.80726, 37.85147;
String axis "Y";
String comment "GPS decimal latitude; downcast = start latitude, upcast = latitude at first bottle tripped (CalCOFI Lat_Dec)";
String ioos_category "Location";
String long_name "Latitude";
String standard_name "latitude";
String units "degrees_north";
}
longitude {
String _CoordinateAxisType "Lon";
Float64 actual_range -126.4843, -117.2734;
String axis "X";
String comment "GPS decimal longitude; downcast = start longitude, upcast = longitude at first bottle tripped (CalCOFI Lon_Dec)";
String ioos_category "Location";
String long_name "Longitude";
String standard_name "longitude";
String units "degrees_east";
}
depth {
String _CoordinateAxisType "Height";
String _CoordinateZisPositive "down";
Float64 actual_range 1.0, 3630.0;
String axis "Z";
String comment "depth in meters";
String ioos_category "Location";
String long_name "Depth";
String positive "down";
String standard_name "depth";
String units "m";
}
cruise_key {
String comment "cruise identifier in YYYY-MM-NODC format; hive partition key";
String ioos_category "Identifier";
String long_name "Cruise Key";
}
site_key {
String comment "CalCOFI Line and Station composite key in the form \"LLL.L SSS.S\" (renamed from Sta_ID)";
String ioos_category "Identifier";
String long_name "Site Key";
}
line {
String comment "CalCOFI Line in LLL.L format (e.g. 80.0)";
String ioos_category "Location";
String long_name "Line";
}
sta {
String comment "CalCOFI Station in SSS.S format (e.g. 60.0)";
String ioos_category "Other";
String long_name "Station";
}
measurement_type {
String comment "measurement type key (FK to measurement_type.measurement_type)";
String ioos_category "Other";
String long_name "Measurement Type";
}
measurement_value {
String comment "Units VARY by measurement_type — this long-format column holds the numeric value for whichever sensor the row's measurement_type names. Canonical examples: temperature (degC), salinity (PSS-78), oxygen_ml_l (ml/L), sigma_theta (kg/m3), oxygen_saturation (%), oxygen_umol_kg (umol/kg), chlorophyll_a (ug/L), phaeopigment (ug/L). See the measurement_type variable and https://calcofi.io/schema.";
String ioos_category "Other";
String long_name "Measurement Value";
}
measurement_qual {
String comment "quality code (nullable)";
String ioos_category "Other";
String long_name "Measurement Quality";
}
ctd_measurement_uuid {
String comment "PK: deterministic UUID v5 from (ctd_cast_uuid, depth_m, measurement_type)";
String ioos_category "Identifier";
String long_name "CTD Measurement UUID";
}
}
NC_GLOBAL {
String cdm_data_type "Point";
String comment "Long format: one row per cast x depth x measurement_type. measurement_value units depend on measurement_type. time/latitude/longitude are denormalized from ctd_cast via a DuckDB view over Parquet (EDDTableFromDatabase) — see https://calcofi.io/schema.";
String Conventions "COARDS, CF-1.10, ACDD-1.3";
String creator_email "calcofi@ucsd.edu";
String creator_name "CalCOFI";
String creator_url "https://calcofi.org";
Float64 Easternmost_Easting -117.2734;
String featureType "Point";
Float64 geospatial_lat_max 37.85147;
Float64 geospatial_lat_min 29.80726;
String geospatial_lat_units "degrees_north";
Float64 geospatial_lon_max -117.2734;
Float64 geospatial_lon_min -126.4843;
String geospatial_lon_units "degrees_east";
Float64 geospatial_vertical_max 3630.0;
Float64 geospatial_vertical_min 1.0;
String geospatial_vertical_positive "down";
String geospatial_vertical_units "m";
String history
"2026-07-07T22:42:33Z (source database)
2026-07-07T22:42:33Z http://localhost:8090/erddap/tabledap/calcofi_ctd_measurement.html";
String infoUrl "https://calcofi.org";
String institution "CalCOFI";
String keywords "CalCOFI, California Current, CTD, depth, fluorescence, ocean, oxygen, profiles, salinity, temperature";
String license "CC-BY 4.0";
Float64 Northernmost_Northing 37.85147;
String project "CalCOFI";
String publisher_name "CalCOFI";
String publisher_url "https://calcofi.org";
String references "https://calcofi.io/schema ; https://calcofi.org/data/oceanographic-data/ctd-cast-files/";
String source "CalCOFI CTD cast files (https://calcofi.org)";
String sourceUrl "(source database)";
Float64 Southernmost_Northing 29.80726;
String standard_name_vocabulary "CF Standard Name Table v79";
String subsetVariables "cruise_key, measurement_type";
String summary "Full long-format CTD measurements (~216M rows, all sensor variants), joined to cast coordinates/time. Served via DuckDB views over Parquet partitioned by cruise_key (EDDTableFromDatabase). The adaptively-thinned calcofi_ctd_thin is the lighter headline table.";
String time_coverage_end "2026-01-30T16:39:00Z";
String time_coverage_start "1998-01-23T11:14:25Z";
String title "CalCOFI CTD Measurements (full)";
Float64 Westernmost_Easting -126.4843;
}
}
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.
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.