Aggregated Troll Data Format
Aggregate Catch and Effort data for troll are to be submitted for data aggregated to the level of:
year, month, flag, fleet, gear, and 5x5 degree cell.
Aggregate data represent raised logbook catches and should represent total annual or monthly catch and effort within the WCPFC Convention Area for a given fleet.
The effort information includes:
- number of fishing days
- type of activity (e.g., fishing, searching, in port, bad weather)
The catch information includes:
- catch in weight (mt) and number of individuals (n)
- an indicator to note whether the catch was discarded or not
The vessel information may also be reported to indicate the number of active vessels contributing to the aggregated data at the same spatial and temporal level.
Field formatting details
- Year (or season) must be reported as
YYYY. - Month must be reported as
mm(01 to 12). - Latitude and longitude must be reported in whole degrees, floored by 5° increments (e.g., 24° reported as 20°, and -137° reported as -140°).
The valid range is -180 to 175 for longitude and -90 to 85 for latitude. - Species codes must use FAO 3-letter Species Codes.
- Fleet codes must follow the Fleet reference table.
- Activity types must follow the Activity reference table.
Table documents format
Aggregated data are structured in two interconnected levels: Effort and Catch.
In this format, separate tables are used for each data level to maintain clarity and reduce redundancy.
Each table is connected using a unique identifier, which is set at Effort level: effort_id and referenced at Catch level.
These identifiers must be numeric or alphanumeric and unique within the set of files.
👉 Data providers can also download ready-to-use CSV data templates for each level (catch and effort).
CSV Data Templates
Example document at effort level
| effort_id | flag_code | fleet_code | year | month | latitude | longitude | activity_id | days_n |
|---|---|---|---|---|---|---|---|---|
| EFF001 | NZ | 2025 | 1 | -32 | -174 | 1 | 12 | |
| EFF002 | NZ | 2025 | 1 | -33 | -174 | 1 | 26 |
Field descriptions at effort level
| Field name | Type | Format | Description | Mandatory |
|---|---|---|---|---|
| effort_id | Text | Unique ID | Identifier linking effort and catch data | Yes |
| flag_code | Text | 2-letter flag-state code (UN/LOCODE) | Authorized flag of the reporting CCM | Yes |
| fleet_code | Text | 2-letter code for sub-fleet (see Fleet reference table) | Sub-fleet code | Optional |
| year | Number | YYYY | Calendar year of fishing activity | Yes |
| month | Number | 1–12 | Month of fishing activity | Yes |
| latitude | Number | Whole degrees (floored by 5° increment) | Centre of 5x5° grid cell | Yes |
| longitude | Number | Whole degrees (floored by 5° increment) | Centre of 5x5° grid cell | Yes |
| activity_id | Number | Coded integer (see Activity reference table) | Type of fishing activity | Yes |
| days_n | Number | Integer | Number of fishing days in the cell | Yes |
Example document at catch level
| effort_id | sp_code | retained_n | discard_n | retained_kg | discard_kg |
|---|---|---|---|---|---|
| EFF001 | ALB | 3842 | 10 | 23436.2 | 43 |
| EFF001 | BET | 3 | 0 | 23 | 0 |
| EFF002 | ALB | 5200 | 15 | 31720 | 64.5 |
| EFF002 | BET | 1 | 0 | 10.2 | 0 |
Field descriptions at catch level
| Field name | Type | Format | Description | Mandatory |
|---|---|---|---|---|
| effort_id | Text | Links to Effort | Identifier linking catch record to effort record | Yes |
| sp_code | Text | FAO 3-letter species code (see Species reference table) | Species caught | Yes |
| retained_n | Number | Integer | Number of fish retained | Optional |
| discard_n | Number | Integer | Number of fish discarded | Optional |
| retained_kg | Number | Decimal | Retained catch weight in kilograms | Optional |
| discard_kg | Number | Decimal | Discarded catch weight in kilograms | Optional |
Example document at vessel level
| flag_code | fleet_code | year | month | latitude | longitude | vessels_n |
|---|---|---|---|---|---|---|
| NZ | 2025 | 1 | -32 | 174 | 14 |
Field descriptions at vessel level
| Field name | Type | Format | Description | Mandatory |
|---|---|---|---|---|
| flag_code | Text | 2-letter flag-state code (UN/LOCODE) | Authorized flag of the reporting CCM | Yes |
| fleet_code | Text | 2-letter code for sub-fleet (see Fleet reference table) | Sub-fleet code | Optional |
| year | Number | YYYY | Calendar year of fishing activity | Yes |
| month | Number | 1–12 | Month of fishing activity | Yes |
| latitude | Number | Whole degrees (floored by 5° increment) | Centre of 5x5° grid cell | Yes |
| longitude | Number | Whole degrees (floored by 5° increment) | Centre of 5x5° grid cell | Yes |
| vessels_n | Number | Integer | Number of vessels active in that cell during the period | Yes |
References
Reference Table 1: Activity Type identifiers
| activity_id | Description |
|---|---|
| 1 | Fishing Set |
| 2 | Searching |
| 3 | Transit |
| 4 | No fishing - Breakdown/other issues |
| 5 | No fishing - Bad weather |
| 6 | In port - unload/transhipment |
| 7 | Net cleaning set |
| 51 | Transhipping or bunkering |
Reference Table 2: School Type identifiers
| school_id | Description |
|---|---|
| 1 | Unassociated/free school |
| 2 | Feeding on baitfish |
| 3 | Drifting log, debris or dead animal |
| 4 | Drifting raft, FAD or payao |
| 5 | Anchored raft, FAD or payao |
| 6 | Live whale |
| 7 | Live whale shark |
| 8 | Other |
Reference Table 3: List of Fleets
| country_code | fleet_code | gear_code | is_active | ocean_codes | description |
|---|---|---|---|---|---|
| AO | NULL | O | 1 | AO | AO Other |
| AU | NULL | O | 1 | SP,SX,WP | Australia Other |
| AU | NULL | P | 1 | WX,SP,SX,WP | Australia pole-and-line |
| AU | NULL | T | 1 | WX,SP,SX,WP | Australia troll |
| AU | AF | S | 1 | WX,SP,SX,WP | Australia purse seine, inside the Australian Fishing Zone |
| AU | AU | L | 1 | WX,SP,SX,WP | Australia domestic and chartered longline |
| AU | EX | S | 1 | WX,SP,SX,WP | Australia distant-water purse seine |
| AU | JV | L | 1 | WX,SP,SX,WP | Australian joint-venture Longline |
| BZ | NULL | L | 1 | SP,SX,WP | Belize Longline |
| CA | NULL | S | 1 | SP,NP,WP | Canadian Purse seine |
| CA | NULL | T | 1 | NP,NX | Canada troll |
| CK | NULL | L | 1 | WX,SP,SX,WP | Cook Islands longline |
| CK | NULL | O | 1 | WX,SP,SX,WP | Cook Islands Artisanal |
| CK | NULL | S | 1 | WX,WP | Cook Islands purse seine |
| CN | NULL | L | 1 | WX,SP,NP,SX,NX,WP | China offshore and distant-water longline |
| CN | NULL | S | 1 | WX,WP | China purse seine |
| CN | DW | L | 1 | SP,NP,NX,SX | China distant-water longline |
| EC | NULL | S | 1 | WX,EP,WP | Ecuador Purse seine |
| EP | NULL | L | 1 | SP,NP,EP | EP Longline |
| EP | NULL | O | 1 | EP | EP Other |
| EP | NULL | P | 1 | EP | EP Pole and line |
| EP | NULL | S | 1 | EP | EP Seiner |
| EP | NULL | T | 1 | SP,NP,EP | EP Troll |
| ES | NULL | L | 1 | WX,SP,NP,SX,NX,WP | EU - Spanish Longline |
| ES | NULL | S | 1 | WX,WP | EU - Spanish purse seine |
| FJ | NULL | L | 1 | WX,SP,SX,WP | Fiji longline |
| FJ | NULL | O | 1 | WX,SP,SX,WP | Fiji Artisanal Tuna Fisheries |
| FJ | NULL | P | 1 | WX,SP,SX,WP | Fiji pole-and-line |
| FM | NULL | L | 1 | WX,SP,NP,NX,SX,WP | Federated States of Micronesia longline |
| FM | NULL | S | 1 | WX,WP | Federated States of Micronesia purse seine |
| GU | NULL | L | 1 | NP,NX,WP | Guam longline |
| ID | NULL | G | 1 | WX,SP,SX,WP | Indonesia gillnet |
| ID | NULL | H | 1 | WX,SP,SX,WP | Indonesia handline (large-fish) |
| ID | NULL | K | 1 | WX,SP,SX,WP | Indonesia small-fish hook-and-line |
| ID | NULL | L | 1 | WX,SP,SX,WP | Indonesia longline |
| ID | NULL | O | 1 | WX,SP,SX,WP | Indonesia unclassified |
| ID | NULL | P | 1 | WX,SP,SX,WP | Indonesia pole-and-line |
| ID | NULL | T | 1 | WX,SP,SX,WP | Indonesia troll |
| ID | DW | S | 1 | WX,WP | Indonesia distant-water purse seine |
| ID | ID | S | 1 | WX,WP | Indonesia domestic purse seine |
| IO | NULL | O | 1 | IO | IO Other |
| JP | NULL | G | 1 | WX,SP,NP,NX,SX,WP | Japan drift gillnet |
| JP | NULL | N | 1 | WX,SP,NP,WP | Japanese Gillnet |
| JP | NULL | O | 1 | WX,NP,NX,WP | Japanese Other |
| JP | NULL | T | 1 | WX,NP,NX,WP | Japanese Troll |
| JP | CS | L | 1 | WX,NP,NX,WP | Japan coastal fleet longline |
| JP | CS | P | 1 | WX,NP,NX,WP | Japan coastal fleet pole-and-line |
| JP | CS | S | 1 | WX,NP,NX,WP | Japan coastal fleet purse seine |
| JP | DW | P | 1 | WX,SP,NP,NX,WP | Japan offshore and distant water pole-and-line |
| JP | DW | S | 1 | WX,SP,NP,NX,WP | Japan offshore and distant-water purse seine |
| JP | JP | L | 1 | WX,SP,NP,SX,NX,WP | Japan offshore and distant water longline |
| KI | NULL | L | 1 | WX,SP,NP,SX,NX,WP | Kiribati longline |
| KI | NULL | O | 1 | SP,NX,WP | Kiribati Artisanal |
| KI | NULL | P | 1 | WX,NP,NX,WP | Kiribati pole-and-line |
| KI | NULL | S | 1 | WX,NX,WP | Kiribati purse seine |
| KR | NULL | G | 1 | WX,SP,NP,NX,SX,WP | Korea drift gillnet |
| KR | NULL | L | 1 | WX,SP,NP,SX,NX,WP | Korea longline |
| KR | NULL | S | 1 | WX,WP | Korea purse seine |
| MH | NULL | L | 1 | WX,NP,NX,WP | Marshall Islands longline |
| MH | NULL | S | 1 | WX,NX,WP | Marshall Islands purse seine |
| MX | NULL | O | 1 | WP | Mexico Other |
| MX | NULL | S | 1 | WX,WP | Mexico purse seine |
| NC | NULL | L | 1 | WX,SP,SX,WP | New Caledonia longline |
| NC | NULL | P | 1 | WX,SP,SX,WP | New Caledonia pole-and-line |
| NI | NULL | S | 1 | WP | Nicaragua purse seine |
| NP | NULL | L | 1 | SP,NP | NP Longline |
| NP | NULL | T | 1 | SP,NP | NP Troll |
| NR | NULL | L | 1 | NP,NX,WP | Nauru longline |
| NR | NULL | O | 1 | WX,SP,NX,WP | Nauru Artisanal Tuna Fisheries |
| NR | NULL | S | 1 | WX,NX,WP | Nauru purse seine |
| NU | NULL | L | 1 | SP,SX,WP | Niue longline |
| NU | NULL | O | 1 | WX,SP,SX,WP | Niue Artisanal |
| NZ | NULL | L | 1 | WX,SP,SX,WP | New Zealand longline |
| NZ | NULL | O | 1 | SP,SX,WP | New Zealand Other |
| NZ | NULL | P | 1 | WX,SP,SX,WP | New Zealand pole-and-line |
| NZ | NULL | S | 1 | WX,WP | New Zealand purse seine |
| NZ | NULL | T | 1 | WX,SP,SX,WP | New Zealand troll |
| PA | NULL | S | 1 | WP | Panama Purse seine |
| PF | NULL | L | 1 | WX,SP,SX | French Polynesia longline |
| PF | NULL | P | 1 | SP,SX | French Polynesia pole-and-line |
| PF | NULL | T | 1 | WX,SP,SX,WP | French Polynesia troll |
| PF | O | 1 | WX,SP,SX,EP,WP | French Polynesia Other | |
| PG | NULL | L | 1 | WX,SP,SX,WP | Papua New Guinea longline |
| PG | NULL | P | 1 | WX,SP,SX,WP | Papua New Guinea pole-and-line |
| PG | NULL | S | 1 | WX,SX,WP | Papua New Guinea purse seine |
| PH | NULL | G | 1 | SP,NP,WP | Philippines gillnet |
| PH | NULL | H | 1 | WX,NP,NX,WP | Philippines handline (large-fish) |
| PH | NULL | K | 1 | NP,NX,WP | Philippines handline (small-fish) |
| PH | NULL | L | 1 | WX,NP,NX,WP | Philippines domestic longline |
| PH | NULL | O | 1 | NP,NX,WP | Philippines artisanal gears (not specified) |
| PH | NULL | R | 1 | WX,NP,NX,WP | Philippines ringnet |
| PH | DW | S | 1 | WX,WP | Philippines distant-water purse seine |
| PH | PH | S | 1 | WX,NX,WP | Philippines domestic purse seine |
| PT | NULL | L | 1 | SP,SX,WP | EU - Portuguese Longline |
| PW | NULL | L | 1 | WX,NP,NX,WP | Palau longline |
| PW | NULL | P | 1 | WX,NP,NX,WP | Palau pole-and-line |
| SB | NULL | L | 1 | WX,SP,NP,SX,NX,WP | Solomon Islands longline |
| SB | NULL | P | 1 | WX,SP,SX,WP | Solomon Islands pole-and-line |
| SB | NULL | S | 1 | WX,SX,WP | Solomon Islands purse seine |
| SN | NULL | L | 1 | SP,NP,NX,WP | Senegal Longline |
| SU | NULL | L | 1 | SP,NP,NX,WP | Soviet Union longline |
| SU | NULL | S | 1 | WX,WP | Russia purse seine |
| SV | NULL | S | 1 | WP | El Salvador Purse seine |
| TK | NULL | O | 1 | WX,SP,SX,WP | Tokelau Artisanal Tuna Fisheries |
| TO | NULL | L | 1 | WX,SP,SX,WP | Tonga longline |
| TO | NULL | O | 1 | WX,SP,SX,NX,WP | Tonga Artisanal Tuna Fisheries |
| TV | NULL | L | 1 | WX,SP,SX,WP | Tuvalu longline |
| TV | NULL | O | 1 | WX,SP,SX,WP | Tuvalu Artisanal Tuna Fisheries |
| TV | NULL | P | 1 | WX,SP,SX,WP | Tuvalu pole-and-line |
| TV | NULL | S | 1 | WX,WP | Tuvalu Purse seine |
| TW | NULL | G | 1 | SP,NP,NX,SX,WP | Chinese Taipei drift gillnet |
| TW | NULL | O | 1 | NP,NX,WP | Chinese Taipei Other |
| TW | NULL | R | 1 | WX,WP | Chinese Taipei domestic SEINE |
| TW | NULL | S | 1 | WX,WP | Chinese Taipei purse seine |
| TW | DW | L | 1 | WX,SP,NP,SX,NX,WP | Chinese Taipei distant-water longline |
| TW | OD | L | 1 | NP,NX | Chinese Taipei offshore domestic longline (REDUNDANT -STLL) |
| TW | OS | L | 1 | WX,SP,NP,SX,NX,WP | Chinese Taipei small-scale Longline (STLL) |
| US | NULL | G | 1 | SP,NP | United States of America Gillnet |
| US | NULL | O | 1 | WP | United States of America (Sports fishery) |
| US | NULL | O | 1 | WP | United States of America (Unclassified) |
| US | NULL | P | 1 | SP,NP,NX,WP | United States of America Pole and line (Albacore) |
| US | NULL | S | 1 | WX,WP | United States of America purse seine |
| US | NULL | T | 1 | WX,SP,NP,SX,NX,WP | United States of America Troll (Tropical) |
| US | NULL | T | 1 | WX,SP,NP,SX,NX,WP | United States of America (Albacore) troll |
| US | AS | L | 1 | WX,SP,NP,SX,NX,WP | American Samoa longline |
| US | AS | T | 1 | WX,SP,SX,NX,WP | American Samoa (US) Troll |
| US | GU | L | 1 | WX,NP,NX,WP | Guam (US) Longline |
| US | GU | T | 1 | WX,SP,SX,NX,WP | Guam (US) Troll |
| US | HW | H | 1 | WX,NP,NX,WP | Hawaii (US) Handline |
| US | HW | L | 1 | WX,SP,NP,NX,WP | United States of America longline (Hawaii) |
| US | HW | P | 1 | SP,NP,NX,WP | Hawaii pole-and-line |
| US | HW | T | 1 | WX,NP,SX,NX,WP | Hawaii (US) Troll |
| US | HW | T | 1 | SP,NX,SX,WP | Hawaii (US) Troll and Handline |
| US | MP | L | 1 | WX,NP,NX,WP | Northern Marianas Islands (US) Longline |
| US | MP | T | 1 | WX,SP,SX,NX,WP | Northern Mariana Islands (US) troll |
| US | US | L | 1 | WX,SP,NP,NX,WP | United States of America longline |
| VN | NULL | G | 1 | WX,NP,NX,WP | Vietnamese Gillnet |
| VN | NULL | H | 1 | WX,NP,NX,WP | Vietnamese Handline |
| VN | NULL | L | 1 | WX,NP,NX,WP | Vietnamese Longline |
| VN | NULL | S | 1 | WX,NP,NX,WP | Vietnamese Purse seine |
| VU | NULL | L | 1 | WX,SP,NP,SX,NX | Vanuatu longline |
| VU | NULL | O | 1 | WX,SP,SX,WP | Vanuatu Artisanal Tuna Fisheries |
| VU | NULL | S | 1 | WX,WP | Vanuatu purse seine |
| WF | NULL | L | 1 | WX,SP,SX,WP | Wallis and Futuna Longline |
| WF | NULL | O | 1 | WX | Wallis and Futuna artisanal |
| WF | NULL | T | 1 | WX,SP,SX,WP | Wallis and Futuna Troll |
| WN | NULL | L | 1 | SP,NP | North Western Pacific longline |
| WN | NULL | P | 1 | North Western Pacific pole-and-line | |
| WN | NULL | T | 1 | SP,NP | North Western Pacific troll |
| WP | NULL | L | 1 | SP,NP,EP | WP Longline |
| WP | NULL | O | 1 | EP | WP Other |
| WP | NULL | P | 1 | EP | WP Pole and line |
| WP | NULL | S | 1 | EP | WP Purse Seine |
| WS | NULL | L | 1 | WX,SP,SX,WP | Samoa longline |