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.
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.
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 9075, 07-28-2016 12:23

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
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
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: 336695
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: 336706
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: 336717
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: 336728
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: 336739
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: 336761
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: 336708
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: 336709
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: 336710
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: 336711
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: 336712
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: 336713
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: 336714
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: 336715
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: 336716
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: 336718
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: 336719
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: 336720
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: 336721
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: 336722
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: 336723
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: 336724
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: 336725
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: 336726
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: 336727
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: 336729
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: 336730
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: 336731
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: 336732
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: 336733
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: 336734
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: 336735
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: 336736
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: 336737
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: 336738
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: 336740
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: 336741
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: 336742
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: 336743
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: 336744
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: 336745
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: 336746
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: 336747
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: 336748
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: 336749
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: 336751
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: 336752
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: 336753
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: 336754
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: 336755
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: 336756
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: 336757
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: 336758
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: 336759
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: 336760
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: 336762
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: 336763
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: 336764
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: 336765
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: 336766
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: 336767
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: 336768
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: 336769
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: 336770
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: 336771
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: 336773
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: 336774
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: 336775
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: 336776
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: 336777
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: 336778
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: 336779
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: 336780
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: 336781
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: 336782
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: 336784
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: 336785
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: 336786
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: 336787
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: 336788
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: 336789
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: 336790
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: 33638
GUID: gov.noaa.nmfs.inport:33638
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-07-28 12:23+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