Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Data Tab Trip Landings Record. in Historical red snapper trip landings records.xlsx
Short Name: Trip Landings Data
Status: Completed
Abstract:

Provides List Of Trip Landings Record.

Purpose:

To document Tab Historical Red Snapper in Historical red snapper trip landings records.xlsx

Entity Information

Entity Type: Data Table
Active Version?: Yes
Alias: Trip Landings Data
Description:

Provides List Of Trip Landings Records

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Year Numeric Yeart Of Landings Record
100
Month Numeric Numeric Month of the provided Trip Landings Record
100
Day Numeric Numeric Day of the Month of the Landings Record
100
Issue_Date Date Date/ISssue of the Newspaper containg the Trip Landings Record
100
Source Character Name of the newspaper used to gather the landings data
100
Vessel Character Supplied Vessel Name in Newspaper
100
Standard Vessel Character Standardized Vessel Name. This is usually the vessel name, but minor variants in spelling of the same vessel are standardized/corrected for purpose of totaling
100
Captain Character The name of the vessels captain
100
Port CHaracter Name of Port Of Landins
100
Number Snappers Landed Numeric Number of Snapper Landed Reported For The Trip
100
lbs snapper landed Numeric Total Snapper Landings In Pounds
100
lbs grouper landed Numeric Number of Pounds of grouper landed
100
lbs Sum of snapper + grouper Numeric Sum of the landings of snapper and grouper
100
lbs fish (i.e., if not specifically reported as snapper) Numeric lbs fish landed that are reported as snapper
100
Record type Character Indicates whether landings reported is either a fish count or fist weight. Values are count or weight
100
Trip duration (d) Numeric Trip duration in days
100
No. of crew or size of party Numeric crew size or numbrt of people on fishing vessel
100
Fishing Location Character Optional description of where fishing took place
100
Com or Rec Character Indicates whether fishing trip was commercial or recretional
100
comment Character Optional comment about the record

Attribute Details

Year

CC ID: 837676
Seq. Order: 10
Data Storage Type: Numeric
Max Length: 4
Required: Yes
Primary Key: No
Status: Active
Description:

Yeart Of Landings Record

Month

CC ID: 837677
Seq. Order: 20
Data Storage Type: Numeric
Max Length: 2
Required: Yes
Primary Key: No
Status: Active
Description:

Numeric Month of the provided Trip Landings Record

Allowed Values: 1-12

Day

CC ID: 837678
Seq. Order: 30
Data Storage Type: Numeric
Max Length: 2
Required: Yes
Primary Key: No
Status: Active
Description:

Numeric Day of the Month of the Landings Record

Allowed Values: 1-31 subject to number of days in a given month

Issue_Date

CC ID: 837679
Seq. Order: 40
Data Storage Type: Date
Max Length: 10
Required: Yes
Primary Key: No
Status: Active
Description:

Date/ISssue of the Newspaper containg the Trip Landings Record

Format Mask: mm/dd/yyyy
Derivation:

Appropriate concatenation of the year month and day columns.

Source

CC ID: 837675
Seq. Order: 50
Data Storage Type: Character
Max Length: 40
Required: Yes
Primary Key: No
Status: Active
Description:

Name of the newspaper used to gather the landings data

Vessel

CC ID: 837680
Seq. Order: 60
Data Storage Type: Character
Max Length: 25
Required: Yes
Primary Key: No
Status: Active
Description:

Supplied Vessel Name in Newspaper

Standard Vessel

CC ID: 837681
Seq. Order: 70
Data Storage Type: Character
Max Length: 25
Required: Yes
Primary Key: No
Status: Active
Description:

Standardized Vessel Name. This is usually the vessel name, but minor variants in spelling of the same vessel are standardized/corrected for purpose of totaling

Captain

CC ID: 837692
Seq. Order: 75
Data Storage Type: Character
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

The name of the vessels captain

Port

CC ID: 840328
Seq. Order: 80
Data Storage Type: CHaracter
Max Length: 20
Required: Yes
Primary Key: No
Status: Active
Description:

Name of Port Of Landins

Number Snappers Landed

CC ID: 837682
Seq. Order: 85
Data Storage Type: Numeric
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Number of Snapper Landed Reported For The Trip

lbs snapper landed

CC ID: 837683
Seq. Order: 90
Data Storage Type: Numeric
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

Total Snapper Landings In Pounds

Unit of Measure: lns

lbs grouper landed

CC ID: 837684
Seq. Order: 100
Data Storage Type: Numeric
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Number of Pounds of grouper landed

lbs Sum of snapper + grouper

CC ID: 837685
Seq. Order: 110
Data Storage Type: Numeric
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Sum of the landings of snapper and grouper

Unit of Measure: lbs

lbs fish (i.e., if not specifically reported as snapper)

CC ID: 837686
Seq. Order: 120
Data Storage Type: Numeric
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

lbs fish landed that are reported as snapper

Unit of Measure: lbs

Record type

CC ID: 837687
Seq. Order: 130
Data Storage Type: Character
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Indicates whether landings reported is either a fish count or fist weight.

Values are count or weight

Allowed Values: count weight

Trip duration (d)

CC ID: 837688
Seq. Order: 140
Data Storage Type: Numeric
Max Length: 4
Min Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Trip duration in days

Unit of Measure: days

No. of crew or size of party

CC ID: 837689
Seq. Order: 150
Data Storage Type: Numeric
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

crew size or numbrt of people on fishing vessel

Fishing Location

CC ID: 837690
Seq. Order: 160
Data Storage Type: Character
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Optional description of where fishing took place

Com or Rec

CC ID: 837691
Seq. Order: 170
Data Storage Type: Character
Max Length: 3
Required: Yes
Primary Key: No
Status: Active
Description:

Indicates whether fishing trip was commercial or recretional

Allowed Values: com =commercial rec - recreational

comment

CC ID: 837693
Seq. Order: 180
Data Storage Type: Character
Max Length: 200
Required: No
Primary Key: No
Status: Active
Description:

Optional comment about the record

Catalog Details

Catalog Item ID: 56157
GUID: gov.noaa.nmfs.inport:56157
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2019-04-30 17:06+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-10-22 02:10+0000
Metadata Record Published: 2021-10-22
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-10-23