Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Data Management Systems (DMS) > Commercial Fisheries Database Biological Sample... >

View: GEAR

Entity (ENT)  |  Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:33433  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Commercial Fisheries Gear Support Table.

Description

Commercial Fisheries Gear Support Table.

Entity Information

Entity Type
Data View

Data Attribute / Type Description
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.
NEGEAR2
VARCHAR2 		First two digits of the Northeast Gear code. See CFDBS Gear Table (GEAR) for actual codes.
GEARNM
VARCHAR2 		Descriptive name for the NE Gear Code.
WASHGEAR
VARCHAR2 		Washington Gear Code.
NAFOGEAR
VARCHAR2 		NAFO Gear Code.
NAFOGRAB
VARCHAR2 		NAFO Gear Code abbreviation.
NAFOGRGP
VARCHAR2 		NAFO Gear Group.
NAFOGRNM
VARCHAR2 		Descriptive NAFO Gear Name.
GEARABB
VARCHAR2 		Abbreviated Gear Code
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.
LISTCOL
VARCHAR2 		Abbreviated Description Used for Select Lists
DOC
DATE 		The date of the last change to this record.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (NEFSC) for inquiries on this record.

Item Identification

Title: View: GEAR
Short Name: GEAR
Status: Completed
Abstract:

Commercial Fisheries Gear Support Table.
Notes:

Loaded by batch 8988, 07-11-2016 08:41

Entity Information

Entity Type: Data View
Active Version?: Yes
Schema Name: CFDBS
Description:

Commercial Fisheries Gear Support Table.

Data Attributes

Attribute Summary

Rubric Score Primary Key? 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