5324
Table: POP_ANIMAL_LOG_EXP
POP_ANIMAL_LOG_EXP
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 Experimental Hauls
Loaded by batch 1683, 10-12-2007 05:01
Theme
experimental data
Theme
protective species
Theme
turtles
Temporal
2002-2011
Spatial
Atantic Ocean
Spatial
Gulf of Mexico
Spatial
NED
Data Table
Yes
POPOL
Animal Log for 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
SECTION
NUMBER
22
No
No
2
0
Active
Section of the gear the animal was caught in
NUMBER
21
TREATMENT
VARCHAR2
1
No
No
Active
Treatment the animal received
VARCHAR2
22
TIME_BOARDED
DATE
7
No
No
Active
When the animal was boarded
DATE
23
HOOK_TIMER_ELAPSED_TIME
VARCHAR2
4
No
No
Active
Hook Timer elapsed time
VARCHAR2
24
HOW_HOOKED
VARCHAR2
1
No
No
Active
How the animal was hooked
VARCHAR2
25
ENTANGLED
VARCHAR2
1
No
No
Active
Was it entangled?
VARCHAR2
26
COMMENTS
VARCHAR2
2000
No
No
Active
Comments
VARCHAR2
27
HOOK_DEPTH
VARCHAR2
1
No
No
Active
Hook Depth
VARCHAR2
28
UNK_CODE
VARCHAR2
1
No
No
Active
Unknow Code
VARCHAR2
29
TDR
VARCHAR2
1
No
No
Active
Time Depth Recorder
VARCHAR2
30
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Created by whom
VARCHAR2
31
CREATED_DATE
DATE
7
Yes
No
Active
Created when
DATE
32
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Modified by whom
VARCHAR2
33
MODIFIED_DATE
DATE
7
No
No
Active
Modified when
DATE
34
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
35
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
36
DAMAGE_TYPE
VARCHAR2
2
No
No
Active
Code assigned to indicate observed damge on the fish
VARCHAR2
gov.noaa.nmfs.inport:5324
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