35952 LL_STATION Entity Published / External 27731 Gulf of Maine Cooperative Bottom Longline Survey Database Data Set Completed Table contains the operational and location data for each station Data Table Yes Table contains the operational and location data for each station 1 CRUISE NUMBER 22 No No 10 0 Active 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 NUMBER 2 STATION NUMBER 22 No No 5 0 Active Unique sequential order in which stations have been completed, unique to each cruise code. Failed gear deployments each receive a non-repeated consecutive number. NUMBER 3 STATION_ID VARCHAR2 10 No No Active 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. VARCHAR2 4 TRIP_ID NUMBER 22 No No 20 0 Active 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 NUMBER 5 EFFORT_NUM NUMBER 22 No No 5 0 Active Unique identifier for each fishing effort (gear deployment) within a trip, see FVTR.CRPP_VERS_TRIP NUMBER 6 STRATUM NUMBER 22 No No 5 0 Active 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. NUMBER 7 ASSIGNED_STRATUM NUMBER 22 No No 5 0 Active 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 NUMBER 8 BOTTOM_TYPE VARCHAR2 10 No No Active 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. VARCHAR2 9 AREA NUMBER 22 No No 5 0 Active Standard area code used for commercial data (New England Statistical Area Code) for the position of the beginning of the tow. NUMBER 10 BEGIN_SET_TIME DATE 7 No No Active Datetime (UTC) when the gear is first placed in the water at the start of the fishing effort DATE 11 END_SET_TIME DATE 7 No No Active Datetime (UTC) when setting of the gear has stopped and the gear begins to fish DATE 12 BEGIN_HAUL_TIME DATE 7 No No Active Datetime (UTC) when fishing stops and hauling the gear starts DATE 13 END_HAUL_TIME DATE 7 No No Active Datetime (UTC) when the gear has been completely hauled and is back aboard the vessel DATE 14 SOAK_DURATION_DH NUMBER 22 No No 7 4 Active Soak or haul duration of the fishing effort (h.hh), from END_SET_TIME until BEGIN_HAUL_TIME NUMBER 15 DECDEG_BEGLAT_SET NUMBER 22 No No 8 5 Active Latitude where the gear is first placed in the water at the start of the fishing effort (ddmm.mmmm) NUMBER 16 DECDEG_BEGLON_SET NUMBER 22 No No 8 5 Active Longitude where the gear is first placed in the water at the start of the fishing effort (dddmm.mmmm) NUMBER 17 DECDEG_ENDLAT_SET NUMBER 22 No No 8 5 Active Latitude where the setting of the gear has stopped and the gear begins to fish (ddmm.mmmm) NUMBER 18 DECDEG_ENDLON_SET NUMBER 22 No No 8 5 Active Longitude where the setting of the gear has stopped and the gear begins to fish (dddmm.mmmm) NUMBER 19 DECDEG_BEGLAT_HAUL NUMBER 22 No No 8 5 Active Latitude where fishing stops and hauling the gear starts (ddmm.mmmm) NUMBER 20 DECDEG_BEGLON_HAUL NUMBER 22 No No 8 5 Active Longitude where fishing stops and hauling the gear starts (dddmm.mmmm) NUMBER 21 DECDEG_ENDLAT_HAUL NUMBER 22 No No 8 5 Active Latitude where the gear has been completely hauled and is back aboard the vessel (ddmm.mmmm) NUMBER 22 DECDEG_ENDLON_HAUL NUMBER 22 No No 8 5 Active Longitude where the gear has been completely hauled and is back aboard the vessel (dddmm.mmmm) NUMBER 23 STATION_TYPE NUMBER 22 No No 1 Active Survey station type. See LL_STA_EVAL_CODES for values. Value = 1 is the recommended threshold for valid standard survey sets NUMBER 24 STATION_ASSIGNMENT NUMBER 22 No No 1 Active Source for the station assignment. See LL_STA_EVAL_CODES for values. Any value is considered acceptable for valid standard survey sets NUMBER 25 GEAR_EVALUATION NUMBER 22 No No 1 Active 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 NUMBER 26 GEAR_DAMAGE NUMBER 22 No No 1 Active 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 NUMBER 27 GEAR_INTERACTION NUMBER 22 No No 1 Active 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 NUMBER 28 INTERACTION_TYPE NUMBER 22 No No 1 Active Category for the gear or object with which the survey interacted. See LL_STA_EVAL_CODES for values. NUMBER 29 ENVIRONMENTAL_CONDITONS NUMBER 22 No No 1 Active 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 NUMBER 30 DATA_ACQUISITION NUMBER 22 No No 1 Active 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 NUMBER 31 SET_NOTES VARCHAR2 300 No No Active Comments field for notes related to the deployment of the gear VARCHAR2 32 HAUL_NOTES VARCHAR2 300 No No Active Comments field for notes related to the hauling of the gear VARCHAR2 33 CATCH_NOTES VARCHAR2 300 No No Active Comments field for notes related to the catch VARCHAR2 34 BOTTOM_VIDEO NUMBER 22 No No 1 Active Binary indicator of whether a drop camera video was taken at the station: 1 = usable video footage obtained, 0 = no usable video footage obtained NUMBER 35 WINDDIR VARCHAR2 3 No No Active Direction of wind during deployment of gear (degrees). VARCHAR2 36 WINDSP NUMBER 22 No No 3 0 Active Speed of wind in knots. NUMBER 37 WAVEHGT NUMBER 22 No No 3 0 Active Height of waves (m). NUMBER 38 SWELLHGT NUMBER 22 No No 3 0 Active Swell height (m). NUMBER 39 VESSEL_NAME VARCHAR2 50 No No Active Name of vessel. VARCHAR2 40 CURRENT_INSTR_ID1 VARCHAR2 14 No No Active Identification code for the current instrument attached to the first end of the longline gear deployed 41 CURRENT_INSTR_ID2 VARCHAR2 14 No No Active Identification code for the current instrument attached to the first end of the longline gear deployed gov.noaa.nmfs.inport:35952 Patricia Jones 2016-12-13T16:38:06 SysAdmin InPortAdmin 2022-08-09T17:11:16 2016-12-13 Northeast Fisheries Science Center NEFSC 166 Water Street Woods Hole MA 02543-1026 USA (508)495-2000 https://www.nefsc.noaa.gov 8:00 a.m. to 4:30 p.m. Monday - Friday 1001 Public No 2016-12-13 1 Year 2017-12-13