63468 Entity Published / External 5620 Guam Boat-based Creel Survey Data Set Completed Data View Yes guam_dawr_wh 1 INTERVIEW_PK varchar 14 No No Active Primary key, a unique identifier for each record in this table. 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 (WD= weekday, WE = weekend/holiday). 4 INTERVIEW_TIME int No No 10 0 Active Time the interview was conducted. 5 INTERVIEWER1_FK int No No 10 0 Active Interviewer1 code. 6 INTERVIEWER2_FK int No No 10 0 Active Interviewer2 code. 7 INTERVIEW_ORDER int No No 10 0 Active Order of the survey was taken. 8 BOATLOG_DT_FK int No No 10 0 Active Filler, not in used. 9 AREA_FK int No No 10 0 Active Code for the area fished. Detailed information can be found in G_BBS_AREA. 10 METHOD_FK int No No 10 0 Active Fishing method code. 11 DEPTH varchar 1 No No Active If bottomfishing, indicates the type of set used (D = deep, S = shallow, M = mixed). 12 WEATHER_FK int No No 10 0 Active Weather conditions. Detailed information can be found in G_WEATHER. 13 CLOUD_FK int No No 10 0 Active Cloud conditions. Detailed information can be found in G_CLOUD or G_CLOUD.DBF. 14 WIND_DIRECTION varchar 2 No No Active Wind direction (e.g. E=east, NE=northeast). 15 WIND_SPEED int No No 10 0 Active Wind speed in knots. 16 HOURS_FISHED decimal No No 7 2 Active Number of hours spent fishing. 17 NUM_FISHER int No No 10 0 Active Number of fishermen fishing. 18 NUM_GUEST int No No 10 0 Active Number of guests on vessel. 19 NUM_DAYS_FISHED int No No 10 0 Active Number of days fished. 20 NUM_GEAR int No No 10 0 Active Number of gears used. 21 VESSEL_NAME varchar 20 No No Active Name of the fishing vessel. 22 PORT_FK int No No 10 0 Active Port code. 23 CAR_LICENSE varchar 10 No No Active Vehicle/trailer license number. 24 TOT_NUM_KEPT_TYPE int No No 10 0 Active How NUM_KEPT was collected (1 = actual, 2 = calculated, 3 = estimated). 25 TOT_NUM_KEPT int No No 10 0 Active Total pieces of fish caught. 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_EST_KGS decimal No No 12 2 Active Total fish caught in kgs for this trip. 28 TOT_SPECIES_TYPE int No No 10 0 Active How TOT_SPECIES was collected (1 = actual, 2 = calculated, 3 = estimated). 29 TOT_SPECIES int No No 10 0 Active Number of species caught on this trip. 30 PERCENT_UNSOLD decimal No No 5 1 Active Percent of unsold catch. 31 PERCENT_SOLD decimal No No 5 1 Active Percent of catch sold (to the hundredths). 32 BUYER_FK int No No 10 0 Active Filler, not in used. 33 BYCATCH_F varchar 1 No No Active If true, this was a bycatch. 34 CHARTER_F char 1 No No Active If true, it is a charter trip. 35 BERTHED_F char 1 No No Active If true, the vessel is berthed. 36 SMALLCRAFT_F char 1 No No Active If true (T), small craft advisory was in effect. 37 HIGHSURF_F char 1 No No Active If true, high surf warning was in effect. 38 NON_SCHED_F char 1 No No Active If true (T), the interview was non-scheduled (opportunistic). 39 LUNAR_DAY int No No 10 0 Active Calculated using G_BBS_LUNAR (15 = full moon, 1 or 29/30 = new moon). This field was not used after 2011. 40 INCOMPLETE_F char 1 No No Active This interview is not complete (all catch from this trip was not captured on this interview). 41 REMARKS varchar 255 No No Active Comment field. 42 INT_CREATE_TIME datetime No No Active Date and time that the record was created or date the record was created. 43 INT_MODIFY_TIME datetime No No Active When was the last date this record was editted 44 INT_CREATE_USER varchar 32 No No Active Name of the user who created the record. 45 INT_MODIFY_USER varchar 32 No No Active Name of the user who last modified the record. 46 INT_LOAD_TABLE varchar 32 No No Active Which VFP table where this data was loaded from 47 INT_LOAD_DATETIME datetime No No Active When this record was loade into MySQL VFP 48 INT_LOAD_USER varchar 32 No No Active User load the data into MySQL 49 CATCH_PK varchar 22 No No Active Primary key, a unique identifier for each record in this table. 50 INTERVIEW_FK varchar 14 No No Active Key that link this record back to its related record found in the c_bbs_int. 51 SPECIES_FK int No No 10 0 Active Species code. 52 NUM_KEPT int No No 10 0 Active Number of fish (pieces) kept. 53 NUM_KEPT_TYPE int No No 10 0 Active Method used to determine pieces of species caught (1 = actual, 2 = calculated, 3 = estimated). 54 EST_KGS decimal No No 8 2 Active Total catch of this species. 55 EST_KGS_TYPE int No No 10 0 Active How weight was collected (1 = actual, 2 = calculated, 3 = estimated). 56 DISPOSITION int No No 10 0 Active Disposition of the fish. Detailed information can be found in G_BBS_DISPOSITION. Old field for archived data conversion. 57 PRICE_LB decimal No No 6 2 Active Place holder, not used. 58 PRICE_LB_TYPE int No No 10 0 Active Place holder, not used. 59 SIZE_GROUP int No No 10 0 Active fish size goup. 60 BYCATCH_TYPE varchar 1 No No Active Condition of bycatch if caught (1= live, 2 = damaged/injured, 3 = other). 61 CAT_REMARKS varchar 255 No No Active Comment field. 62 CAT_CREATE_TIME datetime No No Active When this record was created 63 CAT_MODIFY_TIME datetime No No Active When was the last date this record was editted 64 CAT_LOAD_TABLE varchar 32 No No Active Which VFP table where this data was loaded from 65 CAT_LOAD_DATETIME datetime No No Active When this record was loade into MySQL VFP 66 CAT_LOAD_USER varchar 32 No No Active User load the data into MySQL 67 SIZE_PK int No No 10 0 Active System-generated artificial primary key. 68 CATCH_FK varchar 22 No No Active Key link this record to its related record in C_BBS_CATCH. 69 LEN_MM int No No 10 0 Active Fork length of fish in mm. 70 LEN_MM_TYPE int No No 10 0 Active How len was collected (1 = actual, 2 = calculated, 3 = estimated). 71 KGS decimal No No 7 2 Active Fish weight in kilograms. 72 KGS_TYPE int No No 10 0 Active How weight was collected (1 = actual, 2 = calculated, 3 = estimated). 73 SEX varchar 1 No No Active Place holder, not in used. 74 SIZ_CREATE_TIME datetime No No Active Date the record was created 75 SIZ_MODIFY_TIME datetime No No Active Date the record was last modified 76 SIZ_LOAD_TABLE varchar 32 No No Active varchar(32) 77 SIZ_LOAD_DATETIME datetime No No Active datetime 78 SIZ_LOAD_USER varchar 32 No No Active varchar(32) 79 FISHING_METHOD varchar 25 No No Active Fishing method. 80 FISHING_AREA varchar 35 No No Active Fishing area code. 81 PORT_NAME varchar 20 No No Active Port name. 82 SCIENTIFIC_NAME varchar 40 No No Active Scientific name of the species (Genus name + Species name). 83 COMMON_NAME varchar 45 No No Active Common English name for the species. gov.noaa.nmfs.inport:63468 Brent Miyamoto 2021-01-21T01:05:36 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