27384 Paired Trawl Sweep Comparison Study Data Set Published / External 55533 Cooperative Research Surveys Project Completed In the spring of 2009, Northeast Fisheries Science Center (NEFSC) replaced the previous standard bottom trawl gear (Yankee 36) with a new standard survey trawl designed in close collaboration with the fishing industry and local net manufacturers. Some stakeholders expressed concern that the rockhopper sweep introduced with this gear was not suitable for the efficient capture of flatfish and could therefore bias survey estimates. To address this question, a paired trawl experiment was conducted during the fall of 2009 and the spring and fall of 2010 aboard three chartered fishing vessels, the Mary K, the Moragh K, and the Endurance. The new standard survey trawl with rockhopper sweep was compared with an identical net with a 3” cookie sweep using paired tows between 2 vessels. Results in general showed significantly more flatfish caught with the cookie sweep, although differences in size distributions between the two sweeps were negligible in most cases. To compare catchability of rockhopper and cookie sweeps on the NEFSC standard bottom trawl survey net and allow more direct comparability between NEFSC bottom trawl survey and NEAMAP bottom trawl survey. Theme 3" cookie sweep Theme cooperative research Theme flatfish Theme paired trawl Theme rock hopper sweep Theme size distribution Temporal 2009 Temporal 2010 Spatial Georges Bank Spatial Gulf of Maine Spatial Southern New England Stratum benthic Stratum demersal NEFSC Woods Hole Lab Woods Hole MA USA Data Set Oracle Database As Needed Table (digital) Standard Bottom Trawl Survey 4-seam trawl with cookie sweep, ship based DGPS, ship based sounder Vessels: Mary K, Moragh K, Endurance Standard Bottom Trawl Survey 4-seam trawl with rockhopper sweep 31549 CLOUD Published / External Completed Support table describing cloud cover. Loaded by batch 8363, 03-16-2016 14:51 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 31554 MATURITY_CODES Published / External Completed MASSACHUSETTS Historical support table containing acceptable maturity codes and their description. FSCS_MATURITY_CODES replaces this table. Loaded by batch 8363, 03-16-2016 14:51 Data Table Yes SVDBS MASSACHUSETTS 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 31555 SEX_CODES Published / External Completed Historical support table containing acceptable codes and descriptions for the field sex. Loaded by batch 8363, 03-16-2016 14:51 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 31559 SVGEAR Published / External Completed Support table containing gear codes and descriptions for the field SVGEAR of the table SVSTA_BASE. Loaded by batch 8363, 03-16-2016 14:51 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 31566 WEATHER Published / External Completed Support table containing codes and descriptions used in the WEATHER field of the SVSTA_BASE table. Loaded by batch 8363, 03-16-2016 14:51 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 31567 XBT Published / External Completed Historical support table containing codes and descriptions for the field XBT of the table SVSTA_BASE. Loaded by batch 8363, 03-16-2016 14:51 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 33826 SVMSTRATA Published / External Completed Historical support table containing all acceptable stratum codes. Loaded by batch 9100, 07-29-2016 12:08 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 33827 SVVESSEL Published / External Completed Support table identifying all vessel codes and descriptions. Loaded by batch 9100, 07-29-2016 12:08 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 33828 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 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 33829 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 9100, 07-29-2016 12:08 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 a species caught at a given station. NUMBER 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 33830 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 9100, 07-29-2016 12:08 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 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 33831 UNION_FSCS_SVSTA Published / External Completed Materialized view joining pre-FSCS and FSCS data sets into one structure. Contains station data for each station. 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 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 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 72 No No Active Concatenation of Cruise6, Stratum, Tow and Station values. VARCHAR2 8 STATYPE VARCHAR2 4 No No Active Code designating type of tow being performed (e.g. random vs. nonrandom tows). See SVDBS.STATION_VALUE table for all statype codes and their descriptions. VARCHAR2 9 HAUL VARCHAR2 4 No No Active Code for relative success of haul. See SVDBS.HAUL_VALUE table VARCHAR2 10 GEARCOND VARCHAR2 4 No No Active Refer to SVDBS.GEAR_CONDITION table for gear condition codes and descriptions. VARCHAR2 11 SHG VARCHAR2 12 No No Active Concatenation of Station, Haul and Gear values. See SVDBS.STATION_VALUE, SVDBS.HAUL_VALUE, SVDBS.GEAR_CONDITION VARCHAR2 12 TYPE_CODE NUMBER 22 No No 2 0 Active Code concerning station details. This defines the type of sampling conducted at each station. Standard NEFSC BTS tows are coded with a T value = 1. The T value=1 is subdivided into 6 components: 1- Random Tow, within 1nm Radius; 1- Random Tow, outside 1nm, within 3nm Radius; 1- Repeat Tow; 1- Random Altername; 1- Random Offshore Continental Shelf; 1- Altername Offshore Protocol. Tow types other than NEFSC BTS standard random tows are defined by the following code values: 2- Non-Random Tow - Tow is not conducted according a random and stratified statistical design. Tow must follow NEFSC BTS protocols.; 3- Survey Standardization - Tow conducted to evaluate NEFSC BTS standardization (i.e. gear testing); 4- Comparison Tow - Tow conducted in comparison of other gears, surveys, vessels or operating procedures ; 5- Aborted Tow - Gear set but timed tow duration never started (aborted tow); 6- Site Specific - Non-random tow conducted in a specific, targeted region; 7- Experimental Survey Design - Survey design type other than random and stratified (i.e. transect, depletion study, grid, fixed etc.); 8 Other - Tows that do not fall into the previous categories. Detailed description of the tow type shall be recorded. NUMBER 13 TYPE_COMMENT VARCHAR2 1000 No No Active Comment concerning the Type_Code of the given operation. VARCHAR2 14 OPERATION_CODE NUMBER 22 No No 2 0 Active Code to define tow in terms of the operational characteristics (i.e. tow duration, vessel speed, scope ratio, depth, trawl perf., winch perf., stratum boundaries. O-Value= 4 is considered non-valid. Tow should be repeated, when possible, at the discretion of Chief Scientist. 1- Good Performance - All operational parameters are within optimal tol.range.2- Representative - Tow dur. 18.00min 19.49min or 20.50min-21.00min; 75-99% on-bottom tow dist. within the correct stratum; Door Spread mean outside optimal but within tol. limit. Wing Spread mean outside optimal but within tolerance limit. (Door and Wing spread are depth dependant calcs.); Headrope Height mean outside optimal but within the tolerance limit(Optimal Height is 3.2-4.1m.3- Representative - Tow dur. 16.00min -17.99min; Acqu. Code Value = 4 (details given with A code); Door Spread Std Deviation High (greater than 4.5m);Wing Spread Std Deviation High (> than 2.0m; Headrope Ht Spread Std Deviation High (Greater than 1.0m; Scope Ratio outside tolerance limit. (+/- 25%)4- Non Representative - Tow dur. < than 16.00min or > than 21.00min; Tow distance < than 0.8nm or > than 1.05nm; Door Spread mean outside tol. limit. (Depth dependant); Wing Spread mean outside tol. limit.(Depth dependant); Headrope Height mean outside tol. limit. (Less than 2.7m or greater than 4.7m); SOG mean outside tol. limit. (Less than 2.6 or greater than 3.4kts); Depth mean outside tol. limit. (EK6018kHz, must be within +/- 10% of set depth, or +/-5m at depths less than 50m); Mean Starboard and Mean Port Block Tension not equalized within ±0.5t; Diff. between mean Starboard and Port Winch calculated wire out lengths greater than 10m; Diff. between mean STBD and Port Block wire out lengths greater than 10m; Less than 75% of on-bottom tow distance within correct stratum; Trawl Depth > than 20% difference of vessel tow depth; Chief Scientist or Watch Chief Failed tow- tow considered unsatisfactory based on vessel or gear performance. NUMBER 15 OPERATION_COMMENT VARCHAR2 1000 No No Active Comment concerning Operation Code of given operation (tow duration, vessel speed, scope ration, depth, trawl performance,winch performance, and stratum boundaries. VARCHAR2 16 GEAR_CODE NUMBER 22 No No 2 0 Active Gear condition code.Gear defined as trawl net,cod-end,liner,sweep,doors & rigging. Valid Gear values =1,2,4(no code 3).1-Good Tow- No damage to webbing, frame ropes, sweep doors or rigging. Trawl properly rigged and considered to be in standard configuration. 2- Representative- Minor Small Holes/Tears in webbing (incl. cod-end and liner).Tears easily repaired coded 2. Larger holes/tears in Jibs,Wings,Bunts,Square or 1st & 2nd Top Bellies.Hole not thought to sig. alter fish capture.Obstr. in/on gear, not thought to signif. alter fish capture Minor Hang;No signif. gear damage;Hang,after 16.00min tow dur.;Tow dur. adjust to time hang occurred;Insignif. sweep damage (i.e. slight damage to rockhoppers not thought to increase fish escapement);Loss or damage to < than 12 floats; Very large catch;Deck tow of dogfish or other species;Other gear damage/malfunction not thought to significantly alter fish capture.4-Non_Representative -Signif. holes/tears/large holes in bottom bellies, or any portion of webbing aft of 2nd belly;Major Gear Damage(i.e. rim-rack, whole sections torn out,loss of trawl door(s) etc.);Open Cod-end;Improperly Attached Liner OR Open Liner OR Signif. Catch Outside Liner;Twisted Wing(s);Signif. Loss of bottom contacts (4min duration or longer).Improper Rigging;Collapsed Doors;Crossed Doors;Major Sweep Damage. (Parted sweep and/or major damage(i.e. loss of more than one rockhopper, or damage to sweep components thought to significantly increase fish escapement. Damaged Frame Rope(s)(headrope,up&down line,bolshline);Open Gore;Twisted or Crossed Bridle(s); Parted Legs;Loss/damage to 12 or > floats;Signif. damage to wing-end extension (i.e. loss, broken or altered length).Signif. Hang. Occurring at <16.00min tow dur.(OR unknown tow dur.;Large obstr. IN/ON gear thought to alter catch effic. or trawl geom.(i.e. pot stuck in front opening of cod-end. Catch not landed on deck;Damage to main towing cable(s);Other gear dam./malf. signif. altering catch efficiency. NUMBER 17 GEAR_COMMENT VARCHAR2 1000 No No Active Comment concerning gear condition, damage or malfunction of a given operation. VARCHAR2 18 ACQUISITION_CODE NUMBER 22 No No 2 0 Active Code concerning data acquisition (i.e. SCS data, trawl mens., SCS event button press).1- No Data Acq Errors. All data acq 75% or greater valid.2- Representative: Door Spread 50.00% - 74.99% data acq.;Wing Spread 50.00% - 74.99% data acq.;Height 50.00% - 74.99% data acq.;Trawl Depth 50.00% - 74.99% data acq.;Winch Tension 50.00% - 74.99% data acq.;Winch Wire Out 50.00% - 74.99% data acq.;Block Tension 50.00% - 74.99% data acq.;Block Wire Out 50.00% - 74.99% data acq.;Speed Over Ground 50.00% - 74.99% data acq.;Vessel Depth 50.00% - 74.99% data acq.;GPS 50.00% - 74.99% data acq.;3-Representative: Door Spread 25.00% - 49.99% data acq.;Wing Spread 25.00% - 49.99% data acq.;Height 25.00% - 49.99% data acq.;Trawl Depth 25.00% - 49.99% data acq.;Winch Tension 25.00% - 49.99% data acq.;Winch Wire Out 25.00% - 49.99% data acq.;Block Tension 25.00% - 49.99% data acq.;Block Wire Out 25.00% - 49.99% data acq.;Speed Over Ground 25.00% - 49.99% data acq.;Vessel Depth 25.00% - 49.99% data acq.;GPS 25.00% - 49.99% data acquisition.4- Non_Representative: Door Spread Less Than 25.00% data acq.;Wing Spread Less Than 25.00% data acq.;Height Less Than 25.00% data acq.;Trawl Depth Less Than 25.00% data acq.;Winch Tension Less Than 25.00% data acq.;Winch Wire Out Less Than 25.00% data acq.;Block Tension Less Than 25.00% data acq.;Block Wire Out Less Than 25.00% data acq.;Speed Over Ground Less Than 25.00% data acq.;Vessel Depth Less Than 25.00% data acq.;GPS Less Than 25.00% data acq.;Error Recording Event Data. Trawl event data missing.;Critical Button Press Error, Unknown Event Time(s). NUMBER 19 ACQUISITION_COMMENT VARCHAR2 1000 No No Active Comment concerning data acquisition (i.e. SCS data, trawl mensuration, SCS event button press). VARCHAR2 20 TOGA NUMBER 22 No No 8 0 Active A concatentation of the T, O, G and A codes assigned to an operation. Each standard survey tow is evaluated based on four categories, Type, Operational, Gear and Acquisition (T.O.G.A.). Type (T), Operational (O) and Gear (G) categories are used to validate each tow; the Acquisition (A) category is additional information not used for validation. T.O.G.A. is a detailed analysis of survey trawl and vessel performance during each tow, utilizing available data from trawl mensuration systems and vessel sensors not previously analyzed by the historical Station, Haul, and Gear (S.H.G.) coding system. NUMBER 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 45 BEGEKVLOG NUMBER 22 No No 8 3 Active An eight digit number measuring to the nearest thousandth of a nautical mile (e.g., 14564.345). Used to mark the beginning of a survey trawl for acoustic data purposes. NUMBER 46 ENDEKVLOG NUMBER 22 No No 8 3 Active An eight digit number measuring to the nearest thousandth of a nautical mile (e.g., 14564.345). Used to mark the end of a survey trawl for acoustic data purposes. NUMBER 47 BEGLAT NUMBER 22 No No 9 4 Active Beginning latitude of tow (decimal degrees). NUMBER 48 BEGLON NUMBER 22 No No 9 4 Active Beginning longitude of tow (decimal degrees). NUMBER 49 ENDLAT NUMBER 22 No No 9 4 Active Latitude at end of tow. NUMBER 50 ENDLON NUMBER 22 No No 9 4 Active Logitude at end of tow. 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 55 LORS1 VARCHAR2 9 No No Active Starting Loran C time delay. VARCHAR2 56 LORE1 VARCHAR2 9 No No Active Ending Loran C time delay. VARCHAR2 57 LORS2 VARCHAR2 9 No No Active Starting Loran C time delay. VARCHAR2 58 LORE2 VARCHAR2 9 No No Active Ending Loran C time delay. VARCHAR2 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 Speed over bottom recorded by GPS. NUMBER 65 DOPDISTW NUMBER 22 No No 5 3 Active Speed through water recorded by AMATEK when the water depth is >200m. NUMBER 66 DESSPEED NUMBER 22 No No 2 1 Active Designated towing speed for a particular gear (knots). NUMBER 67 GEARID VARCHAR2 2 No No Active Net identification number located on wing of net. VARCHAR2 68 DOORID VARCHAR2 2 No No Active Identification number of doors. VARCHAR2 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 Foley, Catherine catherine.foley@noaa.gov 166 Water Street Woods Hole MA 02543 Distributor 2014 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 Foley, Catherine catherine.foley@noaa.gov 166 Water Street Woods Hole MA 02543 Originator 2014 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 2025 Person Foley, Catherine catherine.foley@noaa.gov 166 Water Street Woods Hole MA 02543 -70.865883 -66.955583 44.691317 41.108983 Gulf of Maine, Southern New England, Georges Bank Range 2009-10-29 2010-11-03 The paired trawl sweep comparison study was conducted during the fall of 2009 and the spring and fall of 2010. Unclassified Available to qualified researchers. Please contact Point of Contact via email. NEFSC Data Access Procedure: 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 if 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. User must read and fully comprehend the metadata prior to use. Applications or inferences derived from the data should be carefully considered for accuracy. NEFSC Data Access Constraint: 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. 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/27384/27384_CooperativeResearchPairedTrawlSweepComparisonStudy.zip 27384_CooperativeResearchPairedTrawlSweepComparisonStudy.zip The compressed file contains the following comma delimited files: 27384_UNION_FSCS_SVBIO.csv 27384_UNION_FSCS_SVCAT.csv 27384_UNION_FSCS_SVLEN.csv 27384_UNION_FSCS_SVSTA.csv 2019-05-31T00:00:00 Zip 281.2KB Zip https://storage.googleapis.com/nmfs_odp_nefsc/PARR/PEMAD/ESB/SVDBS/SVDBS_SupportTables.zip SVDBS_SupportTables.zip Support tables Description 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 2018-08-08T00:00:00 Zip 27.7KB Zip Oracle database on Centralized Database Management System Data validation during data collection using FSCS 1.6, Data auditing post-survey by established auditing routines, Data validation during database load 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 were collected electronically using SCS. Catch and biological data were collected electronically using FSCS 1.6. At the completion of the cruise, a database copy was inserted into the shoreside database. 31549 Entity 31554 Entity 31555 Entity 31559 Entity 33826 Entity 33827 Entity 33828 Entity 33829 Entity 33830 Entity 33831 Entity 31566 Entity 31567 Entity gov.noaa.nmfs.inport:27384 Patricia Jones 2015-09-23T09:24:27 SysAdmin InPortAdmin 2026-03-04T19:17:17 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