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 9078, 07-28-2016 12:36

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: 336942
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: 336953
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: 336964
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: 336975
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: 336986
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: 336997
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: 337008
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: 337019
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: 337030
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: 336943
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: 336944
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: 336945
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: 336946
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: 336947
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: 336948
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: 336949
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: 336950
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: 336951
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: 336952
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: 336954
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: 336955
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: 336956
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: 336957
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: 336958
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: 336959
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: 336960
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: 336961
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: 336962
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: 336963
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: 336965
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: 336966
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: 336967
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: 336968
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: 336969
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: 336970
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: 336971
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: 336972
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: 336973
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: 336974
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: 336976
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: 336977
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: 336978
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: 336979
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: 336980
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: 336981
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: 336982
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: 336983
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: 336984
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: 336985
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: 336987
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: 336988
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: 336989
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: 336990
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: 336991
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: 336992
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: 336993
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: 336994
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: 336995
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: 336996
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: 336998
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: 336999
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: 337000
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: 337001
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: 337002
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: 337003
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: 337004
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: 337005
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: 337006
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: 337007
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: 337009
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: 337010
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: 337011
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: 337012
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: 337013
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: 337014
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: 337015
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: 337016
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: 337017
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: 337018
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: 337020
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: 337021
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: 337022
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: 337023
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: 337024
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: 337025
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: 337026
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: 337027
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: 337028
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: 337029
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: 337031
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: 337032
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: 337033
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: 337034
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: 337035
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: 337036
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: 337037
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: 33646
GUID: gov.noaa.nmfs.inport:33646
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-07-28 12:36+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