View: CFLENyyyy
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:33431 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Commercial Fisheries Length Data from 1994 to date.
DescriptionCommercial Fisheries Length Data from 1994 to date.
Entity Information
Entity Type
Data View
Data Attribute / Type | Description |
---|---|
YEAR
NUMBER |
The year in which the landings or negative report occurred. |
LINK
VARCHAR2 |
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. |
MONTH
VARCHAR2 |
The month (01-12) of the vessel landing or negative dealer report. 00 = unknown. |
QTR
VARCHAR2 |
The quarter of the calendar year in which weighout occurred: 1=January-March; 2=April-June; 3=July-September; 4=October-December. |
DOCN
VARCHAR2 |
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). |
DEALNUM
VARCHAR2 |
The dealer permit number assigned by the Northeast Regional Office Permit System (PERMIT). 00000=Unknown. Not available for 1994 in CFDBS data. |
DAY
VARCHAR2 |
Day of month (01-31). Unknown=00. Day = 00 may indicate a consolidated trip that represents more than one trip. |
PORT
VARCHAR2 |
A combined code for state, port and county. The port in which the vessel landed the catch. |
STATE
VARCHAR2 |
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. |
PORT2
VARCHAR2 |
The 3rd and 4th digit of the port code--meaningless without the rest of the port code. |
COUNTY
VARCHAR2 |
Name of county., ex.ESSEX. |
PERMIT
VARCHAR2 |
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. |
HULLNUM
VARCHAR2 |
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. |
NEGEAR
VARCHAR2 |
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. |
NEGEAR2
VARCHAR2 |
First two digits of the Northeast Gear code. See CFDBS Gear Table (GEAR) for actual codes. |
SOURCE
VARCHAR2 |
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. |
EFFIND
VARCHAR2 |
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. |
NESPP4
VARCHAR2 |
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. |
NESPP3
VARCHAR2 |
The Northeast Species code, without the market category, i.e. the first 3 digits of NESPP4. See CFDBS Species Table (CFSPP) for actual codes. |
AREA
VARCHAR2 |
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. |
NEMAREA
VARCHAR2 |
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. |
SPPLNDLB
VARCHAR2 |
The pounds landed for a given species. |
CATDISP
VARCHAR2 |
Indicates if the catch from which the sample was taken was: <br> 0=discarded, 1=kept. |
UTILCD
VARCHAR2 |
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. |
SAMPMETH
NUMBER |
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. |
AGESTRCT
NUMBER |
The structure retained for age determination: 0=No structure taken; 1=Scale; 2=Otoliths; 3=Shells; 4=Pen; 5=Vertebra; 6=Dorsal spine. |
SEX
NUMBER |
Sex code: 0=unsexed; 1=male; 2=female. |
VESSEL2
VARCHAR2 |
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. |
NAGESPEC
NUMBER |
The number of specimens from which aging structures were removed for this sample. |
WGTSAMP
NUMBER |
The weight of specimens in sample. |
AREASAMP
VARCHAR2 |
NEMFIS area code for the area from which the sample was taken; may be different from the area recorded for the trip. |
AREASRCE
VARCHAR2 |
Code indicating how the area of the sample was determined: <br> 0=unknown; 1=weighout; 2=interview; 3=port agent's best guess. |
NUMSAMP
NUMBER |
The number of specimens in sample. |
NPAIRS
NUMBER |
The number of length frequency pairs. |
LENGTH
NUMBER |
The length of specimen in centimeters. |
NUMLEN
NUMBER |
The total number of specimens at specified length. |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (NEFSC) for inquiries on this record.
Item Identification
Title: | View: CFLENyyyy |
---|---|
Short Name: | CFLENyyyy |
Status: | Completed |
Abstract: |
Commercial Fisheries Length Data from 1994 to date. |
Notes: |
Loaded by batch 8988, 07-11-2016 08:41 |
Entity Information
Entity Type: | Data View |
---|---|
Active Version?: | Yes |
Schema Name: | CFDBS |
Description: |
Commercial Fisheries Length Data from 1994 to date. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
YEAR | NUMBER | The year in which the landings or negative report occurred. | |
100
|
LINK | VARCHAR2 | 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. | |
100
|
MONTH | VARCHAR2 | The month (01-12) of the vessel landing or negative dealer report. 00 = unknown. | |
100
|
QTR | VARCHAR2 | The quarter of the calendar year in which weighout occurred: 1=January-March; 2=April-June; 3=July-September; 4=October-December. | |
100
|
DOCN | VARCHAR2 | 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). | |
100
|
DEALNUM | VARCHAR2 | The dealer permit number assigned by the Northeast Regional Office Permit System (PERMIT). 00000=Unknown. Not available for 1994 in CFDBS data. | |
100
|
DAY | VARCHAR2 | Day of month (01-31). Unknown=00. Day = 00 may indicate a consolidated trip that represents more than one trip. | |
100
|
PORT | VARCHAR2 | A combined code for state, port and county. The port in which the vessel landed the catch. | |
100
|
STATE | VARCHAR2 | 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. | |
100
|
PORT2 | VARCHAR2 | The 3rd and 4th digit of the port code--meaningless without the rest of the port code. | |
100
|
COUNTY | VARCHAR2 | Name of county., ex.ESSEX. | |
100
|
PERMIT | VARCHAR2 | 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. | |
100
|
HULLNUM | VARCHAR2 | 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. | |
100
|
NEGEAR | VARCHAR2 | 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. | |
100
|
NEGEAR2 | VARCHAR2 | First two digits of the Northeast Gear code. See CFDBS Gear Table (GEAR) for actual codes. | |
100
|
SOURCE | VARCHAR2 | 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. | |
100
|
EFFIND | VARCHAR2 | 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. | |
100
|
NESPP4 | VARCHAR2 | 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. | |
100
|
NESPP3 | VARCHAR2 | The Northeast Species code, without the market category, i.e. the first 3 digits of NESPP4. See CFDBS Species Table (CFSPP) for actual codes. | |
100
|
AREA | VARCHAR2 | 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. | |
100
|
NEMAREA | VARCHAR2 | 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. | |
100
|
SPPLNDLB | VARCHAR2 | The pounds landed for a given species. | |
100
|
CATDISP | VARCHAR2 | Indicates if the catch from which the sample was taken was: <br> 0=discarded, 1=kept. | |
100
|
UTILCD | VARCHAR2 | 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. | |
100
|
SAMPMETH | NUMBER | 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. | |
100
|
AGESTRCT | NUMBER | The structure retained for age determination: 0=No structure taken; 1=Scale; 2=Otoliths; 3=Shells; 4=Pen; 5=Vertebra; 6=Dorsal spine. | |
100
|
SEX | NUMBER | Sex code: 0=unsexed; 1=male; 2=female. | |
100
|
VESSEL2 | VARCHAR2 | 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. | |
100
|
NAGESPEC | NUMBER | The number of specimens from which aging structures were removed for this sample. | |
100
|
WGTSAMP | NUMBER | The weight of specimens in sample. | |
100
|
AREASAMP | VARCHAR2 | NEMFIS area code for the area from which the sample was taken; may be different from the area recorded for the trip. | |
100
|
AREASRCE | VARCHAR2 | Code indicating how the area of the sample was determined: <br> 0=unknown; 1=weighout; 2=interview; 3=port agent's best guess. | |
100
|
NUMSAMP | NUMBER | The number of specimens in sample. | |
100
|
NPAIRS | NUMBER | The number of length frequency pairs. | |
100
|
LENGTH | NUMBER | The length of specimen in centimeters. | |
100
|
NUMLEN | NUMBER | The total number of specimens at specified length. |
Attribute Details
YEAR
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
The year in which the landings or negative report occurred. |
General Data Type: | NUMBER |
LINK
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
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. |
General Data Type: | VARCHAR2 |
MONTH
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
The month (01-12) of the vessel landing or negative dealer report. 00 = unknown. |
General Data Type: | VARCHAR2 |
QTR
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The quarter of the calendar year in which weighout occurred: 1=January-March; 2=April-June; 3=July-September; 4=October-December. |
General Data Type: | VARCHAR2 |
DOCN
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
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). |
General Data Type: | VARCHAR2 |
DEALNUM
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
The dealer permit number assigned by the Northeast Regional Office Permit System (PERMIT). 00000=Unknown. Not available for 1994 in CFDBS data. |
General Data Type: | VARCHAR2 |
DAY
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Day of month (01-31). Unknown=00. Day = 00 may indicate a consolidated trip that represents more than one trip. |
General Data Type: | VARCHAR2 |
PORT
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
A combined code for state, port and county. The port in which the vessel landed the catch. |
General Data Type: | VARCHAR2 |
STATE
Seq. Order: | 9 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
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. |
General Data Type: | VARCHAR2 |
PORT2
Seq. Order: | 10 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The 3rd and 4th digit of the port code--meaningless without the rest of the port code. |
General Data Type: | VARCHAR2 |
COUNTY
Seq. Order: | 11 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Name of county., ex.ESSEX. |
General Data Type: | VARCHAR2 |
PERMIT
Seq. Order: | 12 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
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. |
General Data Type: | VARCHAR2 |
HULLNUM
Seq. Order: | 13 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
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. |
General Data Type: | VARCHAR2 |
NEGEAR
Seq. Order: | 14 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
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. |
General Data Type: | VARCHAR2 |
NEGEAR2
Seq. Order: | 15 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
First two digits of the Northeast Gear code. See CFDBS Gear Table (GEAR) for actual codes. |
General Data Type: | VARCHAR2 |
SOURCE
Seq. Order: | 16 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
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. |
General Data Type: | VARCHAR2 |
EFFIND
Seq. Order: | 17 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
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. |
General Data Type: | VARCHAR2 |
NESPP4
Seq. Order: | 18 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
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. |
General Data Type: | VARCHAR2 |
NESPP3
Seq. Order: | 19 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The Northeast Species code, without the market category, i.e. the first 3 digits of NESPP4. See CFDBS Species Table (CFSPP) for actual codes. |
General Data Type: | VARCHAR2 |
AREA
Seq. Order: | 20 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
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. |
General Data Type: | VARCHAR2 |
NEMAREA
Seq. Order: | 21 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
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. |
General Data Type: | VARCHAR2 |
SPPLNDLB
Seq. Order: | 22 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 9 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The pounds landed for a given species. |
General Data Type: | VARCHAR2 |
CATDISP
Seq. Order: | 23 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Indicates if the catch from which the sample was taken was: <br> 0=discarded, 1=kept. |
General Data Type: | VARCHAR2 |
UTILCD
Seq. Order: | 24 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
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. |
General Data Type: | VARCHAR2 |
SAMPMETH
Seq. Order: | 25 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 1 |
Scale: | 0 |
Status: | Active |
Description: |
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. |
General Data Type: | NUMBER |
AGESTRCT
Seq. Order: | 26 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 1 |
Scale: | 0 |
Status: | Active |
Description: |
The structure retained for age determination: 0=No structure taken; 1=Scale; 2=Otoliths; 3=Shells; 4=Pen; 5=Vertebra; 6=Dorsal spine. |
General Data Type: | NUMBER |
SEX
Seq. Order: | 27 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 1 |
Scale: | 0 |
Status: | Active |
Description: |
Sex code: 0=unsexed; 1=male; 2=female. |
General Data Type: | NUMBER |
VESSEL2
Seq. Order: | 28 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
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. |
General Data Type: | VARCHAR2 |
NAGESPEC
Seq. Order: | 29 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
The number of specimens from which aging structures were removed for this sample. |
General Data Type: | NUMBER |
WGTSAMP
Seq. Order: | 30 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
The weight of specimens in sample. |
General Data Type: | NUMBER |
AREASAMP
Seq. Order: | 31 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
NEMFIS area code for the area from which the sample was taken; may be different from the area recorded for the trip. |
General Data Type: | VARCHAR2 |
AREASRCE
Seq. Order: | 32 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code indicating how the area of the sample was determined: <br> 0=unknown; 1=weighout; 2=interview; 3=port agent's best guess. |
General Data Type: | VARCHAR2 |
NUMSAMP
Seq. Order: | 33 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The number of specimens in sample. |
General Data Type: | NUMBER |
NPAIRS
Seq. Order: | 34 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Status: | Active |
Description: |
The number of length frequency pairs. |
General Data Type: | NUMBER |
LENGTH
Seq. Order: | 35 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
The length of specimen in centimeters. |
General Data Type: | NUMBER |
NUMLEN
Seq. Order: | 36 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
The total number of specimens at specified length. |
General Data Type: | NUMBER |
Catalog Details
Catalog Item ID: | 33431 |
---|---|
GUID: | gov.noaa.nmfs.inport:33431 |
Metadata Record Created By: | Patricia L Jones |
Metadata Record Created: | 2016-07-11 08:41+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2016-07-27 |
Owner Org: | NEFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2016-07-27 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2017-07-27 |