Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > POPULATION & ECOSYSTEMS MONITORING DIV > Galveston Fisheries Ecology Projects > Oyster Reef Projects 2000-2001 >

OR2000-2001Fishlength.csv

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:54562  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Physical Location
Entity Info
Data Attributes
Support Roles
Catalog Details

Summary

Abstract

Data table is called tblFishLength. It was created by the export of data from an SQL Server database.

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 refers to number of specimens above the subsample size that were not measured. Empty length column indicates given length measurement was not taken.

Description

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.

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
NUMBER 		Number of individuals of a given taxon measured and/or unmeasured
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, code '-999' in length column represents remaining number of specimens above subsample size not measured. If column empty, TL was not measured.
Standard_Length_in_mm
NUMBER 		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, code '-999' in length column represents remaining number of specimens above subsample size not measured. If column empty, SL was not measured.
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
James Ditty
Jim.Ditty@noaa.gov
409-766-3782

Item Identification

Title: OR2000-2001Fishlength.csv
Short Name: fish length Data
Status: Completed
Abstract:

Data table is called tblFishLength. It was created by the export of data from an SQL Server database.

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 refers to number of specimens above the subsample size that were not measured. Empty length column indicates given length measurement was not taken.
Supplemental Information:

All total counts must be divided by 2.6 to obtain number per meter-squared because the larger drop trap sampled an area of 2.6 m2. Fish measurement protocol: Largest and smallest specimens were located, removed, and measured first, then a subsample of up to 20 additional specimens were measured at random from the remainder of the sample.

Physical Location

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

contained in .zip file on the PARR Data Server

Entity Information

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

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.

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 NUMBER Number of individuals of a given taxon measured and/or unmeasured
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, code '-999' in length column represents remaining number of specimens above subsample size not measured. If column empty, TL was not measured.
100
 Standard_Length_in_mm NUMBER 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, code '-999' in length column represents 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: 795233
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: 795232
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: 795234
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: 795236
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: 795231
Seq. Order: 50
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: 795237
Seq. Order: 60
Data Storage Type: Numeric
Max Length: 4
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, code '-999' in length column represents remaining number of specimens above subsample size not measured. If column empty, TL was not measured.
Unit of Measure: mm
Null Value: -999
Null Value Meaning:

no measurement taken/available

Standard_Length_in_mm

CC ID: 795235
Seq. Order: 80
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
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, code '-999' in length column represents remaining number of specimens above subsample size not measured. If column empty, SL was not measured.
Unit of Measure: mm

COMMENTS

CC ID: 795230
Seq. Order: 100
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

Distributor

CC ID: 795257
Date Effective From: 2000
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: 795260
Date Effective From: 2017
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: 795259
Date Effective From: 2016
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
View Historical Support Roles

Catalog Details

Catalog Item ID: 54562
GUID: gov.noaa.nmfs.inport:54562
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2018-10-31 19:06+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