33610
Table: UNION_FSCS_SVSTA
UNION_FSCS_SVSTA
Entity
Published / External
22561
Spring Bottom Trawl Survey
Data Set
Completed
Materialized view joining pre-FSCS and FSCS data sets into one structure. Contains station data for each station.
Loaded by batch 9071, 07-28-2016 11:53
Data Table
Yes
SVDBS
Materialized view joining pre-FSCS and FSCS data sets into one structure. Contains station data for each station.
1
CRUISE6
VARCHAR2
6
No
No
Active
Code uniquely identifying cruise. The first four digits indicate the year and the last two digit uniquely identify the cruise within the year. The 5th byte signifies cruises other than groundfish: Shrimp survey = 7 (i.e. 201470), State of Massachusetts survey = 9 (i.e. 201491), Food habits = 5 (i.e.199554)
VARCHAR2
2
CRUISE
VARCHAR2
6
No
No
Active
Unique numerical code for a cruise.
VARCHAR2
3
STRATUM
VARCHAR2
5
No
No
Active
A predefined area where a net dredge, or other piece of gear was deployed. Code consists of 2 parts: Stratum group code number (2 bytes) and stratum number (3 bytes). Stratum group refers to if area fished is inshore or offshore North or South of Cape Hatteras or the type of cruise (shellfish, State of MA, offshore deepwater). The stratum number (third and fourth digits of code) refers to area defined by depth zone. See SVDBS.SVMSTRATA. The fifth digit of the code increases the length of the stratum number for revised strata after the Hague Line was established. Stratum group code: 01 = Trawl, offshore north of Hatteras; 02 = BIOM; 03 = Trawl, inshore north of Hatteras; 04 = Shrimp; 05 = Scotian shelf; 06 = Shellfish; 07 = Trawl, inshore south of Hatteras; 08 = Trawl, Offshore south of Hatteras; 09 = MA DMF; 99 = Offshore deepwater (outside the stratified area). A change in Bottom Trawl Stratum for the Gulf of Maine-Bay of Fundy has been in effect since Spring 1987, and may be summarized as follows: Previous strata: 01350; Present strata: 01351, 01352.
VARCHAR2
4
TOW
VARCHAR2
3
No
No
Active
Sequential number representing order in which station was selected within a stratum.
VARCHAR2
5
STATION
VARCHAR2
4
No
No
Active
Unique sequential order in which stations have been completed. Hangups and short tows each receive a non-repeated consecutive number.
VARCHAR2
6
STATUS_CODE
VARCHAR2
2
No
No
Active
Code referencing whether or not a cruise is available in the SVDBS system. See SVDBS.SVCRUISE_STATUS.
VARCHAR2
7
ID
VARCHAR2
72
No
No
Active
Concatenation of Cruise6, Stratum, Tow and Station values.
VARCHAR2
8
STATYPE
VARCHAR2
4
No
No
Active
Code designating type of tow being performed (e.g. random vs. nonrandom tows). See SVDBS.STATION_VALUE table for all statype codes and their descriptions.
VARCHAR2
9
HAUL
VARCHAR2
4
No
No
Active
Code for relative success of haul. See SVDBS.HAUL_VALUE table
VARCHAR2
10
GEARCOND
VARCHAR2
4
No
No
Active
Refer to SVDBS.GEAR_CONDITION table for gear condition codes and descriptions.
VARCHAR2
11
SHG
VARCHAR2
12
No
No
Active
Concatenation of Station, Haul and Gear values. See SVDBS.STATION_VALUE, SVDBS.HAUL_VALUE, SVDBS.GEAR_CONDITION
VARCHAR2
12
TYPE_CODE
NUMBER
22
No
No
2
0
Active
Code concerning station details. This defines the type of sampling conducted at each station. Standard NEFSC BTS tows are coded with a T value = 1. The T value=1 is subdivided into 6 components: 1- Random Tow, within 1nm Radius; 1- Random Tow, outside 1nm, within 3nm Radius; 1- Repeat Tow; 1- Random Altername; 1- Random Offshore Continental Shelf; 1- Altername Offshore Protocol. Tow types other than NEFSC BTS standard random tows are defined by the following code values: 2- Non-Random Tow - Tow is not conducted according a random and stratified statistical design. Tow must follow NEFSC BTS protocols.; 3- Survey Standardization - Tow conducted to evaluate NEFSC BTS standardization (i.e. gear testing); 4- Comparison Tow - Tow conducted in comparison of other gears, surveys, vessels or operating procedures ; 5- Aborted Tow - Gear set but timed tow duration never started (aborted tow); 6- Site Specific - Non-random tow conducted in a specific, targeted region; 7- Experimental Survey Design - Survey design type other than random and stratified (i.e. transect, depletion study, grid, fixed etc.); 8 Other - Tows that do not fall into the previous categories. Detailed description of the tow type shall be recorded.
NUMBER
13
TYPE_COMMENT
VARCHAR2
1000
No
No
Active
Comment concerning the Type_Code of the given operation.
VARCHAR2
14
OPERATION_CODE
NUMBER
22
No
No
2
0
Active
Code to define tow in terms of the operational characteristics (i.e. tow duration, vessel speed, scope ratio, depth, trawl perf., winch perf., stratum boundaries. O-Value= 4 is considered non-valid. Tow should be repeated, when possible, at the discretion of Chief Scientist. 1- Good Performance - All operational parameters are within optimal tol.range.2- Representative - Tow dur. 18.00min 19.49min or 20.50min-21.00min; 75-99% on-bottom tow dist. within the correct stratum; Door Spread mean outside optimal but within tol. limit. Wing Spread mean outside optimal but within tolerance limit. (Door and Wing spread are depth dependant calcs.); Headrope Height mean outside optimal but within the tolerance limit(Optimal Height is 3.2-4.1m.3- Representative - Tow dur. 16.00min -17.99min; Acqu. Code Value = 4 (details given with A code); Door Spread Std Deviation High (greater than 4.5m);Wing Spread Std Deviation High (> than 2.0m; Headrope Ht Spread Std Deviation High (Greater than 1.0m; Scope Ratio outside tolerance limit. (+/- 25%)4- Non Representative - Tow dur. < than 16.00min or > than 21.00min; Tow distance < than 0.8nm or > than 1.05nm; Door Spread mean outside tol. limit. (Depth dependant); Wing Spread mean outside tol. limit.(Depth dependant); Headrope Height mean outside tol. limit. (Less than 2.7m or greater than 4.7m); SOG mean outside tol. limit. (Less than 2.6 or greater than 3.4kts); Depth mean outside tol. limit. (EK6018kHz, must be within +/- 10% of set depth, or +/-5m at depths less than 50m); Mean Starboard and Mean Port Block Tension not equalized within ±0.5t; Diff. between mean Starboard and Port Winch calculated wire out lengths greater than 10m; Diff. between mean STBD and Port Block wire out lengths greater than 10m; Less than 75% of on-bottom tow distance within correct stratum; Trawl Depth > than 20% difference of vessel tow depth; Chief Scientist or Watch Chief Failed tow- tow considered unsatisfactory based on vessel or gear performance.
NUMBER
15
OPERATION_COMMENT
VARCHAR2
1000
No
No
Active
Comment concerning Operation Code of given operation (tow duration, vessel speed, scope ration, depth, trawl performance,winch performance, and stratum boundaries.
VARCHAR2
16
GEAR_CODE
NUMBER
22
No
No
2
0
Active
Gear condition code.Gear defined as trawl net,cod-end,liner,sweep,doors & rigging. Valid Gear values =1,2,4(no code 3).1-Good Tow- No damage to webbing, frame ropes, sweep doors or rigging. Trawl properly rigged and considered to be in standard configuration. 2- Representative- Minor Small Holes/Tears in webbing (incl. cod-end and liner).Tears easily repaired coded 2. Larger holes/tears in Jibs,Wings,Bunts,Square or 1st & 2nd Top Bellies.Hole not thought to sig. alter fish capture.Obstr. in/on gear, not thought to signif. alter fish capture Minor Hang;No signif. gear damage;Hang,after 16.00min tow dur.;Tow dur. adjust to time hang occurred;Insignif. sweep damage (i.e. slight damage to rockhoppers not thought to increase fish escapement);Loss or damage to < than 12 floats; Very large catch;Deck tow of dogfish or other species;Other gear damage/malfunction not thought to significantly alter fish capture.4-Non_Representative -Signif. holes/tears/large holes in bottom bellies, or any portion of webbing aft of 2nd belly;Major Gear Damage(i.e. rim-rack, whole sections torn out,loss of trawl door(s) etc.);Open Cod-end;Improperly Attached Liner OR Open Liner OR Signif. Catch Outside Liner;Twisted Wing(s);Signif. Loss of bottom contacts (4min duration or longer).Improper Rigging;Collapsed Doors;Crossed Doors;Major Sweep Damage. (Parted sweep and/or major damage(i.e. loss of more than one rockhopper, or damage to sweep components thought to significantly increase fish escapement. Damaged Frame Rope(s)(headrope,up&down line,bolshline);Open Gore;Twisted or Crossed Bridle(s); Parted Legs;Loss/damage to 12 or > floats;Signif. damage to wing-end extension (i.e. loss, broken or altered length).Signif. Hang. Occurring at <16.00min tow dur.(OR unknown tow dur.;Large obstr. IN/ON gear thought to alter catch effic. or trawl geom.(i.e. pot stuck in front opening of cod-end. Catch not landed on deck;Damage to main towing cable(s);Other gear dam./malf. signif. altering catch efficiency.
NUMBER
17
GEAR_COMMENT
VARCHAR2
1000
No
No
Active
Comment concerning gear condition, damage or malfunction of a given operation.
VARCHAR2
18
ACQUISITION_CODE
NUMBER
22
No
No
2
0
Active
Code concerning data acquisition (i.e. SCS data, trawl mens., SCS event button press).1- No Data Acq Errors. All data acq 75% or greater valid.2- Representative: Door Spread 50.00% - 74.99% data acq.;Wing Spread 50.00% - 74.99% data acq.;Height 50.00% - 74.99% data acq.;Trawl Depth 50.00% - 74.99% data acq.;Winch Tension 50.00% - 74.99% data acq.;Winch Wire Out 50.00% - 74.99% data acq.;Block Tension 50.00% - 74.99% data acq.;Block Wire Out 50.00% - 74.99% data acq.;Speed Over Ground 50.00% - 74.99% data acq.;Vessel Depth 50.00% - 74.99% data acq.;GPS 50.00% - 74.99% data acq.;3-Representative: Door Spread 25.00% - 49.99% data acq.;Wing Spread 25.00% - 49.99% data acq.;Height 25.00% - 49.99% data acq.;Trawl Depth 25.00% - 49.99% data acq.;Winch Tension 25.00% - 49.99% data acq.;Winch Wire Out 25.00% - 49.99% data acq.;Block Tension 25.00% - 49.99% data acq.;Block Wire Out 25.00% - 49.99% data acq.;Speed Over Ground 25.00% - 49.99% data acq.;Vessel Depth 25.00% - 49.99% data acq.;GPS 25.00% - 49.99% data acquisition.4- Non_Representative: Door Spread Less Than 25.00% data acq.;Wing Spread Less Than 25.00% data acq.;Height Less Than 25.00% data acq.;Trawl Depth Less Than 25.00% data acq.;Winch Tension Less Than 25.00% data acq.;Winch Wire Out Less Than 25.00% data acq.;Block Tension Less Than 25.00% data acq.;Block Wire Out Less Than 25.00% data acq.;Speed Over Ground Less Than 25.00% data acq.;Vessel Depth Less Than 25.00% data acq.;GPS Less Than 25.00% data acq.;Error Recording Event Data. Trawl event data missing.;Critical Button Press Error, Unknown Event Time(s).
NUMBER
19
ACQUISITION_COMMENT
VARCHAR2
1000
No
No
Active
Comment concerning data acquisition (i.e. SCS data, trawl mensuration, SCS event button press).
VARCHAR2
20
TOGA
NUMBER
22
No
No
8
0
Active
A concatentation of the T, O, G and A codes assigned to an operation. Each standard survey tow is evaluated based on four categories, Type, Operational, Gear and Acquisition (T.O.G.A.). Type (T), Operational (O) and Gear (G) categories are used to validate each tow; the Acquisition (A) category is additional information not used for validation. T.O.G.A. is a detailed analysis of survey trawl and vessel performance during each tow, utilizing available data from trawl mensuration systems and vessel sensors not previously analyzed by the historical Station, Haul, and Gear (S.H.G.) coding system.
NUMBER
21
AREA
VARCHAR2
3
No
No
Active
Standard area code used for commercial data (New England Statistical Area Code) for the position of the beginning of the tow.
VARCHAR2
22
SVVESSEL
VARCHAR2
2
No
No
Active
Standard two character code for a survey vessel. Refer to SVDBS.SV_VESSEL
VARCHAR2
23
CRUNUM
VARCHAR2
8
No
No
Active
National Ocean Services (NOS) consecutive cruise number on a particular vessel.
VARCHAR2
24
SVGEAR
VARCHAR2
8
No
No
Active
Code referencing predominant gear type used on a cruise. See SVDBS.SVGEAR table.
VARCHAR2
25
BEGIN_EST_TOWDATE
DATE
7
No
No
Active
Date and time represented by Eastern Standard Time (EST) for the start of a tow or deployment.
DATE
26
END_EST_TOWDATE
DATE
7
No
No
Active
Date and time represented by Eastern Standard Time (EST) at the end of a tow or deployment.
DATE
27
BEGIN_GMT_TOWDATE
DATE
7
No
No
Active
Date and time represented by Greenwich Mean Time (GMT) for the start of a tow or deployment.
DATE
28
END_GMT_TOWDATE
DATE
7
No
No
Active
Date and time represented by Greenwich Mean Time (GMT) at the end of a tow or deployment.
DATE
29
EST_YEAR
VARCHAR2
4
No
No
Active
Year, represented by Eastern Standard Time (EST).
VARCHAR2
30
EST_MONTH
VARCHAR2
2
No
No
Active
Month, represented by Eastern Standard Time (EST).
VARCHAR2
31
EST_DAY
VARCHAR2
2
No
No
Active
Day of the month represented by Eastern Standard Time (EST).
VARCHAR2
32
EST_JULIAN_DAY
VARCHAR2
7
No
No
Active
Julian day of towdate represented as Eastern Standard Time (EST).
VARCHAR2
33
EST_TIME
VARCHAR2
8
No
No
Active
Time, represented by Eastern Standard Time (EST).
VARCHAR2
34
GMT_YEAR
VARCHAR2
4
No
No
Active
Year, represented as Greenwich Mean Time (GMT).
VARCHAR2
35
GMT_MONTH
VARCHAR2
2
No
No
Active
Month, represented as Greenwich Mean Time (GMT).
VARCHAR2
36
GMT_DAY
VARCHAR2
2
No
No
Active
Day of the month, represented as Greenwich Mean Time (GMT).
VARCHAR2
37
GMT_JULIAN_DAY
VARCHAR2
7
No
No
Active
Julian day of towdate represented as Greenwich Mean Time (GMT).
VARCHAR2
38
GMT_TIME
VARCHAR2
8
No
No
Active
Time, represented as Greenwich Mean Time (GMT).
VARCHAR2
39
TOWDUR
NUMBER
22
No
No
5
2
Active
Duration of tow in minutes.
NUMBER
40
SETDEPTH
NUMBER
22
No
No
4
0
Active
Depth at the time the primary gear is set to fish, to the nearest meter.
NUMBER
41
ENDDEPTH
NUMBER
22
No
No
4
0
Active
Water depth (m) at end of tow.
NUMBER
42
MINDEPTH
NUMBER
22
No
No
4
0
Active
Minimum depth (m) at which gear fished.
NUMBER
43
MAXDEPTH
NUMBER
22
No
No
4
0
Active
Maximum depth at which gear fished.
NUMBER
44
AVGDEPTH
NUMBER
22
No
No
4
0
Active
A four digit number recording the average depth, to the nearest meter, during a survey gear deployment.
NUMBER
45
BEGEKVLOG
NUMBER
22
No
No
8
3
Active
An eight digit number measuring to the nearest thousandth of a nautical mile (e.g., 14564.345). Used to mark the beginning of a survey trawl for acoustic data purposes.
NUMBER
46
ENDEKVLOG
NUMBER
22
No
No
8
3
Active
An eight digit number measuring to the nearest thousandth of a nautical mile (e.g., 14564.345). Used to mark the end of a survey trawl for acoustic data purposes.
NUMBER
47
BEGLAT
NUMBER
22
No
No
9
4
Active
Beginning latitude of tow (decimal minutes).
NUMBER
48
BEGLON
NUMBER
22
No
No
9
4
Active
Beginning longitude of tow (decimal minutes).
NUMBER
49
ENDLAT
NUMBER
22
No
No
9
4
Active
Latitude at end of tow (decimal minutes).
NUMBER
50
ENDLON
NUMBER
22
No
No
9
4
Active
Longitude at end of tow (decimal minutes).
NUMBER
51
DECDEG_BEGLAT
NUMBER
22
No
No
10
6
Active
Beginning latitude of tow in decimal degrees.
NUMBER
52
DECDEG_BEGLON
NUMBER
22
No
No
10
6
Active
Beginning longitude of tow in decimal degrees.
NUMBER
53
DECDEG_ENDLAT
NUMBER
22
No
No
10
6
Active
Ending latitide of tow in decimal degrees.
NUMBER
54
DECDEG_ENDLON
NUMBER
22
No
No
10
6
Active
Ending longitude of tow in decimal degrees.
NUMBER
55
LORS1
VARCHAR2
9
No
No
Active
Starting Loran C time delay.
VARCHAR2
56
LORE1
VARCHAR2
9
No
No
Active
Ending Loran C time delay.
VARCHAR2
57
LORS2
VARCHAR2
9
No
No
Active
Starting Loran C time delay.
VARCHAR2
58
LORE2
VARCHAR2
9
No
No
Active
Ending Loran C time delay.
VARCHAR2
59
CABLE
NUMBER
22
No
No
5
0
Active
Wire out (meters) at the water surface.
NUMBER
60
PITCH
NUMBER
22
No
No
3
0
Active
Pitch of variable pitch propeller.
NUMBER
61
HEADING
NUMBER
22
No
No
4
1
Active
Vessel compass heading.
NUMBER
62
COURSE
NUMBER
22
No
No
4
1
Active
Actual course the vessel made good in degrees.
NUMBER
63
RPM
NUMBER
22
No
No
3
0
Active
Average shaft revolutions per minute while under tow.
NUMBER
64
DOPDISTB
NUMBER
22
No
No
5
3
Active
Distance traveled, in nautical miles, between the start and stop of the gear deployment event.
NUMBER
nm
65
DOPDISTW
NUMBER
22
No
No
5
3
Active
Distance traveled, in nautical miles, between the start and stop of the gear deployment using doppler through the water. This is a deprecated field, and only collected prior to 1993.
NUMBER
nm
66
DESSPEED
NUMBER
22
No
No
2
1
Active
Designated towing speed for a particular gear (knots).
NUMBER
67
GEARID
VARCHAR2
2
No
No
Active
Net identification number located on wing of net.
VARCHAR2
68
DOORID
VARCHAR2
2
No
No
Active
Identification number of doors.
VARCHAR2
69
OTHGEAR
VARCHAR2
4
No
No
Active
Code for gear deployed other than primary gear (i.e. net, dredge) such as bongo, Neuston, etc. See SVDBS.OTHGEAR
VARCHAR2
70
AIRTEMP
NUMBER
22
No
No
5
2
Active
Air temperature (degrees Celsius) rounded to nearest whole degree.
NUMBER
71
CLOUD
VARCHAR2
3
No
No
Active
Code to represent percentage of cloud cover. See SVDBS.CLOUD
VARCHAR2
72
BAROPRESS
NUMBER
22
No
No
5
1
Active
Barometric pressure (millibars).
NUMBER
73
WINDDIR
NUMBER
22
No
No
4
1
Active
Direction of wind during deployment of gear (degrees).
NUMBER
74
WINDSP
NUMBER
22
No
No
4
1
Active
Speed of wind in knots.
NUMBER
75
WEATHER
VARCHAR2
3
No
No
Active
Code reflecting weather condition. See SVDBS.WEATHER table
VARCHAR2
76
WAVEHGT
NUMBER
22
No
No
4
2
Active
Height of waves (m).
NUMBER
77
SWELLDIR
NUMBER
22
No
No
3
0
Active
Swell direction (degrees).
NUMBER
78
SWELLHGT
NUMBER
22
No
No
4
2
Active
Swell height (m).
NUMBER
79
BKTTEMP
NUMBER
22
No
No
6
3
Active
Surface water temperature (degrees Celsius).
NUMBER
80
TRASHAMT
NUMBER
22
No
No
4
0
Active
Volume of trash in liters.
NUMBER
81
TRASHSHL
NUMBER
22
No
No
3
0
Active
Trash by % of shells collected during shellfish surveys.
NUMBER
82
TRASHBIO
NUMBER
22
No
No
3
0
Active
Trash by % of living animals such as fish, starfish and snails colected during shellfish surveys.
NUMBER
83
TRASHSUB
NUMBER
22
No
No
3
0
Active
Trash by % of rocks, pebbles, sand collected during shellfish surveys.
NUMBER
84
XBT
VARCHAR2
1
No
No
Active
Code associated with expendable bathythermograph (temperature/depth profile instrument). See SVDBS.XBT
VARCHAR2
85
SURFTEMP
NUMBER
22
No
No
6
3
Active
Surface temperature of water (degrees Celcius).
NUMBER
86
SURFSALIN
NUMBER
22
No
No
6
3
Active
Salinity at water surface in practical salinity units (PSU).
NUMBER
87
BOTTEMP
NUMBER
22
No
No
6
3
Active
Bottom temperature (degrees Celsius).
NUMBER
88
BOTSALIN
NUMBER
22
No
No
6
3
Active
Bottom salinity in Practical Salinity Units (PSU).
NUMBER
89
FULD
NUMBER
22
No
No
3
0
Active
Fullness of the dredge, measured to the nearest bushel (used on scallop and clam surveys only).
NUMBER
90
NO_DETAIL_SVSPP
NUMBER
22
No
No
4
0
Active
Number of biological data sheets associated with a given station.
NUMBER
91
BOTSPEED
NUMBER
22
No
No
3
1
Active
Speed over bottom (knots) recorded by GPS.
NUMBER
94
WATCH_CHIEF_COMMENTS
VARCHAR2
500
No
No
Active
Watch Chief comment regarding current tow.
VARCHAR2
95
STATION_COMMENTS
VARCHAR2
500
No
No
Active
Comment from the bridge officers.
VARCHAR2
96
HABITAT_COMMENTS
VARCHAR2
500
No
No
Active
Comments on non-coded species found in catch.
VARCHAR2
gov.noaa.nmfs.inport:33610
Patricia Jones
2016-07-28T11:53:42
Paul Kostovick
2023-01-25T16:30:04
2019-05-31
Northeast Fisheries Science Center
NEFSC
166 Water Street
Woods Hole
MA
02543-1026
USA
(508)495-2000
http://www.nefsc.noaa.gov
8:00 a.m. to 4:30 p.m. Monday - Friday
1001
Public
No
2019-05-31
1 Year
2020-05-31