Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: LL_STATION
Short Name: LL_STATION
Status: Completed
Abstract:

Table contains the operational and location data for each station

Entity Information

Entity Type: Data Table
Active Version?: Yes
Description:

Table contains the operational and location data for each station

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
CRUISE NUMBER Unique numerical code for each cruise. Specific to a vessel and season. Five digits, where first 2 digits indicate vessel, next 2 year, last digit season. For example 24142 = Tenacious II 2014 fall survey or 25151 = Mary Elizabeth 2015 spring survey. If last digit = 3 it is an experimental survey trip
100
STATION NUMBER Unique sequential order in which stations have been completed, unique to each cruise code. Failed gear deployments each receive a non-repeated consecutive number.
100
STATION_ID VARCHAR2 A predefined identifier generated during the random station assignment indicating the area where a piece of fishing gear is to be deployed. (Strata coding modified from the SVDBS definition, see SVDBS.UNION_FSCS_SVSTA.STRATUM) Code consists of 3 parts: Stratum number (2bytes) and bottom stratum type (1 bytes). Stratum number refers to strata from the SVDBS offshore stratum group with the numbers defined by depth zone. The third byte refers to the longline survey bottom strata type; 1 = smooth bottom; 0 = rough bottom. The fifth byte (following a dash as the fourth byte) is the number assigned based on the random sequential order drawn within each stratum and bottom type. For example: 270-5 would be the fifth random rough-bottom station drawn in strata 27; 361-1 would be the first random smooth-bottom station drawn in strata 36.
100
TRIP_ID NUMBER Unique trip identifier generated in FLDRS software. Generated to identify each fishing trip from port. Fishing operation data collected using the FLDRS software and initially loaded into FVTR tables, before being migrated to this schema. See FVTR.CRPP_VERS_TRIP
100
EFFORT_NUM NUMBER Unique identifier for each fishing effort (gear deployment) within a trip, see FVTR.CRPP_VERS_TRIP
100
STRATUM NUMBER A predefined area where the longline gear was deployed. Stratum is a two digit number referring to the stratum number from the SVDBS stratum definition, see SVDBS.UNION_FSCS_SVSTA.STRATUM. All longline strata are taken from the SVDBS offshore stratum group. May be null or differ from ASSIGNED_STRATUM, if more than 50% of the gear was deployed over the boundary into an adjoining stratum.
100
ASSIGNED_STRATUM NUMBER The predefined area where the longline gear was assigned to be deployed. Stratum is a two digit number referring to the stratum number from the SVDBS stratum definition, see SVDBS.UNION_FSCS_SVSTA.STRATUM. All longline strata are taken from the SVDBS offshore stratum group. ASSIGNED STRATUM will match the first two bytes of the STATION_ID code
100
BOTTOM_TYPE VARCHAR2 A bottom type substratification specific to the longline survey. Rough bottom strata were defined as areas above the 70th percentile for Terrain Rugged Index values (Hare at al. 2012) within each stratum. Regions below the 70th percentile cut point were assigned to the smooth-bottom sub-stratum.
100
AREA NUMBER Standard area code used for commercial data (New England Statistical Area Code) for the position of the beginning of the tow.
100
BEGIN_SET_TIME DATE Datetime (UTC) when the gear is first placed in the water at the start of the fishing effort
100
END_SET_TIME DATE Datetime (UTC) when setting of the gear has stopped and the gear begins to fish
100
BEGIN_HAUL_TIME DATE Datetime (UTC) when fishing stops and hauling the gear starts
100
END_HAUL_TIME DATE Datetime (UTC) when the gear has been completely hauled and is back aboard the vessel
100
SOAK_DURATION_DH NUMBER Soak or haul duration of the fishing effort (h.hh), from END_SET_TIME until BEGIN_HAUL_TIME
100
DECDEG_BEGLAT_SET NUMBER Latitude where the gear is first placed in the water at the start of the fishing effort (ddmm.mmmm)
100
DECDEG_BEGLON_SET NUMBER Longitude where the gear is first placed in the water at the start of the fishing effort (dddmm.mmmm)
100
DECDEG_ENDLAT_SET NUMBER Latitude where the setting of the gear has stopped and the gear begins to fish (ddmm.mmmm)
100
DECDEG_ENDLON_SET NUMBER Longitude where the setting of the gear has stopped and the gear begins to fish (dddmm.mmmm)
100
DECDEG_BEGLAT_HAUL NUMBER Latitude where fishing stops and hauling the gear starts (ddmm.mmmm)
100
DECDEG_BEGLON_HAUL NUMBER Longitude where fishing stops and hauling the gear starts (dddmm.mmmm)
100
DECDEG_ENDLAT_HAUL NUMBER Latitude where the gear has been completely hauled and is back aboard the vessel (ddmm.mmmm)
100
DECDEG_ENDLON_HAUL NUMBER Longitude where the gear has been completely hauled and is back aboard the vessel (dddmm.mmmm)
100
STATION_TYPE NUMBER Survey station type. See LL_STA_EVAL_CODES for values. Value = 1 is the recommended threshold for valid standard survey sets
100
STATION_ASSIGNMENT NUMBER Source for the station assignment. See LL_STA_EVAL_CODES for values. Any value is considered acceptable for valid standard survey sets
100
GEAR_EVALUATION NUMBER Evaluation of the condition of the longline gear made at the end of gear hauling. Most commonly tangled sections of mainline, buoy line, and hooks. Tangles could have occurred during gear setting, hauling, or while on bottom. Captured fish could have contributed to the tangle. Tangles observed at haul back do not inherently indicate a reduced fishing capacity. See LL_STA_EVAL_CODES for values. A value < 4 is the recommended threshold for valid standard survey sets
100
GEAR_DAMAGE NUMBER Mainline parted during hauling, once or multiple times. In most cases this will not impact fishing capacity, unless there is a loss of some gear, but may increase haul time. See LL_STA_EVAL_CODES for values. A value < 5 is the recommended threshold for valid standard survey sets
100
GEAR_INTERACTION NUMBER Any interactions of the survey gear with other fishing gear or other human objects. See LL_STA_EVAL_CODES for values. A value < 4 is the recommended threshold for valid standard survey sets
100
INTERACTION_TYPE NUMBER Category for the gear or object with which the survey interacted. See LL_STA_EVAL_CODES for values.
100
ENVIRONMENTAL_CONDITONS NUMBER Any conditions or situations related to environmental conditions or biota that might have impacted the survey gear and its capacity to fish consistently. See LL_STA_EVAL_CODES for values. A value < 4 is the recommended threshold for valid standard survey sets
100
DATA_ACQUISITION NUMBER Equipment, computer, or other data collection problems that might have contributed to the amount or quality of the data collected. See LL_STA_EVAL_CODES for values. A value < 4 is the recommended threshold for valid standard survey sets
100
SET_NOTES VARCHAR2 Comments field for notes related to the deployment of the gear
100
HAUL_NOTES VARCHAR2 Comments field for notes related to the hauling of the gear
100
CATCH_NOTES VARCHAR2 Comments field for notes related to the catch
100
BOTTOM_VIDEO NUMBER Binary indicator of whether a drop camera video was taken at the station: 1 = usable video footage obtained, 0 = no usable video footage obtained
100
WINDDIR VARCHAR2 Direction of wind during deployment of gear (degrees).
100
WINDSP NUMBER Speed of wind in knots.
100
WAVEHGT NUMBER Height of waves (m).
100
SWELLHGT NUMBER Swell height (m).
100
VESSEL_NAME VARCHAR2 Name of vessel.
100
CURRENT_INSTR_ID1 VARCHAR2 Identification code for the current instrument attached to the first end of the longline gear deployed
100
CURRENT_INSTR_ID2 VARCHAR2 Identification code for the current instrument attached to the first end of the longline gear deployed

Attribute Details

CRUISE

CC ID: 363172
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Unique numerical code for each cruise. Specific to a vessel and season. Five digits, where first 2 digits indicate vessel, next 2 year, last digit season. For example 24142 = Tenacious II 2014 fall survey or 25151 = Mary Elizabeth 2015 spring survey. If last digit = 3 it is an experimental survey trip

General Data Type: NUMBER

STATION

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

Unique sequential order in which stations have been completed, unique to each cruise code. Failed gear deployments each receive a non-repeated consecutive number.

General Data Type: NUMBER

STATION_ID

CC ID: 363174
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

A predefined identifier generated during the random station assignment indicating the area where a piece of fishing gear is to be deployed. (Strata coding modified from the SVDBS definition, see SVDBS.UNION_FSCS_SVSTA.STRATUM) Code consists of 3 parts: Stratum number (2bytes) and bottom stratum type (1 bytes). Stratum number refers to strata from the SVDBS offshore stratum group with the numbers defined by depth zone. The third byte refers to the longline survey bottom strata type; 1 = smooth bottom; 0 = rough bottom. The fifth byte (following a dash as the fourth byte) is the number assigned based on the random sequential order drawn within each stratum and bottom type. For example: 270-5 would be the fifth random rough-bottom station drawn in strata 27; 361-1 would be the first random smooth-bottom station drawn in strata 36.

General Data Type: VARCHAR2

TRIP_ID

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

Unique trip identifier generated in FLDRS software. Generated to identify each fishing trip from port. Fishing operation data collected using the FLDRS software and initially loaded into FVTR tables, before being migrated to this schema. See FVTR.CRPP_VERS_TRIP

General Data Type: NUMBER

EFFORT_NUM

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

Unique identifier for each fishing effort (gear deployment) within a trip, see FVTR.CRPP_VERS_TRIP

General Data Type: NUMBER

STRATUM

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

A predefined area where the longline gear was deployed. Stratum is a two digit number referring to the stratum number from the SVDBS stratum definition, see SVDBS.UNION_FSCS_SVSTA.STRATUM. All longline strata are taken from the SVDBS offshore stratum group. May be null or differ from ASSIGNED_STRATUM, if more than 50% of the gear was deployed over the boundary into an adjoining stratum.

General Data Type: NUMBER

ASSIGNED_STRATUM

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

The predefined area where the longline gear was assigned to be deployed. Stratum is a two digit number referring to the stratum number from the SVDBS stratum definition, see SVDBS.UNION_FSCS_SVSTA.STRATUM. All longline strata are taken from the SVDBS offshore stratum group. ASSIGNED STRATUM will match the first two bytes of the STATION_ID code

General Data Type: NUMBER

BOTTOM_TYPE

CC ID: 363179
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

A bottom type substratification specific to the longline survey. Rough bottom strata were defined as areas above the 70th percentile for Terrain Rugged Index values (Hare at al. 2012) within each stratum. Regions below the 70th percentile cut point were assigned to the smooth-bottom sub-stratum.

General Data Type: VARCHAR2

AREA

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

Standard area code used for commercial data (New England Statistical Area Code) for the position of the beginning of the tow.

General Data Type: NUMBER

BEGIN_SET_TIME

CC ID: 363181
Seq. Order: 10
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Datetime (UTC) when the gear is first placed in the water at the start of the fishing effort

General Data Type: DATE

END_SET_TIME

CC ID: 363182
Seq. Order: 11
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Datetime (UTC) when setting of the gear has stopped and the gear begins to fish

General Data Type: DATE

BEGIN_HAUL_TIME

CC ID: 363183
Seq. Order: 12
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Datetime (UTC) when fishing stops and hauling the gear starts

General Data Type: DATE

END_HAUL_TIME

CC ID: 363184
Seq. Order: 13
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Datetime (UTC) when the gear has been completely hauled and is back aboard the vessel

General Data Type: DATE

SOAK_DURATION_DH

CC ID: 363185
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 7
Scale: 4
Status: Active
Description:

Soak or haul duration of the fishing effort (h.hh), from END_SET_TIME until BEGIN_HAUL_TIME

General Data Type: NUMBER

DECDEG_BEGLAT_SET

CC ID: 363186
Seq. Order: 15
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 8
Scale: 5
Status: Active
Description:

Latitude where the gear is first placed in the water at the start of the fishing effort (ddmm.mmmm)

General Data Type: NUMBER

DECDEG_BEGLON_SET

CC ID: 363187
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 8
Scale: 5
Status: Active
Description:

Longitude where the gear is first placed in the water at the start of the fishing effort (dddmm.mmmm)

General Data Type: NUMBER

DECDEG_ENDLAT_SET

CC ID: 363188
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 8
Scale: 5
Status: Active
Description:

Latitude where the setting of the gear has stopped and the gear begins to fish (ddmm.mmmm)

General Data Type: NUMBER

DECDEG_ENDLON_SET

CC ID: 363189
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 8
Scale: 5
Status: Active
Description:

Longitude where the setting of the gear has stopped and the gear begins to fish (dddmm.mmmm)

General Data Type: NUMBER

DECDEG_BEGLAT_HAUL

CC ID: 363190
Seq. Order: 19
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 8
Scale: 5
Status: Active
Description:

Latitude where fishing stops and hauling the gear starts (ddmm.mmmm)

General Data Type: NUMBER

DECDEG_BEGLON_HAUL

CC ID: 363191
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 8
Scale: 5
Status: Active
Description:

Longitude where fishing stops and hauling the gear starts (dddmm.mmmm)

General Data Type: NUMBER

DECDEG_ENDLAT_HAUL

CC ID: 363192
Seq. Order: 21
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 8
Scale: 5
Status: Active
Description:

Latitude where the gear has been completely hauled and is back aboard the vessel (ddmm.mmmm)

General Data Type: NUMBER

DECDEG_ENDLON_HAUL

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

Longitude where the gear has been completely hauled and is back aboard the vessel (dddmm.mmmm)

General Data Type: NUMBER

STATION_TYPE

CC ID: 363194
Seq. Order: 23
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Status: Active
Description:

Survey station type. See LL_STA_EVAL_CODES for values. Value = 1 is the recommended threshold for valid standard survey sets

General Data Type: NUMBER

STATION_ASSIGNMENT

CC ID: 363195
Seq. Order: 24
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Status: Active
Description:

Source for the station assignment. See LL_STA_EVAL_CODES for values. Any value is considered acceptable for valid standard survey sets

General Data Type: NUMBER

GEAR_EVALUATION

CC ID: 363196
Seq. Order: 25
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Status: Active
Description:

Evaluation of the condition of the longline gear made at the end of gear hauling. Most commonly tangled sections of mainline, buoy line, and hooks. Tangles could have occurred during gear setting, hauling, or while on bottom. Captured fish could have contributed to the tangle. Tangles observed at haul back do not inherently indicate a reduced fishing capacity. See LL_STA_EVAL_CODES for values. A value < 4 is the recommended threshold for valid standard survey sets

General Data Type: NUMBER

GEAR_DAMAGE

CC ID: 363197
Seq. Order: 26
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Status: Active
Description:

Mainline parted during hauling, once or multiple times. In most cases this will not impact fishing capacity, unless there is a loss of some gear, but may increase haul time. See LL_STA_EVAL_CODES for values. A value < 5 is the recommended threshold for valid standard survey sets

General Data Type: NUMBER

GEAR_INTERACTION

CC ID: 363198
Seq. Order: 27
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Status: Active
Description:

Any interactions of the survey gear with other fishing gear or other human objects. See LL_STA_EVAL_CODES for values. A value < 4 is the recommended threshold for valid standard survey sets

General Data Type: NUMBER

INTERACTION_TYPE

CC ID: 363199
Seq. Order: 28
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Status: Active
Description:

Category for the gear or object with which the survey interacted. See LL_STA_EVAL_CODES for values.

General Data Type: NUMBER

ENVIRONMENTAL_CONDITONS

CC ID: 363200
Seq. Order: 29
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Status: Active
Description:

Any conditions or situations related to environmental conditions or biota that might have impacted the survey gear and its capacity to fish consistently. See LL_STA_EVAL_CODES for values. A value < 4 is the recommended threshold for valid standard survey sets

General Data Type: NUMBER

DATA_ACQUISITION

CC ID: 363201
Seq. Order: 30
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Status: Active
Description:

Equipment, computer, or other data collection problems that might have contributed to the amount or quality of the data collected. See LL_STA_EVAL_CODES for values. A value < 4 is the recommended threshold for valid standard survey sets

General Data Type: NUMBER

SET_NOTES

CC ID: 363202
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 300
Required: No
Primary Key: No
Status: Active
Description:

Comments field for notes related to the deployment of the gear

General Data Type: VARCHAR2

HAUL_NOTES

CC ID: 363203
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 300
Required: No
Primary Key: No
Status: Active
Description:

Comments field for notes related to the hauling of the gear

General Data Type: VARCHAR2

CATCH_NOTES

CC ID: 363204
Seq. Order: 33
Data Storage Type: VARCHAR2
Max Length: 300
Required: No
Primary Key: No
Status: Active
Description:

Comments field for notes related to the catch

General Data Type: VARCHAR2

BOTTOM_VIDEO

CC ID: 363205
Seq. Order: 34
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Status: Active
Description:

Binary indicator of whether a drop camera video was taken at the station: 1 = usable video footage obtained, 0 = no usable video footage obtained

General Data Type: NUMBER

WINDDIR

CC ID: 363206
Seq. Order: 35
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Direction of wind during deployment of gear (degrees).

General Data Type: VARCHAR2

WINDSP

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

Speed of wind in knots.

General Data Type: NUMBER

WAVEHGT

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

Height of waves (m).

General Data Type: NUMBER

SWELLHGT

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

Swell height (m).

General Data Type: NUMBER

VESSEL_NAME

CC ID: 363210
Seq. Order: 39
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Name of vessel.

General Data Type: VARCHAR2

CURRENT_INSTR_ID1

CC ID: 712317
Seq. Order: 40
Data Storage Type: VARCHAR2
Max Length: 14
Required: No
Primary Key: No
Status: Active
Description:

Identification code for the current instrument attached to the first end of the longline gear deployed

CURRENT_INSTR_ID2

CC ID: 712318
Seq. Order: 41
Data Storage Type: VARCHAR2
Max Length: 14
Required: No
Primary Key: No
Status: Active
Description:

Identification code for the current instrument attached to the first end of the longline gear deployed

Catalog Details

Catalog Item ID: 35952
GUID: gov.noaa.nmfs.inport:35952
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-12-13 16:38+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-12-13
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-12-13
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-12-13