View: OBCDG
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:33560 | Updated: August 9, 2022 | Published / External
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |