56040 CRF_DRIFT_20190321 Entity Published / External 20969 Bottomfish Fishery-Independent Survey in Hawaii (BFISH) - Cooperative Research Fishing Surveys Data Set On Going . Data Table . 1 BFISH VARCHAR2 12 Yes Yes Active Id for survey Mission: BFISH_Year_Season (e.g. BFISH_2017_F). CHARACTER 2 SAMPLE_ID VARCHAR2 16 No No Active Concatinated unique ID for collected sample: Year("000"), Month("00"), Day("00"), Sample_Start_time hour("00"), Sample_start_time minute("00"), Captain_CD. CHARACTER 3 DRIFT_ID VARCHAR2 18 No No Active Concatinated unique ID for collected sample: Year("000"), Month("00"), Day("00"), Sample_Start_time hour("00"), Sample_start_time minute("00"), Captain_CD, Drift_NR("00"). CHARACTER 4 DRIFT_NR NUMBER 3 No No Active Sequential number for each unique drift within a "PSU". NUMBER 5 DRIFT_MEAN_DEPTH_M NUMBER 3 No No Active "mean_depth_fa" * 1.8288. Units for values are meters. NUMBER meters 6 DRIFT_START_TIME VARCHAR2 4 No No Active Local time sampling began on the drift. CHARACTER 7 START_DEPTH_FA NUMBER 5 No No 1 Active Depth in fathoms at the start of the drift. Units for values are fathoms. Measures are reported with a precision of 4. NUMBER fathoms 8 START_DEPTH_M NUMBER 9 No No 5 Active Depth in meters at the start of the drift. Units for values are meters. Measures are reported with a precision of 8. NUMBER meters 9 START_LAT NUMBER 11 No No 8 Active Latitiude in decimal degrees at the start of the drift. Units for values are degrees. Measures are reported with a precision of 10. NUMBER degrees 10 START_LAT_DEG NUMBER 2 No No Active Latitude degrees at the start of the drift. Units for values are degrees. NUMBER degrees 11 START_LAT_MIN NUMBER 7 No No 4 Active Latitude minutes at the start of the drift. Units for values are minutes. Measures are reported with a precision of 6. NUMBER minutes 12 START_LAT_POS VARCHAR2 1 No No Active Latitude hemisphere at the start of the drift (N,S). CHARACTER 13 START_LON NUMBER 12 No No 7 Active Longitude in decimal degrees at the start of the drift. Units for values are degrees. Measures are reported with a precision of 10. NUMBER degrees 14 START_LON_DEG NUMBER 3 No No Active Longitude degrees at the start of the drift. Units for values are degrees. NUMBER degrees 15 START_LON_MIN NUMBER 6 No No 3 Active Longitude minutes at the start of the drift. Units for values are minutes. Measures are reported with a precision of 5. NUMBER minutes 16 START_LON_POS VARCHAR2 1 No No Active Longitude hemisphere at the start of the drift (E,W). CHARACTER 17 DRIFT_END_TIME VARCHAR2 4 No No Active Local time sampling ended on the drift. CHARACTER 18 DRIFT_DURATION VARCHAR2 4 No No Active "drift_end_time" - "Drift_Start_Time". CHARACTER 19 END_DEPTH_FA NUMBER 5 No No 1 Active Depth in fathoms at the end of the drift. Units for values are fathoms. Measures are reported with a precision of 4. NUMBER fathoms 20 END_DEPTH_M NUMBER 9 No No 5 Active Depth in meters at the end of the drift. Units for values are meters. Measures are reported with a precision of 8. NUMBER meters 21 END_LAT NUMBER 11 No No 8 Active Latitude in decimal degrees at the end of the drift. Units for values are degrees. Measures are reported with a precision of 10. NUMBER degrees 22 END_LAT_DEG NUMBER 2 No No Active Latitude degrees at the end of the drift. Units for values are degrees. NUMBER degrees 23 END_LAT_MIN NUMBER 7 No No 4 Active Latitude minutes at the end of the drift. Units for values are minutes. Measures are reported with a precision of 6. NUMBER minutes 24 END_LAT_POS VARCHAR2 1 No No Active Latitude hemisphere at end start of the drift (N,S). CHARACTER 25 END_LON NUMBER 12 No No 7 Active Longitude in decimal degrees at the end of the drift. Units for values are degrees. Measures are reported with a precision of 10. NUMBER degrees 26 END_LON_DEG NUMBER 3 No No Active Longitude degrees at the end of the drift. Units for values are degrees. NUMBER degrees 27 END_LON_MIN NUMBER 6 No No 3 Active Longitude minutes at the end of the drift. Units for values are minutes. Measures are reported with a precision of 5. NUMBER minutes 28 END_LON_POS VARCHAR2 1 No No Active Longitude hemisphere at the end of the drift (E,W). CHARACTER 29 BOTTOM_TYPE_CD VARCHAR2 1 No No Active "H" or "S" to denote hardbottom or softbottom. CHARACTER 30 SEQUENCE_NR VARCHAR2 8 8 Yes Yes Active Consecutive number added to each record. Starts with 00000001 for each BFISH (Survey Mission) CHARACTER 31 CREATE_DTM DATE No No Active Date and time this record was added to the database (populated by trigger); field added in August 2019. DATE 32 CREATED_BY VARCHAR2 30 No No Active Application Express or Oracle username of the person creating this record (populated by trigger); field added in August 2019. CHARACTER 33 LAST_MOD_DTM DATE No No Active Date and time this record was last modified (populated by trigger); field added in August 2019. DATE 34 LAST_MOD_BY VARCHAR2 30 No No Active Application Express or Oracle username of the person who last modified this record (populated by trigger); field added in August 2019. CHARACTER gov.noaa.nmfs.inport:56040 Brent Miyamoto 2019-04-12T22:22:22 SysAdmin InPortAdmin 2022-08-09T17:11:43 2019-08-21 Pacific Islands Fisheries Science Center PIFSC 1845 Wasp Blvd. Honolulu HI 96818 USA 808-725-5300 https://www.pifsc.noaa.gov 8:00 a.m. - 4:30 p.m. 1001 Public No 2019-08-21 1 Year 2020-08-21