| Table name |
Definition |
| NORPAC.FOREIGN_PROHIB8790 |
Prohibited species catch information from foreign and joint venture fishing operations in the Bering Sea and Aleutian Islands, Gulf of Alaska, and Washington-Oregon-California Regions for the years 1987-90. These are weekly compilations separated by nation, area, vessel class, company (for joint venture operations), and species. The information are provided for Pacific halibut, red king crab, blue king crab, other king crab (combined), bairdi Tanner crab, other Tanner crab (combined), Chinook salmon, and other salmon (combined). The offical groundfish catch estimate (blend estimate) is given as well as average weight per individual (Pacific halibut only), number of individuals per ton of groundfish, total number of individuals, and total tons of individuals (Pacific halibut only). A source code is listed, to identify whether the information came from data collected that week or from some other source. |
| Column name |
Type |
Definition |
| WEEKENDING_DATE |
number(6,0) |
These data are a weekly compilation. The weekending_date is the date (YYMMDD) of the last day associated with the compilation period. |
| NATION |
varchar2(13) |
The name of the nation(s) associated with each fishing operation. These nations are: JAPAN, POLAND, PRC (People’s Republic of China),
ROK (Republic of Korea), US-ICELAND, US-JAPAN, US-POLAND, US-PRC,
US-ROK, US-USSR (United Soviet Socialist Republic).
All nation names beginning with US- are joint venture operations between the United States and a foreign nation. |
| AREA_NAME |
varchar2(14) |
The name of the International North Pacific Fish Commission area in which the catch was made. These areas are: BERING SEA 1, BERING SEA 2,
BERING SEA 3, ALEUTIANS, SHUMAGIN, CHIRIKOF, KODIAK, VANCOUVER, COLUMBIA, EUREKA, MONTEREY. |
| SPECIES_NAME |
varchar2(20) |
The name of the prohibited species group. The species groups are:
BAIRDI TANNER CRAB, OTHER TANNER CRAB, RED KING CRAB,
BLUE KING CRAB, OTHER KING CRAB, CHINOOK SALMON, OTHER SALMON, PACIFIC HALIBUT. |
| VESSEL_CLASS |
varchar2(16) |
The vessel type used in the fishing operations. The larger trawlers were separated based on their ability to make surimi. If they could make surimi, they were called SURIMI TRAWL; if not, they were called LG FRZ TRAWL. The smaller trawlers were called SMALL TRAWL. In 1987-90, longliners only targeted Pacific cod and so were called LONGLINE COD. Joint venture motherships were separated by target and surimi capability (OTHER FREEZER JV, OTHER SURIMI JV, YELL/FLAT FRZ JV, YELL/FLAT SUR JV, POLL-BOT FRZ JV (1989 only), POLL-BOT SUR JV (1989 only), POLL-MID FRZ JV (1989 only), POLL-MID SUR JV (1989 only) [No joint ventures targeted pollock in 1990]). |
| COMPANY |
char(4) |
A code used to differentiate between the different companies involved in joint venture operations. The first two digits identified the nationality of the processing vessel, and the second two digits identified different companies within that nationality. IJ designated Iceland, JA designated Japan, KS designated the Republic of Korea (ROK), PC designated the Peoples Republic of China (PRC), PL designated Poland, and UR designated the USSR.
A list associating company name with company code is not currently available. |
| AREA_NUMBER |
number(4,0) |
The number associated with the International North Pacific Fish Commission area_name. Within BERING SEA 1, the sub-areas were: 511, 513, 514, 515, 516, 517. Within BERING SEA 2, the sub-areas were: 521, 522. The other areas were: 530 (BERING SEA 3), 540 (ALEUTIANS), 610 (SHUMAGIN),
620 (CHIRIKOF), 630 (KODIAK), 670 (VANCOUVER), 710 (COLUMBIA),
720 (EUREKA), 730 (MONTEREY).
|
| BLEND_TONNAGE |
number(12,3) |
The best estimate of the allocated tonnage caught (i.e., combined tonnage caught of those species groups that had catch allocations) for the year, month, nation, vessel_class, and area_number. |
| KG_PER_IND |
number(12,3) |
The average weight (kg) of the individuals of that species found in the observers' samples (only collected for Pacific halibut). |
| NOS_PER_TON |
number(12,3) |
The number of individuals caught per ton of allocated groundfish sampled for the presence of that species. |
| EST_NOS |
number(12,3) |
The estimated total number of individuals of that species caught for the weekending_date, nation, vessel_class, area_number, and company (if applicable). |
| EST_TONS |
number(12,3) |
The estimated tonnage of that species caught for the weekending_date, nation, vessel_class, area_number, and company (if applicable) (only collected for Pacific halibut). |
| SOURCE |
char(1) |
A one-digit alpha code that indicates where the prohibited species information came from.
If the field is null, the information came directly from sampling that occurred for that weekending_date and cell (nation, vessel_class, area_number, and company [company can be null]).
If the field contains an M, no sampling occurred for that weekending_date and cell, so the information came from sampling that occurred from the same month for that cell.
If the field contains a Q, no sampling occurred for that weekending_date or month for that cell, so the information came from sampling that occurred from the same quarter for that cell.
If the field contains a Y, no sampling occurred for that weekending_date, month, or quarter for that cell, so the information came from sampling that occurred from the same year for that cell.
If the field contains a C, there was no sampling data at all for that cell [company can't be null], so the sampling information came from the same weekending_date, nation, and vessel_class, but for all companies combined.
If the field contains a D, there was no sampling data at all for that cell [company can't be null], so the sampling information came from the same month, nation, and vessel_class but for all companies combined.
If the field contains an E, there was no sampling data for that cell [company can't be null], so the sampling information came from the same quarter, nation, and vessel_class but for all companies combined.
If the field contains an F, there was no sampling data for that cell [company can't be null], so the sampling information came from the same year, nation, and vessel_class but for all companies combined. |
| YR |
number(2,0) |
The last two digits of the year in which the fishing occurred. |
|
