Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Fisheries Research and Monitoring Divisio... > Stock Assessment Program > Bottomfish Fishery-Independent Survey in Hawaii... > Bottomfish Fishery-Independent Survey in Hawaii... >

CAM_LENGTHS_20190321

Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:56044 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Data source: 20190321

Description

Entity Type
Data Table

Data Attribute / Type	Description
BFISH VARCHAR2	Id for survey Mission: BFISH_Year_Season (e.g. BFISH_2017_F).
MISSION_ID VARCHAR2	Id for NOAA ship mission (e.g. SE1707).
DROP_CD VARCHAR2	Unique ID for the collected sample.
SPECIES_CD VARCHAR2	4 letter code for species name.
SCIENTIFIC_NAME VARCHAR2	Linean (Latin) species name.
COMMON_NAME VARCHAR2	Local Hawaiian species name.
N NUMBER	Number of individuals measured.
REPLICATES NUMBER	Number of times the individual fish was measured.
MIN_MM NUMBER	Minimum length in millimeters of target within 3 replicate measures. Units for values are millimeters. Measures are reported with a precision of 6.
MAX_MM NUMBER	Maximum length in millimeters of target within 3 replicate measures. Units for values are millimeters. Measures are reported with a precision of 6.
MEAN_MM NUMBER	Mean length in millimeters of target within3 replicate measures. Units for values are millimeters. Measures are reported with a precision of 11.
SD_MM NUMBER	Standard deviation of length in millimeters of target within 3 replicate measures. Units for values are millimeters. Measures are reported with a precision of 11.
RANGE_TO_TARGET_MM NUMBER	Distance (mm) from camera to measured fish at time of measurement. Units for values are millimeters. Measures are reported with a precision of 11.
SEQUENCE_NR VARCHAR2	Consecutive number added to each record. Starts with 00000001 for each BFISH (Survey Mission).
CREATE_DTM DATE	Date and time this record was added to the database (populated by trigger); field added in August 2019.
CREATED_BY VARCHAR2	Application Express or Oracle username of the person creating this record (populated by trigger); field added in August 2019.
LAST_MOD_DTM DATE	Date and time this record was last modified (populated by trigger); field added in August 2019.
LAST_MOD_BY VARCHAR2	Application Express or Oracle username of the person who last modified this record (populated by trigger); field added in August 2019.

Data Attribute / Type

Description

BFISH
VARCHAR2

Id for survey Mission: BFISH_Year_Season (e.g. BFISH_2017_F).

MISSION_ID
VARCHAR2

Id for NOAA ship mission (e.g. SE1707).

DROP_CD
VARCHAR2

Unique ID for the collected sample.

SPECIES_CD
VARCHAR2

4 letter code for species name.

SCIENTIFIC_NAME
VARCHAR2

Linean (Latin) species name.

COMMON_NAME
VARCHAR2

Local Hawaiian species name.

N
NUMBER

Number of individuals measured.

REPLICATES
NUMBER

Number of times the individual fish was measured.

MIN_MM
NUMBER

Minimum length in millimeters of target within 3 replicate measures. Units for values are millimeters. Measures are reported with a precision of 6.

MAX_MM
NUMBER

Maximum length in millimeters of target within 3 replicate measures. Units for values are millimeters. Measures are reported with a precision of 6.

MEAN_MM
NUMBER

Mean length in millimeters of target within3 replicate measures. Units for values are millimeters. Measures are reported with a precision of 11.

SD_MM
NUMBER

Standard deviation of length in millimeters of target within 3 replicate measures. Units for values are millimeters. Measures are reported with a precision of 11.

RANGE_TO_TARGET_MM
NUMBER

Distance (mm) from camera to measured fish at time of measurement. Units for values are millimeters. Measures are reported with a precision of 11.

SEQUENCE_NR
VARCHAR2

Consecutive number added to each record. Starts with 00000001 for each BFISH (Survey Mission).

CREATE_DTM
DATE

Date and time this record was added to the database (populated by trigger); field added in August 2019.

CREATED_BY
VARCHAR2

Application Express or Oracle username of the person creating this record (populated by trigger); field added in August 2019.

LAST_MOD_DTM
DATE

Date and time this record was last modified (populated by trigger); field added in August 2019.

LAST_MOD_BY
VARCHAR2

Application Express or Oracle username of the person who last modified this record (populated by trigger); field added in August 2019.

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (PIFSC) for inquiries on this record.

Title:	CAM_LENGTHS_20190321
Short Name:	CAM_LENGTHS_20190321
Status:	On Going
Abstract:	Data source: 20190321

Entity Type:	Data Table
Description:	.

Attribute Summary

	Name	Type	Description
100	BFISH	VARCHAR2	Id for survey Mission: BFISH_Year_Season (e.g. BFISH_2017_F).
100	MISSION_ID	VARCHAR2	Id for NOAA ship mission (e.g. SE1707).
100	DROP_CD	VARCHAR2	Unique ID for the collected sample.
100	SPECIES_CD	VARCHAR2	4 letter code for species name.
100	SCIENTIFIC_NAME	VARCHAR2	Linean (Latin) species name.
100	COMMON_NAME	VARCHAR2	Local Hawaiian species name.
100	N	NUMBER	Number of individuals measured.
100	REPLICATES	NUMBER	Number of times the individual fish was measured.
100	MIN_MM	NUMBER	Minimum length in millimeters of target within 3 replicate measures. Units for values are millimeters. Measures are reported with a precision of 6.
100	MAX_MM	NUMBER	Maximum length in millimeters of target within 3 replicate measures. Units for values are millimeters. Measures are reported with a precision of 6.
100	MEAN_MM	NUMBER	Mean length in millimeters of target within3 replicate measures. Units for values are millimeters. Measures are reported with a precision of 11.
100	SD_MM	NUMBER	Standard deviation of length in millimeters of target within 3 replicate measures. Units for values are millimeters. Measures are reported with a precision of 11.
100	RANGE_TO_TARGET_MM	NUMBER	Distance (mm) from camera to measured fish at time of measurement. Units for values are millimeters. Measures are reported with a precision of 11.
100	SEQUENCE_NR	VARCHAR2	Consecutive number added to each record. Starts with 00000001 for each BFISH (Survey Mission).
100	CREATE_DTM	DATE	Date and time this record was added to the database (populated by trigger); field added in August 2019.
100	CREATED_BY	VARCHAR2	Application Express or Oracle username of the person creating this record (populated by trigger); field added in August 2019.
100	LAST_MOD_DTM	DATE	Date and time this record was last modified (populated by trigger); field added in August 2019.
100	LAST_MOD_BY	VARCHAR2	Application Express or Oracle username of the person who last modified this record (populated by trigger); field added in August 2019.

Name

Type

Description

100

BFISH

VARCHAR2

Id for survey Mission: BFISH_Year_Season (e.g. BFISH_2017_F).

100

MISSION_ID

VARCHAR2

Id for NOAA ship mission (e.g. SE1707).

100

DROP_CD

VARCHAR2

Unique ID for the collected sample.

100

SPECIES_CD

VARCHAR2

4 letter code for species name.

100

SCIENTIFIC_NAME

VARCHAR2

Linean (Latin) species name.

100

COMMON_NAME

VARCHAR2

Local Hawaiian species name.

100

NUMBER

Number of individuals measured.

100

REPLICATES

NUMBER

Number of times the individual fish was measured.

100

MIN_MM

NUMBER

Minimum length in millimeters of target within 3 replicate measures. Units for values are millimeters. Measures are reported with a precision of 6.

100

MAX_MM

NUMBER

Maximum length in millimeters of target within 3 replicate measures. Units for values are millimeters. Measures are reported with a precision of 6.

100

MEAN_MM

NUMBER

Mean length in millimeters of target within3 replicate measures. Units for values are millimeters. Measures are reported with a precision of 11.

100

SD_MM

NUMBER

Standard deviation of length in millimeters of target within 3 replicate measures. Units for values are millimeters. Measures are reported with a precision of 11.

100

RANGE_TO_TARGET_MM

NUMBER

Distance (mm) from camera to measured fish at time of measurement. Units for values are millimeters. Measures are reported with a precision of 11.

100

SEQUENCE_NR

VARCHAR2

Consecutive number added to each record. Starts with 00000001 for each BFISH (Survey Mission).

100

CREATE_DTM

DATE

Date and time this record was added to the database (populated by trigger); field added in August 2019.

100

CREATED_BY

VARCHAR2

Application Express or Oracle username of the person creating this record (populated by trigger); field added in August 2019.

100

LAST_MOD_DTM

DATE

Date and time this record was last modified (populated by trigger); field added in August 2019.

100

LAST_MOD_BY

VARCHAR2

Application Express or Oracle username of the person who last modified this record (populated by trigger); field added in August 2019.

Attribute Details

BFISH

CC ID: 833682

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	12
Required:	Yes
Primary Key:	Yes
Status:	Active
Description:	Id for survey Mission: BFISH_Year_Season (e.g. BFISH_2017_F).
General Data Type:	CHARACTER

MISSION_ID

CC ID: 833683

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	Id for NOAA ship mission (e.g. SE1707).
General Data Type:	CHARACTER

DROP_CD

CC ID: 833684

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	15
Required:	No
Primary Key:	No
Status:	Active
Description:	Unique ID for the collected sample.
General Data Type:	CHARACTER

SPECIES_CD

CC ID: 833685

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	4 letter code for species name.
General Data Type:	CHARACTER

SCIENTIFIC_NAME

CC ID: 833686

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	Linean (Latin) species name.
General Data Type:	CHARACTER

COMMON_NAME

CC ID: 833687

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	Local Hawaiian species name.
General Data Type:	CHARACTER

N

CC ID: 833688

Seq. Order:	7
Data Storage Type:	NUMBER
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Number of individuals measured.
General Data Type:	NUMBER

REPLICATES

CC ID: 833689

Seq. Order:	8
Data Storage Type:	NUMBER
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Number of times the individual fish was measured.
General Data Type:	NUMBER

MIN_MM

CC ID: 833690

Seq. Order:	9
Data Storage Type:	NUMBER
Max Length:	7
Required:	No
Primary Key:	No
Scale:	3
Status:	Active
Description:	Minimum length in millimeters of target within 3 replicate measures. Units for values are millimeters. Measures are reported with a precision of 6.
General Data Type:	NUMBER
Unit of Measure:	millimeters

MAX_MM

CC ID: 833691

Seq. Order:	10
Data Storage Type:	NUMBER
Max Length:	7
Required:	No
Primary Key:	No
Scale:	3
Status:	Active
Description:	Maximum length in millimeters of target within 3 replicate measures. Units for values are millimeters. Measures are reported with a precision of 6.
General Data Type:	NUMBER
Unit of Measure:	millimeters

MEAN_MM

CC ID: 833692

Seq. Order:	11
Data Storage Type:	NUMBER
Max Length:	11
Required:	No
Primary Key:	No
Scale:	8
Status:	Active
Description:	Mean length in millimeters of target within3 replicate measures. Units for values are millimeters. Measures are reported with a precision of 11.
General Data Type:	NUMBER
Unit of Measure:	millimeters

SD_MM

CC ID: 833693

Seq. Order:	12
Data Storage Type:	NUMBER
Max Length:	11
Required:	No
Primary Key:	No
Scale:	9
Status:	Active
Description:	Standard deviation of length in millimeters of target within 3 replicate measures. Units for values are millimeters. Measures are reported with a precision of 11.
General Data Type:	NUMBER
Unit of Measure:	millimeters

RANGE_TO_TARGET_MM

CC ID: 833694

Seq. Order:	13
Data Storage Type:	NUMBER
Max Length:	11
Required:	No
Primary Key:	No
Scale:	7
Status:	Active
Description:	Distance (mm) from camera to measured fish at time of measurement. Units for values are millimeters. Measures are reported with a precision of 11.
General Data Type:	NUMBER
Unit of Measure:	millimeters

SEQUENCE_NR

CC ID: 868050

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	8
Min Length:	8
Required:	Yes
Primary Key:	Yes
Status:	Active
Description:	Consecutive number added to each record. Starts with 00000001 for each BFISH (Survey Mission).
General Data Type:	CHARACTER

CREATE_DTM

CC ID: 868051

Seq. Order:	15
Data Storage Type:	DATE
Required:	No
Primary Key:	No
Status:	Active
Description:	Date and time this record was added to the database (populated by trigger); field added in August 2019.
General Data Type:	DATE

CREATED_BY

CC ID: 868052

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	Application Express or Oracle username of the person creating this record (populated by trigger); field added in August 2019.
General Data Type:	CHARACTER

LAST_MOD_DTM

CC ID: 868053

Seq. Order:	17
Data Storage Type:	DATE
Required:	No
Primary Key:	No
Status:	Active
Description:	Date and time this record was last modified (populated by trigger); field added in August 2019.
General Data Type:	DATE

LAST_MOD_BY

CC ID: 868054

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	Application Express or Oracle username of the person who last modified this record (populated by trigger); field added in August 2019.
General Data Type:	CHARACTER

Catalog Item ID:	56044
GUID:	gov.noaa.nmfs.inport:56044
Metadata Record Created By:	Brent M Miyamoto
Metadata Record Created:	2019-04-12 22:38+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2019-08-20
Owner Org:	PIFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2019-08-20
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2020-08-20

CAM_LENGTHS_20190321

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

BFISH

MISSION_ID

DROP_CD

SPECIES_CD

SCIENTIFIC_NAME

COMMON_NAME

N

REPLICATES

MIN_MM

MAX_MM

MEAN_MM

SD_MM

RANGE_TO_TARGET_MM

SEQUENCE_NR

CREATE_DTM

CREATED_BY

LAST_MOD_DTM

LAST_MOD_BY

Catalog Details