56043 CAM_MAXN_20190321 Entity Published / External 20970 Bottomfish Fishery-Independent Survey in Hawaii (BFISH) - Camera Surveys Data Set On Going Data source: 20190321 Data Table . 1 BFISH VARCHAR2 12 Yes Yes Active Id for survey Mission: BFISH_Year_Season (e.g. BFISH_2017_F). CHARACTER 2 MISSION_ID VARCHAR2 6 No No Active Id for NOAA ship mission (e.g. SE1707). CHARACTER 3 DROP_CD VARCHAR2 15 No No Active Unique ID for the collected sample. CHARACTER 4 VIDEO_FRAME NUMBER 5 No No Active Sequential image frame number from which data record was derived. NUMBER 5 TIME_FROM_TOUCHDOWN_MIN NUMBER 7 No No 6 Active Cummulative number of mintues from time of camera contact with seafloor to "video_frame". NUMBER 4 6 SPECIES_CD VARCHAR2 4 No No Active 4 letter code for species name. CHARACTER 7 SCIENTIFIC_NAME VARCHAR2 50 No No Active Linean (Latin) species name. CHARACTER 8 COMMON_NAME CHARACTER 50 No No Active Local Hawaiian species name. CHARACTER 9 MAXN NUMBER 3 No No Active Maximum number of individuals of "scientific_name" observed during "drop_code". NUMBER 10 DATA_TYPE VARCHAR2 50 No No Active Anazlysis classification method. CHARACTER 11 SEQUENCE_NR VARCHAR2 8 8 Yes Yes Active Consecutive number added to each record. Starts with 00000001 for each BFISH (Survey Mission). CHARACTER 12 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 13 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 14 LAST_MOD_DTM DATE No No Active Date and time this record was last modified (populated by trigger); field added in August 2019. DATE 15 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:56043 Brent Miyamoto 2019-04-12T22:37:56 SysAdmin InPortAdmin 2022-08-09T17:11:45 2019-08-20 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-20 1 Year 2020-08-20