Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > POPULATION & ECOSYSTEMS MONITORING DIV > Galveston Fisheries Ecology Projects > Houston Ship Channel 1993-1994 >

Houston_Ship_Channel_1993_1994_tblSizeRange.csv

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

Summary

Abstract

Table contains count, size range, and weight information, if available, for fish, non-penaeid shrimp, and 'Other Invertebrates'. If count = 0, a code of '-999' indicates no fish, non-penaeid shrimp, and/or 'Other Invertebrates' to measure or weigh for given record or sample. If count ≥1, a code of '-999' in measurement column indicates damaged specimen(s) that could not be measured for given taxon. Empty column indicates parameter was not measured.

Table was created by export from a sqlserver database

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 Information

Entity Type
Data Table

Data Attribute / Type Description
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
Sizerange_in_mm
Character 		Minimum and maximum length (total or standard), or carapace width (crabs only), in millimeters, of individuals in the sample or given subsample, by taxon, if available. The word to is used in the range so data from .csv will come in as text value rather than a date.
RangeMidpoint_in_mm
NUMBER 		Numeric midpoint of each size interval, not mean size of individuals 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.
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: Houston_Ship_Channel_1993_1994_tblSizeRange.csv
Short Name: SizeRange Data
Status: Completed
Abstract:

Table contains count, size range, and weight information, if available, for fish, non-penaeid shrimp, and 'Other Invertebrates'. If count = 0, a code of '-999' indicates no fish, non-penaeid shrimp, and/or 'Other Invertebrates' to measure or weigh for given record or sample. If count ≥1, a code of '-999' in measurement column indicates damaged specimen(s) that could not be measured for given taxon. Empty column indicates parameter was not measured.

Table was created by export from a sqlserver database

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:

No samples 38, 40, or 186 through 199.

Midpoint of each size interval is for development of length frequency tables, and does not represent the mean size of individuals measured.

No biomass/weight data for any nekton.

Fish recorded in 10-mm total length (TL) intervals; ‘Other crustaceans’ (non-penaeid shrimp and crabs) recorded in 5-mm TL or carapace weight (CW) intervals.

Penaeid shrimp data located on 'tblPenaeids'

Physical Location

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

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

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
 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
 Sizerange_in_mm Character Minimum and maximum length (total or standard), or carapace width (crabs only), in millimeters, of individuals in the sample or given subsample, by taxon, if available. The word to is used in the range so data from .csv will come in as text value rather than a date.
100
 RangeMidpoint_in_mm NUMBER Numeric midpoint of each size interval, not mean size of individuals 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
 COMMENTS VARCHAR2 Optional general or specific comment about overall project or a given record

Attribute Details

PROJECTNAME

CC ID: 758657
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: 758659
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
Foreign Key Relations:

LWEINBER.SABINENWR1999_SAMPLES

TAXON

CC ID: 758661
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: 758655
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

Sizerange_in_mm

CC ID: 758660
Seq. Order: 6
Data Storage Type: Character
Max Length: 20
Required: No
Primary Key: No
Precision: 5
Scale: 1
Status: Active
Description:

Minimum and maximum length (total or standard), or carapace width (crabs only), in millimeters, of individuals in the sample or given subsample, by taxon, if available.

The word to is used in the range so data from .csv will come in as text value rather than a date.
Unit of Measure: mm

RangeMidpoint_in_mm

CC ID: 758658
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 1
Status: Active
Description:

Numeric midpoint of each size interval, not mean size of individuals measured.
Unit of Measure: mm

MASS_IN_GRAMS

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

COMMENTS

CC ID: 758654
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: 758662
Date Effective From: 1993
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: 758663
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

Metadata Contact

CC ID: 758664
Date Effective From: 1993
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: 758665
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: 52911
GUID: gov.noaa.nmfs.inport:52911
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2018-06-24 11:42+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