# Biogeochemical Database - National Reference Station and Continuous Plankton Recorder plankton, pigments and chemistry (CSV)

## Facts

- Provider: IMOS
- License: http://creativecommons.org/licenses/by/4.0/
- Size: 20 objects, 45,694,984 bytes (45.7 MB)
- Records: bgc_trip 4,114; bgc_phyto_raw 46,217; bgc_zoop_raw 66,266; bgc_chemistry 9,316; bgc_pigments 3,077; bgc_picoplankton 5,177; bgc_picoplankton_meta 8,706; bgc_tss 1,518; bgc_tss_meta 3,534
- Format: CSV (in sampled files)
- Stored at: Amazon S3, s3://imos-data/IMOS/BGC_DB/harvested_from_CSIRO (ap-southeast-2)
- Access: public, readable without an account
- Category: Life Sciences
- Source: https://catalogue-imos.aodn.org.au/geonetwork/srv/eng/catalog.search#/metadata/f098f0d0-88ac-4f4b-addb-24b3e5e8d0b9
- Page: https://scigantic.com/archive/b93484c7-9cf9-5b1a-af04-4d711e9fdb31
- Keywords: Life Sciences, time series, CSV, AWS Open Data

## About

This dataset comprises the phytoplankton and zooplankton abundance, biovolume and biomass measurements, HPLC pigments, picoplankton flow cytometry, total suspended solids and water chemistry (salinity, nutrients, carbon, alkalinity, oxygen) from samples collected at the Integrated Marine Observing System (IMOS) National Reference Stations (NRS), the Southern Ocean Time Series (SOTS), the Bonney Coast mooring, the SARDI South Australian mooring array and other repeatedly sampled coastal stations, together with the Australian Continuous Plankton Recorder (AusCPR) survey samples towed by ships of opportunity. Sampling and analysis follow the IMOS NRS Biogeochemical Operations Manual (Davies and Sommerville 2020) and Eriksen et al. 2019; SOTS phytoplankton follow Eriksen et al. 2018; SARDI mooring samples are collected with a Niskin bottle and analysed by Microalgal Solutions. This store is the raw harvest layer behind the AODN plankton products: 20 CSV tables (45.7 MB) exported from the CSIRO BGC database on 2026-09-29, with NRS tables keyed by TRIP_CODE, CPR tables keyed by SAMPLE, taxon lookups (phytoinfo, zoopinfo) carrying a harmful-algal-bloom flag, and taxonomic changelogs, covering 2002 to September 2026 and including the active South Australian stations at Kangaroo Island, Gulf St Vincent, Spencer Gulf and Coffin Bay. For the 2025-26 South Australian harmful algal bloom this is the hosted source of Karenia cell counts: the SARDI Gulf St Vincent, Spencer Gulf and Kangaroo Island stations recorded Karenia spp., Karenia mikimotoi and Karenia cristata through 2025, so it is the dataset to open for the bloom's phytoplankton record.

## Load the data

```python
import os
import pandas as pd
df = pd.read_csv(os.path.join(os.environ['SCIGANTIC_MOUNT_PATH'], 'bgc_lfish_samples.csv'), nrows=1000)
df.head()
```

Run in a Scigantic notebook on 2026-10-04 against `bgc_lfish_samples.csv`: CSV/TSV: columns ['I_SAMPLE_ID', 'PROJECTNAME', 'TRIP_CODE', 'SAMPLEDATELOCAL', 'SAMPLEDATEUTC', 'LATITUDE', 'LONGITUDE', 'STATIONNAME', 'SAMPVOL_M3', 'VESSEL', 'TOWTYPE', 'GEARDEPTH_M'], dtypes ['int64', 'object', 'object', 'object', 'object', 'float64', 'float64', 'object', 'float64', 'object', 'o.

From any machine:

```python
# Task: station table (one row per station) with first/last sampling dates, NRS + SARDI (South Australia) rows
import pandas as pd
so = {'anon': True, 'client_kwargs': {'region_name': 'ap-southeast-2'}}
base = 's3://imos-data/IMOS/BGC_DB/harvested_from_CSIRO'
trip = pd.read_csv(f'{base}/bgc_trip.csv', parse_dates=['SAMPLEDATELOCAL', 'SAMPLEDATEUTC'], storage_options=so)
stations = (trip.groupby(['PROJECTNAME', 'STATIONCODE', 'STATIONNAME'])
                .agg(trips=('TRIP_CODE', 'size'), lat=('LATITUDE', 'median'), lon=('LONGITUDE', 'median'),
                     first=('SAMPLEDATELOCAL', 'min'), last=('SAMPLEDATELOCAL', 'max')).reset_index())
print(stations[stations.PROJECTNAME.isin(['NRS', 'SARDI'])].to_string())
```

Lists the files with anonymous access. Runs on any machine, with no cloud account.

## Data structure

File types in sampled files: CSV

| Field | Type |
| --- | --- |
| `bgc_trip.TRIP_CODE` | string, unique key (4,114); '<STATIONCODE><YYYYMMDD>' for NRS/SARDI (e.g. 'KAI20250520', 'GSV20250703'); Coastal… |
| `bgc_trip.PROJECTNAME` | string: Coastal Stations 1,864 / NRS 1,302 / SARDI 388 / SOTS 273 / NRS Ichthyoplankton 160 / NWS 46 / Moreton Bay 29 /… |
| `bgc_trip.STATIONNAME / STATIONCODE` | string; 64 codes. NRS: DAR, ESP (to 2013), KAI Kangaroo Island, MAI, NIN (to 2013), NSI, PH4 (to 2009), PHB, ROT, VBM… |
| `bgc_trip.LATITUDE / LONGITUDE` | float64 degrees, nominal station position (not per-cast); e.g. KAI -35.83217, 136.44733; GSV -35.023, 138.46; USG… |
| `bgc_trip.SAMPLEDATELOCAL / SAMPLEDATEUTC` | string 'YYYY-MM-DD HH:MM:SS' (parse with parse_dates); 2002-02-19 to 2026-09-02 |
| `bgc_trip.ZOOPSAMPLEDEPTH_M / PHYTOSAMPLEDEPTH_M` | float64 m, filled on 1,350 / 1,577 trips |
| `bgc_trip.BIOMASS_MGM3 / ASHFREEBIOMASS_MGM3` | float64 zooplankton dry weight / ash-free dry weight, filled on 1,183 / 404 trips |
| `bgc_trip.SECCHI_M` | float64 m, 1,119 trips |
| `bgc_trip.SAMPLETYPE` | string, 1,987 filled: letters for what was sampled, P phyto, Z zoop, F fish larvae (PZ 1,015; P 466; FPZ 301; F 156; Z… |
| `bgc_phyto_raw.TRIP_CODE` | string; 1,495 trips, 100% present in bgc_trip.TRIP_CODE (exact string join) |
| `bgc_phyto_raw.TAXON_NAME` | string; 969 values; 99.98% present in phytoinfo.TAXON_NAME; includes size classes and groups such as 'Pseudo-nitzschia… |
| `bgc_phyto_raw.TAXON_GROUP` | string: Centric diatom 16,321 / Dinoflagellate 9,292 / Pennate diatom 8,767 / Flagellate 5,037 / Ciliate 2,694 /… |
| `bgc_phyto_raw.GENUS / SPECIES` | string, NULL on 10,667 rows (group-level taxa); SPECIES holds 'spp.' for genus-level records |
| `bgc_phyto_raw.SPCODE` | float64 (AphiaID-like integer code, 679 distinct, 557 NULL); joins to phytoinfo.SPCODE |
| `bgc_phyto_raw.CELL_L` | float64 cells per litre, never NULL; 647 rows are exactly 0 (looked for, not seen). THE abundance column. |
| `bgc_phyto_raw.BIOVOLUME_UM3L` | float64 cubic micrometres per litre, 718 NULL |
| `bgc_phyto_raw.CELL_COUNT / SAMPVOL_L` | float64 raw count and settled volume in litres, filled on 38,796 rows; NULL where COMMENTS says counts were… |
| `bgc_phyto_raw.METHODS` | string: LM (light microscopy) 45,117 / SEM 1,100 |
| `bgc_phyto_raw.COMMENTS` | string: 'Count data from datasheets' 29,028 / 'Count data back calculated from abundance as datasheets not available'… |
| `phytoinfo.TAXON_NAME / SPCODE` | string key (2,726) / float64 code (2,659 filled); lookup for both bgc_phyto_raw and cpr_phyto_raw |

and 20 more fields

## Open it

- In a hosted notebook with the data mounted: https://scigantic.com/archive/b93484c7-9cf9-5b1a-af04-4d711e9fdb31
- Full record as JSON (schema card included): https://api.scigantic.com/api/archives/b93484c7-9cf9-5b1a-af04-4d711e9fdb31
- Over MCP: `get_schema_card` with id `b93484c7-9cf9-5b1a-af04-4d711e9fdb31` at https://api.scigantic.com/mcp

## Related topics

- [CSV datasets](https://scigantic.com/topics/csv)
- [Time series datasets](https://scigantic.com/topics/time-series)
- [Life Sciences datasets](https://scigantic.com/topics/life-sciences)
