View: ASMSPP
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:33280 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
At Sea Monitor catch and discard data by species for each haul
DescriptionAt 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
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
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
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 |
HAULNUM
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |