27625
Variables in table JLL_EFFORT
Effort variables
Entity
Published / External
27623
JLL_EFFORT
Data Set
Completed
1
TRIP_ID
VARCHAR2(8 BYTE)
8
No
No
Active
Trip identification number. Format is JAYYXX; so a ‘JA’ is followed by the last two digits of the trip year and then a sequential trip number, which starts at 01 for each year. So ‘JA7802’ is the second trip observed in 1978. It should be noted that this ID number appears to have been generated well after data collection; it does not appear on data sheets.
2
HAUL_GEAR
VARCHAR2(5 BYTE)
5
No
No
Active
This 4 or 5 digit number represents the NMFS gear code for pelagic longline (675), prefixed by the haul number. So 12675 is the twelfth haul of this trip.
3
INCIDENTAL_TAKE
VARCHAR2(1 BYTE)
1
No
No
Active
This variable indicates if a turtle, marine mammal, or sea bird was caught during this haul (value=1) or there was no catch of these species (Value=0).
4
BOUYS
VARCHAR2(4 BYTE)
4
No
No
Active
Number of buoys used in the set. This variable tracks to the variable “NO. OF FLTS” on the paper data forms.
5
HOOKS
VARCHAR2(5 BYTE)
5
No
No
Active
Number of hooks used in the set. This variable tracks to the variable “NO. OF HOOKS” on the paper data forms.
6
BEGIN_SET_DATE
VARCHAR2(8 BYTE)
8
No
No
Active
Begin Set Date. The format is not quite straightforward. The last 4 digits are always the year, the two places preceding the year are the day of the month, although for single digit days there are no leading zeros, only a blank space. The one or two digits beginning the numeric string are the month, but this time with no space taking the place of a zero for single digit months; the single digit just starts the string. So for example October first 1979 is represented in the format 10 11979 and July 21st 1980 is represented as 7211980.
7
BEGIN_HAUL_DATE
VARCHAR2(8 BYTE)
8
No
No
Active
Begin Haul date. The format is not quite straightforward. The last 4 digits are always the year, the two places preceding the year are the day of the month, although for single digit days there are no leading zeros, only a blank space. The one or two digits beginning the numeric string are the month, but this time with no space taking the place of a zero for single digit months; the single digit just starts the string. So for example October first 1979 is represented in the format 10 11979 and July 21st 1980 is represented as 7211980.
8
BS_HOUR
VARCHAR2(2 BYTE)
2
No
No
Active
Hour, in 24 hour format, of the beginning of the set.
9
ES_HOUR
VARCHAR2(2 BYTE)
2
No
No
Active
Hour, in 24 hour format, of the end of the set.
10
BH_HOUR
VARCHAR2(2 BYTE)
2
No
No
Active
Hour, in 24 hour format, of the beginning of the haul.
11
EH_HOUR
VARCHAR2(2 BYTE)
2
No
No
Active
Hour, in 24 hour format, of the end of the haul.
12
BS_LAT
VARCHAR2(4 BYTE)
4
No
No
Active
Latitude at the beginning of the set, in 4 digit format (first two are degrees, second two are whole minutes). A value of zero should be interpreted as a null.
13
BS_LON
VARCHAR2(4 BYTE)
4
No
No
Active
Longitude at the beginning of the set, in 4 digit format (first two are degrees, second two are whole minutes). A value of zero should be interpreted as a null.
14
ES_LAT
VARCHAR2(4 BYTE)
4
No
No
Active
Latitude at the end of the set, in 4 digit format (first two are degrees, second two are whole minutes). A value of zero should be interpreted as a null.
15
ES_LON
VARCHAR2(4 BYTE)
4
No
No
Active
Longitude at the end of the set, in 4 digit format (first two are degrees, second two are whole minutes). A value of zero should be interpreted as a null.
16
BH_LAT
VARCHAR2(4 BYTE)
4
No
No
Active
Latitude at the beginning of the haul, in 4 digit format (first two are degrees, second two are whole minutes). A value of zero should be interpreted as a null.
17
BH_LON
VARCHAR2(4 BYTE)
4
No
No
Active
Longitude at the beginning of the haul, in 4 digit format (first two are degrees, second two are whole minutes). A value of zero should be interpreted as a null.
18
EH_LAT
VARCHAR2(4 BYTE)
4
No
No
Active
Latitude at the end of the haul, in 4 digit format (first two are degrees, second two are whole minutes). A value of zero should be interpreted as a null.
19
EH_LON
VARCHAR2(4 BYTE)
4
No
No
Active
Longitude at the end of the haul, in 4 digit format (first two are degrees, second two are whole minutes). A value of zero should be interpreted as a null.
20
BS_TEMP
VARCHAR2(4 BYTE)
4
No
No
Active
Surface water temperature in degrees F at the beginning of the set
21
ES_TEMP
VARCHAR2(4 BYTE)
4
No
No
Active
Surface water temperature in degrees F at the end of the set
22
BH_TEMP
VARCHAR2(4 BYTE)
4
No
No
Active
Surface water temperature in degrees F at the beginning of the haul
23
EH_TEMP
VARCHAR2(4 BYTE)
4
No
No
Active
Surface water temperature in degrees F at the end of the haul
gov.noaa.nmfs.inport:27625
Larry Beerkircher
2015-09-30T12:50:48
SysAdmin InPortAdmin
2022-08-09T17:11:09
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