U.S. Dept Commerce/NOAA/NMFS/NWFSC/Publications

NOAA-NMFS-NWFSC TM-31: Data Collection -- Groundfish (cont):

Table 6.2
Database tables maintained within PacFIN.a


TableAcronymDescription

Species code listSPPacFIN codes for species of fish
Area code listARPacFIN codes for area fished
Gear-type code listGRPacFIN codes for types of fishing gear
Port/JV/Country code listPCPacFIN codes for ports/joint ventures/countries
Agency code listAGPacFIN codes for agencies (data sources)
Code listCLPacFIN codes for miscellaneous fields
Agency-species code listASPAgency codes for species of fish and corresponding PacFIN codes
Agency-area code listAARAgency codes for area fished and corresponding PacFIN codes
Agency-gear type code listAGRAgency codes for types of fishing gear and corresponding PacFIN codes
Agency-port code listAPRAgency codes for ports and corresponding PacFIN codes
Agency-processor code listAPCAgency codes for fish processors
Fish ticketFTFish ticket data, one entry for each delivery of fish (i.e., each fishing trip)
Fish-ticket linesFTLFish ticket data, one entry for each category of fish delivered
Catch-by-area compositionACMArea fished data
Species-compositionSCMSpecies-composition data
Effort-by-area compositionbECMFishing effort data
Summary-catchSCCatch summaries for combinations of time period, species, area, gear type, and port
Detail-catchDCCatch summaries aggregated by day, week, or month
Summary-effortSEEffort summaries for combinations of time period, species, area, gear type, and port
Detail-effortDEEffort summaries aggregated by day, week, or month
State-vesselsSVState-vessel registration records
U.S. Coast Guard vesselsCGSelected attributes from U.S. Coast Guard vessel registration records
Non-vesselNVData not found in SV table, primarily tribal ID data
Average-weightsbAWAverage-weight data
Update-logULProcessing data, one entry for each update transaction
Detail-logDLProcessing data, catch added during each update event by management group and month

aFor a thorough description of each database table, see: Daspit, W. P. 1996. A description of the Pacific Fishery Information Network (PacFIN) 1981-1996. Unpubl. manuscr., 39 p. plus appendices. (Available from Pacific States Marine Fisheries Commission-PacFIN F/AKC, Building 4 - Room 2066, 7600 Sand Point Way NE, Seattle, WA 98115.)

bTables contain only data submitted by the Oregon Department of Fish and Wildlife; AW table includes only average-weight data for salmon, sturgeon, and shad.