27401 Commercial Fisheries Database Biological Sample (CFDBS) Data Set Published / External 24234 Data Management Systems (DMS) Project Completed Age and length frequency data for finfish and invertebrate species collected during commercial fishing vessels. Samples are collected by fisheries reporting specialist from fish dealers in ports along the northwest Atlantic Ocean from Maine to North Carolina. The age and length data is used to characterize the fish populations in stock assessments. Theme AGE Structures Theme Age by species Theme Length by species Northeast Fisheries Science Center Woods Hole MA USA Data Set Oracle Database Continually Table (digital) Time series containing the age of individual finfish and invertebrates species by length. Length frequency data by species. N/A NEFSC and GARFO N/A Online data entry system Collected from fish dealers 33429 AREA Published / External Completed Commercial Fisheries Area Support Table. Loaded by batch 8988, 07-11-2016 08:41 Data Table Yes CFDBS Commercial Fisheries Area Support Table. 1 NEMAREA VARCHAR2 3 No No Active The NEMFIS Area, coded as the NAFO Statistical Area for federally collected data; a three digit code for internal state waters for state collected data. For 1994+ allocated data, if Area Level = A then NEMAREA is from the VTR trip. If Area Level = B, C,D then NEMAREA is selected from a group of VTR trips with similar trip characteristics on a probabilistic basis. If Area Level = X, then nemarea is unknown. VARCHAR2 2 AREA VARCHAR2 3 No No Active The Northwest Atlantic Fisheries Organization (NAFO) Statistical Area code. See CFDBS Area Table (AREA) for actual codes. For 1994+ allocated data, if Area Level = A then NEMAREA is from the VTR trip. If Area Level = B, C,D then AREA is selected from a group of VTR trips with similar trip characteristics on a probabilistic basis. If Area Level = X then AREA is unknown. VARCHAR2 3 REGION VARCHAR2 1 No No Active NMFS Region code: 0=Mississippi River; 1=New England; 2=Mid-Atlantic; 3=Chesapeake Bay; 4=South Atlantic; 5=Gulf of Mexico; 6=Pacific; 7=Great Lakes; 8= Hawaii. VARCHAR2 4 STATECD VARCHAR2 2 No No Active The standard 2-digit state code (07=CT, 08=DE, 22=ME, 23=MD, 24=MA, 32=NH, 33=NJ, 35=NY, 36=NC, 42=RI, 49=VA, 99=unknown). VARCHAR2 5 WATERCD VARCHAR2 4 No No Active NMFS Water Body code. VARCHAR2 6 AREANM VARCHAR2 50 No No Active Descriptive name for area. VARCHAR2 7 NAFODIV VARCHAR2 3 No No Active The alpha NAFO Division code. VARCHAR2 8 NAFDVCD VARCHAR2 2 No No Active The numeric Northwest Atlantic Fisheries Organization (NAFO) Division code. VARCHAR2 9 DOC DATE 7 No No Active The date of the last change to this record. DATE 10 COMMENTS VARCHAR2 160 No No Active Comments related to associated record. VARCHAR2 11 LISTCOL VARCHAR2 20 No No Active Abbreviated Description Used for Select Lists VARCHAR2 33430 CFAGEyyyy Published / External Completed Commercial Fisheries Age Data from 1994 to date. Loaded by batch 8988, 07-11-2016 08:41 Data View Yes CFDBS Commercial Fisheries Age Data from 1994 to date. 1 PORT VARCHAR2 6 No No Active A combined code for state, port and county. The port in which the vessel landed the catch. VARCHAR2 2 STATE VARCHAR2 2 No No Active The 2 digit numeric state code for the port of landing: <br> 07=CT; 08=DE; 22=ME; 23=MD; 24=MA; 32=NH; 33=NJ; 35=NY; 36=NC; 42=RI; 49=VA. VARCHAR2 3 PORT2 VARCHAR2 2 No No Active The 3rd and 4th digit of the port code--meaningless without the rest of the port code. VARCHAR2 4 COUNTY VARCHAR2 2 No No Active Name of county., ex.ESSEX. VARCHAR2 5 YEAR VARCHAR2 4 No No Active The year in which the landings or negative report occurred. VARCHAR2 6 LINK VARCHAR2 8 No No Active The field (month-document) used to link species and biological sampling data to the trip information. Length of the link field depends on the year: pre 1994 document numbers (DOCN) were 4 characters; post 1993, 6 characters. For 1994+ allocated data, for CFDETTyyyyAA and CFDETSyyyyAA, LINK = (dlrtrpid, month, docn, subtrip); VARCHAR2(35); For CFAGEyyyyAA and CFLENyyyyAA, 1994 to 2003, Link = (dlrtrpid, month, docn, subtrip); For CFAGEyyyyAA and CFLENyyyyAA, 2004 to present, LINK = (month,docn,tallyno,sampno,linkpad) where linkpad is 15 zeros. VARCHAR2 7 MONTH VARCHAR2 2 No No Active The month (01-12) of the vessel landing or negative dealer report. 00 = unknown. VARCHAR2 8 DOCN VARCHAR2 6 No No Active Number assigned to each weighout form, or negative dealer report; Unique within a month. For 1994+ allocated data , DOCN column width is expanded, VARCHAR2(15). VARCHAR2 9 AREA VARCHAR2 3 No No Active The Northwest Atlantic Fisheries Organization (NAFO) Statistical Area code. See CFDBS Area Table (AREA) for actual codes. For 1994+ allocated data, if Area Level = A then NEMAREA is from the VTR trip. If Area Level = B, C,D then AREA is selected from a group of VTR trips with similar trip characteristics on a probabilistic basis. If Area Level = X then AREA is unknown. VARCHAR2 10 NEMAREA VARCHAR2 3 No No Active The NEMFIS Area, coded as the NAFO Statistical Area for federally collected data; a three digit code for internal state waters for state collected data. For 1994+ allocated data, if Area Level = A then NEMAREA is from the VTR trip. If Area Level = B, C,D then NEMAREA is selected from a group of VTR trips with similar trip characteristics on a probabilistic basis. If Area Level = X, then nemarea is unknown. VARCHAR2 11 NESPP4 VARCHAR2 4 No No Active The 4-digit Northeast Species code; the fourth digit represents market category. See CFDBS Species Table (CFSPP) for actual codes. For discard species in the CFDISCyyyy and WODISCyy views, NESPP4 is redefined as NESPP3 preceded by a 9, e.g. yellowtail flounder is 9123. VARCHAR2 12 NESPP3 VARCHAR2 3 No No Active The Northeast Species code, without the market category, i.e. the first 3 digits of NESPP4. See CFDBS Species Table (CFSPP) for actual codes. VARCHAR2 13 QTR VARCHAR2 1 No No Active The quarter of the calendar year in which weighout occurred: 1=January-March; 2=April-June; 3=July-September; 4=October-December. VARCHAR2 14 NEGEAR VARCHAR2 3 No No Active Northeast Gear code; 999=Unknown. See CFDBS Gear Table(GEAR) for actual codes. For 1994+ allocated data, negear is taken from the matched VTR trip when Area Level = A; negear is supplied by the Dealer when Area Level = B,C,D or X. VARCHAR2 15 NEGEAR2 VARCHAR2 2 No No Active First two digits of the Northeast Gear code. See CFDBS Gear Table (GEAR) for actual codes. VARCHAR2 16 SAMPMETH NUMBER 22 No No 1 0 Active The method used to sample the vessel's catch: 1=vessel or hold; 2=basket or bushel; 3=chute or conveyor; 4=cart,barrel,tub,large box; 5=bin, floor pile; 6=small box; 7=sorting table. See "Manual for Sampling, Interviewing and Coding for the Northeast Region" by R.I. Schultz. NUMBER 17 CATDISP VARCHAR2 1 No No Active Indicates if the catch from which the sample was taken was: <br> 0=discarded, 1=kept. VARCHAR2 18 AGESTRCT NUMBER 22 No No 1 0 Active The structure retained for age determination: 0=No structure taken; 1=Scale; 2=Otoliths; 3=Shells; 4=Pen; 5=Vertebra; 6=Dorsal spine. NUMBER 19 SEX VARCHAR2 1 No No Active Sex code: 0=unsexed; 1=male; 2=female. VARCHAR2 20 LENGTH NUMBER 22 No No 3 0 Active The length of specimen in centimeters. NUMBER 21 NPAIRS NUMBER 22 No No 3 0 Active The number of length frequency pairs. NUMBER 22 AGE NUMBER 22 No No 2 0 Active The age of specimen in years. NUMBER 23 NUMAGE NUMBER 22 No No 3 0 Active The number of specimens at a given age. NUMBER 24 NO_LEN_MATCH VARCHAR2 1 No No Active Flag indicating that there is no matching length record for the age record. VARCHAR2 33431 CFLENyyyy Published / External Completed Commercial Fisheries Length Data from 1994 to date. Loaded by batch 8988, 07-11-2016 08:41 Data View Yes CFDBS Commercial Fisheries Length Data from 1994 to date. 1 YEAR NUMBER 22 Yes No 4 0 Active The year in which the landings or negative report occurred. NUMBER 2 LINK VARCHAR2 8 No No Active The field (month-document) used to link species and biological sampling data to the trip information. Length of the link field depends on the year: pre 1994 document numbers (DOCN) were 4 characters; post 1993, 6 characters. For 1994+ allocated data, for CFDETTyyyyAA and CFDETSyyyyAA, LINK = (dlrtrpid, month, docn, subtrip); VARCHAR2(35); For CFAGEyyyyAA and CFLENyyyyAA, 1994 to 2003, Link = (dlrtrpid, month, docn, subtrip); For CFAGEyyyyAA and CFLENyyyyAA, 2004 to present, LINK = (month,docn,tallyno,sampno,linkpad) where linkpad is 15 zeros. VARCHAR2 3 MONTH VARCHAR2 2 Yes No Active The month (01-12) of the vessel landing or negative dealer report. 00 = unknown. VARCHAR2 4 QTR VARCHAR2 1 No No Active The quarter of the calendar year in which weighout occurred: 1=January-March; 2=April-June; 3=July-September; 4=October-December. VARCHAR2 5 DOCN VARCHAR2 6 Yes No Active Number assigned to each weighout form, or negative dealer report; Unique within a month. For 1994+ allocated data , DOCN column width is expanded, VARCHAR2(15). VARCHAR2 6 DEALNUM VARCHAR2 5 Yes No Active The dealer permit number assigned by the Northeast Regional Office Permit System (PERMIT). 00000=Unknown. Not available for 1994 in CFDBS data. VARCHAR2 7 DAY VARCHAR2 2 Yes No Active Day of month (01-31). Unknown=00. Day = 00 may indicate a consolidated trip that represents more than one trip. VARCHAR2 8 PORT VARCHAR2 6 Yes No Active A combined code for state, port and county. The port in which the vessel landed the catch. VARCHAR2 9 STATE VARCHAR2 8 No No Active The 2 digit numeric state code for the port of landing: <br> 07=CT; 08=DE; 22=ME; 23=MD; 24=MA; 32=NH; 33=NJ; 35=NY; 36=NC; 42=RI; 49=VA. VARCHAR2 10 PORT2 VARCHAR2 8 No No Active The 3rd and 4th digit of the port code--meaningless without the rest of the port code. VARCHAR2 11 COUNTY VARCHAR2 8 No No Active Name of county., ex.ESSEX. VARCHAR2 12 PERMIT VARCHAR2 6 Yes No Active Vessel permit number assigned by the Northeast Regional Office's Vessel Permit System (VPS). 000000=no permit or no vessel, check hull number; 190998=Unknown undertonnage vessel; 390998=Unknown tonnage vessel. VARCHAR2 13 HULLNUM VARCHAR2 10 No No Active Official vessel registration number painted on the hull. U.S. Coast Guard, State, or Tribal registration number. Text field--State registrations begin with two character state code. Unknown=blank/null. VARCHAR2 14 NEGEAR VARCHAR2 3 Yes No Active Northeast Gear code; 999=Unknown. See CFDBS Gear Table(GEAR) for actual codes. For 1994+ allocated data, negear is taken from the matched VTR trip when Area Level = A; negear is supplied by the Dealer when Area Level = B,C,D or X. VARCHAR2 15 NEGEAR2 VARCHAR2 8 No No Active First two digits of the Northeast Gear code. See CFDBS Gear Table (GEAR) for actual codes. VARCHAR2 16 SOURCE VARCHAR2 2 No No Active Source of the data: <br> 0=Weighout, only (Non-Mandatory);<br> 1=Weighout + Interview;<br> 2=Weighout + Captain's Log;<br> 3=Weighout + Sea Sample Data;<br> 4=Weighout + Foreign JV;<br> 5=NEMFIS State Data (IWP*);<br> 6=Weighout + Domestic JV (IWP*);<br> 7=Mandatory Reporting; <br> 8=Clam Logbook; <br> 9=Tuna Logbook; <br> 10=Estimated General Landings; <br> 11=Estimated Mandatory Landings; <br> 12=Vessel Trip Report w/o Dealer Report; <br> 13=Canadian Transhipment (no IWP*); <br> 14=NMFS Enforcement; <br> 15=State Enforcement. <br> *IWP = Internal Waters Processing. VARCHAR2 17 EFFIND VARCHAR2 1 No No Active 0 = Uninterviewed w/minimal effort data: DA, DF, NTRIPS, FZONE... 1 = Interviewed w/detailed effort data; 2 = Mandatory/Dealer report only, i.e., no effort data; 3 = Mandatory/Vessel log only, i.e., effort data; 4 = Mandatory/Dealer & vessel log, i.e., detailed effort data. VARCHAR2 18 NESPP4 VARCHAR2 4 Yes No Active The 4-digit Northeast Species code; the fourth digit represents market category. See CFDBS Species Table (CFSPP) for actual codes. For discard species in the CFDISCyyyy and WODISCyy views, NESPP4 is redefined as NESPP3 preceded by a 9, e.g. yellowtail flounder is 9123. VARCHAR2 19 NESPP3 VARCHAR2 12 No No Active The Northeast Species code, without the market category, i.e. the first 3 digits of NESPP4. See CFDBS Species Table (CFSPP) for actual codes. VARCHAR2 20 AREA VARCHAR2 3 No No Active The Northwest Atlantic Fisheries Organization (NAFO) Statistical Area code. See CFDBS Area Table (AREA) for actual codes. For 1994+ allocated data, if Area Level = A then NEMAREA is from the VTR trip. If Area Level = B, C,D then AREA is selected from a group of VTR trips with similar trip characteristics on a probabilistic basis. If Area Level = X then AREA is unknown. VARCHAR2 21 NEMAREA VARCHAR2 3 No No Active The NEMFIS Area, coded as the NAFO Statistical Area for federally collected data; a three digit code for internal state waters for state collected data. For 1994+ allocated data, if Area Level = A then NEMAREA is from the VTR trip. If Area Level = B, C,D then NEMAREA is selected from a group of VTR trips with similar trip characteristics on a probabilistic basis. If Area Level = X, then nemarea is unknown. VARCHAR2 22 SPPLNDLB VARCHAR2 9 No No Active The pounds landed for a given species. VARCHAR2 23 CATDISP VARCHAR2 1 No No Active Indicates if the catch from which the sample was taken was: <br> 0=discarded, 1=kept. VARCHAR2 24 UTILCD VARCHAR2 1 No No Active The utilization code: 0=food fish or unknown; 2=aquaculture; 3=canned pet food (1984+); 4=Biomedical (2002+); 5=animal food (1984+); 7=bait; 8=industrial, other (2002+); 9=industrial, reduction. VARCHAR2 25 SAMPMETH NUMBER 22 No No 1 0 Active The method used to sample the vessel's catch: 1=vessel or hold; 2=basket or bushel; 3=chute or conveyor; 4=cart,barrel,tub,large box; 5=bin, floor pile; 6=small box; 7=sorting table. See "Manual for Sampling, Interviewing and Coding for the Northeast Region" by R.I. Schultz. NUMBER 26 AGESTRCT NUMBER 22 No No 1 0 Active The structure retained for age determination: 0=No structure taken; 1=Scale; 2=Otoliths; 3=Shells; 4=Pen; 5=Vertebra; 6=Dorsal spine. NUMBER 27 SEX NUMBER 22 No No 1 0 Active Sex code: 0=unsexed; 1=male; 2=female. NUMBER 28 VESSEL2 VARCHAR2 6 No No Active Second vessel for paired gears. For Federal data, the 6-digit vessel number; for state data, the official US Coast Guard documentation number or a locally assigned number. 190998=unknown undertonnage vessel; 390998=unknown tonnage vessel; 000000=no vessel or unknown vessel. See CFDBS Master Vessel Table (MSTRVESS) for pre 1994 vessel codes. VARCHAR2 29 NAGESPEC NUMBER 22 No No 3 0 Active The number of specimens from which aging structures were removed for this sample. NUMBER 30 WGTSAMP NUMBER 22 No No 5 0 Active The weight of specimens in sample. NUMBER 31 AREASAMP VARCHAR2 3 No No Active NEMFIS area code for the area from which the sample was taken; may be different from the area recorded for the trip. VARCHAR2 32 AREASRCE VARCHAR2 2 No No Active Code indicating how the area of the sample was determined: <br> 0=unknown; 1=weighout; 2=interview; 3=port agent's best guess. VARCHAR2 33 NUMSAMP NUMBER 22 No No Active The number of specimens in sample. NUMBER 34 NPAIRS NUMBER 22 No No 3 Active The number of length frequency pairs. NUMBER 35 LENGTH NUMBER 22 No No 3 0 Active The length of specimen in centimeters. NUMBER 36 NUMLEN NUMBER 22 No No 3 0 Active The total number of specimens at specified length. NUMBER 33432 CFSPP Published / External Completed Commercial Fisheries Species Support Table. Loaded by batch 8988, 07-11-2016 08:41 Data View Yes CFDBS Commercial Fisheries Species Support Table. 1 SPPNM VARCHAR2 20 No No Active Species common name. VARCHAR2 2 MKTNM VARCHAR2 20 No No Active Market category name for a particular species. VARCHAR2 3 SPPNM8 VARCHAR2 8 No No Active Species name abbreviation. VARCHAR2 4 SPPNM3 VARCHAR2 3 No No Active NAFO Species name abbreviation. VARCHAR2 5 NESPP3 VARCHAR2 3 No No Active The Northeast Species code, without the market category, i.e. the first 3 digits of NESPP4. See CFDBS Species Table (CFSPP) for actual codes. VARCHAR2 6 MKTCAT VARCHAR2 1 No No Active Market category of the 3-digit species code. VARCHAR2 7 NESPP4 VARCHAR2 4 No No Active The 4-digit Northeast Species code; the fourth digit represents market category. See CFDBS Species Table (CFSPP) for actual codes. For discard species in the CFDISCyyyy and WODISCyy views, NESPP4 is redefined as NESPP3 preceded by a 9, e.g. yellowtail flounder is 9123. VARCHAR2 8 WASHSPP VARCHAR2 4 No No Active The Washington Species code with market category. VARCHAR2 9 WHSPP VARCHAR2 3 No No Active The 3 digit commercial species code developed by the Woods Hole lab. See CFDBS Species Table (CFSPP) for actual codes. VARCHAR2 10 NAFOSPP VARCHAR2 3 No No Active Northwest Atlantic Fisheries Organization (NAFO) Species code. VARCHAR2 11 SVSPP VARCHAR2 3 No No Active Northeast Resource Surveys Species code. See SVDBS Species Table for actual codes. VARCHAR2 12 NAFSPGRP VARCHAR2 2 No No Active NAFO Species Group. VARCHAR2 13 NECNV NUMBER 22 No No 4 2 Active Northeast conversion factor for converting landed to live weight. NUMBER 14 WASHCNV NUMBER 22 No No 4 2 Active Washington conversion factor to convert landed to live weight. NUMBER 15 MINPR NUMBER 22 No No 3 0 Active The minimum acceptable price per pound for a particular species. NUMBER 16 MAXPR NUMBER 22 No No 3 0 Active The maximum acceptable price per pound for a particular species. NUMBER 17 DOC DATE 7 No No Active The date of the last change to this record. DATE 33433 GEAR Published / External Completed Commercial Fisheries Gear Support Table. Loaded by batch 8988, 07-11-2016 08:41 Data View Yes CFDBS Commercial Fisheries Gear Support Table. 1 NEGEAR VARCHAR2 3 No No Active Northeast Gear code; 999=Unknown. See CFDBS Gear Table(GEAR) for actual codes. For 1994+ allocated data, negear is taken from the matched VTR trip when Area Level = A; negear is supplied by the Dealer when Area Level = B,C,D or X. VARCHAR2 2 NEGEAR2 VARCHAR2 8 No No Active First two digits of the Northeast Gear code. See CFDBS Gear Table (GEAR) for actual codes. VARCHAR2 3 GEARNM VARCHAR2 50 No No Active Descriptive name for the NE Gear Code. VARCHAR2 4 WASHGEAR VARCHAR2 3 No No Active Washington Gear Code. VARCHAR2 5 NAFOGEAR VARCHAR2 2 No No Active NAFO Gear Code. VARCHAR2 6 NAFOGRAB VARCHAR2 4 No No Active NAFO Gear Code abbreviation. VARCHAR2 7 NAFOGRGP VARCHAR2 3 No No Active NAFO Gear Group. VARCHAR2 8 NAFOGRNM VARCHAR2 51 No No Active Descriptive NAFO Gear Name. VARCHAR2 9 GEARABB VARCHAR2 3 No No Active Abbreviated Gear Code VARCHAR2 10 OBGEARCAT VARCHAR2 2 No No Active Gear category or fishery code used for the observer data: Gear Category used by observer program: OT = Otter trawl,GG = gillnet, PT = Pots and traps , LL = Longline and other line gear, BS = beach set, SD = Scallop Dredge, PR = pair trawl,PS = purse seine, ST = Scallop Trawl, TT Twin Trawl, NK =Not known, OB=Obsolete. VARCHAR2 11 LISTCOL VARCHAR2 20 No No Active Abbreviated Description Used for Select Lists VARCHAR2 12 DOC DATE 7 No No Active The date of the last change to this record. DATE 33434 PORT Published / External Completed Commercial Fisheries Port Support Table. Loaded by batch 8988, 07-11-2016 08:41 Data View Yes CFDBS Commercial Fisheries Port Support Table. 1 PORT VARCHAR2 6 No No Active A combined code for state, port and county. The port in which the vessel landed the catch. VARCHAR2 2 STATECD VARCHAR2 8 No No Active The standard 2-digit state code (07=CT, 08=DE, 22=ME, 23=MD, 24=MA, 32=NH, 33=NJ, 35=NY, 36=NC, 42=RI, 49=VA, 99=unknown). VARCHAR2 3 PORT2 VARCHAR2 8 No No Active The 3rd and 4th digit of the port code--meaningless without the rest of the port code. VARCHAR2 4 COUNTYCD VARCHAR2 8 No No Active The last 2 digits of the port code, indicating the county, or, in a few cases, the city in which a port is geographically located. VARCHAR2 5 PORTNM VARCHAR2 25 No No Active The name of the fishing port. VARCHAR2 6 STATEABB VARCHAR2 2 No No Active The 2 character alpha state code (CT, DE, MA, MD, ME, NC, NH, NJ, NY, RI, VA). VARCHAR2 7 COUNTY VARCHAR2 30 No No Active Name of county., ex.ESSEX. VARCHAR2 8 PSREGION VARCHAR2 1 No No Active Northeast sampling regions: 1=Maine/New Hampshire; 2=Northern Massachusetts; 3=Southern Massachusetts, incl Cape Cod; 4=Rhode Island/Connecticut; 5=New York, incl Long Island; 6=New Jersey; 7=Virginia/Maryland/North Carolina. VARCHAR2 9 DOC DATE 7 No No Active The date of the last change to this record. DATE 33437 WOAGEyy Published / External Completed Commercial Fisheries Age Data for 1961, 1965 to 1993. Loaded by batch 8988, 07-11-2016 08:41 Data View Yes CFDBS Commercial Fisheries Age Data for 1961, 1965 to 1993. 1 PORT VARCHAR2 6 No No Active A combined code for state, port and county. The port in which the vessel landed the catch. VARCHAR2 2 STATE VARCHAR2 8 No No Active The 2 digit numeric state code for the port of landing: <br> 07=CT; 08=DE; 22=ME; 23=MD; 24=MA; 32=NH; 33=NJ; 35=NY; 36=NC; 42=RI; 49=VA. VARCHAR2 3 PORT2 VARCHAR2 8 No No Active The 3rd and 4th digit of the port code--meaningless without the rest of the port code. VARCHAR2 4 COUNTY VARCHAR2 8 No No Active Name of county., ex.ESSEX. VARCHAR2 5 YEAR NUMBER 22 No No 4 0 Active The year in which the landings or negative report occurred. NUMBER 6 LINK VARCHAR2 6 No No Active The field (month-document) used to link species and biological sampling data to the trip information. Length of the link field depends on the year: pre 1994 document numbers (DOCN) were 4 characters; post 1993, 6 characters. For 1994+ allocated data, for CFDETTyyyyAA and CFDETSyyyyAA, LINK = (dlrtrpid, month, docn, subtrip); VARCHAR2(35); For CFAGEyyyyAA and CFLENyyyyAA, 1994 to 2003, Link = (dlrtrpid, month, docn, subtrip); For CFAGEyyyyAA and CFLENyyyyAA, 2004 to present, LINK = (month,docn,tallyno,sampno,linkpad) where linkpad is 15 zeros. VARCHAR2 7 MONTH VARCHAR2 2 No No Active The month (01-12) of the vessel landing or negative dealer report. 00 = unknown. VARCHAR2 8 DOCN VARCHAR2 4 No No Active Number assigned to each weighout form, or negative dealer report; Unique within a month. For 1994+ allocated data , DOCN column width is expanded, VARCHAR2(15). VARCHAR2 9 AREA VARCHAR2 3 No No Active The Northwest Atlantic Fisheries Organization (NAFO) Statistical Area code. See CFDBS Area Table (AREA) for actual codes. For 1994+ allocated data, if Area Level = A then NEMAREA is from the VTR trip. If Area Level = B, C,D then AREA is selected from a group of VTR trips with similar trip characteristics on a probabilistic basis. If Area Level = X then AREA is unknown. VARCHAR2 10 NEMAREA VARCHAR2 3 No No Active The NEMFIS Area, coded as the NAFO Statistical Area for federally collected data; a three digit code for internal state waters for state collected data. For 1994+ allocated data, if Area Level = A then NEMAREA is from the VTR trip. If Area Level = B, C,D then NEMAREA is selected from a group of VTR trips with similar trip characteristics on a probabilistic basis. If Area Level = X, then nemarea is unknown. VARCHAR2 11 SAMPAREA VARCHAR2 2 No No Active The sample area code for a given species in a given statistical area. See Port Sampling Manual, Appendix A, for details. VARCHAR2 12 NESPP4 VARCHAR2 4 No No Active The 4-digit Northeast Species code; the fourth digit represents market category. See CFDBS Species Table (CFSPP) for actual codes. For discard species in the CFDISCyyyy and WODISCyy views, NESPP4 is redefined as NESPP3 preceded by a 9, e.g. yellowtail flounder is 9123. VARCHAR2 13 NESPP3 VARCHAR2 12 No No Active The Northeast Species code, without the market category, i.e. the first 3 digits of NESPP4. See CFDBS Species Table (CFSPP) for actual codes. VARCHAR2 14 QTR VARCHAR2 1 No No Active The quarter of the calendar year in which weighout occurred: 1=January-March; 2=April-June; 3=July-September; 4=October-December. VARCHAR2 15 TONCLASS VARCHAR2 3 No No Active The tonnage class code which defines the range of gross registered tons (GRT) for the vessel indicated. If last 2 digits = 00, the exact GRT and the sub-range of GRT is unknown. For pre-82 data, see the applicable appendix of the port manual. For post-81 data, see CFDBS Vesstoncl Table. VARCHAR2 16 NEGEAR VARCHAR2 3 No No Active Northeast Gear code; 999=Unknown. See CFDBS Gear Table(GEAR) for actual codes. For 1994+ allocated data, negear is taken from the matched VTR trip when Area Level = A; negear is supplied by the Dealer when Area Level = B,C,D or X. VARCHAR2 17 NEGEAR2 VARCHAR2 8 No No Active First two digits of the Northeast Gear code. See CFDBS Gear Table (GEAR) for actual codes. VARCHAR2 18 DEPTHCD VARCHAR2 1 No No Active The depth to bottom, in fathoms, coded as follows: <br> 1 = 0-30; 2 = 31-60; 3 = 61-100; 4 = 101-150; 5 = 151-200; <br> 6 = 201-300; 7 = over 300; 8= mixed; 9 = unknown. <br> When the range of fishing depths covers two depth zones, it is the zone in which mid-depth falls. When 3 or more zones are covered, it is mixed. For 1994+ allocated data, if Area Level = A, then depthcd is derived from the VTR trip; if Area Level = B,C, D or X, depthcd is null. VARCHAR2 19 SAMPMETH NUMBER 22 No No 1 0 Active The method used to sample the vessel's catch: 1=vessel or hold; 2=basket or bushel; 3=chute or conveyor; 4=cart,barrel,tub,large box; 5=bin, floor pile; 6=small box; 7=sorting table. See "Manual for Sampling, Interviewing and Coding for the Northeast Region" by R.I. Schultz. NUMBER 20 CATDISP NUMBER 22 No No 1 0 Active Indicates if the catch from which the sample was taken was: <br> 0=discarded, 1=kept. NUMBER 21 AGESTRCT NUMBER 22 No No 1 0 Active The structure retained for age determination: 0=No structure taken; 1=Scale; 2=Otoliths; 3=Shells; 4=Pen; 5=Vertebra; 6=Dorsal spine. NUMBER 22 SEX NUMBER 22 No No 1 0 Active Sex code: 0=unsexed; 1=male; 2=female. NUMBER 23 LENGTH NUMBER 22 No No 3 0 Active The length of specimen in centimeters. NUMBER 24 NPAIRS NUMBER 22 No No 3 0 Active The number of length frequency pairs. NUMBER 25 AGE NUMBER 22 No No 3 0 Active The age of specimen in years. NUMBER 26 NUMAGE NUMBER 22 No No 3 0 Active The number of specimens at a given age. NUMBER 27 NO_LEN_MATCH VARCHAR2 1 No No Active Flag indicating that there is no matching length record for the age record. VARCHAR2 33438 WOLENyy Published / External Completed Commercial Fisheries Length Data from 1969 to 1993. Loaded by batch 8988, 07-11-2016 08:41 Data View Yes CFDBS Commercial Fisheries Length Data from 1969 to 1993. 1 PORT VARCHAR2 6 No No Active A combined code for state, port and county. The port in which the vessel landed the catch. VARCHAR2 2 STATE VARCHAR2 8 No No Active The 2 digit numeric state code for the port of landing: <br> 07=CT; 08=DE; 22=ME; 23=MD; 24=MA; 32=NH; 33=NJ; 35=NY; 36=NC; 42=RI; 49=VA. VARCHAR2 3 PORT2 VARCHAR2 8 No No Active The 3rd and 4th digit of the port code--meaningless without the rest of the port code. VARCHAR2 4 COUNTY VARCHAR2 8 No No Active Name of county., ex.ESSEX. VARCHAR2 5 YEAR NUMBER 22 No No 4 0 Active The year in which the landings or negative report occurred. NUMBER 6 LINK VARCHAR2 6 No No Active The field (month-document) used to link species and biological sampling data to the trip information. Length of the link field depends on the year: pre 1994 document numbers (DOCN) were 4 characters; post 1993, 6 characters. For 1994+ allocated data, for CFDETTyyyyAA and CFDETSyyyyAA, LINK = (dlrtrpid, month, docn, subtrip); VARCHAR2(35); For CFAGEyyyyAA and CFLENyyyyAA, 1994 to 2003, Link = (dlrtrpid, month, docn, subtrip); For CFAGEyyyyAA and CFLENyyyyAA, 2004 to present, LINK = (month,docn,tallyno,sampno,linkpad) where linkpad is 15 zeros. VARCHAR2 7 MONTH VARCHAR2 2 No No Active The month (01-12) of the vessel landing or negative dealer report. 00 = unknown. VARCHAR2 8 DOCN VARCHAR2 4 No No Active Number assigned to each weighout form, or negative dealer report; Unique within a month. For 1994+ allocated data , DOCN column width is expanded, VARCHAR2(15). VARCHAR2 9 AREA VARCHAR2 3 No No Active The Northwest Atlantic Fisheries Organization (NAFO) Statistical Area code. See CFDBS Area Table (AREA) for actual codes. For 1994+ allocated data, if Area Level = A then NEMAREA is from the VTR trip. If Area Level = B, C,D then AREA is selected from a group of VTR trips with similar trip characteristics on a probabilistic basis. If Area Level = X then AREA is unknown. VARCHAR2 10 NEMAREA VARCHAR2 3 No No Active The NEMFIS Area, coded as the NAFO Statistical Area for federally collected data; a three digit code for internal state waters for state collected data. For 1994+ allocated data, if Area Level = A then NEMAREA is from the VTR trip. If Area Level = B, C,D then NEMAREA is selected from a group of VTR trips with similar trip characteristics on a probabilistic basis. If Area Level = X, then nemarea is unknown. VARCHAR2 11 SAMPAREA VARCHAR2 2 No No Active The sample area code for a given species in a given statistical area. See Port Sampling Manual, Appendix A, for details. VARCHAR2 12 NESPP4 VARCHAR2 4 No No Active The 4-digit Northeast Species code; the fourth digit represents market category. See CFDBS Species Table (CFSPP) for actual codes. For discard species in the CFDISCyyyy and WODISCyy views, NESPP4 is redefined as NESPP3 preceded by a 9, e.g. yellowtail flounder is 9123. VARCHAR2 13 NESPP3 VARCHAR2 12 No No Active The Northeast Species code, without the market category, i.e. the first 3 digits of NESPP4. See CFDBS Species Table (CFSPP) for actual codes. VARCHAR2 14 QTR VARCHAR2 1 No No Active The quarter of the calendar year in which weighout occurred: 1=January-March; 2=April-June; 3=July-September; 4=October-December. VARCHAR2 15 DAY VARCHAR2 2 No No Active Day of month (01-31). Unknown=00. Day = 00 may indicate a consolidated trip that represents more than one trip. VARCHAR2 16 VESS1 VARCHAR2 6 No No Active The Woods Hole number (6-digits) of the vessel (or of first vessel if paired trawl). VARCHAR2 17 VESS2 VARCHAR2 6 No No Active The Woods Hole number (6-digits) of the vessel (or of the second vessel if paired trawl). VARCHAR2 18 TONCLASS VARCHAR2 3 No No Active The tonnage class code which defines the range of gross registered tons (GRT) for the vessel indicated. If last 2 digits = 00, the exact GRT and the sub-range of GRT is unknown. For pre-82 data, see the applicable appendix of the port manual. For post-81 data, see CFDBS Vesstoncl Table. VARCHAR2 19 NEGEAR VARCHAR2 3 No No Active Northeast Gear code; 999=Unknown. See CFDBS Gear Table(GEAR) for actual codes. For 1994+ allocated data, negear is taken from the matched VTR trip when Area Level = A; negear is supplied by the Dealer when Area Level = B,C,D or X. VARCHAR2 20 NEGEAR2 VARCHAR2 8 No No Active First two digits of the Northeast Gear code. See CFDBS Gear Table (GEAR) for actual codes. VARCHAR2 21 DEPTH NUMBER 22 No No 3 0 Active The average depth to bottom, in fathoms, over the trip. 0=unknown. NUMBER 22 DEPTHCD VARCHAR2 1 No No Active The depth to bottom, in fathoms, coded as follows: <br> 1 = 0-30; 2 = 31-60; 3 = 61-100; 4 = 101-150; 5 = 151-200; <br> 6 = 201-300; 7 = over 300; 8= mixed; 9 = unknown. <br> When the range of fishing depths covers two depth zones, it is the zone in which mid-depth falls. When 3 or more zones are covered, it is mixed. For 1994+ allocated data, if Area Level = A, then depthcd is derived from the VTR trip; if Area Level = B,C, D or X, depthcd is null. VARCHAR2 23 MESH NUMBER 22 No No 3 1 Active The mesh size of gear used in tenths of inches (one decimal place); 0.0=unknown. For 1994+ allocated data, if Area Level = A then mesh is from the VTR trip, if available. If Area Level = B, C, or D then mesh is null. NUMBER 24 LAT VARCHAR2 4 No No Active Latitude (ddmm) of catch recorded at the center of the ten minute square. VARCHAR2 25 LON VARCHAR2 4 No No Active Longitude (ddmm) of catch recorded at the center of the ten minute square. VARCHAR2 26 SAMPMETH NUMBER 22 No No 1 0 Active The method used to sample the vessel's catch: 1=vessel or hold; 2=basket or bushel; 3=chute or conveyor; 4=cart,barrel,tub,large box; 5=bin, floor pile; 6=small box; 7=sorting table. See "Manual for Sampling, Interviewing and Coding for the Northeast Region" by R.I. Schultz. NUMBER 27 WGTSAMP NUMBER 22 No No 5 0 Active The weight of specimens in sample. NUMBER 28 NUMSAMP NUMBER 22 No No 4 0 Active The number of specimens in sample. NUMBER 29 CATDISP NUMBER 22 No No 1 0 Active Indicates if the catch from which the sample was taken was: <br> 0=discarded, 1=kept. NUMBER 30 AGESTRCT NUMBER 22 No No 1 0 Active The structure retained for age determination: 0=No structure taken; 1=Scale; 2=Otoliths; 3=Shells; 4=Pen; 5=Vertebra; 6=Dorsal spine. NUMBER 31 NAGESPEC NUMBER 22 No No 3 0 Active The number of specimens from which aging structures were removed for this sample. NUMBER 32 HAILWT NUMBER 22 No No 8 0 Active The hail weight (fisherman's estimate) of species/mkt sampled in hundreds of pounds. NUMBER 33 UTILCD VARCHAR2 1 No No Active The utilization code: 0=food fish or unknown; 2=aquaculture; 3=canned pet food (1984+); 4=Biomedical (2002+); 5=animal food (1984+); 7=bait; 8=industrial, other (2002+); 9=industrial, reduction. VARCHAR2 34 SEX NUMBER 22 No No 1 0 Active Sex code: 0=unsexed; 1=male; 2=female. NUMBER 35 NPAIRS NUMBER 22 No No 3 0 Active The number of length frequency pairs. NUMBER 36 LENGTH NUMBER 22 No No 3 0 Active The length of specimen in centimeters. NUMBER 37 NUMLEN NUMBER 22 No No 3 0 Active The total number of specimens at specified length. NUMBER Data Steward 2019-01 Person Moser, Joshua joshua.moser@noaa.gov 166 Water Street Woods Hole MA 02543-1026 USA 508-495-2246 508-495-2393 Distributor 2010-01-01 Person Moser, Joshua joshua.moser@noaa.gov 166 Water Street Woods Hole MA 02543-1026 USA 508-495-2246 508-495-2393 Metadata Contact 2019-01 Person Moser, Joshua joshua.moser@noaa.gov 166 Water Street Woods Hole MA 02543-1026 USA 508-495-2246 508-495-2393 Point of Contact 2010-01-01 Person Moser, Joshua joshua.moser@noaa.gov 166 Water Street Woods Hole MA 02543-1026 USA 508-495-2246 508-495-2393 -76 -65 45 35 US/Canada border to Cape Hatteras, NC; Continental East Coast to the boundary of USA managed waters. Continuing 1963 Unclassified NEFSC Data Access Procedure: 1. Formal request in writing usually to the data owner/contact or Center Director; 2. Requester is contacted by data owner to review and verify the request content and details for data delivery options. 3. If data is confidential then owner will determine if the data may be released to the requester; 4. If data can be released, the data is downloaded and packaged for delivery electronically; or the requester may be directed to where the data is available online. None, recommend citing credits to data provider in publications None None None Oracle 11g data processing procedures Biological samples are collected based on sampling requirements provided by the stock assessment requirements Accuracy of species identification is determined by comparing the biological samples with the information from the fish dealer reports and the vessel trip reports. Routine audits are run as the data is entered and post audits are run when the master data sets are created. The Age and Growth staff also run reports which produce age/length keys which are used to detect outliers. Yes Unknown Yes Yes Yes 1 year To Be Determined 2 months Data is backed up as entered into the Oracle data tables Data is collected by fisheries reporting specialist at the ports from fish processors; data is entered into a web-based data entry system by reporting specialist; age structures are sent to Age and Growth department for processing; age of fish are added to the age data set by Age and Growth staff; data is processed to master data format by database manager for CFDBS. 33429 Entity 33430 Entity 33431 Entity 33432 Entity 33433 Entity 33434 Entity 33437 Entity 33438 Entity gov.noaa.nmfs.inport:27401 Patricia Jones 2015-09-23T13:56:18 SysAdmin InPortAdmin 2022-08-09T17:11:11 2016-07-11 Northeast Fisheries Science Center NEFSC 166 Water Street Woods Hole MA 02543-1026 USA (508)495-2000 https://www.nefsc.noaa.gov 8:00 a.m. to 4:30 p.m. Monday - Friday 1001 Public No No 2016-07-11 1 Year 2017-07-11