63473 Entity Published / External 5621 Guam Shore-based Creel Survey Data Set 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. gov.noaa.nmfs.inport:63473 Brent Miyamoto 2021-01-21T01:10:44 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