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

Summary

Abstract

Table contains total count data by taxon for penaeid shrimp only, if available. If count = 0, a code of '-999' indicates nothing to measure or weigh for given record or sample.

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 Information

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.
IndividualMass_in_grams
NUMBER
Weight of an individual shrimp, unless project comments or spreadsheet comments column state otherwise. If column empty, specimens were not weighed.
TotalMass_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

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: EPA_Seagrass_Restoration _1994_1995tblPenaeids.csv
Status: Completed
Abstract:

Table contains total count data by taxon for penaeid shrimp only, if available. If count = 0, a code of '-999' indicates nothing to measure or weigh for given record or sample.

It was created by export of a sql server database

Other Citation Details:

This project contains little usable animal biology data and was conducted as a vegetation/seagrass transplant survival study. Nekton counts only. No length measurements for any organisms, so no associated Length Tables. Few sample times in data set. Location of paper files for 1996-1997 samples are unknown.

Total counts by taxon/station are equivalent to density/m2 since the gear used sampled a 1-m2 area.

Physical Location

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

PARR Data Server ar The Main Office Of The South East Fisheries Science Center

Entity Information

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.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key 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
IndividualMass_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
TotalMass_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: 762666
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: 762665
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: 762667
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: 762668
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: 762663
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: 762669
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: 762661
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.

IndividualMass_in_grams

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

TotalMass_in_grams

CC ID: 762670
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: 762662
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

Support Roles

Data Steward

CC ID: 762747
Date Effective From: 1994
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.

Distributor

CC ID: 762748
Date Effective From: 1994
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: 762749
Date Effective From: 1994
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: 762750
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: 53087
GUID: gov.noaa.nmfs.inport:53087
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2018-07-19 07:12+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