27633
Variables in table JLL_CATCH
Catch variables
Entity
Published / External
27632
JAPANSE LONGLINE OBSERVER JPLL
Data Set
1
CATCH_KEY
VARCHAR2(20 BYTE)
20
No
No
Active
Unique key for this file; there is a one to 6 digit prefix (starts at 1 and goes sequentially up to 401,217) which is then followed by the trip ID number (see column 1 in the effort file documentation). This column could be used to link the catch to the effort, but the number preceding the trip ID would need to be trimmed out.
2
HAUL_NUMBER
VARCHAR2(2 BYTE)
2
No
No
Active
Haul number of this trip that this animal was caught on.
3
SPECIES_CODE
VARCHAR2(7 BYTE)
7
No
No
Active
Species code, which is formatted as an alpha-numeric string that combines the 3 letter POP alpha species codes with 4-digit NMFS numeric codes. So YFT4655 combines the POP code YFT for yellowfin tuna with the NMFS numeric code of 4655 for yellowfin tuna.
4
LENGTH1
VARCHAR2(3 BYTE)
3
No
No
Active
Length in centimeters, for species other than sharks.
5
LENGTH2
VVARCHAR2(3 BYTE)
3
No
No
Active
Length in centimeters, for species in the shark group.
6
LENGTH_TYPE
VARCHAR2(1 BYTE)
1
No
No
Active
A length type code that relates to whatever length appears in columns LENGTH1 or LENGTH2. The codes are 0=unknown, 1=straight length measurement, 2=curved length measurement, and 3=estimated length measurement.
7
SEX
VARCHAR2(1 BYTE)
1
No
No
Active
Sex ID of the observed animal: : 0 = unknown, 1 = male, and 2 = female.
8
BEGIN_HAUL_DATE
VARCHAR2(20 BYTE)
20
No
No
Active
Begin haul date, in format YYYYMMDD.
9
SPECIES_GROUP
VARCHAR2(20 BYTE)
20
No
No
Active
SPECIES_GROUP: Species group; an alpha code that describes the general group this species fits in. There are 11 distinct values:
JAPSKATES/RAYS
JAPTUNA OTHER
JAPTUNA
JAPBILLFISH
JAPSEA BIRD
JAPMARINE TURTLE
JAPFINFISH OTHER
JAPMARINE MAMMAL
JAPFINFISH
JAPSHARK
JAPMISC
gov.noaa.nmfs.inport:27633
Larry Beerkircher
2015-10-01T08:20:12
SysAdmin InPortAdmin
2022-08-09T17:11:11
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