Metadata Rubric

100%

6 / 6

SEFSC Metadata Library > POPULATION & ECOSYSTEMS MONITORING DIV > Galveston Fisheries Ecology Projects > Terracing at Pierce Marsh in Galveston Bay 2001... >

Pierce_Marsh2001-2002tblFishlength.csv

Entity (ENT) | Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:54692 | 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.

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. Taxon was subsampled for measurement purposes if sample contained >22 specimens, as explained below. If subsampled, a code of '-999' in measurement column represents the number of specimens above subsample size of 20 total (plus minimum and maximum length) that remain unmeasured. Empty length column indicates given length measurement was not taken.

Length frequency distributions include up to 22 specimens measured (20 specimens plus minimum and maximum lengths) per taxon at a given station.

Under this protocol, the largest and smallest specimens were located, removed, and measured first with the largest and smallest specimens recorded on this Table. If <22 total specimens, all specimens were measured. If >22 specimens, largest and smallest specimens were located, removed, and measured first, and a subsample of 20 additional were selected and measured at random; the number of specimens >22 were recorded as unmeasured with code: '-999' in the total measurement column.

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

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:	Pierce_Marsh2001-2002tblFishlength.csv
Status:	Completed
Abstract:	This contains fish count and specimen total 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 the measurement column indicates specimens were damaged and could not be measured. Taxon was subsampled for measurement purposes if sample contained >22 specimens, as explained below. If subsampled, a code of '-999' in measurement column represents the number of specimens above subsample size of 20 total (plus minimum and maximum length) that remain unmeasured. Empty length column indicates given length measurement was not taken. Length frequency distributions include up to 22 specimens measured (20 specimens plus minimum and maximum lengths) per taxon at a given station. Under this protocol, the largest and smallest specimens were located, removed, and measured first with the largest and smallest specimens recorded on this Table. If <22 total specimens, all specimens were measured. If >22 specimens, largest and smallest specimens were located, removed, and measured first, and a subsample of 20 additional were selected and measured at random; the number of specimens >22 were recorded as unmeasured with code: '-999' in the total measurement column. It was created by the export of data from an SQL Server database.

Title:

Pierce_Marsh2001-2002tblFishlength.csv

Status:

Completed

Abstract:

This contains fish count and specimen total length information.

Length frequency distributions include up to 22 specimens measured (20 specimens plus minimum and maximum lengths) per taxon at a given station.

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

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

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

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

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

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

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

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

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

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

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

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

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:	54692
GUID:	gov.noaa.nmfs.inport:54692
Metadata Record Created By:	Lee M Weinberger
Metadata Record Created:	2018-11-07 11:23+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

Pierce_Marsh2001-2002tblFishlength.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