Search Help Show/Hide Menu
Summary
Item Identification
Physical Location
Entity Info
Data Attributes
Support Roles
Catalog Details

Summary

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

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.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
Record_ID_Number
Numeric
System generated record number assigned to each data stream.
PROJECTNAME
VARCHAR2
Combination of assigned project name and year(s) study was conducted
SAMPLENUMBER
VARCHAR2
Project acronym-year-sample number combination used to identify each data record
TAXON
VARCHAR2
Scientific name (any level) assigned under Linnaean system of classification
Count
Numeric
Number of individuals of a given taxon measured and/or unmeasured. Unprocessed unit-free numbers.
Total_Length_or_Carapace_Width_in_mm
Numeric
Total length (TL) or carapace width (CW, crabs only) depending on taxon.
COMMENTS
VARCHAR2
Optional general or specific comment about overall project or a given record

Child Items

No Child Items for this record.

Contact Information

Point of Contact
Tim J Baumer
tim.baumer@noaa.gov
409-766-3784

Metadata Contact
Lawrence P Rozas

Item Identification

Title: Vallisneria_2003_2004_InvertLength.csv
Short Name: InvertLength
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:

No stations for 7, 25, 28, 29, 30 or 92, 93, 94, 95 collected. Length frequency distributions include up to 22 individuals measured per taxon at a given station. Under this original protocol, the largest and smallest specimens were located, removed, and measured first, then a subsample of up to 20 specimens were measured at random from the remainder of the sample.

Specimens of minimum and maximum length, which represent size range, are included on this length table, and were not transferred to the 'Other Inverts' biomass/weight table.

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
Count Numeric Number of individuals of a given taxon measured and/or unmeasured. Unprocessed unit-free numbers.
100
Total_Length_or_Carapace_Width_in_mm Numeric Total length (TL) or carapace width (CW, crabs only) depending on taxon.
100
COMMENTS VARCHAR2 Optional general or specific comment about overall project or a given record

Attribute Details

Record_ID_Number

CC ID: 760666
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: 760665
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: 760667
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

TAXON

CC ID: 760669
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: 760664
Seq. Order: 50
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.

Total_Length_or_Carapace_Width_in_mm

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

Total length (TL) or carapace width (CW, crabs only) depending on taxon.

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

no measurement taken/available

COMMENTS

CC ID: 760663
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: 760671
Date Effective From: 2003
Date Effective To:
Contact (Person): Rozas, Lawrence P
Contact Instructions:

Contact by email preferred.

Distributor

CC ID: 760672
Date Effective From: 2003
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: 760673
Date Effective From: 2003
Date Effective To:
Contact (Person): Rozas, Lawrence P
Contact Instructions:

Contact by email preferred.

Point of Contact

CC ID: 760674
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.

Catalog Details

Catalog Item ID: 53011
GUID: gov.noaa.nmfs.inport:53011
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2018-07-08 12:57+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