22560 Fall Bottom Trawl Survey Data Set Published / External 22557 Bottom Trawl Surveys Project Completed The standardized NEFSC Fall Bottom Trawl Survey was initiated in 1963 and covered an area from Hudson Canyon, NY to Nova Scotia, Canada. Throughout the years, coverage has extended as far south as Florida and sampling depths have ranged from <27 to 366 m. Currently, the survey coverage is from Cape Hatteras, NC to Nova Scotia and the minimum depth range is > 18 m as the result of a change in the sampling platform. This has resulted in the exclusion of many inshore strata. The purpose of the Fall Bottom Trawl Survey is to determine the seasonal distribution, relative abundance, and biodiversity of fish and invertebrate species found on the continental shelf during the fall months, typically September to November. Other cruise objectives are: to collect biological samples for age determinations and growth sutidies, fecundity, maturity, and feeding ecology; opportunistically test trawl gear, methods, or survey-related equipment that may benefit the trawl survey in the future; collect oceanographic data, inclduing CTD casts as well as samples of ichthyoplankton and zooplankton for relative abundance and distribution studies; and to collect hydroacoustic data between stations. Fishery scientists use the data to assess 45 stocks of commercial and recreational fish and invertebrate species in the northeastern United States. Theme NMFS Data Category age & growth Theme NMFS Data Category biological measures Theme NMFS Data Category fishery-independent survey Theme NMFS Data Category genotype/species identification Theme NMFS Data Category maturity data Theme NMFS Data Category physical measures Theme NMFS Data Category population surveys Theme FRV Albatross IV Theme FRV Delaware II Theme FRV Henry B. Bigelow Theme RV Atlantic Twin Theme age sampling Theme biological sampling Theme bottom trawl Theme distribution Theme feeding ecology Theme groundfish Theme hydroacoustics Theme ichthyoplantkon Theme invertebrates Theme oceanographic Theme relative abundance Theme seasonal distribution Theme size composition Theme standardized Theme stratified random sampling Theme survey Theme zooplankton Temporal continous Temporal fall Spatial Cape Hatteras Spatial Continental Shelf Spatial Georges Bank Spatial Gulf of Maine Spatial Mid-Atlantic Bight Spatial northwest Atlantic Spatial southern New England Stratum benthic Stratum demersal Stratum pelagic Northeast Fisheries Science Center Woods Hole MA USA Data Set Oracle Database, CSV file As Needed The time series for the Fall Bottom Trawl Survey began in 1963 with data collection and quality assurance occurring with both paper and digital methods throughout the time series. Data consumers occasionally find questionable data from earlier paper collected data that requires verification via the original paper log. The frequency for such verification is minimal. Table (digital) The provided Fall Bottom Trawl Survey time series from 1963 - most recently audited data set contain standard audited raw survey results without adjustments for changes in gear and/or vessel over the length of the time series. All "good" tows are included in these data sets. Additional non-representative tows are available upon request only. All inquiries for obtaining calibration information for vessel and gear changes should be addressed to the Chief of the Population Dynamics Branch or Chief of the Resource Evaluation and Assessment Division of the Northeast Fisheries Science Center (NEFSC). The provided data sets contain the following information: Station Data - Vessel-related information (e.g., cruise ID, location, speed, course, etc.) and surface and bottom sea water temperature and salinity Aggregate Species Data - Tow-by-tow total weight and number of each species. Species Length Frequencies - Summarized number of fish measured at each length interval Individual Fish Data - Additional parameters collected from individual fish (other than length): sex, individual weight, gonad stage, age, and overall volume of stomach contents. NOAA/NEFSC/FEMAD/ESB 31173 CLOUD Published / External Completed Support table describing cloud cover. Loaded by batch 8334, 03-14-2016 13:01 Data Table Yes SVDBS Support table describing cloud cover. 1 CLOUD NUMBER 22 No No 2 0 Active Code to represent percentage of cloud cover. See SVDBS.CLOUD NUMBER 2 PCTCLEAR NUMBER 22 No No 3 0 Active Cloud cover as a percentage. See SVDBS.CLOUD NUMBER 3 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (MM/DD/YY HH:MI:SS). DATE 4 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (MM/DD/YY HH:MI:SS) DATE 5 UOE VARCHAR2 8 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 6 UOC VARCHAR2 8 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 31178 MATURITY_CODES Published / External Completed Historical support table containing acceptable maturity codes and their description. FSCS_MATURITY_CODES replaces this table. Loaded by batch 8334, 03-14-2016 13:01 Data Table Yes SVDBS Historical support table containing acceptable maturity codes and their description. FSCS_MATURITY_CODES replaces this table. 1 MATURITY CHAR 1 No No Active Stage of maturation of the fish being sampled. See SVDBS.FSCS_MATURITY_CODES CHAR 2 MATURITY_DESCRIPTION VARCHAR2 65 No No Active Description of maturity codes. VARCHAR2 31179 SEX_CODES Published / External Completed Historical support table containing acceptable codes and descriptions for the field sex. Loaded by batch 8334, 03-14-2016 13:01 Data Table Yes SVDBS Historical support table containing acceptable codes and descriptions for the field sex. 1 SEX NUMBER 22 No No 1 0 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. NUMBER 2 SEX_DESCRIPTION VARCHAR2 255 No No Active Description of the sex code field. Only 0, 1, 2 are valid entries for fscs tables. 0=Unsexed, unknown, or sex not observed; Since the summer 1995 Gulf of Maine Trawl Survey forgot to look for American Lobster; 1=Male; 2=Female; Female Stage I for Northern Shrimp; Since the summer 1995 Gulf of Maine Trawl Survey Female (no eggs, no notch) for American Lobster; 3=Female Stage II for Northern Shrimp; Since the summer 1995 Gulf of Maine Trawl Survey Female, with eggs, no notch for American Lobster; 4=Transitional for Northern Shrimp; Since the summer 1995 Gulf of Maine Trawl Survey Female, with notch, no eggs for American Lobster; 5=Ovigerous for Northern Shrimp; Since the summer 1995 Gulf of Maine Trawl Survey Female, with notch and eggs for American Lobster;6=Non-spawning Female for Northern Shrimp; 7=Female for Northern Shrimp not staged (stage I or II not determined) VARCHAR2 31183 SVGEAR Published / External Completed Support table containing gear codes and descriptions for the field SVGEAR of the table SVSTA_BASE. Loaded by batch 8334, 03-14-2016 13:01 Data Table Yes SVDBS Support table containing gear codes and descriptions for the field SVGEAR of the table SVSTA_BASE. 1 SVGEAR VARCHAR2 2 Yes Yes Active Code referencing predominant gear type used on a cruise. See SVDBS.SVGEAR table. VARCHAR2 2 GEAR_DEFINITION VARCHAR2 300 No No Active Type and description of gear. VARCHAR2 3 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (MM/DD/YY HH:MI:SS). DATE 4 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (MM/DD/YY HH:MI:SS) DATE 5 UOE VARCHAR2 8 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 6 UOC VARCHAR2 8 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 31189 WEATHER Published / External Completed Support table containing codes and descriptions used in the WEATHER field of the SVSTA_BASE table. Loaded by batch 8334, 03-14-2016 13:01 Data Table Yes SVDBS Support table containing codes and descriptions used in the WEATHER field of the SVSTA_BASE table. 1 WEATHER VARCHAR2 2 Yes Yes Active Code reflecting weather condition. See SVDBS.WEATHER table VARCHAR2 2 WEATHER_DEF VARCHAR2 65 No No Active Description of weather code. See SVDBS.WEATHER table VARCHAR2 3 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (MM/DD/YY HH:MI:SS). DATE 4 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (MM/DD/YY HH:MI:SS) DATE 5 UOE VARCHAR2 8 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 6 UOC VARCHAR2 8 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 31190 XBT Published / External Completed Historical support table containing codes and descriptions for the field XBT of the table SVSTA_BASE. Loaded by batch 8334, 03-14-2016 13:01 Data Table Yes SVDBS Historical support table containing codes and descriptions for the field XBT of the table SVSTA_BASE. 1 XBT VARCHAR2 1 Yes Yes Active Code associated with expendable bathythermograph (temperature/depth profile instrument). See SVDBS.XBT VARCHAR2 2 XBT_DEF VARCHAR2 65 No No Active Definition of XBT codes. See SVDBS.XBT VARCHAR2 3 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (MM/DD/YY HH:MI:SS). DATE 4 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (MM/DD/YY HH:MI:SS) DATE 5 UOE VARCHAR2 8 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 6 UOC VARCHAR2 8 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 33598 SVMSTRATA Published / External Completed Historical support table containing all acceptable stratum codes. Loaded by batch 9070, 07-28-2016 11:11 Data Table Yes SVDBS Historical support table containing all acceptable stratum codes. 1 STRGRP_DESC VARCHAR2 30 No No Active Description of stratum group. VARCHAR2 2 STRATUM VARCHAR2 5 Yes Yes 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 3 STRATUM_NAME VARCHAR2 30 No No Active Name of stratum area. VARCHAR2 4 STRATUM_AREA NUMBER 22 No No 6 0 Active Stratum area measured in square nautical miles. NUMBER 5 MIDLAT NUMBER 22 No No 6 2 Active Middle latitude in stratum for auditing purposes. NUMBER 6 MIDLON NUMBER 22 No No 6 2 Active Middle longitude in stratum for auditing purposes. NUMBER 7 MINLAT NUMBER 22 No No 6 2 Active Minimum latitude in stratum for auditing purposes. NUMBER 8 MAXLAT NUMBER 22 No No 6 2 Active Maximum latitude in stratum for auditing purposes. NUMBER 9 MINLON NUMBER 22 No No 6 2 Active Minimum longitude in stratum for auditing purposes. NUMBER 10 MAXLON NUMBER 22 No No 6 2 Active Maximum longitude in stratum for auditing purposes. NUMBER 11 BLOCKS NUMBER 22 No No 4 0 Active Statistical area blocks. NUMBER 12 NOTOWS NUMBER 22 No No 2 0 Active Number of tows for a given stratum. NUMBER 13 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (MM/DD/YY HH:MI:SS). DATE 14 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (MM/DD/YY HH:MI:SS) DATE 15 UOE VARCHAR2 8 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 16 UOC VARCHAR2 8 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 33599 SVVESSEL Published / External Completed Support table identifying all vessel codes and descriptions. Loaded by batch 9070, 07-28-2016 11:11 Data Table Yes SVDBS Support table identifying all vessel codes and descriptions. 1 VESSEL_NAME VARCHAR2 20 No No Active Name of vessel. VARCHAR2 2 VESSEL_ABBREV VARCHAR2 4 Yes Yes Active Vessel abbreviation. See SVDBS.SV_VESSEL VARCHAR2 3 COUNTRY_OF_ORIGIN VARCHAR2 20 No No Active Country of origin of vessel. VARCHAR2 4 HOME_PORT VARCHAR2 20 No No Active City where vessel maintains its home port. VARCHAR2 5 AGENCY_NAME VARCHAR2 20 No No Active Name of state or federal agency that utilizes the vessel. VARCHAR2 6 LENGTH_OVERALL_FT NUMBER 22 No No 38 0 Active Overall length of vessel measured to nearest foot. NUMBER 7 CONSTRUCTION VARCHAR2 20 No No Active Construction material of vessel. VARCHAR2 8 YEAR_BUILT VARCHAR2 4 No No Active Year vessel was built. VARCHAR2 33600 UNION_FSCS_SVBIO Published / External Completed Materialized view joining pre-FSCS and FSCS data sets into one structure. Contains individual fish and invertebrate data. Loaded by batch 9070, 07-28-2016 11:11 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 33601 UNION_FSCS_SVCAT Published / External Completed Materialized view joining pre-FSCS and FSCS data sets into one structure. Contains total number and weight of all species caught at a station. Loaded by batch 9070, 07-28-2016 11:11 Data Table Yes SVDBS Materialized view joining pre-FSCS and FSCS data sets into one structure. Contains total number and weight of all species caught at a station. 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 EXPCATCHNUM NUMBER 22 No No 8 0 Active Expanded number of individuals of a species caught at a given station. NUMBER 11 EXPCATCHWT NUMBER 22 No No 9 3 Active Expanded catch weight of all individuals captures of a given species measured to the nearest thousanth of a kilogram. NUMBER kg 12 LOGGED_SPECIES_NAME VARCHAR2 45 No No Active Name of the species, either common, scientific or both. VARCHAR2 13 CATCH_COMMENT VARCHAR2 500 No No Active Comments concerning a species at the catch level. VARCHAR2 33602 UNION_FSCS_SVLEN Published / External Completed Materialized view joining pre-FSCS and FSCS data sets into one structure. Contains total number of fish caught at each length for all species at a station. Loaded by batch 9070, 07-28-2016 11:11 Data Table Yes SVDBS Materialized view joining pre-FSCS and FSCS data sets into one structure. Contains total number of fish caught at each length for all species at a station. 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 LENGTH NUMBER 22 No No 5 2 Active Measured length of species in centimeters (cm). Measure method differs by species. NUMBER cm 11 EXPNUMLEN NUMBER 22 No No 8 0 Active Expanded number of specimens at a given length. NUMBER 12 LOGGED_SPECIES_NAME VARCHAR2 45 No No Active Name of the species, either common, scientific or both. VARCHAR2 13 LENGTH_COMMENT VARCHAR2 100 No No Active Comment related to length of individual fish. VARCHAR2 33603 UNION_FSCS_SVSTA Published / External Completed Materialized view joining entities that store data from 1963 - 2000 (paper log collected data) and 2001 - present (digitally acquired data sets) into a single time-series. Loaded by batch 9070, 07-28-2016 11:11 Data Table Yes SVDBS Materialized view joining pre-FSCS and FSCS data sets into one structure. Contains station data for each station. 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 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 7 ID VARCHAR2 72 No No Active Concatenation of Cruise6, Stratum, Tow and Station values. VARCHAR2 21 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 22 SVVESSEL VARCHAR2 2 No No Active Standard two character code for a survey vessel. Refer to SVDBS.SV_VESSEL VARCHAR2 23 CRUNUM VARCHAR2 8 No No Active National Ocean Services (NOS) consecutive cruise number on a particular vessel. VARCHAR2 24 SVGEAR VARCHAR2 8 No No Active Code referencing predominant gear type used on a cruise. See SVDBS.SVGEAR table. VARCHAR2 25 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 26 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 27 BEGIN_GMT_TOWDATE DATE 7 No No Active Date and time represented by Greenwich Mean Time (GMT) for the start of a tow or deployment. DATE 28 END_GMT_TOWDATE DATE 7 No No Active Date and time represented by Greenwich Mean Time (GMT) at the end of a tow or deployment. DATE 29 EST_YEAR VARCHAR2 4 No No Active Year, represented by Eastern Standard Time (EST). VARCHAR2 30 EST_MONTH VARCHAR2 2 No No Active Month, represented by Eastern Standard Time (EST). VARCHAR2 31 EST_DAY VARCHAR2 2 No No Active Day of the month represented by Eastern Standard Time (EST). VARCHAR2 32 EST_JULIAN_DAY VARCHAR2 7 No No Active Julian day of towdate represented as Eastern Standard Time (EST). VARCHAR2 33 EST_TIME VARCHAR2 8 No No Active Time, represented by Eastern Standard Time (EST). VARCHAR2 34 GMT_YEAR VARCHAR2 4 No No Active Year, represented as Greenwich Mean Time (GMT). VARCHAR2 35 GMT_MONTH VARCHAR2 2 No No Active Month, represented as Greenwich Mean Time (GMT). VARCHAR2 36 GMT_DAY VARCHAR2 2 No No Active Day of the month, represented as Greenwich Mean Time (GMT). VARCHAR2 37 GMT_JULIAN_DAY VARCHAR2 7 No No Active Julian day of towdate represented as Greenwich Mean Time (GMT). VARCHAR2 38 GMT_TIME VARCHAR2 8 No No Active Time, represented as Greenwich Mean Time (GMT). VARCHAR2 39 TOWDUR NUMBER 22 No No 5 2 Active Duration of tow in minutes. NUMBER 40 SETDEPTH NUMBER 22 No No 4 0 Active Depth at the time the primary gear is set to fish, to the nearest meter. NUMBER 41 ENDDEPTH NUMBER 22 No No 4 0 Active Water depth (m) at end of tow. NUMBER 42 MINDEPTH NUMBER 22 No No 4 0 Active Minimum depth (m) at which gear fished. NUMBER 43 MAXDEPTH NUMBER 22 No No 4 0 Active Maximum depth at which gear fished. NUMBER 44 AVGDEPTH NUMBER 22 No No 4 0 Active A four digit number recording the average depth, to the nearest meter, during a survey gear deployment. NUMBER 47 BEGLAT NUMBER 22 No No 9 4 Active Beginning latitude of tow (decimal minutes). NUMBER 48 BEGLON NUMBER 22 No No 9 4 Active Beginning longitude of tow (decimal minutes). NUMBER 49 ENDLAT NUMBER 22 No No 9 4 Active Latitude at end of tow (decimal minutes). NUMBER 50 ENDLON NUMBER 22 No No 9 4 Active Longitude at end of tow (decimal minutes) NUMBER 51 DECDEG_BEGLAT NUMBER 22 No No 10 6 Active Beginning latitude of tow in decimal degrees. NUMBER 52 DECDEG_BEGLON NUMBER 22 No No 10 6 Active Beginning longitude of tow in decimal degrees. NUMBER 53 DECDEG_ENDLAT NUMBER 22 No No 10 6 Active Ending latitide of tow in decimal degrees. NUMBER 54 DECDEG_ENDLON NUMBER 22 No No 10 6 Active Ending longitude of tow in decimal degrees. NUMBER 59 CABLE NUMBER 22 No No 5 0 Active Wire out (meters) at the water surface. NUMBER 60 PITCH NUMBER 22 No No 3 0 Active Pitch of variable pitch propeller. NUMBER 61 HEADING NUMBER 22 No No 4 1 Active Vessel compass heading. NUMBER 62 COURSE NUMBER 22 No No 4 1 Active Actual course the vessel made good in degrees. NUMBER 63 RPM NUMBER 22 No No 3 0 Active Average shaft revolutions per minute while under tow. NUMBER 64 DOPDISTB NUMBER 22 No No 5 3 Active Distance traveled, in nautical miles, between the start and stop of the gear deployment event. NUMBER 65 DOPDISTW NUMBER 22 No No 5 3 Active Distance traveled, in nautical miles, between the start and stop of the gear deployment using doppler through the water. This is a deprecated field, and only collected prior to 1993. NUMBER 66 DESSPEED NUMBER 22 No No 2 1 Active Designated towing speed for a particular gear (knots). NUMBER 69 OTHGEAR VARCHAR2 4 No No Active Code for gear deployed other than primary gear (i.e. net, dredge) such as bongo, Neuston, etc. See SVDBS.OTHGEAR VARCHAR2 70 AIRTEMP NUMBER 22 No No 5 2 Active Air temperature (degrees Celsius) rounded to nearest whole degree. NUMBER 71 CLOUD VARCHAR2 3 No No Active Code to represent percentage of cloud cover. See SVDBS.CLOUD VARCHAR2 72 BAROPRESS NUMBER 22 No No 5 1 Active Barometric pressure (millibars). NUMBER 73 WINDDIR NUMBER 22 No No 4 1 Active Direction of wind during deployment of gear (degrees). NUMBER 74 WINDSP NUMBER 22 No No 4 1 Active Speed of wind in knots. NUMBER 75 WEATHER VARCHAR2 3 No No Active Code reflecting weather condition. See SVDBS.WEATHER table VARCHAR2 76 WAVEHGT NUMBER 22 No No 4 2 Active Height of waves (m). NUMBER 77 SWELLDIR NUMBER 22 No No 3 0 Active Swell direction (degrees). NUMBER 78 SWELLHGT NUMBER 22 No No 4 2 Active Swell height (m). NUMBER 79 BKTTEMP NUMBER 22 No No 6 3 Active Surface water temperature (degrees Celsius). NUMBER 80 TRASHAMT NUMBER 22 No No 4 0 Active Volume of trash in liters. NUMBER 81 TRASHSHL NUMBER 22 No No 3 0 Active Trash by % of shells collected during shellfish surveys. NUMBER 82 TRASHBIO NUMBER 22 No No 3 0 Active Trash by % of living animals such as fish, starfish and snails colected during shellfish surveys. NUMBER 83 TRASHSUB NUMBER 22 No No 3 0 Active Trash by % of rocks, pebbles, sand collected during shellfish surveys. NUMBER 84 XBT VARCHAR2 1 No No Active Code associated with expendable bathythermograph (temperature/depth profile instrument). See SVDBS.XBT VARCHAR2 85 SURFTEMP NUMBER 22 No No 6 3 Active Surface temperature of water (degrees Celcius). NUMBER 86 SURFSALIN NUMBER 22 No No 6 3 Active Salinity at water surface in practical salinity units (PSU). NUMBER 87 BOTTEMP NUMBER 22 No No 6 3 Active Bottom temperature (degrees Celsius). NUMBER 88 BOTSALIN NUMBER 22 No No 6 3 Active Bottom salinity in Practical Salinity Units (PSU). NUMBER 89 FULD NUMBER 22 No No 3 0 Active Fullness of the dredge, measured to the nearest bushel (used on scallop and clam surveys only). NUMBER 90 NO_DETAIL_SVSPP NUMBER 22 No No 4 0 Active Number of biological data sheets associated with a given station. NUMBER 91 BOTSPEED NUMBER 22 No No 3 1 Active Speed over bottom (knots) recorded by GPS. NUMBER 94 WATCH_CHIEF_COMMENTS VARCHAR2 500 No No Active Watch Chief comment regarding current tow. VARCHAR2 95 STATION_COMMENTS VARCHAR2 500 No No Active Comment from the bridge officers. VARCHAR2 96 HABITAT_COMMENTS VARCHAR2 500 No No Active Comments on non-coded species found in catch. VARCHAR2 Data Steward 2025 Person Kircun, Jakub jakub.kircun@noaa.gov 166 Water Street Woods Hole MA 02543 Data Steward 1999 2024 Person Kostovick, Paul paul.kostovick@noaa.gov 166 Water Street Woods Hole MA 02543 USA (508)495-2343 (508)495-2230 8am-4:30pm Email Distributor 1963 Organization Northeast Fisheries Science Center NEFSC https://ror.org/02nc0ck44 166 Water Street Woods Hole MA 02543-1026 USA (508)495-2000 https://www.fisheries.noaa.gov/about/northeast-fisheries-science-center NEFSC Home Page Online Resource 8:00 a.m. to 4:30 p.m. Monday - Friday Metadata Contact 2025 Person Kircun, Jakub jakub.kircun@noaa.gov 166 Water Street Woods Hole MA 02543 Metadata Contact 2018-09 2024 Person Kostovick, Paul paul.kostovick@noaa.gov 166 Water Street Woods Hole MA 02543 USA (508)495-2343 (508)495-2230 8am-4:30pm Originator 1963 Organization Northeast Fisheries Science Center NEFSC https://ror.org/02nc0ck44 166 Water Street Woods Hole MA 02543-1026 USA (508)495-2000 https://www.fisheries.noaa.gov/about/northeast-fisheries-science-center NEFSC Home Page Online Resource 8:00 a.m. to 4:30 p.m. Monday - Friday Point of Contact 2024 Person Foley, Catherine catherine.foley@noaa.gov 166 Water Street Woods Hole MA 02543 Point of Contact 2018 2023 Person Politis, Philip J philip.politis@noaa.gov 166 Water Street Woods Hole MA 02543 (508) 495-2171 Email Ground Condition -78.24 -63.2 44.47 32.41 northwest Atlantic: Cape Hatteras, NC to Nova Scotia Continuing 1963-11-14 The standardized Fall Bottom Trawl Survey began with the first station on November 14,1963 at 12:14 AM (GMT). Unclassified Available to qualified researchers. 1. Formal request in writing usually to the data owner/contact or Center Director. 2. Requester is contacted by data owner to review and verify the request content and details for data delivery options. 3. If data is confidential then owner will determine is the data may be released to the requester. 4. If data can be released, the data is downloaded and packaged for delivery electronically; or the requester may be directed to where the data is available online. If data is stored on an internal NEFSC network, the requester may not have direct access to query the data unless they are also authorized for network access. User must read and fully comprehend the metadata prior to use. Applications or inferences derived from the data should be carefully considered for accuracy. Acknowledgement of NOAA/NMFS/NEFSC, as the source from which these data were obtained in any publications and/or other representations of these, data is suggested. https://storage.googleapis.com/nmfs_odp_nefsc/PARR/PEMAD/ESB/22560/22560_NEFSCFallFisheriesIndependentBottomTrawlData.zip 22560_NEFSCFallFisheriesIndependentBottomTrawlData.zip The compressed file contains the following comma delimited files: 22560_UNION_FSCS_SVBIO.csv 22560_UNION_FSCS_SVCAT.csv 22560_UNION_FSCS_SVLEN.csv 22560_UNION_FSCS_SVSTA.csv 22560_SVDBS_CRUISES.csv Data extracted on 3/11/2026 2026-03-11T00:00:00 Zip 24.7MB Zip https://storage.googleapis.com/nmfs_odp_nefsc/PARR/PEMAD/ESB/SVDBS/SVDBS_SupportTables.zip SVDBS_SupportTables.zip The compressed file contains the following comma delimited files: SVDBS_CLOUD.csv SVDBS_MATURITY_CODES.csv SVDBS_SEX_CODES.csv SVDBS_SVGEAR.csv SVDBS_SVMSTRATA.csv SVDBS_SVVESSEL.csv SVDBS_WEATHER.csv SVDBS_XBT.csv 2017-08-17T00:00:00 Zip 27.7KB Zip https://www.nefsc.noaa.gov/femad/ecosurvey/mainpage/cruise_results.html Online Resource PDF Link to Survey Cruise Results. Cruise results describe the purpose, methods used, personnel who participated, and provides a summary of the total number of samples collected for various government and university investigators during the Ecosystem Surveys Branch's bottom trawl and shellfish surveys. https://www.nefsc.noaa.gov/femad/ecosurvey/mainpage/resource_survey_reports.html Online Resource PDF Link to the Resource Survey Reports. Each report consists of field notes, station and catch summaries, and a series of geographical plots of commercial and recreational important species caught during the Ecosystem Surveys Branch's bottom trawl and shellfish resource cruises. RDBMS: Oracle representative High degree of accuracy. When there is species identification doubt at sea, the specimen is retained for taxonomy at the NEFSC or other taxonomic laboratory. SCS and FSCS data collection software programs employ real-time validation and must meet database integrity constraints. Data are then subject to post-audits. Yes Unknown Yes No 30 days To Be Determined To be determined Archival of source data preserving unaltered collected data, Scheduled backups, Remote storage backups, Password protection. Vessel sensor data are collected electronically using SCS. Catch and biological data are collected electronically using FSCS 2.0. At the completion of each cruise leg, a database copy is inserted into the shoreside database. 2014-12-22 McHugh, Nancy What trawl gear was used during the spring surveys from 1963 - 1996? See Table 3b. of reference: NOAA Technical Memorandum NMFS-NE-122, Essential Fish Habitat Source Document: Fishery-Independent Surveys, Data Sources, and Methods. Robert N. Reid, Frank P. Almeida, and Christine A. Zetlin. The #36 Yankee Trawl was used from 1963-1996 except in years 1972 and 1973 when the #36 Yankee was used and the 3/4 Yankee was used by the R/V Atlantic Twin. 2014-12-22 McHugh, Nancy Where can I find conversion coefficients for for species that had significantly different catch rates (in numbers) at the 0.05 level for each of the major gear changes in the survey? See Table 4. of reference: NOAA Technical Memorandum NMFS-NE-122, Essential Fish Habitat Source Document: Fishery-Independent Surveys, Data Sources, and Methods. Robert N. Reid, Frank P. Almeida, and Christine A. Zetlin. 31173 Entity 31178 Entity 31179 Entity 31183 Entity 33598 Entity 33599 Entity 33600 Entity 33601 Entity 33602 Entity 33603 Entity 31189 Entity 31190 Entity gov.noaa.nmfs.inport:22560 Nancy McHugh 2014-11-14T11:08:53 Jakub Kircun 2026-03-11T19:59:47 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 No 2019-05-31 1 Year 2020-05-31