CalCOFI integrated database release v2026.07.30

Release date: 2026-07-30

Four new datasets, the CTD QA/QC engine, and generic publishing

• Datasets 12 → 15: CCE-LTER euphausiids, CCE-LTER picoplankton/bacteria, SIO mesopelagic fish, and the METS underway series (obs_mets_full, 19.9 M rows). CDFW Dungeness crab is ingested but held out of the release behind a new in_release: false flag pending permission.
• CTD QA/QC engine: a declarative rule registry (metadata/qc_rules/), climatology-anomaly, seafloor-bathymetry and full-resolution profile rules, a Findings report with an input-fingerprint fast path, and a generated QA/QC protocol document.
• Publishing: one dataset-agnostic publish_to-netcdf + publish_to-erddap for every dataset; whole-dataset CF NetCDF to calcofi-files-public; storage.calcofi.io browsing.
• Registries: the hydro-master Access database reconciled against the release; a write-round-trip bug that let nine ingests corrupt measurement_type.csv with literal "NA" fixed; -99 sentinels stripped from CTD; data_stage on sample; one question registry convention (questions.csv, read_questions()).

Packages: calcofi4db 2.11.0 → 3.4.0; calcofi4r 1.4.0–1.4.3 (non-blocking usage analytics).

Contents (generated)

16 tables, 233,728,804 rows, 1.79 GB.

Datasets (15): calcofi_bird_mammal_census, calcofi_bottle, calcofi_ctd-cast, calcofi_dic, calcofi_mets, calcofi_phyllosoma, calcofi_phytoplankton, cce-lter_euphausiids, cce-lter_picoplankton-bacteria, cce-lter_zoodb, cce-lter_zooscan, pic_zooplankton, swfsc_cufes, swfsc_ichthyo, ucsd_sio_mesopelagic-fish

Validation: 19 pass / 0 fail / 4 skip (consumer-contract suite, 2026-07-30T04:38:51Z).

How to cite

CalCOFI (2026). CalCOFI Integrated Database, release v2026.07.30 [Data set]. Scripps Institution of Oceanography, NOAA Fisheries, and California Department of Fish and Wildlife. https://calcofi.io/db-schema/?v=v2026.07.30

Cite the source datasets you use alongside the release:

• calcofi_bird_mammal_census — citation pending · license pending
• calcofi_bottle — CalCOFI. (2023). CalCOFI Bottle Database 194903-202105. CalCOFI.org. · license pending
• calcofi_ctd-cast — CalCOFI. (2023). CalCOFI CTD Cast Files. CalCOFI.org. · license pending
• calcofi_dic — Keeling, C.D.; Lueker, T.J.; Emanuele, G.; Dickson, A.G.; Martz, T.R.; Wolfe, W.H.; Mau, A. (2025). Discrete profile dissolved inorganic carbon, total alkalinity, water temperature and salinity measurements for CalCOFI (NCEI Accession 0301029). NOAA NCEI. https://doi.org/10.25921/3w9f-jd72 · CC BY 4.0
• calcofi_mets — CalCOFI. Underway (METS) TSG/Meteorology Data. CalCOFI.org. · license pending
• calcofi_phyllosoma — citation pending · license pending
• calcofi_phytoplankton — citation pending · license pending
• cce-lter_euphausiids — citation pending · license pending
• cce-lter_picoplankton-bacteria — Landry, M. (2004-2023). Picoplankton and Bacteria Abundance (CalCOFI Cruise). CCE LTER. · license pending
• cce-lter_zoodb — citation pending · license pending
• cce-lter_zooscan — citation pending · license pending
• pic_zooplankton — citation pending · license pending
• swfsc_cufes — citation pending · license pending
• swfsc_ichthyo — NOAA Fisheries SWFSC. CalCOFI Ichthyoplankton Database. · license pending
• ucsd_sio_mesopelagic-fish — Koslow, J. Anthony (2016). CalCOFI Trawl Data. In California Cooperative Oceanic Fisheries Investigations (CalCOFI): Acoustic and Trawl Data. UC San Diego Library Digital Collections. https://doi.org/10.6075/J0BZ64DH · CC BY 4.0

Access

con <- calcofi4r::cc_get_db(version = "v2026.07.30")

con = calcofi4py.cc_get_db("v2026.07.30")

Parquet: https://storage.googleapis.com/calcofi-db/ducklake/releases/v2026.07.30/parquet/{table}.parquet; full history: RELEASES.md.