Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NWFSC Metadata Library > FE (Fish Ecology) Division > FE Legacy Data Sets > Juvenile Fish Data - Coastwide Cooperative Pre-... >

Prerecruit Survey Trawl Data Haul

Entity (ENT)  |  Northwest Fisheries Science Center (NWFSC)
GUID: gov.noaa.nmfs.inport:37563  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

This table contains cruise and haul data from NWFSC prerecruit survey trawls for the years 2011, 2013, 2014, and 2015.

Description

This table contains cruise and haul data from NWFSC prerecruit survey trawls for the years 2011, 2013, 2014, and 2015.

Entity Information

Entity Type
Spreadsheet

Data Attribute / Type Description
Cruise
VARCHAR2 		Cruise name.
DATE_
DATE 		Year of cruise, month and date of sample.
Old Haul #
NUMBER 		Original haul number.
New Haul #
NUMBER 		New haul number.
Original Station
VARCHAR2 		Old station number for database.
Transect
NUMBER 		New transect for database.
Station
NUMBER 		New station for database.
Distance from shore (km)
NUMBER 		Closest distance to shore. Units for values are kilometers.
Start Depth (m)
NUMBER 		Bottom depth at start of trawl. Units for values are meters.
Surface Temp (oC)
NUMBER 		Surface temperature at start of trawl. Units for values are degrees Centigrade.
End Depth (m)
NUMBER 		Bottom depth at end of trawl. Units for values are meters.
Warp out (m)
NUMBER 		Amount of warp out when trawl is set. Units for values are meters.
Start Time
DATE 		Time at start of trawl. Units for values are Pacific time.
End Time
DATE 		Time at end of trawl. Units for values are Pacific time.
Start Latitude
NUMBER 		Latitude at start of trawl. Units for values are North latitude.
End Latitude
NUMBER 		Latitude at end of trawl. Units for values are North latitude.
Start Longitude
NUMBER 		Longitude at start of trawl. Units for values are West longitude.
End Longitude
NUMBER 		Longitude at end of trawl. Units for values are West longitude.
Start Tow Speed (kts)
NUMBER 		Tow speed at start of trawl. Units for values are knots.
End Tow Speed (kts)
NUMBER 		Tow speed at end of trawl. Units for values are knots.
Mean Headrope Depth (m)
NUMBER 		Mean headrope depth of trawl. Units for values are meters.
Mean Footrope Depth (m)
NUMBER 		Mean footrope depth of trawl. Units for values are meters.
Flowmeter Start
NUMBER 		Flowmeter reading at start of trawl.
Flowmeter End
NUMBER 		End at flowmeter of trawl.
Total Revs
NUMBER 		Total Revolutions of flowmeter.
Weather
VARCHAR2 		Weather when trawl is set.
Comments
VARCHAR2 		Comments about trawl or station.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (NWFSC) for inquiries on this record.

Item Identification

Title: Prerecruit Survey Trawl Data Haul
Short Name: Prerecruit Survey Trawl Data Haul
Status: Planned
Abstract:

This table contains cruise and haul data from NWFSC prerecruit survey trawls for the years 2011, 2013, 2014, and 2015.

Entity Information

Entity Type: Spreadsheet
Active Version?: Yes
Schema Name: PARR
Description:

This table contains cruise and haul data from NWFSC prerecruit survey trawls for the years 2011, 2013, 2014, and 2015.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Cruise VARCHAR2 Cruise name.
100
 DATE_ DATE Year of cruise, month and date of sample.
100
 Old Haul # NUMBER Original haul number.
100
 New Haul # NUMBER New haul number.
100
 Original Station VARCHAR2 Old station number for database.
100
 Transect NUMBER New transect for database.
100
 Station NUMBER New station for database.
100
 Distance from shore (km) NUMBER Closest distance to shore. Units for values are kilometers.
100
 Start Depth (m) NUMBER Bottom depth at start of trawl. Units for values are meters.
100
 Surface Temp (oC) NUMBER Surface temperature at start of trawl. Units for values are degrees Centigrade.
100
 End Depth (m) NUMBER Bottom depth at end of trawl. Units for values are meters.
100
 Warp out (m) NUMBER Amount of warp out when trawl is set. Units for values are meters.
100
 Start Time DATE Time at start of trawl. Units for values are Pacific time.
100
 End Time DATE Time at end of trawl. Units for values are Pacific time.
100
 Start Latitude NUMBER Latitude at start of trawl. Units for values are North latitude.
100
 End Latitude NUMBER Latitude at end of trawl. Units for values are North latitude.
100
 Start Longitude NUMBER Longitude at start of trawl. Units for values are West longitude.
100
 End Longitude NUMBER Longitude at end of trawl. Units for values are West longitude.
100
 Start Tow Speed (kts) NUMBER Tow speed at start of trawl. Units for values are knots.
100
 End Tow Speed (kts) NUMBER Tow speed at end of trawl. Units for values are knots.
100
 Mean Headrope Depth (m) NUMBER Mean headrope depth of trawl. Units for values are meters.
100
 Mean Footrope Depth (m) NUMBER Mean footrope depth of trawl. Units for values are meters.
100
 Flowmeter Start NUMBER Flowmeter reading at start of trawl.
100
 Flowmeter End NUMBER End at flowmeter of trawl.
100
 Total Revs NUMBER Total Revolutions of flowmeter.
100
 Weather VARCHAR2 Weather when trawl is set.
100
 Comments VARCHAR2 Comments about trawl or station.

Attribute Details

Cruise

CC ID: 731638
Seq. Order: 1
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Cruise name.
General Data Type: VARCHAR2

DATE_

CC ID: 731639
Seq. Order: 2
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

Year of cruise, month and date of sample.
General Data Type: DATE
Format Mask: mm/dd/yyyy

Old Haul #

CC ID: 731640
Seq. Order: 3
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Original haul number.
General Data Type: NUMBER

New Haul #

CC ID: 731641
Seq. Order: 4
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

New haul number.
General Data Type: NUMBER

Original Station

CC ID: 731642
Seq. Order: 5
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Old station number for database.
General Data Type: VARCHAR2

Transect

CC ID: 731643
Seq. Order: 6
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

New transect for database.
General Data Type: NUMBER

Station

CC ID: 731644
Seq. Order: 7
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

New station for database.
General Data Type: NUMBER

Distance from shore (km)

CC ID: 731645
Seq. Order: 8
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Closest distance to shore. Units for values are kilometers.
General Data Type: NUMBER
Unit of Measure: kilometers

Start Depth (m)

CC ID: 731646
Seq. Order: 9
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Bottom depth at start of trawl. Units for values are meters.
General Data Type: NUMBER
Unit of Measure: meters

Surface Temp (oC)

CC ID: 731647
Seq. Order: 10
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Surface temperature at start of trawl. Units for values are degrees Centigrade.
General Data Type: NUMBER
Unit of Measure: degrees Centigrade

End Depth (m)

CC ID: 731648
Seq. Order: 11
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Bottom depth at end of trawl. Units for values are meters.
General Data Type: NUMBER
Unit of Measure: meters

Warp out (m)

CC ID: 731649
Seq. Order: 12
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Amount of warp out when trawl is set. Units for values are meters.
General Data Type: NUMBER
Unit of Measure: meters

Start Time

CC ID: 731650
Seq. Order: 13
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

Time at start of trawl. Units for values are Pacific time.
General Data Type: DATE
Unit of Measure: Pacific time

End Time

CC ID: 731651
Seq. Order: 14
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

Time at end of trawl. Units for values are Pacific time.
General Data Type: DATE
Unit of Measure: Pacific time

Start Latitude

CC ID: 731652
Seq. Order: 15
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Latitude at start of trawl. Units for values are North latitude.
General Data Type: NUMBER
Unit of Measure: North latitude

End Latitude

CC ID: 731653
Seq. Order: 16
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Latitude at end of trawl. Units for values are North latitude.
General Data Type: NUMBER
Unit of Measure: North latitude

Start Longitude

CC ID: 731654
Seq. Order: 17
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Longitude at start of trawl. Units for values are West longitude.
General Data Type: NUMBER
Unit of Measure: West longitude

End Longitude

CC ID: 731655
Seq. Order: 18
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Longitude at end of trawl. Units for values are West longitude.
General Data Type: NUMBER
Unit of Measure: West longitude

Start Tow Speed (kts)

CC ID: 731656
Seq. Order: 19
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Tow speed at start of trawl. Units for values are knots.
General Data Type: NUMBER
Unit of Measure: knots

End Tow Speed (kts)

CC ID: 731657
Seq. Order: 20
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Tow speed at end of trawl. Units for values are knots.
General Data Type: NUMBER
Unit of Measure: knots

Mean Headrope Depth (m)

CC ID: 731658
Seq. Order: 21
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Mean headrope depth of trawl. Units for values are meters.
General Data Type: NUMBER
Unit of Measure: meters

Mean Footrope Depth (m)

CC ID: 731659
Seq. Order: 22
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Mean footrope depth of trawl. Units for values are meters.
General Data Type: NUMBER
Unit of Measure: meters

Flowmeter Start

CC ID: 731660
Seq. Order: 23
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Flowmeter reading at start of trawl.
General Data Type: NUMBER

Flowmeter End

CC ID: 731661
Seq. Order: 24
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

End at flowmeter of trawl.
General Data Type: NUMBER

Total Revs

CC ID: 731662
Seq. Order: 25
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Total Revolutions of flowmeter.
General Data Type: NUMBER

Weather

CC ID: 731663
Seq. Order: 26
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Weather when trawl is set.
General Data Type: VARCHAR2

Comments

CC ID: 731664
Seq. Order: 27
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Comments about trawl or station.
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 37563
GUID: gov.noaa.nmfs.inport:37563
Metadata Record Created By: Jeffrey W Cowen
Metadata Record Created: 2017-04-03 14:18+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2018-02-27
Owner Org: NWFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2018-02-27
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2019-02-27