Hydrographic Bottle
CalCOFI Bottle Database
calcofi_bottleCalCOFIunstatedv2026.09.11ingested
- years
- 1949–2021
- observations
- 11,135,581
- sampling events
- 35,644
- stations
- 213
- variables
- 26
- depth
- 0–5351 m
Overview
Hydrographic bottle data including temperature, salinity, oxygen, nutrients, pigments, and C14 from CalCOFI cruises.
Open with the provider
- Q10 license — proposed
- Q11 pi_names — proposed
calcofi.org page ↗source ↗ingest notebook ↗record JSON JSON-LD
Coverage
26 variables
alkalinity_rep1 umol/kgammonia umol/Lc14_dark mgC/m3/hldc14_mean mgC/m3/hldc14_rep1 mgC/m3/hldc14_rep2 mgC/m3/hldchlorophyll_a ug/Ldic_rep1 umol/kglight_pct %nitrate umol/Lnitrite umol/Loxygen_ml_l ml/Loxygen_saturation %oxygen_umol_kg umol/kgphaeopigment ug/Lphosphate umol/L
Also contributes to
- Carbonate System — alkalinity_rep1, dic_rep1
- Nutrients & Chemistry — ammonia, nitrate, nitrite, phosphate, r_ammonium, silicate
- Productivity & Pigments — c14_dark, c14_mean, c14_rep1, c14_rep2, chlorophyll_a, light_pct, phaeopigment
Access
Every endpoint this dataset can be reached through, grouped by how you would use it. Each name is the link; the copy button beside it copies the address. Everything is in the release record and was answered when the release was cut.
Apps that read this dataset from the release. The icons after a name are the app’s lenses — the spatial grain it shows the data at.
Every way to have the bytes, by source. Nothing here asks you to register first.
Tables from the release (Parquet)
The release’s own tables, as the parquet objects it is frozen from — the same bytes every app and package below reads. A table this dataset shares with others holds every dataset’s rows, so filter on dataset_key; a partition holds only this dataset’s. since is the release whose rows these are: an unchanged table keeps its object.
CF netCDF
One self-describing file, for a tool that reads netCDF.
how far this file is CF
CF-1.10 where CF applies (coordinates, units, standard names, time). The cast -> bottle -> occurrence hierarchy uses netCDF-4 groups with explicit parent_index links; CF defines no feature type for this nesting.
ERDDAP (erddap.calcofi.io)
One ERDDAP dataset per grain. Subset in the browser or query it from a script; for netCDF take the CF file above.
- observations
- one row per measurement — value, units and quality flag — joined to the sampling event it was taken on
- sampling events
- one row per cast, tow or transect: when, where and how it was sampled, with the effort that scales it
Legacy ids, still answering until 2026-12-04: calcofi_casts (replaced by calcofi_bottle)
From the provider
The dataset as its provider publishes it, before CalCOFI ingested it.
The same release, from a script or a browser SQL shell.
Packages
The whole release, pinned to a version, with the citation one call away.
con <- calcofi4r::cc_get_db()
calcofi4r::cc_cite("calcofi_bottle")
con = calcofi4py.cc_get_db()
calcofi4py.cite("calcofi_bottle")
DuckDB, anywhere
No CalCOFI package needed: each table above is a plain parquet object, readable by any DuckDB (or Arrow, pandas, Spark) from its URL. The path carries a content hash — a table whose rows did not change between releases keeps the same object, so nothing unchanged is stored or downloaded twice. Swap in any table above; one shared with other datasets needs WHERE dataset_key = 'calcofi_bottle'. Every object of every release is listed in db-schema.
SELECT *
FROM read_parquet('https://storage.googleapis.com/calcofi-db/ducklake/tables/obs/dataset_key=calcofi_bottle/67fbe04bd3f7f169c142fd3b/data_0.parquet')
LIMIT 100;
db-query, in the browser
__TBL:obs__ is db-query’s name for the pinned release’s obs object — the hashed path above, resolved for you — so the same SQL keeps working when a release changes the object.
-- calcofi_bottle in the CalCOFI release v2026.09.11
SELECT *
FROM __TBL:obs__
WHERE dataset_key = 'calcofi_bottle'
LIMIT 100;
Records about the data, in the standards each portal harvests.
Where this dataset is registered outside calcofi.io: each portal’s role, what it is for, the dataset’s status there and the identifier it is known by. The policy — which portal is the archive of record and why — is in Portals.
Policy Archive of record: none yet — a CalCOFI program dataset with no DOI-bearing deposit. EDI is the planned archive (the package is built from each release and staged for review; the deposit waits on the EDI account); NCEI planned through the SWFSC data manager. OBIS does not apply (no occurrences). Mirrored on NOAA CoastWatch ERDDAP.
Everything here is open — nothing on calcofi.io asks you to register first. If this dataset ends up in something you build or publish, register your use so it can be credited and linked back; to hear when a release changes it, stay informed. Questions: data@calcofi.io.
Cite
This dataset's own citation. What to cite, and how, is a chapter of the docs book.
CalCOFI. (2023). CalCOFI Bottle Database 194903-202105. CalCOFI.org.
BibTeX
@misc{calcofi_bottle,
title = {CalCOFI Bottle Database},
howpublished = {CalCOFI. (2023). CalCOFI Bottle Database 194903-202105. CalCOFI.org.},
year = {2023}
}
…and the release it came from
CalCOFI (2026). CalCOFI Integrated Database, release v2026.09.11 [Data set]. Scripps Institution of Oceanography, NOAA Fisheries, and California Department of Fish and Wildlife. https://calcofi.io/db-schema/?v=v2026.09.11
BibTeX
@misc{calcofi_release_v2026_09_11,
title = {CalCOFI Integrated Database, release v2026.09.11},
author = {CalCOFI},
year = {2026},
publisher = {Scripps Institution of Oceanography, NOAA Fisheries, and California Department of Fish and Wildlife},
url = {https://calcofi.io/db-schema/?v=v2026.09.11}
}
Source files
The original inputs the ingest notebook read, mirrored nightly from the shared Drive to the public files bucket — 11 files, 423 MB.
- Bottle Database – CalCOFI.pdf1016 KB2026-06-09
- Bottle Database – CalCOFI.webloc283 B2026-06-09
- Bottle Field Descriptions - UTF-8.csv4.1 KB2026-06-09
- Bottle Field Descriptions.csv4.2 KB2026-06-09
- CalCOFI_Database_194903-202001_csv_22Sep2021/194903-202001_Bottle.csv197 MB2026-06-09
- CalCOFI_Database_194903-202001_csv_22Sep2021/194903-202001_Cast.csv12.3 MB2026-06-09
- CalCOFI_Database_194903-202001_csv_22Sep2021/Cast Field Descriptions.csv3.5 KB2026-06-09
- CalCOFI_Database_194903-202105_csv_16October2023/194903-202105_Bottle.csv167 MB2026-06-09
- CalCOFI_Database_194903-202105_csv_16October2023/194903-202105_Cast.csv11.9 MB2026-06-09
- Cast Field Descriptions.csv3.5 KB2026-06-09
- bottle_cast.rds32.8 MB2026-06-09