Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: CWPPRA_1997_2001_tblFishLength.csv
Short Name: Fishlength
Status: Completed
Abstract:

Table contains fish count and individual length information, if available. If count = 0, a code of '-999' in measurement column indicates nothing to measure for given record or sample. If count ≥1, a code of '-999' in the measurement column indicates specimens were damaged and could not be measured. If fish taxon was subsampled, a code of '-999' in the measurement column generally indicates the number of specimens above subsample size that were not measured. Empty length column indicates given length measurement was not taken.

.

.

It was created by export of a sql server database

Supplemental Information:

Gear type: throw trap; except samples 51-60, which were collected by seine.

For Fish only: total length (TL) was measured in millimeters (mm) for Year 1997; standard length (SL) was measured in mm for Year 2001. For both 1997 and 2001, length frequency distribution tables include up to 22 individuals measured per taxon at a given station. Under this measurement protocol, the largest and smallest specimens were located, removed, measured, and recorded first, then a subsample of up to 20 specimens were measured at random from the remainder of the sample (for both sample years). Largest and smallest specimens are recorded on this fish length table.

Specimens of a given taxon were pooled by sample and weighed to nearest 0.1 gram (wet weight/biomass).

Physical Location

Organization: Southeast Fisheries Science Center
City: Miami
State/Province: FL
Country: USA
Location Description:

contained in .zip file 30672.zip on the PARR Data Server

Entity Information

Entity Type: Data Table
Active Version?: Yes
Description:

Table contains total count, size range, and weight by taxon and sample. If count = 0, a code of '-999' indicates nothing to measure or weigh for given record or sample. If count = 1 or ≥2 and measurement column has '-999' code, maximum and minimum length information may be available in Fish Length Table, but was not transferred to Fish Mass Table; or, may represent damaged specimens not measured for given taxon.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Record_ID_Number Numeric System Generated sequential Key
100
PROJECTNAME VARCHAR2 Combination of assigned project name and year(s) study was conducted
100
SAMPLENUMBER VARCHAR2 Project acronym-year-sample number combination used to identify each data record
100
TAXON VARCHAR2 Scientific name (any level) assigned under Linnaean system of classification
100
Count NUMBER Number of individuals of a given taxon measured and/or unmeasured
100
Total_Length_in_mm Numeric Total lengthy) of largest individual in sample or subsample, by taxon. Code '-999' in length column indicates either no specimens of given taxon collected (count = 0) or a damaged specimen not measured. If sample was subsampled, a code of '-999' in length column indicates the remaining number of specimens above subsample size that were not measured. If column empty, TL was not measured.
100
Standard_Length_in_mm Numeric Specimen standard length in millimeters. Code '-999' in length column indicates either no specimens of given taxon collected (count = 0) or a damaged specimen not measured. If sample was subsampled, a code of '-999' in length column indicates the remaining number of specimens above subsample size not measured. If column empty, SL was not measured.
100
COMMENTS VARCHAR2 Optional general or specific comment about overall project or a given record

Attribute Details

Record_ID_Number

CC ID: 760528
Seq. Order: 10
Data Storage Type: Numeric
Max Length: 6
Required: Yes
Primary Key: No
Status: Active
Description:

System Generated sequential Key

PROJECTNAME

CC ID: 760527
Seq. Order: 20
Data Storage Type: VARCHAR2
Max Length: 50
Required: Yes
Primary Key: No
Status: Active
Description:

Combination of assigned project name and year(s) study was conducted

SAMPLENUMBER

CC ID: 760529
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 50
Required: Yes
Primary Key: No
Status: Active
Description:

Project acronym-year-sample number combination used to identify each data record

Foreign Key Relations:

LWEINBER.SABINENWR1999_SAMPLES

TAXON

CC ID: 760530
Seq. Order: 40
Data Storage Type: VARCHAR2
Max Length: 100
Required: Yes
Primary Key: No
Status: Active
Description:

Scientific name (any level) assigned under Linnaean system of classification

Count

CC ID: 760526
Seq. Order: 45
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Number of individuals of a given taxon measured and/or unmeasured

Total_Length_in_mm

CC ID: 760531
Seq. Order: 50
Data Storage Type: Numeric
Required: No
Primary Key: No
Precision: 5
Scale: 1
Status: Active
Description:

Total lengthy) of largest individual in sample or subsample, by taxon. Code '-999' in length column indicates either no specimens of given taxon collected (count = 0) or a damaged specimen not measured. If sample was subsampled, a code of '-999' in length column indicates the remaining number of specimens above subsample size that were not measured. If column empty, TL was not measured.

Standard_Length_in_mm

CC ID: 760536
Seq. Order: 60
Data Storage Type: Numeric
Max Length: 5
Min Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Specimen standard length in millimeters. Code '-999' in length column indicates either no specimens of given taxon collected (count = 0) or a damaged specimen not measured. If sample was subsampled, a code of '-999' in length column indicates the remaining number of specimens above subsample size not measured. If column empty, SL was not measured.

COMMENTS

CC ID: 760525
Seq. Order: 120
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Optional general or specific comment about overall project or a given record

Support Roles

Data Steward

CC ID: 760532
Date Effective From: 1997
Date Effective To:
Contact (Person): Rozas, Lawrence P
Contact Instructions:

Contact by email preferred.

Distributor

CC ID: 760533
Date Effective From: 1997
Date Effective To:
Contact (Organization): Southeast Fisheries Science Center (SEFSC)
Address: 75 Virginia Beach Drive
Miami, FL 33149
USA
Phone: (305)361-5761
URL: https://www.fisheries.noaa.gov/about/southeast-fisheries-science-center
Business Hours: 8:00 a.m. - 4:30 p.m. EST
Contact Instructions:

Contact by email preferred.

Metadata Contact

CC ID: 760534
Date Effective From: 1997
Date Effective To:
Contact (Person): Rozas, Lawrence P
Contact Instructions:

Contact by email preferred.

Point of Contact

CC ID: 760535
Date Effective From: 1997
Date Effective To:
Contact (Person): Baumer, Tim J
Address: 4700 Avenue U
Galveston, TX 77551
Email Address: tim.baumer@noaa.gov
Phone: 409-766-3784
Contact Instructions:

Contact by email preferred.

Catalog Details

Catalog Item ID: 53001
GUID: gov.noaa.nmfs.inport:53001
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2018-07-08 01:53+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-10-21
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-10-21
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-10-21