CalCOFI.io CalCOFI.io Storage

ducklake/releases/v2026.06.07 / RELEASE_NOTES.md · raw markdown ↗

CalCOFI integrated database release v2026.06.07

RELEASE_NOTES.md on gs://calcofi-db/ducklake/releases/v2026.06.07

Release date: 2026-06-07 Documented with v2026.06.07 – v2026.06.08.

Phytoplankton (Venrick, region-pooled) added; 44 tables; full ingest + release re-run with refreshed outputs, DB and PMTiles.

Contents (generated)

table rows
_spatial 3,373
_spatial_attr 40,298
bottle 895,371
bottle_measurement 11,135,600
cast_condition 235,513
casts 35,644
cruise 691
cruise_summary 691
ctd_cast 5,550,014
ctd_summary 108,390,249 partitioned
ctd_thin 5,551,551 partitioned
dataset 5
dic_measurement 16,391
dic_sample 4,391
dic_summary 15,786
grid 218
ichthyo 852,228
invert 9,223
lookup 26
measurement_type 105
net 76,512
segment 60,413
ship 48
site 61,104
species 1,167
taxa_rank 41
taxon 3,385
tow 75,506

28 tables, 133,015,544 rows, 3.72 GB.

Datasets (4): calcofi_bottle, calcofi_ctd-cast, calcofi_dic, swfsc_ichthyo

Validation: 9 pass / 0 fail / 4 skip (consumer-contract suite, 2026-06-07T09:20:08Z).

How to cite

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

Cite the source datasets you use alongside the release:

  • 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
  • swfsc_ichthyo — NOAA Fisheries SWFSC. CalCOFI Ichthyoplankton Database. · license pending

Access

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

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