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
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.
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 | days_n |
|---|---|---|---|---|---|---|---|
| EFF001 | NZ | 2025 | 1 | -32 | -174 | 12 | |
| EFF002 | NZ | 2025 | 1 | -33 | -174 | 26 |
Field descriptions for the Effort data template
| 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 | No |
| 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 |
| 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_mt | discard_mt |
|---|---|---|---|---|---|
| EFF001 | ALB | 3842 | 10 | 23.44 | .043 |
| EFF001 | BET | 3 | 0 | 23 | 0 |
| EFF002 | ALB | 5200 | 15 | 31.72 | .065 |
| EFF002 | BET | 1 | 0 | 0.01 | 0 |
Field descriptions for the Catch data template
| 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 | Yes |
| discard_n | Number | Integer | Number of fish discarded | Yes |
| retained_mt | Number | Decimal | Retained catch weight in metric tonnes | Yes |
| discard_mt | Number | Decimal | Discarded catch weight in metric tonnes | Yes |
Example document at vessel level
| flag_code | fleet_code | year | month | latitude | longitude | vessels_n |
|---|---|---|---|---|---|---|
| NZ | 2025 | 1 | -32 | 174 | 14 |
Field descriptions for the Vessel data template
| 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 | No |
| 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: List of Fleets
| country_code | fleet_code | gear_code | is_active | ocean_codes | description |
|---|---|---|---|---|---|
| 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 | 0 | WX,SP,SX,WP | Australian joint-venture Longline |
| CN | DW | L | 1 | SP,NP,NX,SX | China distant-water longline |
| ID | DW | S | 1 | WX,WP | Indonesia distant-water purse seine |
| ID | ID | S | 1 | WX,WP | Indonesia domestic purse seine |
| 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 |
| PH | DW | S | 1 | WX,WP | Philippines distant-water purse seine |
| PH | PH | S | 1 | WX,NX,WP | Philippines domestic purse seine |
| TW | DW | L | 1 | WX,SP,NP,SX,NX,WP | Chinese Taipei distant-water longline |
| TW | OD | L | 0 | 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 | 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 |