View: GEAR
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:33433 | Updated: August 9, 2022 | Published / External
Entity Information
| Entity Type: | Data View |
|---|---|
| Active Version?: | Yes |
| Schema Name: | CFDBS |
| Description: |
Commercial Fisheries Gear Support Table. |
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
NEGEAR | VARCHAR2 | Northeast Gear code; 999=Unknown. See CFDBS Gear Table(GEAR) for actual codes. For 1994+ allocated data, negear is taken from the matched VTR trip when Area Level = A; negear is supplied by the Dealer when Area Level = B,C,D or X. | |
|
100
|
NEGEAR2 | VARCHAR2 | First two digits of the Northeast Gear code. See CFDBS Gear Table (GEAR) for actual codes. | |
|
100
|
GEARNM | VARCHAR2 | Descriptive name for the NE Gear Code. | |
|
100
|
WASHGEAR | VARCHAR2 | Washington Gear Code. | |
|
100
|
NAFOGEAR | VARCHAR2 | NAFO Gear Code. | |
|
100
|
NAFOGRAB | VARCHAR2 | NAFO Gear Code abbreviation. | |
|
100
|
NAFOGRGP | VARCHAR2 | NAFO Gear Group. | |
|
100
|
NAFOGRNM | VARCHAR2 | Descriptive NAFO Gear Name. | |
|
100
|
GEARABB | VARCHAR2 | Abbreviated Gear Code | |
|
100
|
OBGEARCAT | VARCHAR2 | Gear category or fishery code used for the observer data: Gear Category used by observer program: OT = Otter trawl,GG = gillnet, PT = Pots and traps , LL = Longline and other line gear, BS = beach set, SD = Scallop Dredge, PR = pair trawl,PS = purse seine, ST = Scallop Trawl, TT Twin Trawl, NK =Not known, OB=Obsolete. | |
|
100
|
LISTCOL | VARCHAR2 | Abbreviated Description Used for Select Lists | |
|
100
|
DOC | DATE | The date of the last change to this record. |
Attribute Details
NEGEAR
CC ID: 331993
| Seq. Order: | 1 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Northeast Gear code; 999=Unknown. See CFDBS Gear Table(GEAR) for actual codes. For 1994+ allocated data, negear is taken from the matched VTR trip when Area Level = A; negear is supplied by the Dealer when Area Level = B,C,D or X. |
| General Data Type: | VARCHAR2 |
NEGEAR2
CC ID: 331997
| Seq. Order: | 2 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
First two digits of the Northeast Gear code. See CFDBS Gear Table (GEAR) for actual codes. |
| General Data Type: | VARCHAR2 |
GEARNM
CC ID: 331998
| Seq. Order: | 3 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Descriptive name for the NE Gear Code. |
| General Data Type: | VARCHAR2 |
WASHGEAR
CC ID: 331999
| Seq. Order: | 4 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Washington Gear Code. |
| General Data Type: | VARCHAR2 |
NAFOGEAR
CC ID: 332000
| Seq. Order: | 5 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
NAFO Gear Code. |
| General Data Type: | VARCHAR2 |
NAFOGRAB
CC ID: 332001
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
NAFO Gear Code abbreviation. |
| General Data Type: | VARCHAR2 |
NAFOGRGP
CC ID: 332002
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
NAFO Gear Group. |
| General Data Type: | VARCHAR2 |
NAFOGRNM
CC ID: 332003
| Seq. Order: | 8 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 51 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Descriptive NAFO Gear Name. |
| General Data Type: | VARCHAR2 |
GEARABB
CC ID: 332004
| Seq. Order: | 9 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Abbreviated Gear Code |
| General Data Type: | VARCHAR2 |
OBGEARCAT
CC ID: 331994
| Seq. Order: | 10 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Gear category or fishery code used for the observer data: Gear Category used by observer program: OT = Otter trawl,GG = gillnet, PT = Pots and traps , LL = Longline and other line gear, BS = beach set, SD = Scallop Dredge, PR = pair trawl,PS = purse seine, ST = Scallop Trawl, TT Twin Trawl, NK =Not known, OB=Obsolete. |
| General Data Type: | VARCHAR2 |
LISTCOL
CC ID: 331995
| Seq. Order: | 11 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Abbreviated Description Used for Select Lists |
| General Data Type: | VARCHAR2 |
DOC
CC ID: 331996
| Seq. Order: | 12 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The date of the last change to this record. |
| General Data Type: | DATE |
Catalog Details
| Catalog Item ID: | 33433 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:33433 |
| Metadata Record Created By: | Patricia L Jones |
| Metadata Record Created: | 2016-07-11 08:41+0000 |
| Metadata Record Last Modified By: | SysAdmin InPortAdmin |
| Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
| Metadata Record Published: | 2016-07-11 |
| Owner Org: | NEFSC |
| Metadata Publication Status: | Published Externally |
| Do Not Publish?: | N |
| Metadata Last Review Date: | 2016-07-11 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2017-07-11 |