Item Identification

Title: CAM_LENGTHS_20190321
Short Name: CAM_LENGTHS_20190321
Status: On Going
Abstract:

Data source: 20190321

Entity Information

Entity Type: Data Table
Description:

.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key 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
Primary Key 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 Details

Catalog Item ID: 56044
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2019-04-12 22:38+0000
Metadata Record Last Modified By: Brent M Miyamoto
Metadata Record Last Modified: 2020-01-02 22:12+0000
Metadata Record Published: 2019-08-20
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2020-08-20