Search Help Show/Hide Menu
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