=================================================================================== PacFIN retrieval name is: sum_vdrfd_sp_port_noncon.sql All PacFIN code definitions can be found on the PSMFC/PacFIN website: www.psmfc.org This file contains four comma-separated data sets. The first data set contains total catch for spid = ALBC for landings in each W-O-C state. The second data set contains non-confidential catch for spid = ALBC landed in each W-O-C port group. Some landings may have been excluded from the port group data set due to confidentiality rules. The third data set contains non-confidential catch for spid = ALBC landed in each W-O-C port (i.e. each PacFIN PCID code). Some landings may have been excluded from the port data set due to confidentiality rules. The fourth data set contains counts of trips, vessels, and processors for spid = ALBC landings into each port. Each port having landings will be included. The total landings included in the W-O-C state data set will be more complete than landings included in the port group data set and the port group data set will be more complete than the port data set. Landings from all catch areas are included if the summations are non-confidential. Tables used: vdrfd v, sp, pc; agid = state data source (WA, OR, CA) This data was extracted from the PacFIN tables on: 15-AUG-2016 15:09 **************************************************************** 2015 ALBC landings for each W-O-C data source for all catch areas **************************************************************** '*#*#*#*#*#*#* NON-CONFIDENTIAL DATA *#*#*#*#*#*#*' columns: spid, year, agency, rwt_lbs, lwt-lbs, rwt-mtons, lwt-mtons, revenue in dollars, # of trips, # of vessel identifiers, # of processors =================================================================================== spid,year,agid,rwtlbs,lwtlbs,rwtmt,lwtmt,rev,ntrips,nvids,nprocs ALBC,2015,W,17237526,17237526,7818.82,7818.82,20014654,1142,303,59 ALBC,2015,O,7564711,7564711,3431.3,3431.3,9221099,1184,353,102 ALBC,2015,C,126973,126937,57.59,57.58,244345,129,43,32 Elapsed: 00:00:00.12 ********************************************************************************************** 2015 ALBC landings for each W-O-C port group for all catch areas (confidential summations excluded) ********************************************************************************************** '*#*#*#*#*#*#* NON-CONFIDENTIAL DATA *#*#*#*#*#*#*' columns: spid, year, agency, pcid, port group, rwt_lbs, lwt-lbs, rwt-mtons, lwt-mtons, revenue in dollars, # of trips, # of vessel identifiers, # of processors =================================================================================== spid,year,agid,pcid,portgrp,rwtlbs,lwtlbs,rwtmt,lwtmt,rev,ntrips,nvids,nprocs ALBC,2015,W,NPS,N PUGET S,431709,431709,195.82,195.82,542651,42,29,16 ALBC,2015,W,SPS,S PUGET S,188459,188459,85.48,85.48,214413,23,14,6 ALBC,2015,W,CWA,COAST WA.,11825897,11825897,5364.14,5364.14,13760259,603,156,24 ALBC,2015,W,CLW,COL R WA.,4781691,4781691,2168.94,2168.94,5490656,473,152,12 ALBC,2015,O,CLO,COL R OR.,3509765,3509765,1592,1592,4147150,286,108,13 ALBC,2015,O,TLA,TILLAMOOK,227730,227730,103.3,103.3,294360,153,47,18 ALBC,2015,O,NPA,NEWPORT,2479396,2479396,1124.64,1124.64,3017421,464,142,48 ALBC,2015,O,CBA,COOS BAY,1232061,1232061,558.85,558.85,1616511,235,97,29 ALBC,2015,O,BRA,BROOKINGS,115759,115759,52.51,52.51,145657,48,27,11 ALBC,2015,C,CCA,CRESCENT,25434,25434,11.54,11.54,45226,19,5,4 ALBC,2015,C,ERA,EUREKA,34558,34522,15.68,15.66,77683,44,11,10 ALBC,2015,C,BGA,BRAGG,11479,11479,5.21,5.21,26698,5,4,4 ALBC,2015,C,SFA,SF,18575,18575,8.43,8.43,43847,30,10,5 ALBC,2015,C,MRA,MORRO,5356,5356,2.43,2.43,10836,13,5,6 14 rows selected. Elapsed: 00:00:00.02 **************************************************************************************** 2015 ALBC landings for each W-O-C port for all catch areas (confidential summations excluded) **************************************************************************************** '*#*#*#*#*#*#* NON-CONFIDENTIAL DATA *#*#*#*#*#*#*' columns: spid, year, agency, pcid, port name, rwt_lbs, lwt-lbs, rwt-mtons, lwt-mtons, revenue in dollars, # of trips, # of vessel identifiers, # of processors =================================================================================== spid,year,agid,pcid,portname,rwtlbs,lwtlbs,rwtmt,lwtmt,rev,ntrips,nvids,nprocs ALBC,2015,W,NEA,NEAH BAY,26804,26804,12.16,12.16,30458,17,12,6 ALBC,2015,W,BLL,BELLINGHAM,319657,319657,144.99,144.99,385308,17,13,5 ALBC,2015,W,SEA,SEATTLE,173906,173906,78.88,78.88,193195,8,5,4 ALBC,2015,W,WPT,WESTPORT,11793603,11793603,5349.49,5349.49,13724150,586,149,20 ALBC,2015,W,LWC,ILWCO/CHNK,4726707,4726707,2144,2144,5432212,427,150,10 ALBC,2015,O,AST,ASTORIA,3509700,3509700,1591.98,1591.98,4147079,285,107,13 ALBC,2015,O,TLL,TLMK/GRBLD,221896,221896,100.65,100.65,285484,129,39,14 ALBC,2015,O,PCC,PACIFIC,5834,5834,2.65,2.65,8876,24,9,5 ALBC,2015,O,DPO,DEPOE BAY,4504,4504,2.04,2.04,8473,15,5,6 ALBC,2015,O,NEW,NEWPORT,2474892,2474892,1122.59,1122.59,3008948,449,137,45 ALBC,2015,O,FLR,FLORENCE,17628,17628,8,8,39349,11,3,3 ALBC,2015,O,WIN,WINCHESTER,56171,56171,25.48,25.48,106524,20,10,8 ALBC,2015,O,COS,COOS BAY,1156510,1156510,524.58,524.58,1468886,204,87,18 ALBC,2015,O,ORF,ORFORD,10891,10891,4.94,4.94,17153,19,8,4 ALBC,2015,O,BRK,BROOKINGS,100667,100667,45.66,45.66,122493,23,14,6 ALBC,2015,C,CRS,CRESCENT,25434,25434,11.54,11.54,45226,19,5,4 ALBC,2015,C,ERK,EUREKA,34558,34522,15.68,15.66,77683,44,11,10 ALBC,2015,C,BRG,FORT BRAGG,11479,11479,5.21,5.21,26698,5,4,4 ALBC,2015,C,PRN,PRINCETON,15158,15158,6.88,6.88,40547,15,3,4 ALBC,2015,C,MRO,MORRO BAY,5356,5356,2.43,2.43,10836,13,5,6 20 rows selected. Elapsed: 00:00:00.01 **************************************************************************************** Counts for each W-O-C port for all catch areas for 2015 ALBC **************************************************************************************** '*#*#*#*#*#*#* NON-CONFIDENTIAL DATA *#*#*#*#*#*#*' columns: spid, year, agency, pcid, port name, # of trips, # of vessel identifiers, # of processors =================================================================================== spid,year,agid,pcid,portname,ntrips,nvids,nprocs ALBC,2015,W,NEA,NEAH BAY,17,12,6 ALBC,2015,W,PAG,PT ANGELES,5,2,2 ALBC,2015,W,SEQ,SEQUIM,1,1,1 ALBC,2015,W,TNS,TOWNSEND,2,2,2 ALBC,2015,W,BLL,BELLINGHAM,17,13,5 ALBC,2015,W,ANA,ANACORTES,1,1,1 ALBC,2015,W,SEA,SEATTLE,8,5,4 ALBC,2015,W,TAC,TACOMA,1,1,1 ALBC,2015,W,OLY,OLYMPIA,14,9,1 ALBC,2015,W,LAP,LA PUSH,1,1,1 ALBC,2015,W,GRH,GRAYS HRBR,4,2,1 ALBC,2015,W,WPT,WESTPORT,586,149,20 ALBC,2015,W,WLB,WILLAPA,2,1,1 ALBC,2015,W,OWC,O WA COAST,10,6,2 ALBC,2015,W,LWC,ILWCO/CHNK,427,150,10 ALBC,2015,W,OCR,O COL WA,47,4,2 ALBC,2015,W,OWA,UNKN WASH,10,1,1 ALBC,2015,O,AST,ASTORIA,285,107,13 ALBC,2015,O,GSS,GEARHART,1,1,1 ALBC,2015,O,TLL,TLMK/GRBLD,129,39,14 ALBC,2015,O,PCC,PACIFIC,24,9,5 ALBC,2015,O,DPO,DEPOE BAY,15,5,6 ALBC,2015,O,NEW,NEWPORT,449,137,45 ALBC,2015,O,FLR,FLORENCE,11,3,3 ALBC,2015,O,WIN,WINCHESTER,20,10,8 ALBC,2015,O,COS,COOS BAY,204,87,18 ALBC,2015,O,BDN,BANDON,1,1,1 ALBC,2015,O,ORF,ORFORD,19,8,4 ALBC,2015,O,GLD,GOLD BEACH,6,5,2 ALBC,2015,O,BRK,BROOKINGS,23,14,6 ALBC,2015,C,CRS,CRESCENT,19,5,4 ALBC,2015,C,ERK,EUREKA,44,11,10 ALBC,2015,C,BRG,FORT BRAGG,5,4,4 ALBC,2015,C,SF,SF,15,7,1 ALBC,2015,C,PRN,PRINCETON,15,3,4 ALBC,2015,C,MOS,MOSS LNDG,1,1,1 ALBC,2015,C,MRO,MORRO BAY,13,5,6 ALBC,2015,C,SB,S. BARBARA,1,1,1 ALBC,2015,C,VEN,VENTURA,10,1,1 ALBC,2015,C,SP,SAN PEDRO,4,4,1 ALBC,2015,C,OSD,O S DIEGO,2,2,1 41 rows selected. Elapsed: 00:00:00.02