Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Fishery Monitoring & Research Division (FMRD) > Fisheries Sampling Branch (FSB) > Observer and At Sea Monitor Database (OBDBS) >

View: OBCDG

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

Summary

Abstract

Observer Clam Dredge Gear Characteristics

Description

Observer Clam Dredge Gear Characteristics

Entity Information

Entity Type
Data View

Data Attribute / Type Description
LINK4
VARCHAR2 		Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. Collected for ASM where applicable.
LINK1
VARCHAR2 		15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable.
PROGRAM
VARCHAR2 		First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.
YEAR
VARCHAR2 		Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.
MONTH
VARCHAR2 		Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.
TRIPID
VARCHAR2 		May 1994 - current: 6 - character trip id; first three characters are the observer id number (obsid) and the second are the ordinal number of trips the observer has taken for the current year. Collected for ASM where applicable.
GEARNUM
VARCHAR2 		Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable.
NEGEAR
VARCHAR2 		Northeast gear code. See OBGEAR table. Collected for ASM where applicable.
DREDGEHGT
NUMBER 		Overall height of a clam/quahog dredge cage frame, from the bottom of the cage frame to the top, recorded in whole inches.
DREDGEWID
NUMBER 		Overall width of a clam/quahog dredge cage frame, from one side of the cage frame to the other, recorded in whole inches.
DREDGELEN
NUMBER 		Overall length of a clam/quahog dredge cage frame, from one side of the cage frame to the other, recorded in whole inches.
CAGEBARDIA
NUMBER 		Diameter of the bars in the bottom of the cage in a clam/quahog dredge. Measured to a tenth of an inch.
BARSPACE
NUMBER 		Distance between bars on the bottom of the cage in a clam/quahog dredge. Measured to a tenth of an inch.
SORTERUSD
VARCHAR2 		Indicates whether a mechanized sorter was used to remove undersized shellfish, debris, etc. from the catch on clam/quahog efforts. 0 = no, 1 = yes, 9 = unknown.
NNOZZLES
NUMBER 		Total number of nozzles used on a clam/quahog dredge.
TOWLINETYP
VARCHAR2 		Indicates the type of line configuration used to tow a clam/quahog dredge. 0 = unknown, 1 = single, 2 = bridle, 3 = other. See CDGCOMMENTS for information regarding a type 3 line type configuration.
TOWLINEPOS
VARCHAR2 		Indicates where the towline is attached to a clam/quahog dredge. 0 = unknown, 1 = forward section, 2 = over top of the knife.
CHBAGUSD
VARCHAR2 		Indicator of whether a chain bag was used at the back of the dredge. 0 = no, 1 = yes, 9 = unknown.
NLINKBTW
NUMBER 		Average number of links used between 2 rings on bottom of chain bag
LINKSIZE
NUMBER 		Fractional diameter of steel used in links between rings on bottom of chain bag.
RSITOB
NUMBER 		Inside diameter of ten randomly selected rings from top of chain bag, in whole millimeters.
RSIBOB
NUMBER 		Inside diameter of ten randomly selected rings from bottom of chain bag, in whole millimeters.
RSOBOB
NUMBER 		Outside diameter of ten randomly selected rings from bottom of chain bag, in whole millimeters.
CDGCOMMENTS
VARCHAR2 		Clam/quahog dredge gear comments.

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: OBCDG
Short Name: OBCDG
Status: Completed
Abstract:

Observer Clam Dredge Gear Characteristics
Notes:

Loaded by batch 9053, 07-27-2016 19:10

Entity Information

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

Observer Clam Dredge Gear Characteristics

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 LINK4 VARCHAR2 Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. Collected for ASM where applicable.
100
 LINK1 VARCHAR2 15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable.
100
 PROGRAM VARCHAR2 First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.
100
 YEAR VARCHAR2 Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.
100
 MONTH VARCHAR2 Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.
100
 TRIPID VARCHAR2 May 1994 - current: 6 - character trip id; first three characters are the observer id number (obsid) and the second are the ordinal number of trips the observer has taken for the current year. Collected for ASM where applicable.
100
 GEARNUM VARCHAR2 Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable.
100
 NEGEAR VARCHAR2 Northeast gear code. See OBGEAR table. Collected for ASM where applicable.
100
 DREDGEHGT NUMBER Overall height of a clam/quahog dredge cage frame, from the bottom of the cage frame to the top, recorded in whole inches.
100
 DREDGEWID NUMBER Overall width of a clam/quahog dredge cage frame, from one side of the cage frame to the other, recorded in whole inches.
100
 DREDGELEN NUMBER Overall length of a clam/quahog dredge cage frame, from one side of the cage frame to the other, recorded in whole inches.
100
 CAGEBARDIA NUMBER Diameter of the bars in the bottom of the cage in a clam/quahog dredge. Measured to a tenth of an inch.
100
 BARSPACE NUMBER Distance between bars on the bottom of the cage in a clam/quahog dredge. Measured to a tenth of an inch.
100
 SORTERUSD VARCHAR2 Indicates whether a mechanized sorter was used to remove undersized shellfish, debris, etc. from the catch on clam/quahog efforts. 0 = no, 1 = yes, 9 = unknown.
100
 NNOZZLES NUMBER Total number of nozzles used on a clam/quahog dredge.
100
 TOWLINETYP VARCHAR2 Indicates the type of line configuration used to tow a clam/quahog dredge. 0 = unknown, 1 = single, 2 = bridle, 3 = other. See CDGCOMMENTS for information regarding a type 3 line type configuration.
100
 TOWLINEPOS VARCHAR2 Indicates where the towline is attached to a clam/quahog dredge. 0 = unknown, 1 = forward section, 2 = over top of the knife.
100
 CHBAGUSD VARCHAR2 Indicator of whether a chain bag was used at the back of the dredge. 0 = no, 1 = yes, 9 = unknown.
100
 NLINKBTW NUMBER Average number of links used between 2 rings on bottom of chain bag
100
 LINKSIZE NUMBER Fractional diameter of steel used in links between rings on bottom of chain bag.
100
 RSITOB NUMBER Inside diameter of ten randomly selected rings from top of chain bag, in whole millimeters.
100
 RSIBOB NUMBER Inside diameter of ten randomly selected rings from bottom of chain bag, in whole millimeters.
100
 RSOBOB NUMBER Outside diameter of ten randomly selected rings from bottom of chain bag, in whole millimeters.
100
 CDGCOMMENTS VARCHAR2 Clam/quahog dredge gear comments.

Attribute Details

LINK4

CC ID: 334287
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 17
Required: No
Primary Key: No
Status: Active
Description:

Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. Collected for ASM where applicable.
General Data Type: VARCHAR2

LINK1

CC ID: 334298
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable.
General Data Type: VARCHAR2

PROGRAM

CC ID: 334304
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.
General Data Type: VARCHAR2

YEAR

CC ID: 334305
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.
General Data Type: VARCHAR2

MONTH

CC ID: 334306
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.
General Data Type: VARCHAR2

TRIPID

CC ID: 334307
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

May 1994 - current: 6 - character trip id; first three characters are the observer id number (obsid) and the second are the ordinal number of trips the observer has taken for the current year. Collected for ASM where applicable.
General Data Type: VARCHAR2

GEARNUM

CC ID: 334308
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable.
General Data Type: VARCHAR2

NEGEAR

CC ID: 334309
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Northeast gear code. See OBGEAR table. Collected for ASM where applicable.
General Data Type: VARCHAR2

DREDGEHGT

CC ID: 334310
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Overall height of a clam/quahog dredge cage frame, from the bottom of the cage frame to the top, recorded in whole inches.
General Data Type: NUMBER

DREDGEWID

CC ID: 334288
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Overall width of a clam/quahog dredge cage frame, from one side of the cage frame to the other, recorded in whole inches.
General Data Type: NUMBER

DREDGELEN

CC ID: 334289
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Overall length of a clam/quahog dredge cage frame, from one side of the cage frame to the other, recorded in whole inches.
General Data Type: NUMBER

CAGEBARDIA

CC ID: 334290
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 1
Status: Active
Description:

Diameter of the bars in the bottom of the cage in a clam/quahog dredge. Measured to a tenth of an inch.
General Data Type: NUMBER

BARSPACE

CC ID: 334291
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 1
Status: Active
Description:

Distance between bars on the bottom of the cage in a clam/quahog dredge. Measured to a tenth of an inch.
General Data Type: NUMBER

SORTERUSD

CC ID: 334292
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Indicates whether a mechanized sorter was used to remove undersized shellfish, debris, etc. from the catch on clam/quahog efforts. 0 = no, 1 = yes, 9 = unknown.
General Data Type: VARCHAR2

NNOZZLES

CC ID: 334293
Seq. Order: 15
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Total number of nozzles used on a clam/quahog dredge.
General Data Type: NUMBER

TOWLINETYP

CC ID: 334294
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Indicates the type of line configuration used to tow a clam/quahog dredge. 0 = unknown, 1 = single, 2 = bridle, 3 = other. See CDGCOMMENTS for information regarding a type 3 line type configuration.
General Data Type: VARCHAR2

TOWLINEPOS

CC ID: 334295
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Indicates where the towline is attached to a clam/quahog dredge. 0 = unknown, 1 = forward section, 2 = over top of the knife.
General Data Type: VARCHAR2

CHBAGUSD

CC ID: 334296
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Indicator of whether a chain bag was used at the back of the dredge. 0 = no, 1 = yes, 9 = unknown.
General Data Type: VARCHAR2

NLINKBTW

CC ID: 334297
Seq. Order: 19
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Average number of links used between 2 rings on bottom of chain bag
General Data Type: NUMBER

LINKSIZE

CC ID: 334299
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 2
Status: Active
Description:

Fractional diameter of steel used in links between rings on bottom of chain bag.
General Data Type: NUMBER

RSITOB

CC ID: 334300
Seq. Order: 21
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Inside diameter of ten randomly selected rings from top of chain bag, in whole millimeters.
General Data Type: NUMBER

RSIBOB

CC ID: 334301
Seq. Order: 22
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Inside diameter of ten randomly selected rings from bottom of chain bag, in whole millimeters.
General Data Type: NUMBER

RSOBOB

CC ID: 334302
Seq. Order: 23
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Outside diameter of ten randomly selected rings from bottom of chain bag, in whole millimeters.
General Data Type: NUMBER

CDGCOMMENTS

CC ID: 334303
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 250
Required: No
Primary Key: No
Status: Active
Description:

Clam/quahog dredge gear comments.
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 33560
GUID: gov.noaa.nmfs.inport:33560
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-07-27 19:10+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-07-28
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-07-28
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-07-28