Metadata Rubric

100%

6 / 6

SEFSC Metadata Library > POPULATION & ECOSYSTEMS MONITORING DIV > Galveston Fisheries Ecology Projects > Myrtle Grove 2002 >

Myrtle_Grove2002tblFishlength.csv

Entity (ENT) | Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:54657 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Physical Location

Entity Info

Data Attributes

Support Roles

Catalog Details

Abstract

This contains fish count and specimen total length information.

It was created by the export of data from an SQL Server database.

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.

Frequency distributions include up to a total of 20 individuals measured per taxon for a given station. Under the protocol used for this project only, the largest and smallest specimen was located, removed, and measured first, then all specimens up to 18 additional were measured.

A subsample was selected and measured at random from the remainder of the sample if over 20 specimens. Therefore, minimum and maximum lengths for each taxon and station are found on this Fish Length Table.

Minimum and maximum length were not transferred to the fish mass table.'

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

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

No Child Items for this record.

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

Metadata Contact
James Ditty
Jim.Ditty@noaa.gov
409-766-3782

Title:	Myrtle_Grove2002tblFishlength.csv
Short Name:	fish length data
Status:	Completed
Abstract:	This contains fish count and specimen total length information. It was created by the export of data from an SQL Server database. 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. Frequency distributions include up to a total of 20 individuals measured per taxon for a given station. Under the protocol used for this project only, the largest and smallest specimen was located, removed, and measured first, then all specimens up to 18 additional were measured. A subsample was selected and measured at random from the remainder of the sample if over 20 specimens. Therefore, minimum and maximum lengths for each taxon and station are found on this Fish Length Table. Minimum and maximum length were not transferred to the fish mass table.'
Supplemental Information:	Taxon was subsampled for measurement purposes if sample contained >20 specimens, as explained below. If subsampled, a code '-999' in measurement column represents the number of specimens above 20 total that remain unmeasured. Empty length column indicates parameter was not measured.

Organization:	Southeast Fisheries Science Center
City:	Miami
State/Province:	FL
Country:	USA
Location Description:	contained in .zip file on the PARR Data Server

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.

Attribute Summary

	Name	Type	Description
100	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

Name

Type

Description

100

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

100

Standard_Length_in_mm

NUMBER

100

COMMENTS

VARCHAR2

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

Attribute Details

Record_ID_Number

CC ID: 796686

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

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

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

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

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

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

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

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

Distributor

CC ID: 796692

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

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

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 Item ID:	54657
GUID:	gov.noaa.nmfs.inport:54657
Metadata Record Created By:	Lee M Weinberger
Metadata Record Created:	2018-11-04 20:41+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

Myrtle_Grove2002tblFishlength.csv

Summary

Entity Information

Child Items

Contact Information

Item Identification

Physical Location

Entity Information

Data Attributes

Attribute Summary

Attribute Details

Record_ID_Number

PROJECTNAME

SAMPLENUMBER

TAXON

COUNT

Total_Length_in_mm

Standard_Length_in_mm

COMMENTS

Support Roles

Distributor

Metadata Contact

Point of Contact

Catalog Details