|
CalCOFI ERDDAP
Easier access to scientific data |
|
Brought to you by CalCOFI |
| Dataset Title: | CalCOFI CTD Profiles (thinned)
|
| Institution: | CalCOFI (Dataset ID: calcofi_ctd_thin) |
| 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.776981672e+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.82682, 37.84907;
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 0.968, 3630.0;
String axis "Z";
String comment "depth in meters (retained depths only)";
String ioos_category "Location";
String long_name "Depth";
String positive "down";
String standard_name "depth";
String units "m";
}
cruise_key {
String comment "cruise identifier; 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; canonical types only (FK to measurement_type.measurement_type where is_canonical)";
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";
}
cast_dir {
String comment "single retained direction per physical cast: D (downcast, preferred) or U (upcast, fallback)";
String ioos_category "Other";
String long_name "Cast Direction";
}
retained_reason {
String comment "why this depth was kept: grid (on the ~10 m grid) or inflection (RDP-retained between grid nodes)";
String ioos_category "Other";
String long_name "Retained Reason";
}
ctd_thin_uuid {
String comment "PK: deterministic UUID v5 from (ctd_cast_uuid, depth_m, measurement_type)";
String ioos_category "Identifier";
String long_name "CTD Thin 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.84907;
Float64 geospatial_lat_min 29.82682;
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 0.968;
String geospatial_vertical_positive "down";
String geospatial_vertical_units "m";
String history
"2026-07-07T22:38:58Z (source database)
2026-07-07T22:38:58Z http://localhost:8090/erddap/tabledap/calcofi_ctd_thin.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.84907;
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.82682;
String standard_name_vocabulary "CF Standard Name Table v79";
String subsetVariables "cruise_key, measurement_type";
String summary "Adaptively-thinned CTD profiles (long format, one row per cast/depth/measurement_type; canonical sensors only, ~10 m depth grid with inflection points preserved), joined to cast coordinates/time. Served via DuckDB views over partitioned Parquet (EDDTableFromDatabase).";
String time_coverage_end "2026-04-23T22:01:12Z";
String time_coverage_start "1998-01-23T11:14:25Z";
String title "CalCOFI CTD Profiles (thinned)";
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.