Prerecruit Survey Trawl Data Catch
Entity (ENT) | Northwest Fisheries Science Center (NWFSC)GUID: gov.noaa.nmfs.inport:37564 | Updated: August 9, 2022 | Published / External
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
|
|
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 |