5323
Table: POP_ANIMAL_LOG
POP_ANIMAL_LOG
Entity
Published / External
30713
PELAGIC OBSERVER PROGRAM (POP). Catch/Effort data collected by observers on board U.S. commercial Pelagic Longline vessels
Data Set
Completed
Animal Log for NON-experimental hauls
Loaded by batch 1683, 10-12-2007 05:01
Temporal
1992
Temporal
1993
Temporal
1994
Temporal
1995
Temporal
1996
Temporal
1997
Temporal
1998
Temporal
1999
Temporal
2000
Temporal
2001
Temporal
2002
Temporal
2003
Temporal
2004
Temporal
2005
Temporal
2006
Temporal
2007
Temporal
2008
Temporal
2009
Temporal
2010
Temporal
2011
Data Table
Yes
POPOL
Animal Log for NON-experimental hauls
1
ANIMAL_LOG_KEY
NUMBER
22
Yes
Yes
10
0
Active
Primary Key
NUMBER
2
HAUL_LOG_KEY
NUMBER
22
Yes
No
10
0
Active
Haul Log Key
NUMBER
3
CARCASS_TAG_NUMBER
VARCHAR2
5
No
No
Active
Number assigned by the sampler to the carcass of the fish.
VARCHAR2
4
ALPHA_SPECIES_CODE
VARCHAR2
3
No
No
Active
POP Spc. Code
VARCHAR2
5
LENGTH_MEASUREMENT_ONE
NUMBER
22
No
No
3
0
Active
First Length Measurement Taken
NUMBER
6
LENGTH_MEASUREMENT_TWO
NUMBER
22
No
No
3
0
Active
Second Length Measurement Taken
NUMBER
7
LENGTH_MEASUREMENT_THREE
NUMBER
22
No
No
3
0
Active
Third Length Measurement Taken
NUMBER
8
LENGTH_TYPE_ONE
VARCHAR2
3
No
No
Active
What was measured in Length Measurement One
VARCHAR2
9
LENGTH_TYPE_TWO
VARCHAR2
3
No
No
Active
What was measured in Length Measurement Two
VARCHAR2
10
LENGTH_TYPE_THREE
VARCHAR2
3
No
No
Active
What was measured in Length Measurement Three
VARCHAR2
11
LENGTH_MEASUREMENT_TAKEN_CODE
VARCHAR2
2
No
No
Active
Length Measurement Taken Code
VARCHAR2
12
DRESSED_WEIGHT
NUMBER
22
No
No
4
0
Active
Dressed weight of the fish landed. (should not be estimated)
NUMBER
13
TAG_NUMBER
VARCHAR2
12
No
No
Active
Theoretically a link could be made to the CTS system here.
VARCHAR2
14
SEX
VARCHAR2
1
No
No
Active
Can be: Undetermined, Male, Female
VARCHAR2
15
TAG_ACTION
VARCHAR2
1
No
No
Active
Coded item describing, what if anything happened with respect to the tagging of the fish.
VARCHAR2
16
BOARDING_STATUS
VARCHAR2
1
No
No
Active
Code For how the animal was boarded (Dead, Alive etc)
VARCHAR2
17
KEPT_OR_RELEASED
VARCHAR2
1
No
No
Active
Code to indicate whether animal caught was kept or released
VARCHAR2
18
KEPT_OR_RELEASED2
VARCHAR2
1
No
No
Active
Valid Values: Dead, AliveThe column only had data in it when KEPT_OR_RELEASED is RELEASED
VARCHAR2
19
ESTIMATED_WEIGHT
NUMBER
22
No
No
4
0
Active
In Pounds
NUMBER
20
COMMENTS
VARCHAR2
2000
No
No
Active
Comments
VARCHAR2
21
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Created by whom
VARCHAR2
22
CREATED_DATE
DATE
7
Yes
No
Active
Created when
DATE
23
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Modified by whom
VARCHAR2
24
MODIFIED_DATE
DATE
7
No
No
Active
Modified when
DATE
25
PAGE_NO
NUMBER
22
No
No
2
0
Active
Which Page Number Of The Animal Log Form record is found on. This column was added during conversion between POP and POPOL
NUMBER
26
LINE_NO
NUMBER
22
No
No
2
0
Active
Which Line Number Of The Animal Log Form record is found on. This column was added during conversion between POP and POPOL
NUMBER
27
DAMAGE_TYPE
VARCHAR2
2
No
No
Active
Code assigned to indicate observed damge on the fish
VARCHAR2
video data
x
gov.noaa.nmfs.inport:5323
Lee Weinberger
2007-10-12T05:01:39
SysAdmin InPortAdmin
2022-08-09T17:11:00
2021-05-06
Southeast Fisheries Science Center
SEFSC
75 Virginia Beach Drive
Miami
FL
33149
USA
(305)361-5761
www.sefsc.noaa.gov
8:00 a.m. - 4:30 p.m. EST
1001
Public
No
2021-05-06
1 Year
2022-05-06