Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

At Sea Monitor catch and discard data by species for each haul

Description

At Sea Monitor catch and discard data by species for each haul

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.
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.
HAULNUM
VARCHAR2
Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable.
AREA
VARCHAR2
Statistical area code obtained from positions at beginning of haul for fixed gear and end of the haul for mobile gear or at sighting position. See LOC2AREAS table on sole. Collected for ASM where applicable.
NEMAREA
VARCHAR2
Inshore area codes. See Loc2areas table. Not collected before 5/1994; set to statistical area.
NEGEAR
VARCHAR2
Northeast gear code. See OBGEAR table. Collected for ASM where applicable.
OBSRFLAG
VARCHAR2
Indicator of whether haul was observed for discards (all hauls are observed for catch except for offwatch (sdo, sto, cdo) hauls). 0=no; 1=yes. Collected for ASM where applicable.
LATHBEG
VARCHAR2
Latitude location, (DDMMSS) where haul began. Pre 2001 : SS rounded to 30 where no loran. Collected for ASM where applicable.
LONHBEG
VARCHAR2
Longitude location of where haul began, (DDMMSS). Pre 2001: SS rounded to 30 where no lorans. Collected for ASM where applicable.
NESPP4
VARCHAR2
Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBSPEC Table. Collected for ASM where applicable.
HAILWT
NUMBER
The dressed or round, actual or estimated weight for each caught species. Actual weights recorded to the nearest tenth of a pound, estimated to nearest whole pound. SPP : Previous to 5/1994 the dressed /round and actual/estimated fields were recorded but not entered so both dressed and actual fields are unknown for those years. Collected for ASM where applicable.
FISHDISP
VARCHAR2
Three digit code for disposition of each species (catdisp plus discreason). See OBFISHDISP table. IAL: discard reason not recorded previous to 5/1994; last two digits of fishdisp set to 00 (unknown discard reason); Collected for ASM where applicable.
CATDISP
VARCHAR2
Code to indicate catch disposition. 0 = discarded, 1 = kept, 9 = unknown. Collected for ASM where applicable.
DRFLAG
VARCHAR2
Indicator of whether the species in the record was dressed =1 or round =2, unknown= 0; SPP: prior to 5/1994 data recorded but not entered; set to unknown. Collected for ASM where applicable.
WGTTYPE
VARCHAR2
One digit code denoting type of weight of species. 1=actual; 2=estimated; 0=unknown. SPP: prior to 5/1994 data recorded but not entered; set to unknown. Collected for ASM where applicable.
SPPCOMMENTS
VARCHAR2
Additional information regarding the species. Collected for ASM where applicable.
HAUCOMMENTS
VARCHAR2
Prior to 2001 only true (1), false (0). Collected for ASM where applicable.
ONEFFORT
VARCHAR2
Indicator whether the observer is intentionally present to witness the haulback 1 = yes, 0 = no, 9 = unknown Collected beginning with obdbs Version 10 (01/01/2011).
ESTMETH
VARCHAR2
Method used to estimate the catch weight of each species (including debris). See OBESTMETH table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.
ASMTEST_STATUS
VARCHAR2
Test / Load status for At Sea Monitoring trip. PRELIM = preliminary testing, BASE = fully tested

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

At Sea Monitor catch and discard data by species for each haul

Notes:

Loaded by batch 8948, 07-06-2016 08:22

Entity Information

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

At Sea Monitor catch and discard data by species for each haul

Data Attributes

Attribute Summary

Rubric Score Primary Key? 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
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
HAULNUM VARCHAR2 Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable.
100
AREA VARCHAR2 Statistical area code obtained from positions at beginning of haul for fixed gear and end of the haul for mobile gear or at sighting position. See LOC2AREAS table on sole. Collected for ASM where applicable.
100
NEMAREA VARCHAR2 Inshore area codes. See Loc2areas table. Not collected before 5/1994; set to statistical area.
100
NEGEAR VARCHAR2 Northeast gear code. See OBGEAR table. Collected for ASM where applicable.
100
OBSRFLAG VARCHAR2 Indicator of whether haul was observed for discards (all hauls are observed for catch except for offwatch (sdo, sto, cdo) hauls). 0=no; 1=yes. Collected for ASM where applicable.
100
LATHBEG VARCHAR2 Latitude location, (DDMMSS) where haul began. Pre 2001 : SS rounded to 30 where no loran. Collected for ASM where applicable.
100
LONHBEG VARCHAR2 Longitude location of where haul began, (DDMMSS). Pre 2001: SS rounded to 30 where no lorans. Collected for ASM where applicable.
100
NESPP4 VARCHAR2 Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBSPEC Table. Collected for ASM where applicable.
100
HAILWT NUMBER The dressed or round, actual or estimated weight for each caught species. Actual weights recorded to the nearest tenth of a pound, estimated to nearest whole pound. SPP : Previous to 5/1994 the dressed /round and actual/estimated fields were recorded but not entered so both dressed and actual fields are unknown for those years. Collected for ASM where applicable.
100
FISHDISP VARCHAR2 Three digit code for disposition of each species (catdisp plus discreason). See OBFISHDISP table. IAL: discard reason not recorded previous to 5/1994; last two digits of fishdisp set to 00 (unknown discard reason); Collected for ASM where applicable.
100
CATDISP VARCHAR2 Code to indicate catch disposition. 0 = discarded, 1 = kept, 9 = unknown. Collected for ASM where applicable.
100
DRFLAG VARCHAR2 Indicator of whether the species in the record was dressed =1 or round =2, unknown= 0; SPP: prior to 5/1994 data recorded but not entered; set to unknown. Collected for ASM where applicable.
100
WGTTYPE VARCHAR2 One digit code denoting type of weight of species. 1=actual; 2=estimated; 0=unknown. SPP: prior to 5/1994 data recorded but not entered; set to unknown. Collected for ASM where applicable.
100
SPPCOMMENTS VARCHAR2 Additional information regarding the species. Collected for ASM where applicable.
100
HAUCOMMENTS VARCHAR2 Prior to 2001 only true (1), false (0). Collected for ASM where applicable.
100
ONEFFORT VARCHAR2 Indicator whether the observer is intentionally present to witness the haulback 1 = yes, 0 = no, 9 = unknown Collected beginning with obdbs Version 10 (01/01/2011).
100
ESTMETH VARCHAR2 Method used to estimate the catch weight of each species (including debris). See OBESTMETH table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.
100
ASMTEST_STATUS VARCHAR2 Test / Load status for At Sea Monitoring trip. PRELIM = preliminary testing, BASE = fully tested

Attribute Details

LINK3

CC ID: 329280
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 19
Required: Yes
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

CC ID: 329291
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: 329297
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: 329298
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: 329299
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: 329300
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

HAULNUM

CC ID: 329301
Seq. Order: 7
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

AREA

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

Statistical area code obtained from positions at beginning of haul for fixed gear and end of the haul for mobile gear or at sighting position. See LOC2AREAS table on sole. Collected for ASM where applicable.

General Data Type: VARCHAR2

NEMAREA

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

Inshore area codes. See Loc2areas table. Not collected before 5/1994; set to statistical area.

General Data Type: VARCHAR2

NEGEAR

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

Northeast gear code. See OBGEAR table. Collected for ASM where applicable.

General Data Type: VARCHAR2

OBSRFLAG

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

Indicator of whether haul was observed for discards (all hauls are observed for catch except for offwatch (sdo, sto, cdo) hauls). 0=no; 1=yes. Collected for ASM where applicable.

General Data Type: VARCHAR2

LATHBEG

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

Latitude location, (DDMMSS) where haul began. Pre 2001 : SS rounded to 30 where no loran. Collected for ASM where applicable.

General Data Type: VARCHAR2

LONHBEG

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

Longitude location of where haul began, (DDMMSS). Pre 2001: SS rounded to 30 where no lorans. Collected for ASM where applicable.

General Data Type: VARCHAR2

NESPP4

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

Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBSPEC Table. Collected for ASM where applicable.

General Data Type: VARCHAR2

HAILWT

CC ID: 329286
Seq. Order: 15
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 7
Scale: 1
Status: Active
Description:

The dressed or round, actual or estimated weight for each caught species. Actual weights recorded to the nearest tenth of a pound, estimated to nearest whole pound. SPP : Previous to 5/1994 the dressed /round and actual/estimated fields were recorded but not entered so both dressed and actual fields are unknown for those years. Collected for ASM where applicable.

General Data Type: NUMBER

FISHDISP

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

Three digit code for disposition of each species (catdisp plus discreason). See OBFISHDISP table. IAL: discard reason not recorded previous to 5/1994; last two digits of fishdisp set to 00 (unknown discard reason); Collected for ASM where applicable.

General Data Type: VARCHAR2

CATDISP

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

Code to indicate catch disposition. 0 = discarded, 1 = kept, 9 = unknown. Collected for ASM where applicable.

General Data Type: VARCHAR2

DRFLAG

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

Indicator of whether the species in the record was dressed =1 or round =2, unknown= 0; SPP: prior to 5/1994 data recorded but not entered; set to unknown. Collected for ASM where applicable.

General Data Type: VARCHAR2

WGTTYPE

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

One digit code denoting type of weight of species. 1=actual; 2=estimated; 0=unknown. SPP: prior to 5/1994 data recorded but not entered; set to unknown. Collected for ASM where applicable.

General Data Type: VARCHAR2

SPPCOMMENTS

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

Additional information regarding the species. Collected for ASM where applicable.

General Data Type: VARCHAR2

HAUCOMMENTS

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

Prior to 2001 only true (1), false (0). Collected for ASM where applicable.

General Data Type: VARCHAR2

ONEFFORT

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

Indicator whether the observer is intentionally present to witness the haulback 1 = yes, 0 = no, 9 = unknown Collected beginning with obdbs Version 10 (01/01/2011).

General Data Type: VARCHAR2

ESTMETH

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

Method used to estimate the catch weight of each species (including debris). See OBESTMETH table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.

General Data Type: VARCHAR2

ASMTEST_STATUS

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

Test / Load status for At Sea Monitoring trip. PRELIM = preliminary testing, BASE = fully tested

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 33280
GUID: gov.noaa.nmfs.inport:33280
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-07-06 08:22+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