Item Identification

Title: CAM_SAMPLE_20190321
Short Name: CAM_SAMPLE_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
DROP_DATE VARCHAR2 Local Date of MOUSSS drop based on UTC.
100
DROP_TIME VARCHAR2 Local time of MOUSSS drop based on UTC.
100
VESSEL VARCHAR2 Name of vessel from which sample was collected.
100
GEAR_ID VARCHAR2 Id for individual gear unit.
100
FRAME_RATE NUMBER Number of frames per second collected by the camera.
100
GRID_ID_TARGET VARCHAR2 Id for intended primary sampling unit in which the sample was to be collected.
100
PSU VARCHAR2 Id for primary sampling unit in which the sample was collected.
100
OBS_LAT NUMBER Latitude in decimal degrees at which sample was collected. Units for values are degrees. Measures are reported with a precision of 10.
100
OBS_LON NUMBER Longitude in decimal degrees at which sample was collected. Units for values are degrees. Measures are reported with a precision of 10.
100
OFFICIAL_DEPTH_M NUMBER Official depth reading for drop (if TDR 1&2 both record then mean of TRD 1 & 2. If only one TDR records then depth from that TDR, if neither TDR record then depth from fathometer). Units for values are meters.The depths for SE1701 were updated in December 2019; measures are reported with a precision of 6.
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.
100
OFFICIAL_TEMP_C Number Official temperature reading for drop is the mode of 30 temperature recordings (with recordings every 30 seconds for 15 minutes of bottom time), then calculate the mean of the two temperature modes from TDRs 1 & 2 (if TDRs 1&2 both record then mean of TRD 1 & 2; if only one TDR records then mode of temperature from that TDR; if neither TDR records then no temperature is given). Units of values are degrees Celsius. Measures are reported with a precision of 4.This data field was added in December 2019.

Attribute Details

BFISH

CC ID: 833659
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: 833660
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: 833661
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

DROP_DATE

CC ID: 833662
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Local Date of MOUSSS drop based on UTC.

General Data Type: CHARACTER

DROP_TIME

CC ID: 833663
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

Local time of MOUSSS drop based on UTC.

General Data Type: CHARACTER

VESSEL

CC ID: 833664
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Name of vessel from which sample was collected.

General Data Type: CHARACTER

GEAR_ID

CC ID: 833665
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Id for individual gear unit.

General Data Type: CHARACTER

FRAME_RATE

CC ID: 833666
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Number of frames per second collected by the camera.

General Data Type: NUMBER

GRID_ID_TARGET

CC ID: 833667
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Id for intended primary sampling unit in which the sample was to be collected.

General Data Type: CHARACTER

PSU

CC ID: 833668
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Id for primary sampling unit in which the sample was collected.

General Data Type: CHARACTER

OBS_LAT

CC ID: 833669
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 11
Required: No
Primary Key: No
Scale: 8
Status: Active
Description:

Latitude in decimal degrees at which sample was collected. Units for values are degrees. Measures are reported with a precision of 10.

General Data Type: NUMBER
Unit of Measure: degrees

OBS_LON

CC ID: 833670
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 12
Required: No
Primary Key: No
Scale: 7
Status: Active
Description:

Longitude in decimal degrees at which sample was collected. Units for values are degrees. Measures are reported with a precision of 10.

General Data Type: NUMBER
Unit of Measure: degrees

OFFICIAL_DEPTH_M

CC ID: 833671
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 7
Required: No
Primary Key: No
Precision: 6
Scale: 3
Status: Active
Description:

Official depth reading for drop (if TDR 1&2 both record then mean of TRD 1 & 2. If only one TDR records then depth from that TDR, if neither TDR record then depth from fathometer). Units for values are meters.The depths for SE1701 were updated in December 2019; measures are reported with a precision of 6.

General Data Type: NUMBER
Unit of Measure: meters

SEQUENCE_NR

CC ID: 868060
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: 868061
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: 868062
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: 868063
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: 868064
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

OFFICIAL_TEMP_C

CC ID: 890751
Seq. Order: 19
Data Storage Type: Number
Max Length: 5
Required: No
Primary Key: No
Precision: 4
Scale: 2
Status: Active
Description:

Official temperature reading for drop is the mode of 30 temperature recordings (with recordings every 30 seconds for 15 minutes of bottom time), then calculate the mean of the two temperature modes from TDRs 1 & 2 (if TDRs 1&2 both record then mean of TRD 1 & 2; if only one TDR records then mode of temperature from that TDR; if neither TDR records then no temperature is given). Units of values are degrees Celsius. Measures are reported with a precision of 4.This data field was added in December 2019.

Unit of Measure: degrees Celsius

Catalog Details

Catalog Item ID: 56042
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2019-04-12 22:37+0000
Metadata Record Last Modified By: Brent M Miyamoto
Metadata Record Last Modified: 2020-01-06 13:37+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