Table: UNION_FSCS_SVSTA
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:33603 | Updated: January 25, 2023 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
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.
DescriptionMaterialized 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |