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
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: 2019-06-04 13:14+0000
Metadata Record Published: 2018-02-27
Owner Org: NWFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2019-02-28