About this Dataset

FRD Trawl Database

Specimens captured in trawls by the SWFSC Fisheries Resources Division during surveys for coastal pelagic species. Most tows were targeted for coastal pelagic species (e.g., sardine, anchovy, mackerels) using a Nordic trawl (2023 and before) or a Multi-Function Trawl net (2024 and after) on the surface at night. The database includes information on individual trawls, catch data with identification to various taxonomic levels depending on species, length frequencies, and individual length and weight data.
Organization: National Oceanic and Atmospheric Administration, Department of Commerce
Last updated: 2025-05-24T17:05:02.638222
Tags: anchovy, atm, depm, doc/noaa/nmfs/swfsc, frd and calcofi cruise data, jack mackerel, national marine fisheries service, noaa. u.s. department of commerce, pacific mackerel, sardine, southwest fisheries science center

Tables

CPS Trawl Life History Haul Catch Data

@usgov.noaa_gov_frd_trawl_database2.cps_trawl_life_history_haul_catch_data

390.46 KB
23446 rows
19 columns


CREATE TABLE cps_trawl_life_history_haul_catch_data (
  "cruise" BIGINT,
  "ship" VARCHAR,
  "haul" BIGINT,
  "collection" BIGINT,
  "start_latitude" DOUBLE,
  "start_longitude" DOUBLE,
  "stop_latitude" DOUBLE,
  "stop_longitude" DOUBLE,
  "equilibrium_time" TIMESTAMP,
  "haulback_time" TIMESTAMP,
  "surface_temp" VARCHAR,
  "surface_temp_method" VARCHAR,
  "ship_spd_through_water" VARCHAR,
  "itis_tsn" BIGINT,
  "scientific_name" VARCHAR,
  "subsample_count" VARCHAR,
  "subsample_weight" VARCHAR,
  "remaining_weight" VARCHAR,
  "presence_only" VARCHAR
);

CPS Trawl Life History Length Frequency Data

@usgov.noaa_gov_frd_trawl_database2.cps_trawl_life_history_length_frequency_data

66.31 KB
5388 rows
14 columns


CREATE TABLE cps_trawl_life_history_length_frequency_data (
  "cruise" BIGINT,
  "ship" VARCHAR,
  "haul" BIGINT,
  "collection" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "time" TIMESTAMP,
  "itis_tsn" BIGINT,
  "scientific_name" VARCHAR,
  "length_class" BIGINT,
  "length_type" VARCHAR,
  "male" BIGINT,
  "female" BIGINT,
  "sex_undetermined" BIGINT
);