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

Summary

Abstract

Materialized view joining entities that store data from 1963 - 2000 (paper log collected data) and 2001 - present (digitally acquired data sets) into a single time-series.

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)
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.
ID
VARCHAR2
Concatenation of Cruise6, Stratum, Tow and Station values.
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.
BEGLAT
NUMBER
Beginning latitude of tow (decimal minutes).
BEGLON
NUMBER
Beginning longitude of tow (decimal minutes).
ENDLAT
NUMBER
Latitude at end of tow (decimal minutes).
ENDLON
NUMBER
Longitude at end of tow (decimal minutes)
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.
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
Distance traveled, in nautical miles, between the start and stop of the gear deployment event.
DOPDISTW
NUMBER
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.
DESSPEED
NUMBER
Designated towing speed for a particular gear (knots).
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_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 entities that store data from 1963 - 2000 (paper log collected data) and 2001 - present (digitally acquired data sets) into a single time-series.

Notes:

Loaded by batch 9070, 07-28-2016 11:11

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
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
ID VARCHAR2 Concatenation of Cruise6, Stratum, Tow and Station values.
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
BEGLAT NUMBER Beginning latitude of tow (decimal minutes).
100
BEGLON NUMBER Beginning longitude of tow (decimal minutes).
100
ENDLAT NUMBER Latitude at end of tow (decimal minutes).
100
ENDLON NUMBER Longitude at end of tow (decimal minutes)
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
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 Distance traveled, in nautical miles, between the start and stop of the gear deployment event.
100
DOPDISTW NUMBER 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.
100
DESSPEED NUMBER Designated towing speed for a particular gear (knots).
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_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: 335712
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

STRATUM

CC ID: 335734
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: 335745
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: 335756
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

ID

CC ID: 335778
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

AREA

CC ID: 335725
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: 335726
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: 335727
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: 335728
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: 335729
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: 335730
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: 335731
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: 335732
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: 335733
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: 335735
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: 335736
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: 335737
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: 335738
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: 335739
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: 335740
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: 335741
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: 335742
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: 335743
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: 335744
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: 335746
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: 335747
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: 335748
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: 335749
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: 335750
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

BEGLAT

CC ID: 335753
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 minutes).

General Data Type: NUMBER

BEGLON

CC ID: 335754
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 minutes).

General Data Type: NUMBER

ENDLAT

CC ID: 335755
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 (decimal minutes).

General Data Type: NUMBER

ENDLON

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

Longitude at end of tow (decimal minutes)

General Data Type: NUMBER

DECDEG_BEGLAT

CC ID: 335758
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: 335759
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: 335760
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: 335761
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

CABLE

CC ID: 335766
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: 335768
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: 335769
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: 335770
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: 335771
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: 335772
Seq. Order: 64
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 3
Status: Active
Description:

Distance traveled, in nautical miles, between the start and stop of the gear deployment event.

General Data Type: NUMBER

DOPDISTW

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

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.

General Data Type: NUMBER

DESSPEED

CC ID: 335774
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

OTHGEAR

CC ID: 335777
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: 335779
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: 335780
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: 335781
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: 335782
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: 335783
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: 335784
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: 335785
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: 335786
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: 335787
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: 335788
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: 335790
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: 335791
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: 335792
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: 335793
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: 335794
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: 335795
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: 335796
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: 335797
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: 335798
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: 335799
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: 335801
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: 335802
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_COMMENTS

CC ID: 335805
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: 335806
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: 335807
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: 33603
GUID: gov.noaa.nmfs.inport:33603
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-07-28 11:11+0000
Metadata Record Last Modified By: Paul Kostovick
Metadata Record Last Modified: 2023-01-25 16:28+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