View: WOLENyy
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:33438 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | View: WOLENyy |
---|---|
Short Name: | WOLENyy |
Status: | Completed |
Abstract: |
Commercial Fisheries Length Data from 1969 to 1993. |
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 1969 to 1993. |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
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
|
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
|
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
|
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
|
SAMPAREA | VARCHAR2 | The sample area code for a given species in a given statistical area. See Port Sampling Manual, Appendix A, for details. | |
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
|
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
|
DAY | VARCHAR2 | Day of month (01-31). Unknown=00. Day = 00 may indicate a consolidated trip that represents more than one trip. | |
100
|
VESS1 | VARCHAR2 | The Woods Hole number (6-digits) of the vessel (or of first vessel if paired trawl). | |
100
|
VESS2 | VARCHAR2 | The Woods Hole number (6-digits) of the vessel (or of the second vessel if paired trawl). | |
100
|
TONCLASS | VARCHAR2 | 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. | |
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
|
DEPTH | NUMBER | The average depth to bottom, in fathoms, over the trip. 0=unknown. | |
100
|
DEPTHCD | VARCHAR2 | 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. | |
100
|
MESH | NUMBER | 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. | |
100
|
LAT | VARCHAR2 | Latitude (ddmm) of catch recorded at the center of the ten minute square. | |
100
|
LON | VARCHAR2 | Longitude (ddmm) of catch recorded at the center of the ten minute square. | |
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
|
WGTSAMP | NUMBER | The weight of specimens in sample. | |
100
|
NUMSAMP | NUMBER | The number of specimens in sample. | |
100
|
CATDISP | NUMBER | Indicates if the catch from which the sample was taken was: <br> 0=discarded, 1=kept. | |
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
|
NAGESPEC | NUMBER | The number of specimens from which aging structures were removed for this sample. | |
100
|
HAILWT | NUMBER | The hail weight (fisherman's estimate) of species/mkt sampled in hundreds of pounds. | |
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
|
SEX | NUMBER | Sex code: 0=unsexed; 1=male; 2=female. | |
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
PORT
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
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: | 2 |
---|---|
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: | 3 |
---|---|
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: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Name of county., ex.ESSEX. |
General Data Type: | VARCHAR2 |
YEAR
Seq. Order: | 5 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
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: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
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: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The month (01-12) of the vessel landing or negative dealer report. 00 = unknown. |
General Data Type: | VARCHAR2 |
DOCN
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
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 |
AREA
Seq. Order: | 9 |
---|---|
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: | 10 |
---|---|
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 |
SAMPAREA
Seq. Order: | 11 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The sample area code for a given species in a given statistical area. See Port Sampling Manual, Appendix A, for details. |
General Data Type: | VARCHAR2 |
NESPP4
Seq. Order: | 12 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
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: | 13 |
---|---|
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 |
QTR
Seq. Order: | 14 |
---|---|
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 |
DAY
Seq. Order: | 15 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
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 |
VESS1
Seq. Order: | 16 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The Woods Hole number (6-digits) of the vessel (or of first vessel if paired trawl). |
General Data Type: | VARCHAR2 |
VESS2
Seq. Order: | 17 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The Woods Hole number (6-digits) of the vessel (or of the second vessel if paired trawl). |
General Data Type: | VARCHAR2 |
TONCLASS
Seq. Order: | 18 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
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. |
General Data Type: | VARCHAR2 |
NEGEAR
Seq. Order: | 19 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
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: | 20 |
---|---|
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 |
DEPTH
Seq. Order: | 21 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
The average depth to bottom, in fathoms, over the trip. 0=unknown. |
General Data Type: | NUMBER |
DEPTHCD
Seq. Order: | 22 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
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. |
General Data Type: | VARCHAR2 |
MESH
Seq. Order: | 23 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 1 |
Status: | Active |
Description: |
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. |
General Data Type: | NUMBER |
LAT
Seq. Order: | 24 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latitude (ddmm) of catch recorded at the center of the ten minute square. |
General Data Type: | VARCHAR2 |
LON
Seq. Order: | 25 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude (ddmm) of catch recorded at the center of the ten minute square. |
General Data Type: | VARCHAR2 |
SAMPMETH
Seq. Order: | 26 |
---|---|
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 |
WGTSAMP
Seq. Order: | 27 |
---|---|
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 |
NUMSAMP
Seq. Order: | 28 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
The number of specimens in sample. |
General Data Type: | NUMBER |
CATDISP
Seq. Order: | 29 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 1 |
Scale: | 0 |
Status: | Active |
Description: |
Indicates if the catch from which the sample was taken was: <br> 0=discarded, 1=kept. |
General Data Type: | NUMBER |
AGESTRCT
Seq. Order: | 30 |
---|---|
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 |
NAGESPEC
Seq. Order: | 31 |
---|---|
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 |
HAILWT
Seq. Order: | 32 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Scale: | 0 |
Status: | Active |
Description: |
The hail weight (fisherman's estimate) of species/mkt sampled in hundreds of pounds. |
General Data Type: | NUMBER |
UTILCD
Seq. Order: | 33 |
---|---|
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 |
SEX
Seq. Order: | 34 |
---|---|
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 |
NPAIRS
Seq. Order: | 35 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
The number of length frequency pairs. |
General Data Type: | NUMBER |
LENGTH
Seq. Order: | 36 |
---|---|
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: | 37 |
---|---|
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: | 33438 |
---|---|
GUID: | gov.noaa.nmfs.inport:33438 |
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 |