CAM_SAMPLE_20190321
Pacific Islands Fisheries Science Center
Entity
(ENT)
| ID: 56042
| Published / External
Created: 2019-04-12
|
Last Modified: 2022-08-09
Parent: Bottomfish Fishery-Independent Survey in Hawaii (BFISH) - Camera Surveys
Data Set (DS) | ID: 20970
Data Set (DS) | ID: 20970
ID: 56042
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
| * » Title | CAM_SAMPLE_20190321 |
|---|---|
| Short Name | CAM_SAMPLE_20190321 |
| * Status | On Going |
| Creation Date | |
| Revision Date | |
| • Publication Date | |
| * » Abstract |
Data source: 20190321 |
| * Purpose | |
| Notes | |
| Other Citation Details | |
| • Supplemental Information | |
| DOI (Digital Object Identifier) | |
| DOI Registration Authority | |
| DOI Issue Date |
Keywords
Theme Keywords
| Thesaurus | Keyword |
|---|---|
Temporal Keywords
| Thesaurus | Keyword |
|---|---|
* Spatial Keywords
| Thesaurus | Keyword |
|---|---|
Stratum Keywords
| Thesaurus | Keyword |
|---|---|
Instrument Keywords
| Thesaurus | Keyword |
|---|---|
Platform Keywords
| Thesaurus | Keyword |
|---|---|
Physical Location
| • » Organization | |
|---|---|
| • » City | |
| • » State/Province | |
| • Country | |
| • » Location Description |
Entity Information
| Entity Type | Data Table |
|---|---|
| Active Version? | |
| Alias | |
| Schema Name | |
| » Description |
. |
| Change Summary |
Data Attributes
Attribute Summary
| Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
|---|---|---|---|---|---|
| 100 | Yes | Yes | BFISH | VARCHAR2 | Id for survey Mission: BFISH_Year_Season (e.g. BFISH_2017_F). |
| 100 | No | No | MISSION_ID | VARCHAR2 | Id for NOAA ship mission (e.g. SE1707). |
| 100 | No | No | DROP_CD | VARCHAR2 | Unique ID for the collected sample. |
| 100 | No | No | DROP_DATE | VARCHAR2 | Local Date of MOUSSS drop based on UTC. |
| 100 | No | No | DROP_TIME | VARCHAR2 | Local time of MOUSSS drop based on UTC. |
| 100 | No | No | VESSEL | VARCHAR2 | Name of vessel from which sample was collected. |
| 100 | No | No | GEAR_ID | VARCHAR2 | Id for individual gear unit. |
| 100 | No | No | FRAME_RATE | NUMBER | Number of frames per second collected by the camera. |
| 100 | No | No | GRID_ID_TARGET | VARCHAR2 | Id for intended primary sampling unit in which the sample was to be collected. |
| 100 | No | No | PSU | VARCHAR2 | Id for primary sampling unit in which the sample was collected. |
| 100 | No | No | 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 | No | No | 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 | No | No | 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 | Yes | Yes | SEQUENCE_NR | VARCHAR2 | Consecutive number added to each record. Starts with 00000001 for each BFISH (Survey Mission). |
| 100 | No | No | CREATE_DTM | DATE | Date and time this record was added to the database (populated by trigger); field added in August 2019. |
| 100 | No | No | CREATED_BY | VARCHAR2 | Application Express or Oracle username of the person creating this record (populated by trigger); field added in August 2019. |
| 100 | No | No | LAST_MOD_DTM | DATE | Date and time this record was last modified (populated by trigger); field added in August 2019. |
| 100 | No | No | 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 | No | No | 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
| Attribute Name | BFISH |
|---|---|
| Seq. Order | 1 |
| Data Storage Type | VARCHAR2 |
| Max Length | 12 |
| Min Length | |
| Required | Yes |
| Primary Key | Yes |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Id for survey Mission: BFISH_Year_Season (e.g. BFISH_2017_F). |
| General Data Type | CHARACTER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | MISSION_ID |
|---|---|
| Seq. Order | 2 |
| Data Storage Type | VARCHAR2 |
| Max Length | 6 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Id for NOAA ship mission (e.g. SE1707). |
| General Data Type | CHARACTER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | DROP_CD |
|---|---|
| Seq. Order | 3 |
| Data Storage Type | VARCHAR2 |
| Max Length | 15 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Unique ID for the collected sample. |
| General Data Type | CHARACTER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | DROP_DATE |
|---|---|
| Seq. Order | 4 |
| Data Storage Type | VARCHAR2 |
| Max Length | 8 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Local Date of MOUSSS drop based on UTC. |
| General Data Type | CHARACTER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | DROP_TIME |
|---|---|
| Seq. Order | 5 |
| Data Storage Type | VARCHAR2 |
| Max Length | 6 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Local time of MOUSSS drop based on UTC. |
| General Data Type | CHARACTER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | VESSEL |
|---|---|
| Seq. Order | 6 |
| Data Storage Type | VARCHAR2 |
| Max Length | 25 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Name of vessel from which sample was collected. |
| General Data Type | CHARACTER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | GEAR_ID |
|---|---|
| Seq. Order | 7 |
| Data Storage Type | VARCHAR2 |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Id for individual gear unit. |
| General Data Type | CHARACTER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | FRAME_RATE |
|---|---|
| Seq. Order | 8 |
| Data Storage Type | NUMBER |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Number of frames per second collected by the camera. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | GRID_ID_TARGET |
|---|---|
| Seq. Order | 9 |
| Data Storage Type | VARCHAR2 |
| Max Length | 5 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Id for intended primary sampling unit in which the sample was to be collected. |
| General Data Type | CHARACTER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | PSU |
|---|---|
| Seq. Order | 10 |
| Data Storage Type | VARCHAR2 |
| Max Length | 5 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Id for primary sampling unit in which the sample was collected. |
| General Data Type | CHARACTER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | OBS_LAT |
|---|---|
| Seq. Order | 11 |
| Data Storage Type | NUMBER |
| Max Length | 11 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| 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 |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | OBS_LON |
|---|---|
| Seq. Order | 12 |
| Data Storage Type | NUMBER |
| Max Length | 12 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| 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 |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | OFFICIAL_DEPTH_M |
|---|---|
| Seq. Order | 13 |
| Data Storage Type | NUMBER |
| Max Length | 7 |
| Min Length | |
| 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 |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SEQUENCE_NR |
|---|---|
| Seq. Order | 14 |
| Data Storage Type | VARCHAR2 |
| Max Length | 8 |
| Min Length | 8 |
| Required | Yes |
| Primary Key | Yes |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Consecutive number added to each record. Starts with 00000001 for each BFISH (Survey Mission). |
| General Data Type | CHARACTER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | CREATE_DTM |
|---|---|
| Seq. Order | 15 |
| Data Storage Type | DATE |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | CREATED_BY |
|---|---|
| Seq. Order | 16 |
| Data Storage Type | VARCHAR2 |
| Max Length | 30 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LAST_MOD_DTM |
|---|---|
| Seq. Order | 17 |
| Data Storage Type | DATE |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Date and time this record was last modified (populated by trigger); field added in August 2019. |
| General Data Type | DATE |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LAST_MOD_BY |
|---|---|
| Seq. Order | 18 |
| Data Storage Type | VARCHAR2 |
| Max Length | 30 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | OFFICIAL_TEMP_C |
|---|---|
| Seq. Order | 19 |
| Data Storage Type | Number |
| Max Length | 5 |
| Min Length | |
| 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. |
| General Data Type | |
| Unit of Measure | degrees Celsius |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | |
|---|---|
| Seq. Order | |
| Data Storage Type | |
| Max Length | |
| Precision | |
| Scale | |
| Required | |
| Primary Key | |
| Status | |
| Description | |
| General Data Type | |
| Case Restriction | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Min Length | |
| Unit of Measure | |
| Display Example | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | |
|---|---|
| Seq. Order | |
| Data Storage Type | |
| Max Length | |
| Precision | |
| Scale | |
| Required | |
| Primary Key | |
| Status | |
| Description | |
| General Data Type | |
| Case Restriction | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Min Length | |
| Unit of Measure | |
| Display Example | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | |
|---|---|
| Seq. Order | |
| Data Storage Type | |
| Max Length | |
| Precision | |
| Scale | |
| Required | |
| Primary Key | |
| Status | |
| Description | |
| General Data Type | |
| Case Restriction | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Min Length | |
| Unit of Measure | |
| Display Example | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
Support Roles
» At least one Distributor Org, one Metadata Contact, one Point of Contact, and one Data Steward should be listed.
| * » Support Role | |
|---|---|
| * » Date Effective From | |
| Date Effective To | |
| * » Contact | |
| * Contact Instructions |
| * » Support Role | |
|---|---|
| * » Date Effective From | |
| Date Effective To | |
| * » Contact | |
| * Contact Instructions |
| * » Support Role | |
|---|---|
| * » Date Effective From | |
| Date Effective To | |
| * » Contact | |
| * Contact Instructions |
Extents
| Currentness Reference |
|---|
Extent Group 1
| Extent Description |
|---|
Extent Group 1 / Geographic Area
| * » W° Bound | |
|---|---|
| * » E° Bound | |
| * » N° Bound | |
| * » S° Bound | |
| * » Description |
Extent Group 1 / Vertical Extent
| EPSG Code | |
|---|---|
| Vertical Minimum | |
| Vertical Maximum |
Extent Group 1 / Time Frame
| * » Time Frame Type | |
|---|---|
| * » Start | |
| End | |
| Alternate Start as of Info | |
| Alternate End as of Info | |
| Description |
Access Information
| * » Security Class | |
|---|---|
| * Security Classification System |
|
| Security Handling Description |
|
| • Data Access Policy |
|
| » Data Access Procedure |
|
| • » Data Access Constraints |
|
| • Data Use Constraints |
|
| Metadata Access Constraints |
|
| Metadata Use Constraints |
|
Distribution Information
| Start Date | |
|---|---|
| End Date | |
| » Download URL | |
| Distributor | |
| File Name | |
| Description | |
| File Date/Time | |
| File Type | |
| FGDC Content Type | |
| File Size | |
| Application Version | |
| Compression | |
| Review Status |
| Start Date | |
|---|---|
| End Date | |
| » Download URL | |
| Distributor | |
| File Name | |
| Description | |
| File Date/Time | |
| File Type | |
| FGDC Content Type | |
| File Size | |
| Application Version | |
| Compression | |
| Review Status |
| Start Date | |
|---|---|
| End Date | |
| » Download URL | |
| Distributor | |
| File Name | |
| Description | |
| File Date/Time | |
| File Type | |
| FGDC Content Type | |
| File Size | |
| Application Version | |
| Compression | |
| Review Status |
Activity Log
| Activity Time | |
|---|---|
| Activity Type | |
| Responsible Party | |
| Description |
| Activity Time | |
|---|---|
| Activity Type | |
| Responsible Party | |
| Description |
| Activity Time | |
|---|---|
| Activity Type | |
| Responsible Party | |
| Description |
Issues
| Issue Date | |
|---|---|
| Author | |
| Issue |
| Issue Date | |
|---|---|
| Author | |
| Issue |
| Issue Date | |
|---|---|
| Author | |
| Issue |
FAQs
| Date | |
|---|---|
| Author | |
| Question | |
| Answer |
Child Items
Rubric scores updated every 15m
| Score | Type | Title |
|---|---|---|
Related Items
| Item Type | Relationship Type | Title |
|---|---|---|
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 | 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 Workflow State | Published / External |
| Metadata Last Review Date | 2019-08-20 |
| Metadata Review Frequency | 1 Year |
| Metadata Next Review Date | 2020-08-20 |
| Tags |
|---|