Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NWFSC Metadata Library > FE (Fish Ecology) Division > English sole 2010-2011 - Suitability of somatic... >

Sampled fish

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

Summary

Abstract

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

Description

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

Entity Information

Entity Type
Spreadsheet

Data Attribute / Type Description
Species
VARCHAR2 		Fish species.
Collection year
NUMBER 		Year when fish was collected.
Collection month
VARCHAR2 		Month when fish was collected.
Collection location
VARCHAR2 		Location where fish was collected.
Location code
VARCHAR2 		Location code -- An abbreviation of the COLLECTION_LOCATION.
Fish ID
VARCHAR2 		Unique identifier for each fish that includes collection code.
Total length
NUMBER 		Length of the fish from tip of snout to fork of tail. Units for values are millimeters.
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.
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.
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.
Growth during last 7days
NUMBER 		The differences between total length at capture and total length 7days before capture. Units for values are millimeters.
Growth rate
NUMBER 		Growth rate was calculated by dividing the growth during the last 7days by 7. Units for values are mm/day.

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: 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