Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Estuary fish data
Short Name: Estuary fish data
Status: Planned
Abstract:

Abundance and size of fish caught in Columbia estuary.

Entity Information

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

Abundance and size of fish caught in Columbia estuary.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Cruise_Number number The numerical designation of the cruise in sequence of research performed.
100
Sample_Date_Local date The local time data were collected. Units for values are Month/Day/Year.
100
Year_ number The year the data were collected. Units for values are Year.
100
Station_Depth_Meters number The bottom depth of the station where the data were collected. Units for values are Meters.
100
Station_Code text The code created to name the date and location when and where the data were collected.
100
Start_Time_Local date The local time trawl started collecting data. Units for values are hh:mm (24 hour).
100
Latitude_Decimal_Degrees_North number The latitude recorded at start of trawl sampling. Units for values are decimal degrees North.
100
Longitude_Decimal_Degrees_West number The longitude recorded at start of trawl sampling. Units for values are decimal degrees West.
100
Salmon_ID_Number text The unique identifier of the salmon in sequence of research performed.
100
Common_Name text The common name of fishes and invertebrates captured in the trawl.
100
Genus_Species text The Latin name of fishes and invertebrates captured in the trawl.
100
Age_ClassByLength text The age class of salmon based on their length, which may not be their actual age, but is our best estimate from length.
100
Tagged_Code text The list of codes assigned to salmon as identifying marks such as coded wire tags.
100
Tagged_Description text The descriptions of codes assigned to salmon as identifying marks such as coded wire tags.
100
Count_ number The count of each fish or invertebrate. Units for values are whole number.
100
Field_Length_millimeters number The field length recorded. Units for values are milimeters.
100
Type_of_Length text The type of the length measurement recorded.
100
Length_Description text The description of the type of the length measurement.
100
Method_Saved text The description of how fishes and invertebrates were retained.
100
Sorting_ID number The numerical designation of the data point in sequence of data entry - primary key. Units for values are whole number.
100
Station text The name of the station where the data was collected.
100
Haul_Number number The sequentially unique number for each deployment of the net. Units for values are whole number.
100
Net_Type text Type of net used to collect the sample.
100
Net_Length number Length of the net in meters. Units for values are meters.
100
Net_Depth number Depth of the net in meters. Units for values are meters.

Attribute Details

Cruise_Number

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

The numerical designation of the cruise in sequence of research performed.

General Data Type: number

Sample_Date_Local

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

The local time data were collected. Units for values are Month/Day/Year.

General Data Type: date
Unit of Measure: Month/Day/Year

Year_

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

The year the data were collected. Units for values are Year.

General Data Type: number
Unit of Measure: Year

Station_Depth_Meters

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

The bottom depth of the station where the data were collected. Units for values are Meters.

General Data Type: number
Unit of Measure: Meters

Station_Code

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

The code created to name the date and location when and where the data were collected.

General Data Type: text

Start_Time_Local

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

The local time trawl started collecting data. Units for values are hh:mm (24 hour).

General Data Type: date
Unit of Measure: hh:mm (24 hour)

Latitude_Decimal_Degrees_North

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

The latitude recorded at start of trawl sampling. Units for values are decimal degrees North.

General Data Type: number
Unit of Measure: decimal degrees North

Longitude_Decimal_Degrees_West

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

The longitude recorded at start of trawl sampling. Units for values are decimal degrees West.

General Data Type: number
Unit of Measure: decimal degrees West

Salmon_ID_Number

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

The unique identifier of the salmon in sequence of research performed.

General Data Type: text

Common_Name

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

The common name of fishes and invertebrates captured in the trawl.

General Data Type: text

Genus_Species

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

The Latin name of fishes and invertebrates captured in the trawl.

General Data Type: text

Age_ClassByLength

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

The age class of salmon based on their length, which may not be their actual age, but is our best estimate from length.

General Data Type: text

Tagged_Code

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

The list of codes assigned to salmon as identifying marks such as coded wire tags.

General Data Type: text

Tagged_Description

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

The descriptions of codes assigned to salmon as identifying marks such as coded wire tags.

General Data Type: text

Count_

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

The count of each fish or invertebrate. Units for values are whole number.

General Data Type: number
Unit of Measure: whole number

Field_Length_millimeters

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

The field length recorded. Units for values are milimeters.

General Data Type: number
Unit of Measure: milimeters

Type_of_Length

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

The type of the length measurement recorded.

General Data Type: text

Length_Description

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

The description of the type of the length measurement.

General Data Type: text

Method_Saved

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

The description of how fishes and invertebrates were retained.

General Data Type: text

Sorting_ID

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

The numerical designation of the data point in sequence of data entry - primary key. Units for values are whole number.

General Data Type: number
Unit of Measure: whole number

Station

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

The name of the station where the data was collected.

General Data Type: text

Haul_Number

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

The sequentially unique number for each deployment of the net. Units for values are whole number.

General Data Type: number
Unit of Measure: whole number

Net_Type

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

Type of net used to collect the sample.

General Data Type: text

Net_Length

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

Length of the net in meters. Units for values are meters.

General Data Type: number
Unit of Measure: meters

Net_Depth

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

Depth of the net in meters. Units for values are meters.

General Data Type: number
Unit of Measure: meters

Catalog Details

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