Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > POPULATION & ECOSYSTEMS MONITORING DIV > Galveston Fisheries Ecology Projects > CWPPRA-East Mud Lake 1997-2001 >

CWPPRA_1997_2001_tblInvertLength.csv

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

Summary

Abstract

Table contains count and individual length information for 'Other Invertebrates' (non-penaeid shrimp, crabs, etc.). 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 represents the number of damaged specimens that could not be measured for a given taxon. If a taxon was subsampled, code '-999' in the measurement column represents the remaining number of specimens above the subsample size that were not measured. Empty length column indicates parameter was not measured.

.

It was created by export of a sql server database

Description

Table contains total count, size range, and weight by taxon and sample. 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 Fish Length Table, but was not transferred to Fish Mass Table; or, may represent damaged specimens not measured for given taxon.

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
Count
NUMBER 		Number of individuals of a given taxon measured and/or unmeasured
Total_Length_or_Carapace_Width_in_mm
Numeric 		Total length or carapace width (CW; crabs only) of largest individual in sample or subsample, by taxon.
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
Lawrence P Rozas

Item Identification

Title: CWPPRA_1997_2001_tblInvertLength.csv
Short Name: InvertLength
Status: Completed
Abstract:

Table contains count and individual length information for 'Other Invertebrates' (non-penaeid shrimp, crabs, etc.). 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 represents the number of damaged specimens that could not be measured for a given taxon. If a taxon was subsampled, code '-999' in the measurement column represents the remaining number of specimens above the subsample size that were not measured. Empty length column indicates parameter was not measured.

.

It was created by export of a sql server database
Supplemental Information:

Gear type: throw trap; except samples 51-60, which were collected by seine. For 1997 and 2001, length frequency distribution tables include up to 22 individuals measured per taxon at a given station. Under this measurement protocol, the largest and smallest specimens were located, removed, measured, and recorded first, then a subsample of up to 20 additional specimens were measured at random from the remainder of the sample. Largest and smallest specimens are recorded on this length table.

Physical Location

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

contained in .zip file 30672.zip on the PARR Data Server

Entity Information

Entity Type: Data Table
Active Version?: Yes
Description:

Table contains total count, size range, and weight by taxon and sample. 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 Fish Length Table, but was not transferred to Fish Mass Table; or, may represent damaged specimens not measured for given taxon.

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
 Count NUMBER Number of individuals of a given taxon measured and/or unmeasured
100
 Total_Length_or_Carapace_Width_in_mm Numeric Total length or carapace width (CW; crabs only) of largest individual in sample or subsample, by taxon.
100
 COMMENTS VARCHAR2 Optional general or specific comment about overall project or a given record

Attribute Details

Record_ID_Number

CC ID: 760511
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: 760510
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: 760512
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
Foreign Key Relations:

LWEINBER.SABINENWR1999_SAMPLES

TAXON

CC ID: 760513
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: 760514
Seq. Order: 45
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_or_Carapace_Width_in_mm

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

Total length or carapace width (CW; crabs only) of largest individual in sample or subsample, by taxon.

COMMENTS

CC ID: 760507
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: 760521
Date Effective From: 1997
Date Effective To:
Contact (Person): Rozas, Lawrence P
Contact Instructions:

Contact by email preferred.

Distributor

CC ID: 760522
Date Effective From: 1997
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: 760523
Date Effective From: 1997
Date Effective To:
Contact (Person): Rozas, Lawrence P
Contact Instructions:

Contact by email preferred.

Point of Contact

CC ID: 760524
Date Effective From: 1997
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: 53000
GUID: gov.noaa.nmfs.inport:53000
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2018-07-08 01:44+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