Metadata Rubric

100%

6 / 6

SEFSC Metadata Library > POPULATION & ECOSYSTEMS MONITORING DIV > Galveston Fisheries Ecology Projects > Chocolate Bay/Halls Lake 1987-1988 >

Chocolate_Bay_Halls_Lake _1987_1988_tblPenaeids.csv

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

Summary

Item Identification

Physical Location

Entity Info

Data Attributes

Support Roles

Catalog Details

Abstract

Table contains count, measurement, and weight information, if available, for penaeid shrimp only. If count = 0, a code of '-999' in measurement column indicates nothing to measure or weigh for given record or sample. If count ≥1, a code of '-999' in measurement column indicates damaged specimens that could not be measured for given taxon. An empty column indicates parameter was not measured.

It was created by export of a sql server database

Description

Table contains count, measurement, and weight information, if available, for penaeid shrimp only. If count = 0, a code of -999 in measurement column indicates nothing to measure or weigh for given record or sample. If count =1, a code of -999 in measurement column indicates damaged specimens that could not be measured for given taxon. An empty column indicates parameter was not measured.

Entity Type
Data Table

Data Attribute / Type	Description
RECORD_ID_NUMBER NUMBER	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 NUMBER	Specimen total length in millimeters as measured from tip of rostrum to tip of telson. 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.
CARAPACE_LENGTH_IN_MM NUMBER	Specimen carapace length in millimeters as measured from anterior to posterior margins of carapace. Code -999 in length column indicates either no specimens of given taxon collected (count = 0) ; a damaged specimen not measured; or, carapace length was not measured for project. If sample was subsampled, code -999 in length column represents remaining number of specimens above subsample size not measured. Carapace length (excludes rostrum), unless stated otherwise in comments section. If column empty, CL was not measured.
MASS_IN_GRAMS NUMBER	Weight of an individual shrimp, unless project comments or spreadsheet comments column state otherwise. If column empty, specimens were not weighed.
TOTALBIOMASS_IN_GRAMS NUMBER	Total weight of all penaeids of a given taxon by sample, unless project comments or spreadsheet comments column state otherwise. If column empty, specimens were not weighed.
COMMENTS VARCHAR2	Optional general or specific comment about overall project or a given record

Data Attribute / Type

Description

RECORD_ID_NUMBER
NUMBER

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
NUMBER

Specimen total length in millimeters as measured from tip of rostrum to tip of telson. 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.

CARAPACE_LENGTH_IN_MM
NUMBER

Specimen carapace length in millimeters as measured from anterior to posterior margins of carapace. Code -999 in length column indicates either no specimens of given taxon collected (count = 0) ; a damaged specimen not measured; or, carapace length was not measured for project. If sample was subsampled, code -999 in length column represents remaining number of specimens above subsample size not measured. Carapace length (excludes rostrum), unless stated otherwise in comments section. If column empty, CL was not measured.

MASS_IN_GRAMS
NUMBER

Weight of an individual shrimp, unless project comments or spreadsheet comments column state otherwise. If column empty, specimens were not weighed.

TOTALBIOMASS_IN_GRAMS
NUMBER

Total weight of all penaeids of a given taxon by sample, unless project comments or spreadsheet comments column state otherwise. If column empty, specimens were not weighed.

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:	Chocolate_Bay_Halls_Lake _1987_1988_tblPenaeids.csv
Short Name:	Penaeid Data
Status:	Completed
Abstract:	Table contains count, measurement, and weight information, if available, for penaeid shrimp only. If count = 0, a code of '-999' in measurement column indicates nothing to measure or weigh for given record or sample. If count ≥1, a code of '-999' in measurement column indicates damaged specimens that could not be measured for given taxon. An empty column indicates parameter was not measured. It was created by export of a sql server database
Supplemental Information:	Counts and measurements only; no mass/weight data for this project. Counts must be summed by taxon and sample, and then divided by 2.6 to calculate number per meter squared values because larger 1.8-m drop trap sampled an area of 2.6 m2. Each penaeid shrimp measured to nearest mm total length (TL). Fish & 'Other Inverts' count and length data, if available, are found on 'tblSizeRange'.

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

Entity Type:	Data Table
Active Version?:	Yes
Description:	Table contains count, measurement, and weight information, if available, for penaeid shrimp only. If count = 0, a code of -999 in measurement column indicates nothing to measure or weigh for given record or sample. If count =1, a code of -999 in measurement column indicates damaged specimens that could not be measured for given taxon. An empty column indicates parameter was not measured.

Attribute Summary

	Name	Type	Description
100	RECORD_ID_NUMBER	NUMBER	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	NUMBER	Specimen total length in millimeters as measured from tip of rostrum to tip of telson. 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	CARAPACE_LENGTH_IN_MM	NUMBER	Specimen carapace length in millimeters as measured from anterior to posterior margins of carapace. Code -999 in length column indicates either no specimens of given taxon collected (count = 0) ; a damaged specimen not measured; or, carapace length was not measured for project. If sample was subsampled, code -999 in length column represents remaining number of specimens above subsample size not measured. Carapace length (excludes rostrum), unless stated otherwise in comments section. If column empty, CL was not measured.
100	MASS_IN_GRAMS	NUMBER	Weight of an individual shrimp, unless project comments or spreadsheet comments column state otherwise. If column empty, specimens were not weighed.
100	TOTALBIOMASS_IN_GRAMS	NUMBER	Total weight of all penaeids of a given taxon by sample, unless project comments or spreadsheet comments column state otherwise. If column empty, specimens were not weighed.
100	COMMENTS	VARCHAR2	Optional general or specific comment about overall project or a given record

Name

Type

Description

100

RECORD_ID_NUMBER

NUMBER

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

NUMBER

100

CARAPACE_LENGTH_IN_MM

NUMBER

100

MASS_IN_GRAMS

NUMBER

Weight of an individual shrimp, unless project comments or spreadsheet comments column state otherwise. If column empty, specimens were not weighed.

100

TOTALBIOMASS_IN_GRAMS

NUMBER

Total weight of all penaeids of a given taxon by sample, unless project comments or spreadsheet comments column state otherwise. If column empty, specimens were not weighed.

100

COMMENTS

VARCHAR2

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

Attribute Details

RECORD_ID_NUMBER

CC ID: 758308

Seq. Order:	1
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	Yes
Precision:	6
Scale:	0
Status:	Active
Description:	System generated record number assigned to each data stream

PROJECTNAME

CC ID: 758307

Seq. Order:	2
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: 758309

Seq. Order:	3
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: 758310

Seq. Order:	4
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: 758305

Seq. Order:	5
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: 758312

Seq. Order:	6
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	5
Scale:	1
Status:	Active
Description:	Specimen total length in millimeters as measured from tip of rostrum to tip of telson. 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.

CARAPACE_LENGTH_IN_MM

CC ID: 758303

Seq. Order:	7
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	5
Scale:	1
Status:	Active
Description:	Specimen carapace length in millimeters as measured from anterior to posterior margins of carapace. Code -999 in length column indicates either no specimens of given taxon collected (count = 0) ; a damaged specimen not measured; or, carapace length was not measured for project. If sample was subsampled, code -999 in length column represents remaining number of specimens above subsample size not measured. Carapace length (excludes rostrum), unless stated otherwise in comments section. If column empty, CL was not measured.

MASS_IN_GRAMS

CC ID: 758306

Seq. Order:	8
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	7
Scale:	4
Status:	Active
Description:	Weight of an individual shrimp, unless project comments or spreadsheet comments column state otherwise. If column empty, specimens were not weighed.

TOTALBIOMASS_IN_GRAMS

CC ID: 758311

Seq. Order:	9
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	7
Scale:	4
Status:	Active
Description:	Total weight of all penaeids of a given taxon by sample, unless project comments or spreadsheet comments column state otherwise. If column empty, specimens were not weighed.

COMMENTS

CC ID: 758304

Seq. Order:	10
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

Data Steward

CC ID: 758313

Date Effective From:	1987
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: 758314

Date Effective From:	2018
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: 758315

Date Effective From:	1987
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:	Contact by email preferred.

Point of Contact

CC ID: 758316

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

Chocolate_Bay_Halls_Lake _1987_1988_tblPenaeids.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

CARAPACE_LENGTH_IN_MM

MASS_IN_GRAMS

TOTALBIOMASS_IN_GRAMS

COMMENTS

Support Roles

Data Steward

Distributor

Metadata Contact

Point of Contact

Catalog Details