5621 Data Set Published / External 5608 Western Pacific Fisheries Information Network (WPacFIN) Project In Work Similar in basic design to other shore-based creel surveys in the region, the Guam survey has been ongoing since the early 1980s and is continuing today. Creel surveys have 2 major sub-surveys; one to estimate participation (fishing effort), and one to provide catch-rate (CPUE), species composition data, and size of fishes. One unique feature about this survey is that it has an aerial survey component which obtains near-shore, non-boat based fishing effort for areas not covered by the Creel survey routes surveyed from vehicles driving along shoreline roads collecting the participation and interview data. Aerial survey data are used to create adjustment factors to estimate the amount of fishing effort and catch made in areas too remote or not accessible by road to surveyors (e.g. too far off the main roads on remote beaches and cliffs, or on military bases). These data are considered confidential. Monitoring Theme DAWR Theme FMB Theme FRMD Theme IFMP Theme PIFSC Theme WPacFIN Theme creel Theme fisheries Theme shore Spatial Guam Spatial island Pacific Islands Fisheries Science Center Honolulu HI USA 1845 Wasp Boulevard, Bldg. #176, Honolulu, Hawaii 96818 Data Set Database Quarterly Table (digital) N/A N/A Creel Survey 63471 Published / External Completed Contains shore-based creel survey expanded catch data based on monthly, quarterly, or yearly periods. Data Table Yes guam_dawr_wh Contains shore-based creel survey expanded catch data based on monthly, quarterly, or yearly periods. 1 EXP_PK varchar 10 Yes Yes Active Key link each species record back to it parent record (g_sbs_exp_vfp) 2 YEAR int No No 10 0 Active Year of the survey date 3 SHIFT int No No 10 0 Active Time of survey shift (1 = 6:00 to 17:59, 2 = 18:00 to 5:59 on next day. 4 TYPE_OF_DAY varchar 2 No No Active Type of day on which interview/survey was conducted. (1 = weekday, 2 = weekend/holiday). Calculated field. 5 METHOD_FK int No No 10 0 Active Code for the fishing method used. Detailed information about method codes can be found in G_SBS_METHOD or G_METHOD.DBF. 6 REGION int No No 10 0 Active Route code of the survey. 7 NUM_PAR int No No 10 0 Active Record counts in the stratum from GINyyPAR.DBF. 8 NUM_INTERVIEW int No No 10 0 Active Number of interviews in this stratum. 9 NUM_SAMPLE_DAYS int No No 10 0 Active The number of participation log entries for the current stratum 10 NUM_CALENDAR_DAYS int No No 10 0 Active number of calender days used in the expansion. 11 SUM_GEAR_PAR int No No 10 0 Active The total number of gears recorded during participation runs for the current stratum. 12 SUM_GEAR2_PAR int No No 10 0 Active The total number of gears recorded during participation runs for the current stratum squared. 13 SUM_FISHER_PAR int No No 10 0 Active The total number of fishers recorded during participation runs for the current stratum. 14 SUM_GEAR_HOUR decimal No No 9 5 Active The number of gear hours represented by interviews collected for the current stratum. 15 SUM_GEAR_HOUR2 decimal No No 14 5 Active The number of gear hours represented by interviews collected for the current stratum squared. 16 SUM_TOT_KGS decimal No No 10 4 Active Total species weight per this stratum 17 SUM_TOT_KGS2 decimal No No 11 4 Active Total species weight per this stratum squared 18 SUM_KGS_GEAR_HOUR decimal No No 14 5 Active The sum of the product of total catch weight and number of gear hours represented by interviews for the current stratum. 19 SUM_HOUR_INT decimal No No 5 1 Active The number of fishing hours represented by interviews collected for the current stratum. 20 SUM_GEAR_INT decimal No No 5 1 Active The total number of gears represented by interviews collected for the current stratum 21 SUM_FISHER_INT int No No 10 0 Active The number of fishers represented by interviews collected for the current stratum 22 SUM_FISHER_HOUR_INT decimal No No 7 2 Active The number of fisher-hours represented by interviews collected for the current stratum. 23 CPUE_GEAR_HOUR decimal No No 7 4 Active Gear-Hour CPUE (Kgs/Gear-Hour) = SM_KG / SM_GR_HR. 24 AVG_GEAR_PAR decimal No No 8 6 Active Average number of gears 25 AVG_FISHER_PAR decimal No No 8 6 Active Average number of fishers 26 EXP_HOUR int No No 10 0 Active Expanded hours fished per stratum = 12 * DAYS (for Shift = 1); 8 * DAYS (for Shift = 2). 27 EXP_GEAR_HOUR decimal No No 11 2 Active Expanded Gear_Hour per stratum = AV_GR * EX_HR. 28 EXP_FISHER_HOUR decimal No No 11 2 Active Expanded Fisherman_Hour per stratum = EX_FACTOR * SM_PR_HR. 29 EXP_KGS decimal No No 9 2 Active Expanded kgs of this gear and stratum 30 EXP_KGS_POOLED decimal No No 9 2 Active Not used. Temporary place holder value during the expansion. 31 VAR_EXP_KGS decimal No No 19 4 Active Varian of expanded fish weight 32 VAR_AVG_GEAR decimal No No 9 7 Active Varian of average gears 33 VAR_GEAR_HOUR decimal No No 15 5 Active Varian of gear-hours CPUE 34 VAR_CPUE_GEAR_HOUR decimal No No 14 10 Active Varian of gear-hours CPUE 35 STD_GEAR_HOUR decimal No No 4 1 Active Standard deviation of gear-hours 36 STD_CPUE_GEAR_HOUR decimal No No 4 1 Active Standard deviation of gear-hours CPUE 37 STD_EXP_KGS decimal No No 4 1 Active Standard deviation of expanded weight 38 P2 decimal No No 5 4 Active A spatial adjustment factor for region = 4 or Region = 0 Expansion): from G_P2.DBF. 39 LOAD_TABLE varchar 32 No No Active Name of the FoxPro table that was loaded into MySQL. 40 LOAD_DATETIME datetime No No Active The date and time the data was loaded in to the table 41 LOAD_USER varchar 32 No No Active User who loaded the data to the MySQL table. 63472 Published / External Completed Data View Yes guam_dawr_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 when 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 varchar 3 No No Active Code for the interviewer. 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 Actual time spent on the fishing trip. Calculated field: INT_TIME - 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 used. Detailed information about method codes can be found in G_SBS_METHOD or G_METHOD.DBF. 16 AREA_FK int No No 10 0 Active Area fished code 17 NUM_GEAR int No No 10 0 Active Number of gears used. 18 REEF_ZONE 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_TYPE 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 BAIT_FK int No No 10 0 Active bait code 29 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. 30 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. 31 SURF int No No 10 0 Active Surf high in feet. 32 TIDE varchar 4 No No Active Tide level 33 NON_SCHED_F char 1 No No Active If true, the interview was not scheduled (opportunistic). 34 INCOMPLETE_F char 1 No No Active This interview was not able to record all the catch of the trip. 35 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.) 36 LUNAR_DAY int No No 10 0 Active Lunar day. 15 = full moon, 1 or 29/30 = new moon based on the value of the survey date 37 INT_REMARKS varchar 255 No No Active Remarks 38 INT_CREATE_TIME datetime No No Active When this record was created 39 INT_MODIFY_TIME datetime No No Active When was the last date this record was editted 40 INT_CREATE_USER varchar 35 No No Active Staff code who enter this data 41 INT_MODIFY_USER varchar 35 No No Active Staff code who last editted this record 42 INT_LOAD_TABLE varchar 32 No No Active Which VFP table where this data was loaded from 43 INT_LOAD_DATETIME datetime No No Active When this record was loade into MySQL VFP 44 INT_LOAD_USER varchar 32 No No Active User load the data into MySQL 45 CATCH_PK varchar 22 No No Active Primary key (only in MySQL) which is a unique identifier for each record in this table. Auto-generated. 46 INTERVIEW_FK varchar 14 No No Active Key value that link this record to the related record found in the g_sbs_int 47 SPECIES_FK int No No 10 0 Active Code for the species. Detailed information can be found in G_SBS_SPECIES or G_SPEC.DBF 48 NUM_KEPT_TYPE int No No 10 0 Active How num_kept was collected (1 = actual, 2 = calculated, 3 = estimated). 49 NUM_KEPT int No No 10 0 Active Number of pieces of fish caught. 50 EST_KGS_TYPE int No No 10 0 Active How weight was collected, 1=actual, 2=calculated and 3=estimated) 51 EST_KGS decimal No No 10 4 Active total catch weight of this species. 52 SIZE_GROUP int No No 10 0 Active fish size goup. 53 BYCATCH_TYPE varchar 1 No No Active Condition of the fish when release (1 = live, 2 = damaged/injured, 3 = other). 54 CAT_CREATE_TIME datetime No No Active When this record was created 55 CAT_MODIFY_TIME datetime No No Active When was the last date this record was editted 56 CAT_LOAD_TABLE varchar 32 No No Active Which VFP table where this data was loaded from 57 CAT_LOAD_DATETIME datetime No No Active When this record was loade into MySQL VFP 58 CAT_LOAD_USER varchar 32 No No Active User load the data into MySQL 59 SIZE_PK int No No 10 0 Active UID created for this record 60 CATCH_FK varchar 22 No No Active Link key to link this record to it parent record in c_bbs_catch 61 LEN_MM_TYPE int No No 10 0 Active How length was measured (1 = actual, 2 = calculated, 3 = estimated). 62 LEN_MM int No No 10 0 Active Fork length of fish, from snout tip to tail fork, in millimeters. 63 KGS_TYPE int No No 10 0 Active How weight was collected (1 = actual, 2 = calculated, 3 = estimated). 64 KGS decimal No No 9 4 Active Fish weight in kilograms. 65 SIZ_CREATE_TIME datetime No No Active This record created date 66 SIZ_MODIFY_TIME datetime No No Active When was last update to this record 67 SIZ_LOAD_TABLE varchar 32 No No Active Which table where data was loaded from VFP database 68 SIZ_LOAD_DATETIME datetime No No Active this record loaded date-time form VFP table 69 SIZ_LOAD_USER varchar 32 No No Active User migrated this data from FVP 70 FISHING_METHOD varchar 25 No No Active fishing method code 71 FISHING_AREA varchar 35 No No Active fishing area code 72 BUYER_NAME varchar 20 No No Active Buyer name 73 BAIT_NAME varchar 16 No No Active type of bait description 74 WEATHER varchar 20 No No Active Code for the weather conditions. Detailed information can be found in C_WEATHER or C_WEATHE.DBF. 75 SCIENTIFIC_NAME varchar 40 No No Active Scientific name of the species (Genus name + Species name). 76 COMMON_NAME varchar 45 No No Active Common English name for the species. 63473 Published / External Completed Contains shore-based creel survey expanded catch data based on monthly, quarterly, or yearly periods. Data Table Yes guam_dawr_wh Contains shore-based creel survey expanded catch data based on monthly, quarterly, or yearly periods. 1 SPC_PK varchar 15 Yes Yes Active UID created for this record 2 EXP_FK varchar 10 No No Active Key link each species record back to it parent record (c_sbs_exp_vfp, EXP_KEY2) 3 SPECIES_FK int No No 10 0 Active Code for the species. Detailed information can be found in G_SBS_SPECIES or G_SPEC.DBF 4 SPECIES_NAME varchar 35 No No Active Species name 5 PERCENT_COMP decimal No No 6 3 Active This species composition 6 EXP_KGS decimal No No 9 2 Active Expanded kgs of this species 7 KGS decimal No No 8 4 Active Fish weight in kilograms. 8 NUM_KEPT int No No 10 0 Active Number of pieces of fish caught. 9 LOAD_TABLE varchar 32 No No Active Name of the FoxPro table that was loaded into MySQL. 10 LOAD_DATETIME datetime No No Active The date and time the data was loaded in to the table 11 LOAD_USER varchar 32 No No Active User who loaded the data to the MySQL table. Data Steward 2025-11-11 Person Suter, Jenny M jenny.suter@noaa.gov 1845 Wasp Blvd Honolulu HI 96818 USA Data Steward 2021-07 Person Gough, Bradley M bradley.gough@noaa.gov 1845 Wasp Blvd. Honolulu HI 96818 USA Contact via email Data Steward 2011-11-01 2020-12 Person Quach, Michael M michael.quach@noaa.gov 1845 Wasp Blvd. Honolulu HI 96818 USA (808)725-5695 1845 Wasp Boulevard, Bldg. #176, Honolulu, Hawaii 96818 Contact via email Distributor 1980 Organization Western Pacific Fishery Information Network WPacFIN NMFS/PIFSC/FRMD/IFMP, 1845 Wasp Blvd., Building 176 Honolulu HI 96818 (808) 725-5660 8:00am-4:30pm (HST) Metadata Contact 2021-07 Person Gough, Bradley M bradley.gough@noaa.gov 1845 Wasp Blvd. Honolulu HI 96818 USA Contact via email Metadata Contact 2015-11-01 2020-02 Person Dukes, Stefanie NS stefanie.dukes@noaa.gov 1845 Wasp Blvd. Honolulu HI 96818 USA (808)725-5615 (808)725-5475 1845 Wasp Boulevard, Bldg. #176, Honolulu, Hawaii 96818 Contact via email Point of Contact 2025-11-11 Person Gough, Bradley M bradley.gough@noaa.gov 1845 Wasp Blvd. Honolulu HI 96818 USA Point of Contact 2021-12 Person Suter, Jenny M jenny.suter@noaa.gov 1845 Wasp Blvd Honolulu HI 96818 USA Contact via email Point of Contact 2019-04-01 2021-04 Person Lumsden, Beth beth.lumsden@noaa.gov 1845 Wasp Blvd. Honolulu HI 96818 USA (808)725-5330 Contact via email Point of Contact 2011-11-01 2018 Person Lowe, Kimberly kimberly.lowe@noaa.gov 1845 Wasp Blvd. Honolulu HI 96818 USA (808)725-5660 9:00 a.m. - 5:30 p.m. HST M-F 2570 Dole Street Honolulu, HI 96822 Contact via email 144.5 145 13.66666666667 13.16666666667 Island of Guam shoreline access may include divers using boats or floatation devices Continuing 1982 Sensitive Data belong to the Guam Divison of Aquatic & Wildlife Resources (DAWR). Data sharing is by cooperative WPacFIN agreement. Other access can be granted only by DAWR. Requires signing a PIFSC non-disclosure statement for fisheries confidential data and approval from the data owner. QC review prior to data entry, some automated QC during data entry, and further QC after data entry. Yes Unknown Yes Yes No 1 Year To Be Determined Unknown PIFSC ITS performs scheduled back-ups. Creel survey data are collected by staff of the Guam Division of Aquatic and Wildlife Resources (DAWR) and entered by a WPacFIN JIMAR employee under a WPacFIN cooperative agreement. 63471 Entity 63472 Entity 63473 Entity gov.noaa.nmfs.inport:5621 Christopher Tokita 2007-10-18T15:55:19 Matthew Long 2025-11-11T22:30:32 2019-07-23 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 No 2019-07-23 1 Year 2020-07-23