Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Sampled fish
Short Name: Sampled fish
Status: Planned
Abstract:

This table describes data associated with each English sole collected in Puget Sound in 2010 and 2011.

Entity Information

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

This table describes data associated with each English sole collected in Puget Sound in 2010 and 2011.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Species VARCHAR2 Fish species.
100
Collection year NUMBER Year when fish was collected.
100
Collection month VARCHAR2 Month when fish was collected.
100
Collection location VARCHAR2 Location where fish was collected.
100
Location code VARCHAR2 Location code -- An abbreviation of the COLLECTION_LOCATION.
100
Fish ID VARCHAR2 Unique identifier for each fish that includes collection code.
100
Total length NUMBER Length of the fish from tip of snout to fork of tail. Units for values are millimeters.
100
Otolith radius NUMBER Otolith radius was measured on the posterior side of the otolith in the region paralell to the longest axis. Units for values are microns.
100
Otolith radius 7days before capture NUMBER Otolith radius was measured on the posterior side of the otolith in the region paralell to the longest axis and 7 increments in from the edge. Units for values are microns.
100
Total length 7days before capture NUMBER Total length (mm) at 7days before capture was estimated using the following Fraser-Lee equation: Total length 7days before capture = (4.7471)+(Total length at capture-4.7471)*(Otolith radius 7days before capture/Otolith radius at capture)). Units for values are millimeters.
100
Growth during last 7days NUMBER The differences between total length at capture and total length 7days before capture. Units for values are millimeters.
100
Growth rate NUMBER Growth rate was calculated by dividing the growth during the last 7days by 7. Units for values are mm/day.

Attribute Details

Species

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

Fish species.

General Data Type: VARCHAR2

Collection year

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

Year when fish was collected.

General Data Type: NUMBER

Collection month

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

Month when fish was collected.

General Data Type: VARCHAR2

Collection location

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

Location where fish was collected.

General Data Type: VARCHAR2

Location code

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

Location code -- An abbreviation of the COLLECTION_LOCATION.

General Data Type: VARCHAR2

Fish ID

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

Unique identifier for each fish that includes collection code.

General Data Type: VARCHAR2

Total length

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

Length of the fish from tip of snout to fork of tail. Units for values are millimeters.

General Data Type: NUMBER
Unit of Measure: millimeters

Otolith radius

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

Otolith radius was measured on the posterior side of the otolith in the region paralell to the longest axis. Units for values are microns.

General Data Type: NUMBER
Unit of Measure: microns

Otolith radius 7days before capture

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

Otolith radius was measured on the posterior side of the otolith in the region paralell to the longest axis and 7 increments in from the edge. Units for values are microns.

General Data Type: NUMBER
Unit of Measure: microns

Total length 7days before capture

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

Total length (mm) at 7days before capture was estimated using the following Fraser-Lee equation: Total length 7days before capture = (4.7471)+(Total length at capture-4.7471)*(Otolith radius 7days before capture/Otolith radius at capture)). Units for values are millimeters.

General Data Type: NUMBER
Unit of Measure: millimeters

Growth during last 7days

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

The differences between total length at capture and total length 7days before capture. Units for values are millimeters.

General Data Type: NUMBER
Unit of Measure: millimeters

Growth rate

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

Growth rate was calculated by dividing the growth during the last 7days by 7. Units for values are mm/day.

General Data Type: NUMBER
Unit of Measure: mm/day

Catalog Details

Catalog Item ID: 37567
GUID: gov.noaa.nmfs.inport:37567
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