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 Catch

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

Summary

Abstract

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

Description

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

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

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 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
GUID: gov.noaa.nmfs.inport: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: 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