View: OBSDH
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:33571 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Observer Scallop Dredge and Crab Dredge Haul Logs from standard observer trips
DescriptionObserver Scallop Dredge and Crab Dredge Haul Logs from standard observer trips
Entity Information
Entity Type
Data View
Data Attribute / Type | Description |
---|---|
LINK3
VARCHAR2 |
Key field linking tables at the haul level; made up of: link1 plus (4-character) haulnum. 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. |
LINK4
VARCHAR2 |
Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. 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. |
DREDGOBS
VARCHAR2 |
Code to indicate dredge(s) where kept and discard data were collected from haul. 0=unknown,1=port, 2=starboard, 3=both, 4 = aft; aft not collected prior to 2005. |
GEARNUM
VARCHAR2 |
Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable. |
HAULNUM
VARCHAR2 |
Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable. |
TOWSPEED
NUMBER |
Average towing speed over bottom, to nearest 10th of knot. |
WIREOUT
NUMBER |
Amount of wire paid out for haul, in whole fathoms. |
CLAPOBS
VARCHAR2 |
Indicator of whether sea scallop clappers were found in gear for haul. 0 = no, 1 = yes, 9 = unknown. |
NBUSHKEP
NUMBER |
Amount of scallops, in the shell, kept from haul, to nearest hundredth of a bushel. Not entered prior to 5/1994; set to unknown. |
NBUSHDIS
NUMBER |
Amount of scallops, in the shell, discarded from haul, to nearest hundredth of a bushel. Not collected prior to 5/1994; set to unknown. |
AVLBBUSHKEP
NUMBER |
Average pounds per bushel of scallops kept from haul. For standard protocol these are estimated , in shell. For closed area scallop (CAS) trips they are recorded as dressed (shucked) weights. Not recorded before 5/1994; set to unknown. |
AVLBBUSHDIS
NUMBER |
Average pounds per bushel of scallops, in shell, discarded from haul. Not collected prior to 5/1994; set to unknown. |
DRKEPFLAG
VARCHAR2 |
Indicator of whether the avlbbushkept is for dressed/shucked (1) or round (2) scallops 0 = unknown |
DRDISFLAG
VARCHAR2 |
Indicator of whether the avlbbushdis is for dressed/shucked (1) or round (2) scallops 0 = unknown |
SDHCOMMENTS
VARCHAR2 |
Additional information regarding Scallop Dredge Haul. Prior to 2001 only true or false |
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: OBSDH |
---|---|
Short Name: | OBSDH |
Status: | Completed |
Abstract: |
Observer Scallop Dredge and Crab Dredge Haul Logs from standard observer trips |
Notes: |
Loaded by batch 9053, 07-27-2016 19:10 |
Entity Information
Entity Type: | Data View |
---|---|
Active Version?: | Yes |
Schema Name: | OBDBS |
Description: |
Observer Scallop Dredge and Crab Dredge Haul Logs from standard observer trips |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
LINK3 | VARCHAR2 | Key field linking tables at the haul level; made up of: link1 plus (4-character) haulnum. 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
|
LINK4 | VARCHAR2 | Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. 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
|
DREDGOBS | VARCHAR2 | Code to indicate dredge(s) where kept and discard data were collected from haul. 0=unknown,1=port, 2=starboard, 3=both, 4 = aft; aft not collected prior to 2005. | |
100
|
GEARNUM | VARCHAR2 | Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable. | |
100
|
HAULNUM | VARCHAR2 | Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable. | |
100
|
TOWSPEED | NUMBER | Average towing speed over bottom, to nearest 10th of knot. | |
100
|
WIREOUT | NUMBER | Amount of wire paid out for haul, in whole fathoms. | |
100
|
CLAPOBS | VARCHAR2 | Indicator of whether sea scallop clappers were found in gear for haul. 0 = no, 1 = yes, 9 = unknown. | |
100
|
NBUSHKEP | NUMBER | Amount of scallops, in the shell, kept from haul, to nearest hundredth of a bushel. Not entered prior to 5/1994; set to unknown. | |
100
|
NBUSHDIS | NUMBER | Amount of scallops, in the shell, discarded from haul, to nearest hundredth of a bushel. Not collected prior to 5/1994; set to unknown. | |
100
|
AVLBBUSHKEP | NUMBER | Average pounds per bushel of scallops kept from haul. For standard protocol these are estimated , in shell. For closed area scallop (CAS) trips they are recorded as dressed (shucked) weights. Not recorded before 5/1994; set to unknown. | |
100
|
AVLBBUSHDIS | NUMBER | Average pounds per bushel of scallops, in shell, discarded from haul. Not collected prior to 5/1994; set to unknown. | |
100
|
DRKEPFLAG | VARCHAR2 | Indicator of whether the avlbbushkept is for dressed/shucked (1) or round (2) scallops 0 = unknown | |
100
|
DRDISFLAG | VARCHAR2 | Indicator of whether the avlbbushdis is for dressed/shucked (1) or round (2) scallops 0 = unknown | |
100
|
SDHCOMMENTS | VARCHAR2 | Additional information regarding Scallop Dredge Haul. Prior to 2001 only true or false |
Attribute Details
LINK3
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 19 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Key field linking tables at the haul level; made up of: link1 plus (4-character) haulnum. 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 |
LINK4
Seq. Order: | 3 |
---|---|
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 |
PROGRAM
Seq. Order: | 4 |
---|---|
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: | 5 |
---|---|
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: | 6 |
---|---|
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: | 7 |
---|---|
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 |
DREDGOBS
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code to indicate dredge(s) where kept and discard data were collected from haul. 0=unknown,1=port, 2=starboard, 3=both, 4 = aft; aft not collected prior to 2005. |
General Data Type: | VARCHAR2 |
GEARNUM
Seq. Order: | 9 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
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 |
HAULNUM
Seq. Order: | 10 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable. |
General Data Type: | VARCHAR2 |
TOWSPEED
Seq. Order: | 11 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 1 |
Status: | Active |
Description: |
Average towing speed over bottom, to nearest 10th of knot. |
General Data Type: | NUMBER |
WIREOUT
Seq. Order: | 12 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Amount of wire paid out for haul, in whole fathoms. |
General Data Type: | NUMBER |
CLAPOBS
Seq. Order: | 13 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Indicator of whether sea scallop clappers were found in gear for haul. 0 = no, 1 = yes, 9 = unknown. |
General Data Type: | VARCHAR2 |
NBUSHKEP
Seq. Order: | 14 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 2 |
Status: | Active |
Description: |
Amount of scallops, in the shell, kept from haul, to nearest hundredth of a bushel. Not entered prior to 5/1994; set to unknown. |
General Data Type: | NUMBER |
NBUSHDIS
Seq. Order: | 15 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 2 |
Status: | Active |
Description: |
Amount of scallops, in the shell, discarded from haul, to nearest hundredth of a bushel. Not collected prior to 5/1994; set to unknown. |
General Data Type: | NUMBER |
AVLBBUSHKEP
Seq. Order: | 16 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 1 |
Status: | Active |
Description: |
Average pounds per bushel of scallops kept from haul. For standard protocol these are estimated , in shell. For closed area scallop (CAS) trips they are recorded as dressed (shucked) weights. Not recorded before 5/1994; set to unknown. |
General Data Type: | NUMBER |
AVLBBUSHDIS
Seq. Order: | 17 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 1 |
Status: | Active |
Description: |
Average pounds per bushel of scallops, in shell, discarded from haul. Not collected prior to 5/1994; set to unknown. |
General Data Type: | NUMBER |
DRKEPFLAG
Seq. Order: | 18 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Indicator of whether the avlbbushkept is for dressed/shucked (1) or round (2) scallops 0 = unknown |
General Data Type: | VARCHAR2 |
DRDISFLAG
Seq. Order: | 19 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Indicator of whether the avlbbushdis is for dressed/shucked (1) or round (2) scallops 0 = unknown |
General Data Type: | VARCHAR2 |
SDHCOMMENTS
Seq. Order: | 20 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 250 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Additional information regarding Scallop Dredge Haul. Prior to 2001 only true or false |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 33571 |
---|---|
GUID: | gov.noaa.nmfs.inport:33571 |
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 |