33828 UNION_FSCS_SVBIO Entity Published / External 27384 Cooperative Research Paired Trawl Sweep Comparison Study Data Set Completed Materialized view joining pre-FSCS and FSCS data sets into one structure. Contains individual fish and invertebrate data. Loaded by batch 9100, 07-29-2016 12:08 Data Table Yes SVDBS Materialized view joining pre-FSCS and FSCS data sets into one structure. Contains individual fish and invertebrate data. 1 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 2 CRUISE VARCHAR2 6 No No Active Unique numerical code for a cruise. VARCHAR2 3 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 4 TOW VARCHAR2 3 No No Active Sequential number representing order in which station was selected within a stratum. VARCHAR2 5 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 6 STATUS_CODE VARCHAR2 2 No No Active Code referencing whether or not a cruise is available in the SVDBS system. See SVDBS.SVCRUISE_STATUS. VARCHAR2 7 ID VARCHAR2 18 No No Active Concatenation of Cruise6, Stratum, Tow and Station values. VARCHAR2 8 SVSPP VARCHAR2 3 No No Active A standard code which represents a species caught in a trawl or dredge. Refer to the SVDBS.SVSPECIES_LIST VARCHAR2 9 CATCHSEX VARCHAR2 1 No No Active Code used to identify species that are sexed at the catch level. See SVDBS.SEX_CODES VARCHAR2 10 INDID NUMBER 22 No No 6 0 Active A unique identifier for each fish sampled. NUMBER 11 LENGTH NUMBER 22 No No 5 2 Active Measured length of species in centimeters (cm). Measure method differs by species. NUMBER 12 INDWT NUMBER 22 No No 7 3 Active Individual weight (KG) of species being sampled. NUMBER 13 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 14 MATURITY VARCHAR2 2 No No Active Stage of maturation of the fish being sampled. See SVDBS.FSCS_MATURITY_CODES VARCHAR2 15 AGE NUMBER 22 No No 2 0 Active Age of specimen in years. NUMBER 16 AGE_DATA_FLAG VARCHAR2 1 No No Active Code to indicate whether or not an age sample was taken. Valuess: Y = Yes, sample taken; NULL = no age sample taken. VARCHAR2 17 STOM_VOLUME NUMBER 22 No No 5 1 Active Volume of the stomach contents of the fish sampled, measured to the nearest tenth of a cubic centimeter (cc). NUMBER 18 STOM_WGT NUMBER 22 No No 8 3 Active Stomach weight of an individual fish in grams. NUMBER 21 IND_FISH_COMMENTS VARCHAR2 500 No No Active Comment field for an indiviual fish or invertebrate sampled. VARCHAR2 gov.noaa.nmfs.inport:33828 Patricia Jones 2016-07-29T12:08:33 Paul Kostovick 2023-01-25T19:14:43 2019-05-31 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 2019-05-31 1 Year 2020-05-31