checkTrawls: Trawl Database Explorer
Kevin Stierhoff
Last updated: 2025-08-23 09:53:19 PDT
1 Overview
This is a tool used to visualize and conduct QA/QC of trawl specimen data collected during Acoustic-Trawl (AT) surveys of coastal pelagic fish species (CPS) in the California Current Ecosystem.
The data below was collected during the Summer 2025 Integrated West Coast Pelagics Survey (IWCPS) (2506SH).
These results include data from hauls 2 to 81 (79 hauls total), conducted between 2025-06-13 00:42:53 PDT and 2025-08-23 01:14:28 PDT.
2 Length-weight summary
View the length (cm) and weight (g) range for each species.
2.1 CPS
2.2 Market squid
3 Length-frequencies
Length frequency by cruise leg. Length measurements are “native lengths”, which are SL for sardine and anchovies, and FL for mackerels and herring.
4 Outliers
4.1 Outlier plot
View the distribution of Fulton’s Condition Factor (\(K = (w/TL^3)*100\)) for each species. Specimens that fall outside the 0.01 and 99.9 percentiles are identified as potential outliers (flaggedData = Y).
4.2 Outlier table-New
Only show “new” outliers – i.e., those specimens identified as outliers based on the distribution of \(K\) and have not yet been flagged or reviewed in the database (flaggedData = NA or is blank).
4.3 Outlier table-All
All specimens identified as potential outliers that may or may not have been flagged and/or reviewed by trawl personnel (see the flaggedData column).
5 Missing data
5.1 Length measurements
Specimens with missing length measurements. It is expected that standard length is measured for Pacific Sardine and Northern Anchovy, and that fork length is measured for Pacific Herring, Pacific Mackerel, and Jack Mackerel. If missing, length is estimated from the measured weight.
5.2 Weight measurements
Self explanatory; weight is missing and estimated from total length.
5.3 Length and weight measurements
Self explanatory; both length and weight measurements are missing, so K may not be calculated.
5.4 Sex classification
Self explanatory; sex is not specified as either male, female, or unknown.
6 Interactive plots
The plots below provide information about trawl specimens (e.g., length, weight, haul, collection, and specimen number) when you hover over points with the mouse. You may zoom, pan, toggle spike-lines, etc using the menu above each graph (available when the mouse is in the plot area). Red and blue points are specimens that had missing length and weight measurements, respectively. Points with bold black outlines have already been “flagged” in the database but may or may not have been corrected.
The dashed lines represent the season-specific (in this case, Summer) relationship between length and weight as described in Palance et al. (2019). Missing length or weight entries are estimated using the same relationships.
For each species, the native lengths (standard length for Sardine and Anchovy, and fork length for mackerels and Herring) and weights are plotted atop modeled L/W curves. Curves depicting native lengths are dark gray, and the others are light gray. Ideally, the measured values will fall along the darker gray dashed line.
6.1 Sardine
Standard length (mm) vs. weight (g).
6.2 Anchovy
Standard length (mm) vs. weight (g).
6.3 Pacific mackerel
Fork length (mm) vs. weight (g).
6.4 Jack mackerel
Fork length (mm) vs. weight (g).
6.5 Pacific herring
Fork length (mm) vs. weight (g).
6.6 Round herring
Fork length (mm) vs. weight (g).
6.7 Pacific hake
Total length (mm) vs. weight (g).
6.8 Market squid
Mantle length (mm) vs. weight (g). Unlike other species, the dashed line represents the results of a Loess smoother on the length and weight data from this survey, not the length-weight model from all specimens.
## [1] "No specimens present."6.9 Lengths by leg
Total lengths (or mantle length, for Market Squid) vs. weight for all specimens, symbolized by cruise leg.
6.10 Final length-weight comparison
For the purposes of computing biomass, total length is used to estimate target strength. Here, total length vs. weight is plotted along with the models from Palance et al. (2019).
7 Data checks
7.1 Hauls
7.1.1 Removed hauls
Hauls removed due to trawl performance issues (e.g., aborted, bad, poor, etc.) or missing data.
7.1.2 Haul distances
Trawl distances are examined to look for data entry errors. Trawls longer than 5 nmi are highlighted orange.
| haul | distance |
|---|---|
| 81 | 1.6 |
| 80 | 1.8 |
| 79 | 1.7 |
| 78 | 1.8 |
| 77 | 1.9 |
| 76 | 1.7 |
| 75 | 1.8 |
| 74 | 1.5 |
| 73 | 2 |
| 72 | 1.7 |
| 71 | 1.9 |
| 70 | 2 |
| 69 | 2 |
| 68 | 1.9 |
| 67 | 1.7 |
| 66 | 1.7 |
| 65 | 1.9 |
| 64 | 1.6 |
| 63 | 1.6 |
| 62 | 1.7 |
| 61 | 1.5 |
| 60 | 2.2 |
| 59 | 1.9 |
| 58 | 1.8 |
| 57 | 1.8 |
| 56 | 1.8 |
| 55 | 1.8 |
| 54 | 1.8 |
| 53 | 2 |
| 52 | 1.8 |
| 51 | 1.9 |
| 50 | 1.8 |
| 49 | 1.9 |
| 48 | 1.9 |
| 47 | 1.6 |
| 45 | 1.9 |
| 44 | 1.9 |
| 43 | 1.9 |
| 42 | 1.9 |
| 41 | 1.7 |
| 40 | 1.9 |
| 39 | 1.9 |
| 38 | 2 |
| 37 | 1.9 |
| 36 | 2.2 |
| 35 | 2.3 |
| 34 | 2.3 |
| 33 | 1.9 |
| 32 | 2.3 |
| 31 | 2 |
| 30 | 2.3 |
| 29 | 2.1 |
| 28 | 1.9 |
| 27 | 2.3 |
| 26 | 1.9 |
| 25 | 1.8 |
| 24 | 1.9 |
| 23 | 2.1 |
| 22 | 2 |
| 21 | 2.1 |
| 20 | 2 |
| 19 | 1.9 |
| 18 | 1.8 |
| 17 | 1.9 |
| 16 | 1.7 |
| 15 | 2 |
| 14 | 2.1 |
| 13 | 1.9 |
| 12 | 2 |
| 11 | 2 |
| 10 | 1.8 |
| 9 | 2 |
| 8 | 2 |
| 7 | 2 |
| 6 | 1.8 |
| 5 | 2.1 |
| 4 | 2.1 |
| 3 | 1.9 |
| 2 | 1.8 |
7.1.3 Haul durations
Trawl duration is examined to look for data entry errors. Trawls longer than 50 min are highlighted orange.
| haul | cluster | netInWaterTime | equilibriumTime | haulBackTime | netOnDeckTime | duration |
|---|---|---|---|---|---|---|
| 81 | 38 | 2025-08-23 07:48:07 | 2025-08-23 08:14:28 | 2025-08-23 08:44:40 | 2025-08-23 09:17:04 | 30.2 |
| 80 | 38 | 2025-08-23 04:33:03 | 2025-08-23 05:03:44 | 2025-08-23 05:33:52 | 2025-08-23 06:07:14 | 30.1 |
| 79 | 37 | 2025-08-22 04:19:14 | 2025-08-22 05:02:54 | 2025-08-22 05:32:57 | 2025-08-22 06:16:29 | 30.1 |
| 78 | 36 | 2025-08-21 07:13:10 | 2025-08-21 07:42:06 | 2025-08-21 08:12:18 | 2025-08-21 08:47:05 | 30.2 |
| 77 | 36 | 2025-08-21 04:03:08 | 2025-08-21 04:33:26 | 2025-08-21 05:03:31 | 2025-08-21 05:41:11 | 30.1 |
| 76 | 35 | 2025-08-20 07:38:18 | 2025-08-20 08:15:22 | 2025-08-20 08:45:30 | 2025-08-20 09:24:32 | 30.1 |
| 75 | 35 | 2025-08-20 03:46:09 | 2025-08-20 04:27:32 | 2025-08-20 04:57:40 | 2025-08-20 05:45:52 | 30.1 |
| 74 | 34 | 2025-08-13 06:11:46 | 2025-08-13 06:55:59 | 2025-08-13 07:21:44 | 2025-08-13 07:59:02 | 25.8 |
| 73 | 33 | 2025-07-30 09:49:12 | 2025-07-30 10:18:08 | 2025-07-30 10:48:16 | 2025-07-30 11:25:37 | 30.1 |
| 72 | 33 | 2025-07-30 07:19:57 | 2025-07-30 07:51:14 | 2025-07-30 08:21:18 | 2025-07-30 08:59:23 | 30.1 |
| 71 | 33 | 2025-07-30 04:31:41 | 2025-07-30 04:56:53 | 2025-07-30 05:26:58 | 2025-07-30 06:04:18 | 30.1 |
| 70 | 32 | 2025-07-29 10:14:10 | 2025-07-29 10:42:31 | 2025-07-29 11:13:23 | 2025-07-29 11:52:19 | 30.9 |
| 69 | 32 | 2025-07-29 07:35:35 | 2025-07-29 08:06:34 | 2025-07-29 08:36:39 | 2025-07-29 09:17:29 | 30.1 |
| 68 | 32 | 2025-07-29 04:45:36 | 2025-07-29 05:17:22 | 2025-07-29 05:47:26 | 2025-07-29 06:25:45 | 30.1 |
| 67 | 31 | 2025-07-28 10:08:44 | 2025-07-28 10:34:51 | 2025-07-28 11:04:56 | 2025-07-28 11:50:03 | 30.1 |
| 66 | 31 | 2025-07-28 07:20:36 | 2025-07-28 07:47:00 | 2025-07-28 08:17:03 | 2025-07-28 08:51:24 | 30.1 |
| 65 | 31 | 2025-07-28 04:34:25 | 2025-07-28 05:07:36 | 2025-07-28 05:37:39 | 2025-07-28 06:19:22 | 30 |
| 64 | 30 | 2025-07-27 10:58:29 | 2025-07-27 11:24:56 | 2025-07-27 11:55:05 | 2025-07-27 12:45:16 | 30.1 |
| 63 | 30 | 2025-07-27 08:10:28 | 2025-07-27 08:36:51 | 2025-07-27 09:07:03 | 2025-07-27 09:50:17 | 30.2 |
| 62 | 30 | 2025-07-27 04:12:34 | 2025-07-27 04:40:18 | 2025-07-27 05:10:25 | 2025-07-27 05:53:25 | 30.1 |
| 61 | 29 | 2025-07-26 10:49:01 | 2025-07-26 11:21:16 | 2025-07-26 11:51:24 | 2025-07-26 12:35:49 | 30.1 |
| 60 | 29 | 2025-07-26 08:09:04 | 2025-07-26 08:32:49 | 2025-07-26 09:03:04 | 2025-07-26 09:52:30 | 30.2 |
| 59 | 29 | 2025-07-26 05:08:47 | 2025-07-26 05:36:09 | 2025-07-26 06:06:16 | 2025-07-26 06:51:55 | 30.1 |
| 58 | 28 | 2025-07-25 08:06:30 | 2025-07-25 08:38:50 | 2025-07-25 09:09:06 | 2025-07-25 09:51:39 | 30.3 |
| 57 | 28 | 2025-07-25 04:34:49 | 2025-07-25 05:04:23 | 2025-07-25 05:34:24 | 2025-07-25 06:13:47 | 30 |
| 56 | 27 | 2025-07-24 07:56:43 | 2025-07-24 08:28:53 | 2025-07-24 08:58:55 | 2025-07-24 09:48:35 | 30 |
| 55 | 27 | 2025-07-24 04:33:55 | 2025-07-24 05:00:41 | 2025-07-24 05:30:43 | 2025-07-24 06:11:34 | 30 |
| 54 | 26 | 2025-07-23 08:46:08 | 2025-07-23 09:30:54 | 2025-07-23 10:00:57 | 2025-07-23 10:47:34 | 30 |
| 53 | 26 | 2025-07-23 04:37:59 | 2025-07-23 05:09:45 | 2025-07-23 05:39:43 | 2025-07-23 06:27:01 | 30 |
| 52 | 25 | 2025-07-22 08:22:18 | 2025-07-22 08:58:55 | 2025-07-22 09:28:57 | 2025-07-22 10:09:29 | 30 |
| 51 | 25 | 2025-07-22 04:03:55 | 2025-07-22 04:44:03 | 2025-07-22 05:14:06 | 2025-07-22 06:02:25 | 30.1 |
| 50 | 24 | 2025-07-21 10:48:29 | 2025-07-21 11:29:32 | 2025-07-21 11:59:39 | 2025-07-21 12:41:39 | 30.1 |
| 49 | 24 | 2025-07-21 06:47:48 | 2025-07-21 07:18:10 | 2025-07-21 07:48:12 | 2025-07-21 08:43:50 | 30 |
| 48 | 23 | 2025-07-20 10:08:45 | 2025-07-20 10:53:10 | 2025-07-20 11:23:13 | 2025-07-20 12:11:44 | 30.1 |
| 47 | 23 | 2025-07-20 05:40:53 | 2025-07-20 06:22:03 | 2025-07-20 06:52:06 | 2025-07-20 07:44:11 | 30 |
| 45 | 22 | 2025-07-14 09:23:04 | 2025-07-14 12:16:42 | 2025-07-14 12:46:50 | 2025-07-14 13:19:30 | 30.1 |
| 44 | 22 | 2025-07-14 04:42:00 | 2025-07-14 05:19:58 | 2025-07-14 05:50:02 | 2025-07-14 06:29:24 | 30.1 |
| 43 | 21 | 2025-07-13 09:34:08 | 2025-07-13 10:17:07 | 2025-07-13 10:47:09 | 2025-07-13 11:28:51 | 30 |
| 42 | 21 | 2025-07-13 05:44:47 | 2025-07-13 06:22:07 | 2025-07-13 06:52:09 | 2025-07-13 08:00:22 | 30 |
| 41 | 20 | 2025-07-12 11:44:10 | 2025-07-12 12:10:08 | 2025-07-12 12:40:13 | 2025-07-12 13:19:16 | 30.1 |
| 40 | 20 | 2025-07-12 08:20:27 | 2025-07-12 08:52:49 | 2025-07-12 09:22:52 | 2025-07-12 10:15:48 | 30.1 |
| 39 | 19 | 2025-07-11 10:20:12 | 2025-07-11 10:55:55 | 2025-07-11 11:25:58 | 2025-07-11 12:08:40 | 30.1 |
| 38 | 19 | 2025-07-11 05:23:48 | 2025-07-11 06:06:14 | 2025-07-11 06:36:21 | 2025-07-11 07:28:42 | 30.1 |
| 37 | 18 | 2025-07-10 04:44:32 | 2025-07-10 05:35:20 | 2025-07-10 06:05:26 | 2025-07-10 07:15:52 | 30.1 |
| 36 | 17 | 2025-07-09 11:18:55 | 2025-07-09 11:51:24 | 2025-07-09 12:21:28 | 2025-07-09 13:03:08 | 30.1 |
| 35 | 17 | 2025-07-09 08:14:58 | 2025-07-09 08:58:20 | 2025-07-09 09:28:27 | 2025-07-09 10:13:11 | 30.1 |
| 34 | 17 | 2025-07-09 05:05:40 | 2025-07-09 05:47:49 | 2025-07-09 06:17:37 | 2025-07-09 07:03:48 | 29.8 |
| 33 | 16 | 2025-07-08 10:46:30 | 2025-07-08 11:18:36 | 2025-07-08 11:48:40 | 2025-07-08 12:29:00 | 30.1 |
| 32 | 16 | 2025-07-08 07:01:32 | 2025-07-08 07:30:42 | 2025-07-08 08:00:49 | 2025-07-08 08:42:45 | 30.1 |
| 31 | 15 | 2025-07-07 10:44:43 | 2025-07-07 11:15:26 | 2025-07-07 11:45:31 | 2025-07-07 12:29:13 | 30.1 |
| 30 | 15 | 2025-07-07 05:09:41 | 2025-07-07 05:52:07 | 2025-07-07 06:22:13 | 2025-07-07 07:19:41 | 30.1 |
| 29 | 14 | 2025-07-06 06:33:44 | 2025-07-06 09:19:02 | 2025-07-06 09:49:12 | 2025-07-06 10:56:53 | 30.2 |
| 28 | 13 | 2025-07-04 05:32:10 | 2025-07-04 06:19:23 | 2025-07-04 06:49:30 | 2025-07-04 07:44:48 | 30.1 |
| 27 | 12 | 2025-06-25 08:00:46 | 2025-06-25 08:31:25 | 2025-06-25 09:01:31 | 2025-06-25 09:42:28 | 30.1 |
| 26 | 12 | 2025-06-25 04:50:23 | 2025-06-25 05:21:12 | 2025-06-25 05:51:16 | 2025-06-25 06:26:36 | 30.1 |
| 25 | 11 | 2025-06-24 08:09:16 | 2025-06-24 08:45:32 | 2025-06-24 09:15:39 | 2025-06-24 09:54:48 | 30.1 |
| 24 | 11 | 2025-06-24 04:21:36 | 2025-06-24 04:53:45 | 2025-06-24 05:23:50 | 2025-06-24 06:03:34 | 30.1 |
| 23 | 10 | 2025-06-22 04:25:04 | 2025-06-22 04:52:33 | 2025-06-22 05:22:34 | 2025-06-22 06:20:42 | 30 |
| 22 | 9 | 2025-06-21 04:26:18 | 2025-06-21 04:56:27 | 2025-06-21 05:26:32 | 2025-06-21 06:14:57 | 30.1 |
| 21 | 8 | 2025-06-20 11:11:16 | 2025-06-20 12:02:33 | 2025-06-20 12:32:35 | 2025-06-20 13:17:36 | 30 |
| 20 | 8 | 2025-06-20 08:00:04 | 2025-06-20 08:37:05 | 2025-06-20 09:07:07 | 2025-06-20 10:01:09 | 30 |
| 19 | 8 | 2025-06-20 04:13:31 | 2025-06-20 04:46:05 | 2025-06-20 05:16:17 | 2025-06-20 06:34:16 | 30.2 |
| 18 | 7 | 2025-06-19 10:50:09 | 2025-06-19 11:25:20 | 2025-06-19 11:55:33 | 2025-06-19 12:38:07 | 30.2 |
| 17 | 7 | 2025-06-19 07:51:00 | 2025-06-19 08:22:09 | 2025-06-19 08:52:34 | 2025-06-19 09:33:06 | 30.4 |
| 16 | 7 | 2025-06-19 04:28:11 | 2025-06-19 04:58:00 | 2025-06-19 05:28:04 | 2025-06-19 06:02:46 | 30.1 |
| 15 | 6 | 2025-06-18 11:06:50 | 2025-06-18 11:50:41 | 2025-06-18 12:20:55 | 2025-06-18 13:03:14 | 30.2 |
| 14 | 6 | 2025-06-18 07:08:45 | 2025-06-18 07:37:23 | 2025-06-18 08:07:25 | 2025-06-18 09:11:33 | 30 |
| 13 | 6 | 2025-06-18 04:02:09 | 2025-06-18 04:31:53 | 2025-06-18 05:01:55 | 2025-06-18 05:33:43 | 30 |
| 12 | 5 | 2025-06-17 07:16:12 | 2025-06-17 07:46:19 | 2025-06-17 08:16:06 | 2025-06-17 08:52:27 | 29.8 |
| 11 | 5 | 2025-06-17 03:59:48 | 2025-06-17 04:27:31 | 2025-06-17 04:57:33 | 2025-06-17 05:42:27 | 30 |
| 10 | 4 | 2025-06-16 07:46:37 | 2025-06-16 08:17:21 | 2025-06-16 08:47:37 | 2025-06-16 09:53:41 | 30.3 |
| 9 | 4 | 2025-06-16 04:31:44 | 2025-06-16 05:02:43 | 2025-06-16 05:32:34 | 2025-06-16 06:26:36 | 29.8 |
| 8 | 3 | 2025-06-15 10:39:43 | 2025-06-15 11:05:56 | 2025-06-15 11:36:02 | 2025-06-15 12:19:41 | 30.1 |
| 7 | 3 | 2025-06-15 07:23:28 | 2025-06-15 07:54:40 | 2025-06-15 08:24:38 | 2025-06-15 08:57:27 | 30 |
| 6 | 3 | 2025-06-15 04:01:18 | 2025-06-15 04:29:19 | 2025-06-15 04:59:25 | 2025-06-15 05:45:44 | 30.1 |
| 5 | 2 | 2025-06-14 07:27:31 | 2025-06-14 07:56:03 | 2025-06-14 08:26:20 | 2025-06-14 09:12:19 | 30.3 |
| 4 | 2 | 2025-06-14 04:03:20 | 2025-06-14 04:37:51 | 2025-06-14 05:08:04 | 2025-06-14 05:44:43 | 30.2 |
| 3 | 1 | 2025-06-13 10:20:27 | 2025-06-13 10:50:11 | 2025-06-13 11:23:27 | 2025-06-13 11:59:25 | 33.3 |
| 2 | 1 | 2025-06-13 06:31:35 | 2025-06-13 07:42:53 | 2025-06-13 08:13:26 | 2025-06-13 08:55:44 | 30.6 |
Trawl durations are examined to look at trends in deployment, recovery, and total evolution times. The top panel shows total evolution time (from netOnDeckTime - netInWaterTime; green), while the bottom panel shows the deployment time (equilibriumTime - netInWaterTime, blue), fishing time (haulBackTime - equilbriumTime, black), and recovery time (netOnDeckTime - haulBackTime, red).
7.1.4 Haul paths
Examine haul paths: green during deployment, black during fishing, and red during recovery.