Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Materialized view joining pre-FSCS and FSCS data sets into one structure. Contains station data for each station.

Description

Materialized view joining pre-FSCS and FSCS data sets into one structure. Contains station data for each station.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
CRUISE6
VARCHAR2
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)
CRUISE
VARCHAR2
Unique numerical code for a cruise.
STRATUM
VARCHAR2
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.
TOW
VARCHAR2
Sequential number representing order in which station was selected within a stratum.
STATION
VARCHAR2
Unique sequential order in which stations have been completed. Hangups and short tows each receive a non-repeated consecutive number.
STATUS_CODE
VARCHAR2
Code referencing whether or not a cruise is available in the SVDBS system. See SVDBS.SVCRUISE_STATUS.
ID
VARCHAR2
Concatenation of Cruise6, Stratum, Tow and Station values.
STATYPE
VARCHAR2
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.
HAUL
VARCHAR2
Code for relative success of haul. See SVDBS.HAUL_VALUE table
GEARCOND
VARCHAR2
Refer to SVDBS.GEAR_CONDITION table for gear condition codes and descriptions.
SHG
VARCHAR2
Concatenation of Station, Haul and Gear values. See SVDBS.STATION_VALUE, SVDBS.HAUL_VALUE, SVDBS.GEAR_CONDITION
TYPE_CODE
NUMBER
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.
TYPE_COMMENT
VARCHAR2
Comment concerning the Type_Code of the given operation.
OPERATION_CODE
NUMBER
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.
OPERATION_COMMENT
VARCHAR2
Comment concerning Operation Code of given operation (tow duration, vessel speed, scope ration, depth, trawl performance,winch performance, and stratum boundaries.
GEAR_CODE
NUMBER
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.
GEAR_COMMENT
VARCHAR2
Comment concerning gear condition, damage or malfunction of a given operation.
ACQUISITION_CODE
NUMBER
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).
ACQUISITION_COMMENT
VARCHAR2
Comment concerning data acquisition (i.e. SCS data, trawl mensuration, SCS event button press).
TOGA
NUMBER
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.
AREA
VARCHAR2
Standard area code used for commercial data (New England Statistical Area Code) for the position of the beginning of the tow.
SVVESSEL
VARCHAR2
Standard two character code for a survey vessel. Refer to SVDBS.SV_VESSEL
CRUNUM
VARCHAR2
National Ocean Services (NOS) consecutive cruise number on a particular vessel.
SVGEAR
VARCHAR2
Code referencing predominant gear type used on a cruise. See SVDBS.SVGEAR table.
BEGIN_EST_TOWDATE
DATE
Date and time represented by Eastern Standard Time (EST) for the start of a tow or deployment.
END_EST_TOWDATE
DATE
Date and time represented by Eastern Standard Time (EST) at the end of a tow or deployment.
BEGIN_GMT_TOWDATE
DATE
Date and time represented by Greenwich Mean Time (GMT) for the start of a tow or deployment.
END_GMT_TOWDATE
DATE
Date and time represented by Greenwich Mean Time (GMT) at the end of a tow or deployment.
EST_YEAR
VARCHAR2
Year, represented by Eastern Standard Time (EST).
EST_MONTH
VARCHAR2
Month, represented by Eastern Standard Time (EST).
EST_DAY
VARCHAR2
Day of the month represented by Eastern Standard Time (EST).
EST_JULIAN_DAY
VARCHAR2
Julian day of towdate represented as Eastern Standard Time (EST).
EST_TIME
VARCHAR2
Time, represented by Eastern Standard Time (EST).
GMT_YEAR
VARCHAR2
Year, represented as Greenwich Mean Time (GMT).
GMT_MONTH
VARCHAR2
Month, represented as Greenwich Mean Time (GMT).
GMT_DAY
VARCHAR2
Day of the month, represented as Greenwich Mean Time (GMT).
GMT_JULIAN_DAY
VARCHAR2
Julian day of towdate represented as Greenwich Mean Time (GMT).
GMT_TIME
VARCHAR2
Time, represented as Greenwich Mean Time (GMT).
TOWDUR
NUMBER
Duration of tow in minutes.
SETDEPTH
NUMBER
Depth at the time the primary gear is set to fish, to the nearest meter.
ENDDEPTH
NUMBER
Water depth (m) at end of tow.
MINDEPTH
NUMBER
Minimum depth (m) at which gear fished.
MAXDEPTH
NUMBER
Maximum depth at which gear fished.
AVGDEPTH
NUMBER
A four digit number recording the average depth, to the nearest meter, during a survey gear deployment.
BEGEKVLOG
NUMBER
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.
ENDEKVLOG
NUMBER
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.
BEGLAT
NUMBER
Beginning latitude of tow (decimal degrees).
BEGLON
NUMBER
Beginning longitude of tow (decimal degrees).
ENDLAT
NUMBER
Latitude at end of tow.
ENDLON
NUMBER
Logitude at end of tow.
DECDEG_BEGLAT
NUMBER
Beginning latitude of tow in decimal degrees.
DECDEG_BEGLON
NUMBER
Beginning longitude of tow in decimal degrees.
DECDEG_ENDLAT
NUMBER
Ending latitide of tow in decimal degrees.
DECDEG_ENDLON
NUMBER
Ending longitude of tow in decimal degrees.
LORS1
VARCHAR2
Starting Loran C time delay.
LORE1
VARCHAR2
Ending Loran C time delay.
LORS2
VARCHAR2
Starting Loran C time delay.
LORE2
VARCHAR2
Ending Loran C time delay.
CABLE
NUMBER
Wire out (meters) at the water surface.
PITCH
NUMBER
Pitch of variable pitch propeller.
HEADING
NUMBER
Vessel compass heading.
COURSE
NUMBER
Actual course the vessel made good in degrees.
RPM
NUMBER
Average shaft revolutions per minute while under tow.
DOPDISTB
NUMBER
Speed over bottom recorded by GPS.
DOPDISTW
NUMBER
Speed through water recorded by AMATEK when the water depth is >200m.
DESSPEED
NUMBER
Designated towing speed for a particular gear (knots).
GEARID
VARCHAR2
Net identification number located on wing of net.
DOORID
VARCHAR2
Identification number of doors.
OTHGEAR
VARCHAR2
Code for gear deployed other than primary gear (i.e. net, dredge) such as bongo, Neuston, etc. See SVDBS.OTHGEAR
AIRTEMP
NUMBER
Air temperature (degrees Celsius) rounded to nearest whole degree.
CLOUD
VARCHAR2
Code to represent percentage of cloud cover. See SVDBS.CLOUD
BAROPRESS
NUMBER
Barometric pressure (millibars).
WINDDIR
NUMBER
Direction of wind during deployment of gear (degrees).
WINDSP
NUMBER
Speed of wind in knots.
WEATHER
VARCHAR2
Code reflecting weather condition. See SVDBS.WEATHER table
WAVEHGT
NUMBER
Height of waves (m).
SWELLDIR
NUMBER
Swell direction (degrees).
SWELLHGT
NUMBER
Swell height (m).
BKTTEMP
NUMBER
Surface water temperature (degrees Celsius).
TRASHAMT
NUMBER
Volume of trash in liters.
TRASHSHL
NUMBER
Trash by % of shells collected during shellfish surveys.
TRASHBIO
NUMBER
Trash by % of living animals such as fish, starfish and snails colected during shellfish surveys.
TRASHSUB
NUMBER
Trash by % of rocks, pebbles, sand collected during shellfish surveys.
XBT
VARCHAR2
Code associated with expendable bathythermograph (temperature/depth profile instrument). See SVDBS.XBT
SURFTEMP
NUMBER
Surface temperature of water (degrees Celcius).
SURFSALIN
NUMBER
Salinity at water surface in practical salinity units (PSU).
BOTTEMP
NUMBER
Bottom temperature (degrees Celsius).
BOTSALIN
NUMBER
Bottom salinity in Practical Salinity Units (PSU).
FULD
NUMBER
Fullness of the dredge, measured to the nearest bushel (used on scallop and clam surveys only).
NO_DETAIL_SVSPP
NUMBER
Number of biological data sheets associated with a given station.
BOTSPEED
NUMBER
Speed over bottom (knots) recorded by GPS.
WATCH_CHIEF
VARCHAR2
Person responsible for smooth conduct of each watch and the collection of data.
CHIEF_SCIENTIST
VARCHAR2
Person responsible for scientific operations (how and where sampling occurs) and the scientific party.
WATCH_CHIEF_COMMENTS
VARCHAR2
Watch Chief comment regarding current tow.
STATION_COMMENTS
VARCHAR2
Comment from the bridge officers.
HABITAT_COMMENTS
VARCHAR2
Comments on non-coded species found in catch.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (NEFSC) for inquiries on this record.

Item Identification

Title: Table: UNION_FSCS_SVSTA
Short Name: UNION_FSCS_SVSTA
Status: Completed
Abstract:

Materialized view joining pre-FSCS and FSCS data sets into one structure. Contains station data for each station.

Notes:

Loaded by batch 9099, 07-29-2016 11:48

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: SVDBS
Description:

Materialized view joining pre-FSCS and FSCS data sets into one structure. Contains station data for each station.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
CRUISE6 VARCHAR2 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)
100
CRUISE VARCHAR2 Unique numerical code for a cruise.
100
STRATUM VARCHAR2 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.
100
TOW VARCHAR2 Sequential number representing order in which station was selected within a stratum.
100
STATION VARCHAR2 Unique sequential order in which stations have been completed. Hangups and short tows each receive a non-repeated consecutive number.
100
STATUS_CODE VARCHAR2 Code referencing whether or not a cruise is available in the SVDBS system. See SVDBS.SVCRUISE_STATUS.
100
ID VARCHAR2 Concatenation of Cruise6, Stratum, Tow and Station values.
100
STATYPE VARCHAR2 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.
100
HAUL VARCHAR2 Code for relative success of haul. See SVDBS.HAUL_VALUE table
100
GEARCOND VARCHAR2 Refer to SVDBS.GEAR_CONDITION table for gear condition codes and descriptions.
100
SHG VARCHAR2 Concatenation of Station, Haul and Gear values. See SVDBS.STATION_VALUE, SVDBS.HAUL_VALUE, SVDBS.GEAR_CONDITION
100
TYPE_CODE NUMBER 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.
100
TYPE_COMMENT VARCHAR2 Comment concerning the Type_Code of the given operation.
100
OPERATION_CODE NUMBER 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.
100
OPERATION_COMMENT VARCHAR2 Comment concerning Operation Code of given operation (tow duration, vessel speed, scope ration, depth, trawl performance,winch performance, and stratum boundaries.
100
GEAR_CODE NUMBER 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.
100
GEAR_COMMENT VARCHAR2 Comment concerning gear condition, damage or malfunction of a given operation.
100
ACQUISITION_CODE NUMBER 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).
100
ACQUISITION_COMMENT VARCHAR2 Comment concerning data acquisition (i.e. SCS data, trawl mensuration, SCS event button press).
100
TOGA NUMBER 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.
100
AREA VARCHAR2 Standard area code used for commercial data (New England Statistical Area Code) for the position of the beginning of the tow.
100
SVVESSEL VARCHAR2 Standard two character code for a survey vessel. Refer to SVDBS.SV_VESSEL
100
CRUNUM VARCHAR2 National Ocean Services (NOS) consecutive cruise number on a particular vessel.
100
SVGEAR VARCHAR2 Code referencing predominant gear type used on a cruise. See SVDBS.SVGEAR table.
100
BEGIN_EST_TOWDATE DATE Date and time represented by Eastern Standard Time (EST) for the start of a tow or deployment.
100
END_EST_TOWDATE DATE Date and time represented by Eastern Standard Time (EST) at the end of a tow or deployment.
100
BEGIN_GMT_TOWDATE DATE Date and time represented by Greenwich Mean Time (GMT) for the start of a tow or deployment.
100
END_GMT_TOWDATE DATE Date and time represented by Greenwich Mean Time (GMT) at the end of a tow or deployment.
100
EST_YEAR VARCHAR2 Year, represented by Eastern Standard Time (EST).
100
EST_MONTH VARCHAR2 Month, represented by Eastern Standard Time (EST).
100
EST_DAY VARCHAR2 Day of the month represented by Eastern Standard Time (EST).
100
EST_JULIAN_DAY VARCHAR2 Julian day of towdate represented as Eastern Standard Time (EST).
100
EST_TIME VARCHAR2 Time, represented by Eastern Standard Time (EST).
100
GMT_YEAR VARCHAR2 Year, represented as Greenwich Mean Time (GMT).
100
GMT_MONTH VARCHAR2 Month, represented as Greenwich Mean Time (GMT).
100
GMT_DAY VARCHAR2 Day of the month, represented as Greenwich Mean Time (GMT).
100
GMT_JULIAN_DAY VARCHAR2 Julian day of towdate represented as Greenwich Mean Time (GMT).
100
GMT_TIME VARCHAR2 Time, represented as Greenwich Mean Time (GMT).
100
TOWDUR NUMBER Duration of tow in minutes.
100
SETDEPTH NUMBER Depth at the time the primary gear is set to fish, to the nearest meter.
100
ENDDEPTH NUMBER Water depth (m) at end of tow.
100
MINDEPTH NUMBER Minimum depth (m) at which gear fished.
100
MAXDEPTH NUMBER Maximum depth at which gear fished.
100
AVGDEPTH NUMBER A four digit number recording the average depth, to the nearest meter, during a survey gear deployment.
100
BEGEKVLOG NUMBER 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.
100
ENDEKVLOG NUMBER 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.
100
BEGLAT NUMBER Beginning latitude of tow (decimal degrees).
100
BEGLON NUMBER Beginning longitude of tow (decimal degrees).
100
ENDLAT NUMBER Latitude at end of tow.
100
ENDLON NUMBER Logitude at end of tow.
100
DECDEG_BEGLAT NUMBER Beginning latitude of tow in decimal degrees.
100
DECDEG_BEGLON NUMBER Beginning longitude of tow in decimal degrees.
100
DECDEG_ENDLAT NUMBER Ending latitide of tow in decimal degrees.
100
DECDEG_ENDLON NUMBER Ending longitude of tow in decimal degrees.
100
LORS1 VARCHAR2 Starting Loran C time delay.
100
LORE1 VARCHAR2 Ending Loran C time delay.
100
LORS2 VARCHAR2 Starting Loran C time delay.
100
LORE2 VARCHAR2 Ending Loran C time delay.
100
CABLE NUMBER Wire out (meters) at the water surface.
100
PITCH NUMBER Pitch of variable pitch propeller.
100
HEADING NUMBER Vessel compass heading.
100
COURSE NUMBER Actual course the vessel made good in degrees.
100
RPM NUMBER Average shaft revolutions per minute while under tow.
100
DOPDISTB NUMBER Speed over bottom recorded by GPS.
100
DOPDISTW NUMBER Speed through water recorded by AMATEK when the water depth is >200m.
100
DESSPEED NUMBER Designated towing speed for a particular gear (knots).
100
GEARID VARCHAR2 Net identification number located on wing of net.
100
DOORID VARCHAR2 Identification number of doors.
100
OTHGEAR VARCHAR2 Code for gear deployed other than primary gear (i.e. net, dredge) such as bongo, Neuston, etc. See SVDBS.OTHGEAR
100
AIRTEMP NUMBER Air temperature (degrees Celsius) rounded to nearest whole degree.
100
CLOUD VARCHAR2 Code to represent percentage of cloud cover. See SVDBS.CLOUD
100
BAROPRESS NUMBER Barometric pressure (millibars).
100
WINDDIR NUMBER Direction of wind during deployment of gear (degrees).
100
WINDSP NUMBER Speed of wind in knots.
100
WEATHER VARCHAR2 Code reflecting weather condition. See SVDBS.WEATHER table
100
WAVEHGT NUMBER Height of waves (m).
100
SWELLDIR NUMBER Swell direction (degrees).
100
SWELLHGT NUMBER Swell height (m).
100
BKTTEMP NUMBER Surface water temperature (degrees Celsius).
100
TRASHAMT NUMBER Volume of trash in liters.
100
TRASHSHL NUMBER Trash by % of shells collected during shellfish surveys.
100
TRASHBIO NUMBER Trash by % of living animals such as fish, starfish and snails colected during shellfish surveys.
100
TRASHSUB NUMBER Trash by % of rocks, pebbles, sand collected during shellfish surveys.
100
XBT VARCHAR2 Code associated with expendable bathythermograph (temperature/depth profile instrument). See SVDBS.XBT
100
SURFTEMP NUMBER Surface temperature of water (degrees Celcius).
100
SURFSALIN NUMBER Salinity at water surface in practical salinity units (PSU).
100
BOTTEMP NUMBER Bottom temperature (degrees Celsius).
100
BOTSALIN NUMBER Bottom salinity in Practical Salinity Units (PSU).
100
FULD NUMBER Fullness of the dredge, measured to the nearest bushel (used on scallop and clam surveys only).
100
NO_DETAIL_SVSPP NUMBER Number of biological data sheets associated with a given station.
100
BOTSPEED NUMBER Speed over bottom (knots) recorded by GPS.
100
WATCH_CHIEF VARCHAR2 Person responsible for smooth conduct of each watch and the collection of data.
100
CHIEF_SCIENTIST VARCHAR2 Person responsible for scientific operations (how and where sampling occurs) and the scientific party.
100
WATCH_CHIEF_COMMENTS VARCHAR2 Watch Chief comment regarding current tow.
100
STATION_COMMENTS VARCHAR2 Comment from the bridge officers.
100
HABITAT_COMMENTS VARCHAR2 Comments on non-coded species found in catch.

Attribute Details

CRUISE6

CC ID: 340099
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

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)

General Data Type: VARCHAR2

CRUISE

CC ID: 340110
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

Unique numerical code for a cruise.

General Data Type: VARCHAR2

STRATUM

CC ID: 340121
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

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.

General Data Type: VARCHAR2

TOW

CC ID: 340132
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Sequential number representing order in which station was selected within a stratum.

General Data Type: VARCHAR2

STATION

CC ID: 340143
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Unique sequential order in which stations have been completed. Hangups and short tows each receive a non-repeated consecutive number.

General Data Type: VARCHAR2

STATUS_CODE

CC ID: 340154
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Code referencing whether or not a cruise is available in the SVDBS system. See SVDBS.SVCRUISE_STATUS.

General Data Type: VARCHAR2

ID

CC ID: 340165
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 72
Required: No
Primary Key: No
Status: Active
Description:

Concatenation of Cruise6, Stratum, Tow and Station values.

General Data Type: VARCHAR2

STATYPE

CC ID: 340176
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

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.

General Data Type: VARCHAR2

HAUL

CC ID: 340187
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Code for relative success of haul. See SVDBS.HAUL_VALUE table

General Data Type: VARCHAR2

GEARCOND

CC ID: 340100
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Refer to SVDBS.GEAR_CONDITION table for gear condition codes and descriptions.

General Data Type: VARCHAR2

SHG

CC ID: 340101
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

Concatenation of Station, Haul and Gear values. See SVDBS.STATION_VALUE, SVDBS.HAUL_VALUE, SVDBS.GEAR_CONDITION

General Data Type: VARCHAR2

TYPE_CODE

CC ID: 340102
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

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.

General Data Type: NUMBER

TYPE_COMMENT

CC ID: 340103
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 1000
Required: No
Primary Key: No
Status: Active
Description:

Comment concerning the Type_Code of the given operation.

General Data Type: VARCHAR2

OPERATION_CODE

CC ID: 340104
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

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.

General Data Type: NUMBER

OPERATION_COMMENT

CC ID: 340105
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 1000
Required: No
Primary Key: No
Status: Active
Description:

Comment concerning Operation Code of given operation (tow duration, vessel speed, scope ration, depth, trawl performance,winch performance, and stratum boundaries.

General Data Type: VARCHAR2

GEAR_CODE

CC ID: 340106
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

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.

General Data Type: NUMBER

GEAR_COMMENT

CC ID: 340107
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 1000
Required: No
Primary Key: No
Status: Active
Description:

Comment concerning gear condition, damage or malfunction of a given operation.

General Data Type: VARCHAR2

ACQUISITION_CODE

CC ID: 340108
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

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).

General Data Type: NUMBER

ACQUISITION_COMMENT

CC ID: 340109
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 1000
Required: No
Primary Key: No
Status: Active
Description:

Comment concerning data acquisition (i.e. SCS data, trawl mensuration, SCS event button press).

General Data Type: VARCHAR2

TOGA

CC ID: 340111
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 8
Scale: 0
Status: Active
Description:

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.

General Data Type: NUMBER

AREA

CC ID: 340112
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Standard area code used for commercial data (New England Statistical Area Code) for the position of the beginning of the tow.

General Data Type: VARCHAR2

SVVESSEL

CC ID: 340113
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Standard two character code for a survey vessel. Refer to SVDBS.SV_VESSEL

General Data Type: VARCHAR2

CRUNUM

CC ID: 340114
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

National Ocean Services (NOS) consecutive cruise number on a particular vessel.

General Data Type: VARCHAR2

SVGEAR

CC ID: 340115
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Code referencing predominant gear type used on a cruise. See SVDBS.SVGEAR table.

General Data Type: VARCHAR2

BEGIN_EST_TOWDATE

CC ID: 340116
Seq. Order: 25
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date and time represented by Eastern Standard Time (EST) for the start of a tow or deployment.

General Data Type: DATE

END_EST_TOWDATE

CC ID: 340117
Seq. Order: 26
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date and time represented by Eastern Standard Time (EST) at the end of a tow or deployment.

General Data Type: DATE

BEGIN_GMT_TOWDATE

CC ID: 340118
Seq. Order: 27
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date and time represented by Greenwich Mean Time (GMT) for the start of a tow or deployment.

General Data Type: DATE

END_GMT_TOWDATE

CC ID: 340119
Seq. Order: 28
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date and time represented by Greenwich Mean Time (GMT) at the end of a tow or deployment.

General Data Type: DATE

EST_YEAR

CC ID: 340120
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Year, represented by Eastern Standard Time (EST).

General Data Type: VARCHAR2

EST_MONTH

CC ID: 340122
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Month, represented by Eastern Standard Time (EST).

General Data Type: VARCHAR2

EST_DAY

CC ID: 340123
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Day of the month represented by Eastern Standard Time (EST).

General Data Type: VARCHAR2

EST_JULIAN_DAY

CC ID: 340124
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Julian day of towdate represented as Eastern Standard Time (EST).

General Data Type: VARCHAR2

EST_TIME

CC ID: 340125
Seq. Order: 33
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Time, represented by Eastern Standard Time (EST).

General Data Type: VARCHAR2

GMT_YEAR

CC ID: 340126
Seq. Order: 34
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Year, represented as Greenwich Mean Time (GMT).

General Data Type: VARCHAR2

GMT_MONTH

CC ID: 340127
Seq. Order: 35
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Month, represented as Greenwich Mean Time (GMT).

General Data Type: VARCHAR2

GMT_DAY

CC ID: 340128
Seq. Order: 36
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Day of the month, represented as Greenwich Mean Time (GMT).

General Data Type: VARCHAR2

GMT_JULIAN_DAY

CC ID: 340129
Seq. Order: 37
Data Storage Type: VARCHAR2
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Julian day of towdate represented as Greenwich Mean Time (GMT).

General Data Type: VARCHAR2

GMT_TIME

CC ID: 340130
Seq. Order: 38
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Time, represented as Greenwich Mean Time (GMT).

General Data Type: VARCHAR2

TOWDUR

CC ID: 340131
Seq. Order: 39
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 2
Status: Active
Description:

Duration of tow in minutes.

General Data Type: NUMBER

SETDEPTH

CC ID: 340133
Seq. Order: 40
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Depth at the time the primary gear is set to fish, to the nearest meter.

General Data Type: NUMBER

ENDDEPTH

CC ID: 340134
Seq. Order: 41
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Water depth (m) at end of tow.

General Data Type: NUMBER

MINDEPTH

CC ID: 340135
Seq. Order: 42
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Minimum depth (m) at which gear fished.

General Data Type: NUMBER

MAXDEPTH

CC ID: 340136
Seq. Order: 43
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Maximum depth at which gear fished.

General Data Type: NUMBER

AVGDEPTH

CC ID: 340137
Seq. Order: 44
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

A four digit number recording the average depth, to the nearest meter, during a survey gear deployment.

General Data Type: NUMBER

BEGEKVLOG

CC ID: 340138
Seq. Order: 45
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 8
Scale: 3
Status: Active
Description:

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.

General Data Type: NUMBER

ENDEKVLOG

CC ID: 340139
Seq. Order: 46
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 8
Scale: 3
Status: Active
Description:

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.

General Data Type: NUMBER

BEGLAT

CC ID: 340140
Seq. Order: 47
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 9
Scale: 4
Status: Active
Description:

Beginning latitude of tow (decimal degrees).

General Data Type: NUMBER

BEGLON

CC ID: 340141
Seq. Order: 48
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 9
Scale: 4
Status: Active
Description:

Beginning longitude of tow (decimal degrees).

General Data Type: NUMBER

ENDLAT

CC ID: 340142
Seq. Order: 49
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 9
Scale: 4
Status: Active
Description:

Latitude at end of tow.

General Data Type: NUMBER

ENDLON

CC ID: 340144
Seq. Order: 50
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 9
Scale: 4
Status: Active
Description:

Logitude at end of tow.

General Data Type: NUMBER

DECDEG_BEGLAT

CC ID: 340145
Seq. Order: 51
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 10
Scale: 6
Status: Active
Description:

Beginning latitude of tow in decimal degrees.

General Data Type: NUMBER

DECDEG_BEGLON

CC ID: 340146
Seq. Order: 52
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 10
Scale: 6
Status: Active
Description:

Beginning longitude of tow in decimal degrees.

General Data Type: NUMBER

DECDEG_ENDLAT

CC ID: 340147
Seq. Order: 53
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 10
Scale: 6
Status: Active
Description:

Ending latitide of tow in decimal degrees.

General Data Type: NUMBER

DECDEG_ENDLON

CC ID: 340148
Seq. Order: 54
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 10
Scale: 6
Status: Active
Description:

Ending longitude of tow in decimal degrees.

General Data Type: NUMBER

LORS1

CC ID: 340149
Seq. Order: 55
Data Storage Type: VARCHAR2
Max Length: 9
Required: No
Primary Key: No
Status: Active
Description:

Starting Loran C time delay.

General Data Type: VARCHAR2

LORE1

CC ID: 340150
Seq. Order: 56
Data Storage Type: VARCHAR2
Max Length: 9
Required: No
Primary Key: No
Status: Active
Description:

Ending Loran C time delay.

General Data Type: VARCHAR2

LORS2

CC ID: 340151
Seq. Order: 57
Data Storage Type: VARCHAR2
Max Length: 9
Required: No
Primary Key: No
Status: Active
Description:

Starting Loran C time delay.

General Data Type: VARCHAR2

LORE2

CC ID: 340152
Seq. Order: 58
Data Storage Type: VARCHAR2
Max Length: 9
Required: No
Primary Key: No
Status: Active
Description:

Ending Loran C time delay.

General Data Type: VARCHAR2

CABLE

CC ID: 340153
Seq. Order: 59
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Wire out (meters) at the water surface.

General Data Type: NUMBER

PITCH

CC ID: 340155
Seq. Order: 60
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Pitch of variable pitch propeller.

General Data Type: NUMBER

HEADING

CC ID: 340156
Seq. Order: 61
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 1
Status: Active
Description:

Vessel compass heading.

General Data Type: NUMBER

COURSE

CC ID: 340157
Seq. Order: 62
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 1
Status: Active
Description:

Actual course the vessel made good in degrees.

General Data Type: NUMBER

RPM

CC ID: 340158
Seq. Order: 63
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Average shaft revolutions per minute while under tow.

General Data Type: NUMBER

DOPDISTB

CC ID: 340159
Seq. Order: 64
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 3
Status: Active
Description:

Speed over bottom recorded by GPS.

General Data Type: NUMBER

DOPDISTW

CC ID: 340160
Seq. Order: 65
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 3
Status: Active
Description:

Speed through water recorded by AMATEK when the water depth is >200m.

General Data Type: NUMBER

DESSPEED

CC ID: 340161
Seq. Order: 66
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 1
Status: Active
Description:

Designated towing speed for a particular gear (knots).

General Data Type: NUMBER

GEARID

CC ID: 340162
Seq. Order: 67
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Net identification number located on wing of net.

General Data Type: VARCHAR2

DOORID

CC ID: 340163
Seq. Order: 68
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Identification number of doors.

General Data Type: VARCHAR2

OTHGEAR

CC ID: 340164
Seq. Order: 69
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Code for gear deployed other than primary gear (i.e. net, dredge) such as bongo, Neuston, etc. See SVDBS.OTHGEAR

General Data Type: VARCHAR2

AIRTEMP

CC ID: 340166
Seq. Order: 70
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 2
Status: Active
Description:

Air temperature (degrees Celsius) rounded to nearest whole degree.

General Data Type: NUMBER

CLOUD

CC ID: 340167
Seq. Order: 71
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Code to represent percentage of cloud cover. See SVDBS.CLOUD

General Data Type: VARCHAR2

BAROPRESS

CC ID: 340168
Seq. Order: 72
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 1
Status: Active
Description:

Barometric pressure (millibars).

General Data Type: NUMBER

WINDDIR

CC ID: 340169
Seq. Order: 73
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 1
Status: Active
Description:

Direction of wind during deployment of gear (degrees).

General Data Type: NUMBER

WINDSP

CC ID: 340170
Seq. Order: 74
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 1
Status: Active
Description:

Speed of wind in knots.

General Data Type: NUMBER

WEATHER

CC ID: 340171
Seq. Order: 75
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Code reflecting weather condition. See SVDBS.WEATHER table

General Data Type: VARCHAR2

WAVEHGT

CC ID: 340172
Seq. Order: 76
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 2
Status: Active
Description:

Height of waves (m).

General Data Type: NUMBER

SWELLDIR

CC ID: 340173
Seq. Order: 77
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Swell direction (degrees).

General Data Type: NUMBER

SWELLHGT

CC ID: 340174
Seq. Order: 78
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 2
Status: Active
Description:

Swell height (m).

General Data Type: NUMBER

BKTTEMP

CC ID: 340175
Seq. Order: 79
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 3
Status: Active
Description:

Surface water temperature (degrees Celsius).

General Data Type: NUMBER

TRASHAMT

CC ID: 340177
Seq. Order: 80
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Volume of trash in liters.

General Data Type: NUMBER

TRASHSHL

CC ID: 340178
Seq. Order: 81
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Trash by % of shells collected during shellfish surveys.

General Data Type: NUMBER

TRASHBIO

CC ID: 340179
Seq. Order: 82
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Trash by % of living animals such as fish, starfish and snails colected during shellfish surveys.

General Data Type: NUMBER

TRASHSUB

CC ID: 340180
Seq. Order: 83
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Trash by % of rocks, pebbles, sand collected during shellfish surveys.

General Data Type: NUMBER

XBT

CC ID: 340181
Seq. Order: 84
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code associated with expendable bathythermograph (temperature/depth profile instrument). See SVDBS.XBT

General Data Type: VARCHAR2

SURFTEMP

CC ID: 340182
Seq. Order: 85
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 3
Status: Active
Description:

Surface temperature of water (degrees Celcius).

General Data Type: NUMBER

SURFSALIN

CC ID: 340183
Seq. Order: 86
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 3
Status: Active
Description:

Salinity at water surface in practical salinity units (PSU).

General Data Type: NUMBER

BOTTEMP

CC ID: 340184
Seq. Order: 87
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 3
Status: Active
Description:

Bottom temperature (degrees Celsius).

General Data Type: NUMBER

BOTSALIN

CC ID: 340185
Seq. Order: 88
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 3
Status: Active
Description:

Bottom salinity in Practical Salinity Units (PSU).

General Data Type: NUMBER

FULD

CC ID: 340186
Seq. Order: 89
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Fullness of the dredge, measured to the nearest bushel (used on scallop and clam surveys only).

General Data Type: NUMBER

NO_DETAIL_SVSPP

CC ID: 340188
Seq. Order: 90
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Number of biological data sheets associated with a given station.

General Data Type: NUMBER

BOTSPEED

CC ID: 340189
Seq. Order: 91
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 1
Status: Active
Description:

Speed over bottom (knots) recorded by GPS.

General Data Type: NUMBER

WATCH_CHIEF

CC ID: 340190
Seq. Order: 92
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Person responsible for smooth conduct of each watch and the collection of data.

General Data Type: VARCHAR2

CHIEF_SCIENTIST

CC ID: 340191
Seq. Order: 93
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Person responsible for scientific operations (how and where sampling occurs) and the scientific party.

General Data Type: VARCHAR2

WATCH_CHIEF_COMMENTS

CC ID: 340192
Seq. Order: 94
Data Storage Type: VARCHAR2
Max Length: 500
Required: No
Primary Key: No
Status: Active
Description:

Watch Chief comment regarding current tow.

General Data Type: VARCHAR2

STATION_COMMENTS

CC ID: 340193
Seq. Order: 95
Data Storage Type: VARCHAR2
Max Length: 500
Required: No
Primary Key: No
Status: Active
Description:

Comment from the bridge officers.

General Data Type: VARCHAR2

HABITAT_COMMENTS

CC ID: 340194
Seq. Order: 96
Data Storage Type: VARCHAR2
Max Length: 500
Required: No
Primary Key: No
Status: Active
Description:

Comments on non-coded species found in catch.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 33824
GUID: gov.noaa.nmfs.inport:33824
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-07-29 11:48+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2019-05-31
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2019-05-31
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2020-05-31