63465 Entity Published / External 5629 CNMI Shore-based Creel Survey Data Set Completed Data View Yes cnmi_dfw_wh 1 INTERVIEW_PK varchar 14 No No Active UID assigned to this record 2 SAMPLE_DATE date No No Active Date of the survey. 3 TYPE_OF_DAY varchar 2 No No Active Type of day on which the interview was conducted (1 = weekday, 2 = weekend/holiday). 4 NUM_FISHER int No No 10 0 Active Number of fishermen fishing. 5 INTERVIEW_ORDER int No No 10 0 Active Squential number assigned to each line on the interview form. 6 INTERVIEWER_FK int No No 10 0 Active Code for the interviewer. Detailed information can be found in C_SBS_INTERVIEWER or C_INTERV.DBF. 7 INTERVIEW_TIME int No No 10 0 Active Time the interview. 8 START_TIME int No No 10 0 Active Fishing start time. 9 END_TIME int No No 10 0 Active Fishing stop time. 10 DAY_BEFORE int No No 10 0 Active If fisher started the fishing on the day before today. 11 DAY_AFTER int No No 10 0 Active If fisher plan to stop fishing on the day after today. 12 BREAK_HOURS decimal No No 5 2 Active Break time taken during fishing trip, measured in hours. 13 ACTUAL_HOURS decimal No No 5 2 Active Total fished time for catch recorded on this interview. Calculated field: INT_TIME minus START_TIME. 14 EST_HOURS decimal No No 5 2 Active Estimated of trip time. Calculated field: STOP_TIME - START_TIME. 15 METHOD_FK int No No 10 0 Active Code for the fishing method. Detailed information can be found in C_SBS_METHOD or in C_METHOD.DBF. 16 AREA_FK int No No 10 0 Active Code for the area fished. Detailed information can be found in C_SBS_AREA or C_AREA.DBF. 17 NUM_GEAR int No No 10 0 Active Number of gears used. 18 REEF_ZONE_FK int No No 10 0 Active Code of the reef zone 19 PERCENT_SOLD decimal No No 5 1 Active Percentage of catch sold. 20 PERCENT_UNSOLD decimal No No 5 1 Active Percentage of catch not sold. 21 BUYER_FK int No No 10 0 Active Code for the buyer. Detailed information can be found in C_SBS_BUYER or in C_BUYER.DBF. 22 TOT_NUM_KEPT int No No 10 0 Active Total pieces of species caught. 23 TOT_EST_KGS decimal No No 13 4 Active Total fish weight of this interview 24 TOT_SPECIES int No No 10 0 Active Total number of species caught. 25 TOT_NUM_KEPT_TYP int No No 10 0 Active How tot_num_kept was collected (1 = actual, 2 = calculated, 3 = estimated). 26 TOT_EST_KGS_TYPE int No No 10 0 Active How tot_est_kgs was collected (1 = actual, 2 = calculated, 3 = estimated). 27 TOT_SPECIES_TYPE int No No 10 0 Active How tot_species was collected (1 = actual, 2 = calculated, 3 = estimated). 28 WEATHER_FK int No No 10 0 Active Code for the weather conditions. Detailed information can be found in C_WEATHER or C_WEATHE.DBF. 29 CLOUD_FK int No No 10 0 Active Code for the cloud conditions. Detailed information can be found in C_CLOUD or C_CLOUD.DBF. 30 SURF int No No 10 0 Active Surf conditions (1: 0-1 ft. calm, 2: 1-3 ft. light surf, 6: 3-6 ft. medium surf, 9: 6-9 ft high surf). 31 TIDE decimal No No 5 2 Active Tide level 32 ETHNICITY_FK int No No 10 0 Active Code for the ethnicity of fisherman. Detailed information can be found in C_ETHNICITY or C_ETHNIC.DBF. 33 NON_SCHED_F char 1 No No Active Indicates whether an interview is opportunistic or not. If true (T), it is an opportunistic interview (non-scheduled). 34 BYCATCH_F varchar 1 No No Active If true (T), indicates there was bycatch. For VFP, values can be (Y = bycatch, N = no bycatch, U = not known if there was bycatch.) 35 LUNAR_DAY int No No 10 0 Active Lunar day. Data obtained from C_LUNAR.DBF (foxpro table), based on the value of the survey date (15 = full moon, 1 or 29/30 = new moon). 36 INT_CREATE_TIME datetime No No Active When this record was created 37 INT_MODIFY_TIME datetime No No Active When was the last date this record was editted 38 INT_CREATE_USER int No No 10 0 Active Staff code who enter this data 39 INT_MODIFY_USER int No No 10 0 Active Staff code who last editted this record 40 INT_LOAD_TABLE varchar 32 No No Active Which VFP table where this data was loaded from 41 INT_LOAD_DATETIME datetime No No Active When this record was loade into MySQL VFP 42 INT_LOAD_USER varchar 32 No No Active User load the data into MySQL 43 CATCH_PK varchar 23 No No Active UID assigned to this record 44 INTERVIEW_FK varchar 14 No No Active Identifier each record in C_SBS_INT. 45 SPECIES_FK int No No 10 0 Active Species code. Detailed information can be found in C_SBS_SPECIES or C_SPECIES.DBF. 46 NUM_KEPT_TYPE int No No 10 0 Active How num_kept was collected (1 = actual, 2 = calculated, 3 = estimated). 47 NUM_KEPT int No No 10 0 Active Number of pieces of fish caught. 48 EST_KGS_TYPE int No No 10 0 Active How weight was collected, 1=actual, 2=calculated and 3=estimated) 49 EST_KGS decimal No No 10 4 Active total catch weight of this species. 50 SIZE_GROUP int No No 10 0 Active fish size goup. 51 BYCATCH_TYPE varchar 1 No No Active Condition of the fish when release (1 = live, 2 = damaged/injured, 3 = other). 52 CAT_CREATE_TIME datetime No No Active When this record was created 53 CAT_MODIFY_TIME datetime No No Active When was the last date this record was editted 54 CAT_LOAD_TABLE varchar 32 No No Active Which VFP table where this data was loaded from 55 CAT_LOAD_DATETIME datetime No No Active When this record was loade into MySQL VFP 56 CAT_LOAD_USER varchar 32 No No Active User load the data into MySQL 57 SIZE_PK int No No 10 0 Active UID created for this record 58 CATCH_FK varchar 23 No No Active Link key to link this record to it parent record in c_bbs_catch 59 LEN_MM_TYPE int No No 10 0 Active How len was collected (1 = actual, 2 = calculated, 3 = estimated). 60 LEN_MM int No No 10 0 Active Fork length of fish, from snout tip to tail fork, in millimeters. 61 KGS_TYPE int No No 10 0 Active How weight was collected (1 = actual, 2 = calculated, 3 = estimated). 62 KGS decimal No No 9 4 Active Fish weight in kilograms. 63 SIZ_CREATE_TIME datetime No No Active This record created date 64 SIZ_MODIFY_TIME datetime No No Active When was last update to this record 65 SIZ_LOAD_TABLE varchar 32 No No Active Which table where data was loaded from VFP database 66 SIZ_LOAD_DATETIME datetime No No Active this record loaded date-time form VFP table 67 SIZ_LOAD_USER varchar 32 No No Active User migrated this data from FVP 68 FISHING_METHOD varchar 20 No No Active fishing method code 69 FISHING_AREA varchar 25 No No Active fishing area code 70 BUYER_NAME varchar 30 No No Active Buyer name 71 WEATHER varchar 25 No No Active Weather conditions code description. 72 SCIENTIFIC_NAME varchar 40 No No Active Scientific name of the species (Genus name + Species name). 73 COMMON_NAME varchar 25 No No Active Common English name for the species. 74 LOCAL_NAME varchar 25 No No Active Local name of the species. gov.noaa.nmfs.inport:63465 Brent Miyamoto 2021-01-21T00:50:48 SysAdmin InPortAdmin 2022-08-09T17:11:55 2021-01-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 2021-01-21 1 Year 2022-01-21