35888 EBSFD_FSCS_UNION Entity Published / External 26273 Enhanced Biological Sampling Data Data Set Completed Catch data joined in from SVDBS for individual fish sampled from NEFSC and MADMF trawl surveys, as well as some fish from Cooperative Research projects that have data stored on SVDBS. Catch data joined in from SVDBS.UNION_FSCS_SVSTA, and biological data from SVDBS.UNION_FSCS_SVBIO. Data are joined (using SURVEYID, STATIONNUMBER, FISHNUMBER from FLDRPILOT.FISH_ORGANISM and FLDRPILOT.SPECIES.SPECIES_ITIS) to SVDBS columns CRUISE6, STATION, INDID, ITISSPP (respectively). Data Table Yes Catch data joined in from SVDBS for individual fish sampled from NEFSC and MADMF trawl surveys, as well as some fish from Cooperative Research projects that have data stored on SVDBS. Catch data joined in from SVDBS.UNION_FSCS_SVSTA, and biological data from SVDBS.UNION_FSCS_SVBIO. Data are joined (using SURVEYID, STATIONNUMBER, FISHNUMBER from FLDRPILOT.FISH_ORGANISM and FLDRPILOT.SPECIES.SPECIES_ITIS) to SVDBS columns CRUISE6, STATION, INDID, ITISSPP (respectively). 1 FISH_ID_CODE VARCHAR2 20 No No Active Unique code for each sampled fish. Assigned and dependent on FISH_ORGANISM.FISH_ID_CODE VARCHAR2 2 CRUISE6 VARCHAR2 6 No No Active Code uniquely identifying cruise. The first four digits indicate the year and the last two digit uniquely identify the cruise within the year. The 5th byte signifies cruises other than groundfish: Shrimp survey = 7 (i.e. 201470), State of Massachusetts survey = 9 (i.e. 201491), Food habits = 5 (i.e.199554) VARCHAR2 3 STATION VARCHAR2 4 No No Active Unique sequential order in which stations have been completed. Hangups and short tows each receive a non-repeated consecutive number. VARCHAR2 4 ID VARCHAR2 18 No No Active Concatenation of Cruise, Stratum, Tow and Station values. VARCHAR2 5 STRATUM VARCHAR2 5 No No Active A predefined area where a net dredge, or other piece of gear was deployed. Code consists of 2 parts: Stratum group code number (2 bytes) and stratum number (3 bytes). Stratum group refers to if area fished is inshore or offshore North or South of Cape Hatteras or the type of cruise (shellfish, State of MA, offshore deepwater). The stratum number (third and fourth digits of code) refers to area defined by depth zone. See SVDBS.SVMSTRATA. The fifth digit of the code increases the length of the stratum number for revised strata after the Hague Line was established. Stratum group code: 01 = Trawl, offshore north of Hatteras; 02 = BIOM; 03 = Trawl, inshore north of Hatteras; 04 = Shrimp; 05 = Scotian shelf; 06 = Shellfish; 07 = Trawl, inshore south of Hatteras; 08 = Trawl, Offshore south of Hatteras; 09 = MA DMF; 99 = Offshore deepwater (outside the stratified area). A change in Bottom Trawl Stratum for the Gulf of Maine-Bay of Fundy has been in effect since Spring 1987, and may be summarized as follows: Previous strata: 01350; Present strata: 01351, 01352. VARCHAR2 6 AREA VARCHAR2 3 No No Active Standard area code used for commercial data (New England Statistical Area Code) for the position of the beginning of the tow. VARCHAR2 7 BEGIN_EST_TOWDATE DATE 7 No No Active Date and time represented by Eastern Standard Time (EST) for the start of a tow or deployment. DATE 8 END_EST_TOWDATE DATE 7 No No Active Date and time represented by Eastern Standard Time (EST) at the end of a tow or deployment. DATE 9 EST_YEAR VARCHAR2 40 No No Active Year, represented by Eastern Standard Time (EST). VARCHAR2 10 EST_MONTH VARCHAR2 40 No No Active Month, represented by Eastern Standard Time (EST). VARCHAR2 11 EST_DAY VARCHAR2 40 No No Active Day of the month represented by Eastern Standard Time (EST). VARCHAR2 12 EST_TIME VARCHAR2 32 No No Active Time, represented by Eastern Standard Time (EST). VARCHAR2 13 TOWDUR NUMBER 22 No No Active Duration of tow in minutes. NUMBER 14 AVGDEPTH NUMBER 22 No No 38 Active A four digit number recording the average depth, to the nearest meter, during a survey gear deployment. NUMBER 15 BEGLAT NUMBER 22 No No Active Beginning latitude of tow (decimal degrees). NUMBER 16 BEGLON NUMBER 22 No No 38 Active Beginning longitude of tow (decimal degrees). NUMBER 17 ENDLAT NUMBER 22 No No Active Latitude at end of tow. NUMBER 18 ENDLON NUMBER 22 No No 38 Active Longitude at end of tow. NUMBER 19 BOTTEMP NUMBER 22 No No Active Bottom temperature (degrees Celsius). NUMBER 20 STATION_COMMENTS VARCHAR2 500 No No Active Comment from the bridge officers. VARCHAR2 21 INDID NUMBER 22 No No Active A unique identifier for each fish sampled. NUMBER 22 AGE NUMBER 22 No No 38 Active Age of specimen in years. NUMBER 23 IND_FISH_COMMENTS VARCHAR2 500 No No Active Comment field for an individual fish or invertebrate sampled. VARCHAR2 24 SEX VARCHAR2 1 No No Active Code indicating sex of fish or invertebrate species. See SVDBS.FSCS_SEX_CODES if using fscs data and SVDBS.SEX_CODES if using non FSCS data. Codes 0, 1, 2 and 4 are the only valid codes in fscs tables. VARCHAR2 25 LENGTH NUMBER 22 No No Active Measured length of species in centimeters (cm). Measure method differs by species. NUMBER 26 MATURITY VARCHAR2 2 No No Active Stage of maturation of the fish being sampled. See SVDBS.FSCS_MATURITY_CODES VARCHAR2 gov.noaa.nmfs.inport:35888 Patricia Jones 2016-12-07T13:26:54 SysAdmin InPortAdmin 2022-08-09T17:11:17 2016-12-07 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-07 1 Year 2017-12-07