Item Identification

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

This table contains cruise and catch 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 catch 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
Year DATE Year of cruise, month and day of sample.
100
Old_Haul_Number NUMBER Original haul number.
100
New_Haul_Number 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_Kilometers NUMBER Closest distance to shore. Units for values are kilometers.
100
Start_Depth_Meters NUMBER Bottom depth at start of trawl. 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
Surface_Temperature_Celcius NUMBER Surface temperature at start of trawl. Units for values are degrees Centigrade.
100
Taxon VARCHAR2 Species, genus or family caught.
100
Maturity VARCHAR2 Age class or maturity of individuals.
100
Number NUMBER Number of individuals caught.
100
Comments VARCHAR2 Comments about catch.

Attribute Details

Cruise

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

Cruise name.

General Data Type: VARCHAR2

Year

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

Year of cruise, month and day of sample.

General Data Type: DATE

Old_Haul_Number

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

Original haul number.

General Data Type: NUMBER

New_Haul_Number

CC ID: 731668
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: 731669
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: 731670
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: 731671
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_Kilometers

CC ID: 731672
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_Meters

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

Start Time

CC ID: 731674
Seq. Order: 10
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: 731675
Seq. Order: 11
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: 731676
Seq. Order: 12
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: 731677
Seq. Order: 13
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: 731678
Seq. Order: 14
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: 731679
Seq. Order: 15
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: 731680
Seq. Order: 16
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: 731681
Seq. Order: 17
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: 731682
Seq. Order: 18
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

Surface_Temperature_Celcius

CC ID: 731683
Seq. Order: 19
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

Taxon

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

Species, genus or family caught.

General Data Type: VARCHAR2

Maturity

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

Age class or maturity of individuals.

General Data Type: VARCHAR2
Allowed Values: Y = young of the year, A = adult, U = no stage identified

Number

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

Number of individuals caught.

General Data Type: NUMBER

Comments

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

Comments about catch.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 37564
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