FEDBE

Transpose bottom and effort depths if reported effort depth > bottom depth

The fishing (effort) depth cannot be greater than the bottom depth. Any records where the effort depth is greater than the bottom depth are assumed to have the values transposed.

-- © Copyright 2026 The Kahawai Collective
-- SPDX-License-Identifier: MIT
INSERT INTO grooming_rules
VALUES ('FEDBE', 'edw', 'effort', 'Fix', 'Transpose bottom and effort depths if reported effort depth > bottom depth');

CREATE OR REPLACE FUNCTION FEDBE()
RETURNS VOID AS $$

INSERT INTO groomed.checks(code, "table", "column", id, orig, new)
SELECT 'FEDBE', 'effort', 'effort_depth', id, effort_depth, bottom_depth
FROM groomed.effort
WHERE effort_depth > bottom_depth;

INSERT INTO groomed.checks(code, "table", "column", id, orig, new)
SELECT 'FEDBE', 'effort', 'bottom_depth', id, bottom_depth, effort_depth
FROM groomed.effort
WHERE effort_depth > bottom_depth;

UPDATE groomed.effort SET checks = checks || '{FEDBE}', bottom_depth = effort_depth, effort_depth = bottom_depth
  WHERE effort_depth > bottom_depth;

$$ LANGUAGE SQL;
SELECT FEDBE();
Effects of grooming

Most of the records groomed by the FEDBE rule are from the paper form reporting era, although a few ERS records are also groomed (Figure 1).

Figure 1: The number of records affected by the FEDBE rule, by year and source.

The impacts of the FEDBE rule varies by form type (Figure 2), potentially due to form design differences that make transposition of values more or less likely.

The greatest impacts of the FEDBE rule, for form-method-target combinations with more than 50 records, are listed in Table 1. In general, differences in the mean depths are small, but the rule does ensure that the mean bottom depth is greater than the mean fishing depth (Figure 3).

Figure 2: The proportion of records affected by the FEDBE rule, by form type, for all form types where some records are groomed by the FEDBE rule.
Table 1: The impacts of the FEDBE rule for the twenty form-method-target groups with at least 50 records and the largest changes due to grooming.
Original mean
Adjusted mean
Primary method Form type Target species Effort depth Bottom depth Effort depth Bottom depth Number of records
BT TCP TRE 59.3 53.7 52.0 61.0 45104
BT TCP SNA 58.2 54.5 52.5 60.2 77359
BT TCP PTO 765.0 806.8 759.4 812.5 345
BT TCP FLA 39.7 37.5 34.3 42.9 1480
MW TCP FRO 230.5 228.3 225.3 233.6 344
BPT TCP SKI 213.7 221.6 208.6 227.1 63
MW TCP ORH 749.2 797.8 744.1 802.9 157
MW TCP SKI 286.2 284.6 281.1 289.7 1262
PRM ERS - Trawl HOK 342.9 366.6 338.5 371.1 697
BPT TCP BAR 78.9 75.3 74.5 79.7 243
BT TCP SKI 283.0 282.6 278.8 286.8 13398
MW TCP BYX 407.9 418.7 404.1 422.6 9505
MW TCP SWA 301.2 314.3 297.5 318.1 149
BT TCP TAR 129.3 130.8 125.8 134.4 65489
BT TCP SWA 326.3 336.1 323.0 339.4 17524
MW TCE HOK 379.1 406.4 375.9 409.6 8598
BT TCP ORH 911.6 926.8 908.6 929.9 161206
MW TCP HOK 403.8 444.2 400.9 447.1 205832
BT TCP RBY 293.2 292.8 290.2 295.7 784
BT TCE LIN 353.3 352.1 350.5 355.0 5611
Figure 3: The impacts of the FEDBE rule on the relationship between mean fishing depth and mean bottom depth for the twenty form-method-target groups (Table 1) with at least 50 records and the largest changes due to grooming. Unadjusted means are shown with orange triangles, and adjusted means by purple points. The unadjusted and adjusted values for a group are linked by line segments. Both axis are plotted on a pseudo-log scale.