Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > POPULATION & ECOSYSTEMS MONITORING DIV > Galveston Fisheries Ecology Projects > Myrtle Grove 2002 >

Myrtle_Grove2002tblInvtmass.csv

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

Summary

Abstract

Table contains total count and weight/biomass for all specimens by taxon and sample. If count = 0, a code of '-999' in Mass_in_grams column indicates nothing to weigh for given record or sample. If count ?1 and length measurement column has a code of '-999', length is found on Other Inverts Length Table 'tblInvertLength', but this information was not transferred to this Other Inverts Mass Table 'tblInvertMass'. Empty length or weight column indicates parameter was not measured.

It was created by export of a sql server database

Description

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

Table contains taxon count, minimum and maximum length, and weight information for 'Other Invertebrates' (non-penaeid shrimp, crabs, etc.). If count = 0, a code of '-999' indicates nothing to measure or weigh for given record or sample. If count = 1 or ?2, and measurement column has '-999' code, maximum and minimum length information may be available in the Invert Length Table, but was not transferred to Invert Mass Table. Alternately, a code of '-999' may also represent the number of damaged specimens that could not be measured for a given taxon. An empty weight column indicates parameter was not measured.

All nekton were pooled by taxon and sample to determine biomass (wet weight to nearest 0.1 gram). 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. Nekton measurement protocol: Largest and smallest specimens (minimum and maximum size) 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.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
Record_ID_Number
Numeric 		System Generated sequential Key
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
Maximum_Total_Length_or_Carapace_Width_in_mm
Numeric 		Minimum Total length or carapace width (CW; crabs only) of smallest individual in sample or subsample, by taxon.
Minimum_Total_Length_or_Carapace_Width_in_mm
Numeric 		Minimum Total length or carapace width (CW; crabs only) of smallest individual in sample or subsample, by taxon.
Count
NUMBER 		Number of individuals of a given taxon measured and/or unmeasured
Mass_in_grams
NUMBER 		Total weight of all individual(s) of given taxon by sample, usually in grams, unless noted otherwise in comments column. 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: Myrtle_Grove2002tblInvtmass.csv
Short Name: invert mass data
Status: Completed
Abstract:

Table contains total count and weight/biomass for all specimens by taxon and sample. If count = 0, a code of '-999' in Mass_in_grams column indicates nothing to weigh for given record or sample. If count ?1 and length measurement column has a code of '-999', length is found on Other Inverts Length Table 'tblInvertLength', but this information was not transferred to this Other Inverts Mass Table 'tblInvertMass'. Empty length or weight column indicates parameter was not measured.

It was created by export of a sql server database

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:

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

Table contains taxon count, minimum and maximum length, and weight information for 'Other Invertebrates' (non-penaeid shrimp, crabs, etc.). If count = 0, a code of '-999' indicates nothing to measure or weigh for given record or sample. If count = 1 or ?2, and measurement column has '-999' code, maximum and minimum length information may be available in the Invert Length Table, but was not transferred to Invert Mass Table. Alternately, a code of '-999' may also represent the number of damaged specimens that could not be measured for a given taxon. An empty weight column indicates parameter was not measured.

All nekton were pooled by taxon and sample to determine biomass (wet weight to nearest 0.1 gram). 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. Nekton measurement protocol: Largest and smallest specimens (minimum and maximum size) 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.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Record_ID_Number Numeric System Generated sequential Key
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
 Maximum_Total_Length_or_Carapace_Width_in_mm Numeric Minimum Total length or carapace width (CW; crabs only) of smallest individual in sample or subsample, by taxon.
100
 Minimum_Total_Length_or_Carapace_Width_in_mm Numeric Minimum Total length or carapace width (CW; crabs only) of smallest individual in sample or subsample, by taxon.
100
 Count NUMBER Number of individuals of a given taxon measured and/or unmeasured
100
 Mass_in_grams NUMBER Total weight of all individual(s) of given taxon by sample, usually in grams, unless noted otherwise in comments column. 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: 796722
Seq. Order: 10
Data Storage Type: Numeric
Max Length: 6
Required: Yes
Primary Key: No
Status: Active
Description:

System Generated sequential Key

PROJECTNAME

CC ID: 796721
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: 796723
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: 796724
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

Maximum_Total_Length_or_Carapace_Width_in_mm

CC ID: 796719
Seq. Order: 90
Data Storage Type: Numeric
Required: No
Primary Key: No
Precision: 5
Scale: 1
Status: Active
Description:

Minimum Total length or carapace width (CW; crabs only) of smallest individual in sample or subsample, by taxon.
Unit of Measure: mm

Minimum_Total_Length_or_Carapace_Width_in_mm

CC ID: 796720
Seq. Order: 100
Data Storage Type: Numeric
Required: No
Primary Key: No
Precision: 5
Scale: 1
Status: Active
Description:

Minimum Total length or carapace width (CW; crabs only) of smallest individual in sample or subsample, by taxon.
Unit of Measure: mm

Count

CC ID: 796717
Seq. Order: 105
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

Mass_in_grams

CC ID: 796718
Seq. Order: 110
Data Storage Type: NUMBER
Required: No
Primary Key: No
Precision: 5
Scale: 3
Status: Active
Description:

Total weight of all individual(s) of given taxon by sample, usually in grams, unless noted otherwise in comments column. If column empty, specimens were not weighed.
Unit of Measure: gm

COMMENTS

CC ID: 796716
Seq. Order: 120
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: 796725
Date Effective From: 1986-02-07
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

Distributor

CC ID: 796726
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: 796727
Date Effective From: 1986
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: 796729
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.
View Historical Support Roles

Catalog Details

Catalog Item ID: 54663
GUID: gov.noaa.nmfs.inport:54663
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2018-11-05 08:09+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