=================================================================================== 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: 30-JUN-2010 16:05 **************************************************************** 1997 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,1997,W,8323108,8323108,3775.3,3775.3,6791456,541,247,28 ALBC,1997,O,9167738,9167738,4158.42,4158.42,7341599,1316,498,97 ALBC,1997,C,7403702,7399415,3358.27,3356.32,5791066,2105,641,170 Elapsed: 00:00:00.14 ********************************************************************************************** 1997 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,1997,W,NPS,N PUGET S,45156,45156,20.48,20.48,39711,13,12,4 ALBC,1997,W,SPS,S PUGET S,57504,57504,26.08,26.08,48077,7,6,5 ALBC,1997,W,CWA,COAST WA.,3308739,3308739,1500.82,1500.82,2676671,309,142,15 ALBC,1997,W,CLW,COL R WA.,4911709,4911709,2227.92,2227.92,4026996,214,105,5 ALBC,1997,O,CLO,COL R OR.,3966798,3966798,1799.31,1799.31,3204083,229,139,10 ALBC,1997,O,TLA,TILLAMOOK,260880,260880,118.33,118.33,222404,102,30,11 ALBC,1997,O,NPA,NEWPORT,3935277,3935277,1785.01,1785.01,3094164,527,217,36 ALBC,1997,O,CBA,COOS BAY,759231,759231,344.38,344.38,638644,267,113,33 ALBC,1997,O,BRA,BROOKINGS,245552,245552,111.38,111.38,182304,191,66,16 ALBC,1997,C,CCA,CRESCENT,956170,956170,433.71,433.71,736956,258,97,19 ALBC,1997,C,ERA,EUREKA,1167286,1167286,529.47,529.47,934855,153,65,19 ALBC,1997,C,BGA,BRAGG,167499,167499,75.98,75.98,134281,68,37,12 ALBC,1997,C,BDA,BODEGA,174050,174050,78.95,78.95,128754,106,45,13 ALBC,1997,C,SFA,SF,814337,813602,369.38,369.04,651588,254,115,36 ALBC,1997,C,MNA,MONTEREY,2511015,2510543,1138.98,1138.76,1941692,760,225,40 ALBC,1997,C,MRA,MORRO,402887,401408,182.75,182.08,285878,264,97,21 ALBC,1997,C,SBA,BARBARA,32708,32450,14.84,14.72,29022,42,23,16 ALBC,1997,C,LAA,LA,1032218,1030975,468.21,467.64,823821,115,72,19 ALBC,1997,C,SDA,DIEGO,145507,145407,66,65.96,124195,94,38,20 19 rows selected. Elapsed: 00:00:00.11 **************************************************************************************** 1997 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,1997,W,SEA,SEATTLE,57504,57504,26.08,26.08,48077,7,6,5 ALBC,1997,W,WPT,WESTPORT,3169546,3169546,1437.68,1437.68,2570828,265,129,7 ALBC,1997,W,WLB,WILLAPA,40176,40176,18.22,18.22,32690,6,5,3 ALBC,1997,W,LWC,ILWCO/CHNK,4911709,4911709,2227.92,2227.92,4026996,214,105,5 ALBC,1997,O,AST,ASTORIA,3966798,3966798,1799.31,1799.31,3204083,229,139,10 ALBC,1997,O,TLL,TLMK/GRBLD,257245,257245,116.68,116.68,218946,94,27,9 ALBC,1997,O,PCC,PACIFIC,3635,3635,1.65,1.65,3458,8,4,3 ALBC,1997,O,NEW,NEWPORT,3934620,3934620,1784.72,1784.72,3093507,526,216,35 ALBC,1997,O,FLR,FLORENCE,29641,29641,13.44,13.44,25793,14,9,5 ALBC,1997,O,WIN,WINCHESTER,81686,81686,37.05,37.05,83887,35,13,8 ALBC,1997,O,COS,COOS BAY,640873,640873,290.7,290.7,523256,204,92,19 ALBC,1997,O,BDN,BANDON,7031,7031,3.19,3.19,5708,14,5,3 ALBC,1997,O,ORF,ORFORD,67602,67602,30.66,30.66,51171,40,13,4 ALBC,1997,O,BRK,BROOKINGS,171000,171000,77.56,77.56,125226,145,53,14 ALBC,1997,C,CRS,CRESCENT,956170,956170,433.71,433.71,736956,258,97,19 ALBC,1997,C,ERK,EUREKA,1142413,1142413,518.19,518.19,918151,133,59,16 ALBC,1997,C,TRN,TRINIDAD,3223,3223,1.46,1.46,3276,8,4,4 ALBC,1997,C,BRG,FORT BRAGG,156781,156781,71.11,71.11,125289,46,29,6 ALBC,1997,C,ALB,ALBION,6645,6645,3.01,3.01,5601,13,4,4 ALBC,1997,C,BDG,BODEGA BAY,171559,171559,77.82,77.82,125794,98,41,11 ALBC,1997,C,SF,SF,164235,163500,74.5,74.16,122061,84,41,15 ALBC,1997,C,BKL,BERKELEY,4528,4528,2.05,2.05,2813,6,4,3 ALBC,1997,C,PRN,PRINCETON,74478,74478,33.78,33.78,70319,135,51,19 ALBC,1997,C,CRZ,SANTA CRUZ,75347,75347,34.18,34.18,67403,130,34,16 ALBC,1997,C,MNT,MONTEREY,116279,116279,52.74,52.74,74686,173,42,8 ALBC,1997,C,MOS,MOSS LNDG,2315198,2314726,1050.16,1049.94,1796418,466,170,23 ALBC,1997,C,MRO,MORRO BAY,359732,358253,163.17,162.5,252970,203,75,15 ALBC,1997,C,AVL,AVILA,43155,43155,19.57,19.57,32908,63,26,8 ALBC,1997,C,SB,S. BARBARA,1976,1976,.9,.9,1656,9,6,6 ALBC,1997,C,VEN,VENTURA,12946,12721,5.87,5.77,11541,15,10,7 ALBC,1997,C,OXN,OXNARD,16928,16900,7.68,7.67,14943,16,7,5 ALBC,1997,C,SP,SAN PEDRO,974164,973083,441.87,441.38,774500,69,49,9 ALBC,1997,C,TRM,TERMINAL I,54941,54941,24.92,24.92,45400,27,15,3 ALBC,1997,C,OLA,O LA/ORG,1292,1292,.59,.59,2174,10,7,3 ALBC,1997,C,SD,SAN DIEGO,128659,128559,58.36,58.31,109263,68,29,15 ALBC,1997,C,OSD,O S DIEGO,15385,15385,6.98,6.98,13750,28,13,7 36 rows selected. Elapsed: 00:00:00.05 **************************************************************************************** Counts for each W-O-C port for all catch areas for 1997 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,1997,W,PAG,PT ANGELES,6,6,2 ALBC,1997,W,TNS,TOWNSEND,7,6,2 ALBC,1997,W,SEA,SEATTLE,7,6,5 ALBC,1997,W,LAP,LA PUSH,19,8,2 ALBC,1997,W,GRH,GRAYS HRBR,9,4,2 ALBC,1997,W,WPT,WESTPORT,265,129,7 ALBC,1997,W,WLB,WILLAPA,6,5,3 ALBC,1997,W,OWC,O WA COAST,11,2,2 ALBC,1997,W,LWC,ILWCO/CHNK,214,105,5 ALBC,1997,O,AST,ASTORIA,229,139,10 ALBC,1997,O,TLL,TLMK/GRBLD,94,27,9 ALBC,1997,O,PCC,PACIFIC,8,4,3 ALBC,1997,O,DPO,DEPOE BAY,1,1,2 ALBC,1997,O,NEW,NEWPORT,526,216,35 ALBC,1997,O,FLR,FLORENCE,14,9,5 ALBC,1997,O,WIN,WINCHESTER,35,13,8 ALBC,1997,O,COS,COOS BAY,204,92,19 ALBC,1997,O,BDN,BANDON,14,5,3 ALBC,1997,O,ORF,ORFORD,40,13,4 ALBC,1997,O,GLD,GOLD BEACH,6,3,1 ALBC,1997,O,BRK,BROOKINGS,145,53,14 ALBC,1997,C,CRS,CRESCENT,258,97,19 ALBC,1997,C,ERK,EUREKA,133,59,16 ALBC,1997,C,FLN,FIELDS LDG,13,7,1 ALBC,1997,C,TRN,TRINIDAD,8,4,4 ALBC,1997,C,BRG,FORT BRAGG,46,29,6 ALBC,1997,C,ALB,ALBION,13,4,4 ALBC,1997,C,ARE,PNT ARENA,8,4,2 ALBC,1997,C,OMD,O MENDOCNO,1,1,1 ALBC,1997,C,BDG,BODEGA BAY,98,41,11 ALBC,1997,C,BOL,BOLINAS,8,4,2 ALBC,1997,C,SF,SF,84,41,15 ALBC,1997,C,SLT,SAUSALITO,28,25,2 ALBC,1997,C,BKL,BERKELEY,6,4,3 ALBC,1997,C,OSF,O SF/SMTEO,2,1,1 ALBC,1997,C,PRN,PRINCETON,135,51,19 ALBC,1997,C,CRZ,SANTA CRUZ,130,34,16 ALBC,1997,C,MNT,MONTEREY,173,42,8 ALBC,1997,C,MOS,MOSS LNDG,466,170,23 ALBC,1997,C,OCM,O SCRZ/MTR,1,1,1 ALBC,1997,C,MRO,MORRO BAY,203,75,15 ALBC,1997,C,AVL,AVILA,63,26,8 ALBC,1997,C,SB,S. BARBARA,9,6,6 ALBC,1997,C,VEN,VENTURA,15,10,7 ALBC,1997,C,HNM,PT HUENEME,2,2,2 ALBC,1997,C,OXN,OXNARD,16,7,5 ALBC,1997,C,SP,SAN PEDRO,69,49,9 ALBC,1997,C,TRM,TERMINAL I,27,15,3 ALBC,1997,C,LGB,LONG BEACH,3,2,1 ALBC,1997,C,WLM,WILLMNGTN,1,1,1 ALBC,1997,C,NWB,NEWPORT B.,3,2,2 ALBC,1997,C,DNA,DANA POINT,3,3,2 ALBC,1997,C,OLA,O LA/ORG,10,7,3 ALBC,1997,C,SD,SAN DIEGO,68,29,15 ALBC,1997,C,OCN,OCEANSIDE,2,2,2 ALBC,1997,C,OSD,O S DIEGO,28,13,7 ALBC,1997,C,OCA,OTHER CAL,1,1,1 57 rows selected. Elapsed: 00:00:00.05