Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Table contains fish count and individual length information. 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 measurement column indicates damaged specimens unable to measure. If fish taxon was subsampled, code '-999' in measurement column refers to number of specimens above subsample size that were not measured. Empty length column indicates parameter was not measured.

This was created by export of a sql server database

Supplemental Information:

Nekton were not subsampled. All intact fish were measured and recorded in millimeters total length.

Physical Location

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

contained in .zip file 8589.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
Primary Key Record_ID_Number Numeric System generated record number assigned to each data stream.
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
Total_Length_in_mm Numeric Specimen total 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 that were not measured. If column empty, TL was not measured.
100
Count Numeric Number of individuals of a given taxon measured and/or unmeasured. Unprocessed unit-free numbers.
100
COMMENTS VARCHAR2 Optional general or specific comment about overall project or a given record

Attribute Details

Record_ID_Number

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

System generated record number assigned to each data stream.

PROJECTNAME

CC ID: 760273
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: 760275
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: 760276
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

Total_Length_in_mm

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

Specimen total 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 that were not measured. If column empty, TL was not measured.

Unit of Measure: mm
Null Value: -999
Null Value Meaning:

no measurement taken/available

Count

CC ID: 760272
Seq. Order: 100
Data Storage Type: Numeric
Required: Yes
Primary Key: No
Precision: 4
Status: Active
Description:

Number of individuals of a given taxon measured and/or unmeasured. Unprocessed unit-free numbers.

COMMENTS

CC ID: 760271
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: 760282
Date Effective From: 1995
Date Effective To:
Contact (Person): Ditty, James
Address: 4700 Avenue U
Galveston, TX 77551-5997
Email Address: Jim.Ditty@noaa.gov
Phone: 409-766-3782
Fax: 409-766-3508
Contact Instructions:

Phone or email

Distributor

CC ID: 760283
Date Effective From: 1995
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: 760284
Date Effective From: 1995
Date Effective To:
Contact (Person): Ditty, James
Address: 4700 Avenue U
Galveston, TX 77551-5997
Email Address: Jim.Ditty@noaa.gov
Phone: 409-766-3782
Fax: 409-766-3508

Point of Contact

CC ID: 760286
Date Effective From: 2018
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.

View Historical Support Roles

Catalog Details

Catalog Item ID: 52990
GUID: gov.noaa.nmfs.inport:52990
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2018-07-05 08:34+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-10-21 10:06+0000
Metadata Record Published: 2021-10-21
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-10-22