Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: View: OBLEN
Short Name: OBLEN
Status: Completed
Abstract:

Observer Animal Length Data 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 Animal Length Data from standard observer trips

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
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
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
LINK3 VARCHAR2 Key field linking tables at the haul level; made up of: link1 plus (4-character) haulnum. Collected for ASM where applicable.
100
QTR NUMBER Quarter of year landed: 1 = Jan, Feb, Mar; 2 = Apr,May,Jun 3=Jul, Aug, Sep, 4= Oct, Nov, Dec. 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
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
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
OBGEARCAT VARCHAR2 Gear Category used by observer program: OT = Otter trawl,GG = gillnet, PT = Pots and traps , LL = Longline and other line gear, BS = beach set, SD = Scallop Dredge, PR = pair trawl,PS = purse seine, ST = Scallop Trawl, TT Twin Trawl, NK =Not known, OB=Obsolete.
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
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
SEX VARCHAR2 One digit code for sex of each animal whether it is brought on board or not. 0=unknown; 1=male; 2=female.
100
DREDGEPOS VARCHAR2 Which dredge the sample was taken from : P=port, S=Starboard, A= Aft, U= Unknown. Not recorded before 5/1994; set to unknown;
100
SAMPWEIGHT NUMBER Collective Round, actual weight, of measured animals for species , sex, and market category of fish being sampled. Collected for ASM where applicable.
100
AGESTRCT VARCHAR2 Type of age structure collected for sample: 0 = none, 1 = scales, 2 = otoliths, 3 = shells, 4 = whole, 5 = vertebra, 6 = dorsal spines, 7 = scales and otoliths, 8 = head, 9 = other (see comments).
100
NAGESTRCT NUMBER Total number of animals from which age samples were collected.
100
VOLMEATS NUMBER Volumetric measure of scallop meats, to nearest 50 millileters. Not collected previous to 5/1994; set to unknown.
100
LNHCOMMENTS VARCHAR2 Comments on length record. Prior to 2001 only true (1), false (0). Collected for ASM where applicable.
100
LENANML NUMBER Finfish and squid measured in whole centimeters. Shellfish measured in whole millimeters. Collected for ASM where applicable.
100
NUMLEN NUMBER Total number of animals measured at each centimeter or millimeter. Collected for ASM where applicable.

Attribute Details

PROGRAM

CC ID: 334480
Seq. Order: 1
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: 334491
Seq. Order: 2
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: 334500
Seq. Order: 3
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: 334501
Seq. Order: 4
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: 334502
Seq. Order: 5
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

LINK1

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

LINK3

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

QTR

CC ID: 334505
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Quarter of year landed: 1 = Jan, Feb, Mar; 2 = Apr,May,Jun 3=Jul, Aug, Sep, 4= Oct, Nov, Dec. Collected for ASM where applicable.

General Data Type: NUMBER

LATHBEG

CC ID: 334506
Seq. Order: 9
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: 334481
Seq. Order: 10
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

AREA

CC ID: 334482
Seq. Order: 11
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: 334483
Seq. Order: 12
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: 334484
Seq. Order: 13
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

ONEFFORT

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

OBGEARCAT

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

Gear Category used by observer program: OT = Otter trawl,GG = gillnet, PT = Pots and traps , LL = Longline and other line gear, BS = beach set, SD = Scallop Dredge, PR = pair trawl,PS = purse seine, ST = Scallop Trawl, TT Twin Trawl, NK =Not known, OB=Obsolete.

General Data Type: VARCHAR2

NESPP4

CC ID: 334487
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
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

FISHDISP

CC ID: 334488
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
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: 334489
Seq. Order: 18
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

SEX

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

One digit code for sex of each animal whether it is brought on board or not. 0=unknown; 1=male; 2=female.

General Data Type: VARCHAR2

DREDGEPOS

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

Which dredge the sample was taken from : P=port, S=Starboard, A= Aft, U= Unknown. Not recorded before 5/1994; set to unknown;

General Data Type: VARCHAR2

SAMPWEIGHT

CC ID: 334493
Seq. Order: 21
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 1
Status: Active
Description:

Collective Round, actual weight, of measured animals for species , sex, and market category of fish being sampled. Collected for ASM where applicable.

General Data Type: NUMBER

AGESTRCT

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

Type of age structure collected for sample: 0 = none, 1 = scales, 2 = otoliths, 3 = shells, 4 = whole, 5 = vertebra, 6 = dorsal spines, 7 = scales and otoliths, 8 = head, 9 = other (see comments).

General Data Type: VARCHAR2

NAGESTRCT

CC ID: 334495
Seq. Order: 23
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Total number of animals from which age samples were collected.

General Data Type: NUMBER

VOLMEATS

CC ID: 334496
Seq. Order: 24
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Volumetric measure of scallop meats, to nearest 50 millileters. Not collected previous to 5/1994; set to unknown.

General Data Type: NUMBER

LNHCOMMENTS

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

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

General Data Type: VARCHAR2

LENANML

CC ID: 334498
Seq. Order: 26
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Finfish and squid measured in whole centimeters. Shellfish measured in whole millimeters. Collected for ASM where applicable.

General Data Type: NUMBER

NUMLEN

CC ID: 334499
Seq. Order: 27
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Total number of animals measured at each centimeter or millimeter. Collected for ASM where applicable.

General Data Type: NUMBER

Catalog Details

Catalog Item ID: 33564
GUID: gov.noaa.nmfs.inport:33564
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