Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Combined files from historical species-group based logbook forms in USVI. Forms were in use from July 1, 1995 in St. Croix and July 1, 1997 in St. Thomas/St. John until June 30, 2011. Forms were concurrently in use with historical gear forms from 1995-1999.

Description

Combined files from historical species-group based logbook forms in USVI. Forms were in use from July 1, 1995 in St. Croix and July 1, 1997 in St. Thomas/St. John until June 30, 2011. Forms were concurrently in use with historical gear forms from 1995-1999.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
TRIP_KEY
VARCHAR2
Record ID Number
ID_NUM
VARCHAR2
Fisher License Number
LAST_NAME
VARCHAR2
Fisher Last Name
FIRST_NAME
VARCHAR2
Fisher First Name
BOAT_LICENSE
VARCHAR2
Primary Vessel Fished
BOAT_LICENSE_2
VARCHAR2
Secondary Vessel Fished
NUM_FISH_POTS
VARCHAR2
Average number of fish pots (traps) set for month
NUM_LOBSTER_POTS
VARCHAR2
Average number of lobster pots (traps) set for month
REPORT_DATE
DATE
The date of landing
NUM_OF_HELPERS
VARCHAR2
The number of helpers
GEAR_TYPE1
VARCHAR2
Primary Gear Fished
GEAR_NUM1
VARCHAR2
Quantity of Gear_type1 fished (or hauled for traps)
GEAR_TYPE2
VARCHAR2
Secondary Gear Fished
GEAR_NUM2
VARCHAR2
Quantity of Gear_type2 fished (or hauled for traps)
AREA_FISHED
VARCHAR2
Code for Primary Area Fished. Areas defined by map on historical CCR instruction form.
HOURS
BINARY_DOUBLE
Hours active on fishing grounds
TRAP_SOAK_TIME
BINARY_DOUBLE
Hours of trap soak time
GROUPER
BINARY_DOUBLE
Grouper lbs landed
SNAPPER
BINARY_DOUBLE
Snapper lbs landed
GRUNT
BINARY_DOUBLE
Grunt lbs landed
JACK
BINARY_DOUBLE
Jack lbs landed
SURGEONFISH
BINARY_DOUBLE
Surgeonfish lbs landed
PARROTFISH
BINARY_DOUBLE
Parrotfish lbs landed
SHELLFISH
BINARY_DOUBLE
Shellfish lbs landed (these are boxfish, trunkfish, or cowfish, not invertebrate shellfish)
TRIGGERFISH
BINARY_DOUBLE
Triggerfish lbs landed
ANGELFISH
BINARY_DOUBLE
Angelfish lbs landed
PORGY
BINARY_DOUBLE
Porgy lbs landed
BARRACUDA
BINARY_DOUBLE
Barracuda lbs landed
GOATFISH
BINARY_DOUBLE
Goatfish lbs landed
MACKEREL
BINARY_DOUBLE
Mackerel lbs landed
BAITFISH
BINARY_DOUBLE
Baitfish lbs landed
LOBSTER
BINARY_DOUBLE
Spiny lobster lbs landed
CONCH
BINARY_DOUBLE
Queen conch lbs landed
WHELK
BINARY_DOUBLE
Caribbean Topsnail lbs landed
SHARK
BINARY_DOUBLE
Shark lbs landed
PELAGIC
BINARY_DOUBLE
Miscellaneous unknown pelagic species lbs landed
TUNA
BINARY_DOUBLE
Tuna lbs landed
DOLPHIN
BINARY_DOUBLE
Dolphin fish (mahi) lbs landed
WAHOO
BINARY_DOUBLE
Wahoo lbs landed
MARLIN_RELEASED
BINARY_DOUBLE
Marlin estimated lbs released
GAR
BINARY_DOUBLE
Houndfish or needlefish lbs landed
SQUIRRELFISH
BINARY_DOUBLE
Squirrelfish lbs landed
HOGFISH
BINARY_DOUBLE
Hogfish lbs landed
CRAB
BINARY_DOUBLE
Crab lbs landed
LIONFISH
BINARY_DOUBLE
Lionfish lbs landed
SPONGE
BINARY_DOUBLE
Sponge lbs landed
OTHER_SPECIES
BINARY_DOUBLE
Other species lbs landed
LIVE_FISH_DISCARDED
BINARY_DOUBLE
Number of fish released alive
DEAD_FISH_DISCARDED
BINARY_DOUBLE
Number of fish discarded dead
LIVE_LOBSTER_DISCARDED
BINARY_DOUBLE
Number of spiny lobster released alive
DEAD_LOBSTER_DISCARDED
BINARY_DOUBLE
Number of spiny lobster discarded dead
FAD
VARCHAR2
Code for Fish Attracting Device. Locations are in historical CCR instructions
ARTIFICIAL_REEF
VARCHAR2
Code for artificial reef fished
DISTANCE
BINARY_DOUBLE
Perpendicular distance to shoreline in miles. Some fishers are said to have recorded length of miles from port to fishing grounds.
NO_FISHING_FOR_MONTH
VARCHAR2
Field is checked Y if no fishing occurred in the given month (see MONTH and CALENDAR YEAR)
NOTES
VARCHAR2
Notes made by fisher concerning the trip or days in port
SOURCE
VARCHAR2
The original file name and id for record.
CREATED
VARCHAR2
Date of file submission
ISLAND
VARCHAR2
Island (or island platform) where the fish were landed
FISHING_YEAR
VARCHAR2
The license issue year fished July 1 - June 30
CALENDAR_YEAR
VARCHAR2
The calendar year fished
MONTH
VARCHAR2
The month of the report
TOTAL_POUNDS
BINARY_DOUBLE
Total pounds landed on trip
TOTAL_DISCARDS
BINARY_DOUBLE
Total number of discards from fish
DAY
VARCHAR2
Day trip landed

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (SEFSC) for inquiries on this record.

Item Identification

Title: Table: USVI_SPECIES_GROUP_FORMS_ALL
Short Name: USVI_SPECIES_GROUP_FORMS_ALL
Status: Completed
Abstract:

Combined files from historical species-group based logbook forms in USVI. Forms were in use from July 1, 1995 in St. Croix and July 1, 1997 in St. Thomas/St. John until June 30, 2011. Forms were concurrently in use with historical gear forms from 1995-1999.

Notes:

Loaded by batch 7764, 12-03-2015 14:48

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: ALS
Description:

Combined files from historical species-group based logbook forms in USVI. Forms were in use from July 1, 1995 in St. Croix and July 1, 1997 in St. Thomas/St. John until June 30, 2011. Forms were concurrently in use with historical gear forms from 1995-1999.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
TRIP_KEY VARCHAR2 Record ID Number
100
ID_NUM VARCHAR2 Fisher License Number
100
LAST_NAME VARCHAR2 Fisher Last Name
100
FIRST_NAME VARCHAR2 Fisher First Name
100
BOAT_LICENSE VARCHAR2 Primary Vessel Fished
100
BOAT_LICENSE_2 VARCHAR2 Secondary Vessel Fished
100
NUM_FISH_POTS VARCHAR2 Average number of fish pots (traps) set for month
100
NUM_LOBSTER_POTS VARCHAR2 Average number of lobster pots (traps) set for month
100
REPORT_DATE DATE The date of landing
100
NUM_OF_HELPERS VARCHAR2 The number of helpers
100
GEAR_TYPE1 VARCHAR2 Primary Gear Fished
100
GEAR_NUM1 VARCHAR2 Quantity of Gear_type1 fished (or hauled for traps)
100
GEAR_TYPE2 VARCHAR2 Secondary Gear Fished
100
GEAR_NUM2 VARCHAR2 Quantity of Gear_type2 fished (or hauled for traps)
100
AREA_FISHED VARCHAR2 Code for Primary Area Fished. Areas defined by map on historical CCR instruction form.
100
HOURS BINARY_DOUBLE Hours active on fishing grounds
100
TRAP_SOAK_TIME BINARY_DOUBLE Hours of trap soak time
100
GROUPER BINARY_DOUBLE Grouper lbs landed
100
SNAPPER BINARY_DOUBLE Snapper lbs landed
100
GRUNT BINARY_DOUBLE Grunt lbs landed
100
JACK BINARY_DOUBLE Jack lbs landed
100
SURGEONFISH BINARY_DOUBLE Surgeonfish lbs landed
100
PARROTFISH BINARY_DOUBLE Parrotfish lbs landed
100
SHELLFISH BINARY_DOUBLE Shellfish lbs landed (these are boxfish, trunkfish, or cowfish, not invertebrate shellfish)
100
TRIGGERFISH BINARY_DOUBLE Triggerfish lbs landed
100
ANGELFISH BINARY_DOUBLE Angelfish lbs landed
100
PORGY BINARY_DOUBLE Porgy lbs landed
100
BARRACUDA BINARY_DOUBLE Barracuda lbs landed
100
GOATFISH BINARY_DOUBLE Goatfish lbs landed
100
MACKEREL BINARY_DOUBLE Mackerel lbs landed
100
BAITFISH BINARY_DOUBLE Baitfish lbs landed
100
LOBSTER BINARY_DOUBLE Spiny lobster lbs landed
100
CONCH BINARY_DOUBLE Queen conch lbs landed
100
WHELK BINARY_DOUBLE Caribbean Topsnail lbs landed
100
SHARK BINARY_DOUBLE Shark lbs landed
100
PELAGIC BINARY_DOUBLE Miscellaneous unknown pelagic species lbs landed
100
TUNA BINARY_DOUBLE Tuna lbs landed
100
DOLPHIN BINARY_DOUBLE Dolphin fish (mahi) lbs landed
100
WAHOO BINARY_DOUBLE Wahoo lbs landed
100
MARLIN_RELEASED BINARY_DOUBLE Marlin estimated lbs released
100
GAR BINARY_DOUBLE Houndfish or needlefish lbs landed
100
SQUIRRELFISH BINARY_DOUBLE Squirrelfish lbs landed
100
HOGFISH BINARY_DOUBLE Hogfish lbs landed
100
CRAB BINARY_DOUBLE Crab lbs landed
100
LIONFISH BINARY_DOUBLE Lionfish lbs landed
100
SPONGE BINARY_DOUBLE Sponge lbs landed
100
OTHER_SPECIES BINARY_DOUBLE Other species lbs landed
100
LIVE_FISH_DISCARDED BINARY_DOUBLE Number of fish released alive
100
DEAD_FISH_DISCARDED BINARY_DOUBLE Number of fish discarded dead
100
LIVE_LOBSTER_DISCARDED BINARY_DOUBLE Number of spiny lobster released alive
100
DEAD_LOBSTER_DISCARDED BINARY_DOUBLE Number of spiny lobster discarded dead
100
FAD VARCHAR2 Code for Fish Attracting Device. Locations are in historical CCR instructions
100
ARTIFICIAL_REEF VARCHAR2 Code for artificial reef fished
100
DISTANCE BINARY_DOUBLE Perpendicular distance to shoreline in miles. Some fishers are said to have recorded length of miles from port to fishing grounds.
100
NO_FISHING_FOR_MONTH VARCHAR2 Field is checked Y if no fishing occurred in the given month (see MONTH and CALENDAR YEAR)
100
NOTES VARCHAR2 Notes made by fisher concerning the trip or days in port
100
SOURCE VARCHAR2 The original file name and id for record.
100
CREATED VARCHAR2 Date of file submission
100
ISLAND VARCHAR2 Island (or island platform) where the fish were landed
100
FISHING_YEAR VARCHAR2 The license issue year fished July 1 - June 30
100
CALENDAR_YEAR VARCHAR2 The calendar year fished
100
MONTH VARCHAR2 The month of the report
100
TOTAL_POUNDS BINARY_DOUBLE Total pounds landed on trip
100
TOTAL_DISCARDS BINARY_DOUBLE Total number of discards from fish
100
DAY VARCHAR2 Day trip landed

Attribute Details

TRIP_KEY

CC ID: 259964
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Record ID Number

General Data Type: VARCHAR2

ID_NUM

CC ID: 259975
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Fisher License Number

General Data Type: VARCHAR2

LAST_NAME

CC ID: 259986
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Fisher Last Name

General Data Type: VARCHAR2

FIRST_NAME

CC ID: 259997
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Fisher First Name

General Data Type: VARCHAR2

BOAT_LICENSE

CC ID: 260008
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Primary Vessel Fished

General Data Type: VARCHAR2

BOAT_LICENSE_2

CC ID: 260019
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Secondary Vessel Fished

General Data Type: VARCHAR2

NUM_FISH_POTS

CC ID: 260026
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Average number of fish pots (traps) set for month

General Data Type: VARCHAR2

NUM_LOBSTER_POTS

CC ID: 260027
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Average number of lobster pots (traps) set for month

General Data Type: VARCHAR2

REPORT_DATE

CC ID: 260028
Seq. Order: 9
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

The date of landing

General Data Type: DATE

NUM_OF_HELPERS

CC ID: 259965
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

The number of helpers

General Data Type: VARCHAR2

GEAR_TYPE1

CC ID: 259966
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Primary Gear Fished

General Data Type: VARCHAR2

GEAR_NUM1

CC ID: 259967
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Quantity of Gear_type1 fished (or hauled for traps)

General Data Type: VARCHAR2

GEAR_TYPE2

CC ID: 259968
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Secondary Gear Fished

General Data Type: VARCHAR2

GEAR_NUM2

CC ID: 259969
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Quantity of Gear_type2 fished (or hauled for traps)

General Data Type: VARCHAR2

AREA_FISHED

CC ID: 259970
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Code for Primary Area Fished. Areas defined by map on historical CCR instruction form.

General Data Type: VARCHAR2

HOURS

CC ID: 259971
Seq. Order: 16
Data Storage Type: BINARY_DOUBLE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Hours active on fishing grounds

General Data Type: BINARY_DOUBLE

TRAP_SOAK_TIME

CC ID: 259972
Seq. Order: 17
Data Storage Type: BINARY_DOUBLE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Hours of trap soak time

General Data Type: BINARY_DOUBLE

GROUPER

CC ID: 259973
Seq. Order: 18
Data Storage Type: BINARY_DOUBLE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Grouper lbs landed

General Data Type: BINARY_DOUBLE

SNAPPER

CC ID: 259974
Seq. Order: 19
Data Storage Type: BINARY_DOUBLE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Snapper lbs landed

General Data Type: BINARY_DOUBLE

GRUNT

CC ID: 259976
Seq. Order: 20
Data Storage Type: BINARY_DOUBLE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Grunt lbs landed

General Data Type: BINARY_DOUBLE

JACK

CC ID: 259977
Seq. Order: 21
Data Storage Type: BINARY_DOUBLE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Jack lbs landed

General Data Type: BINARY_DOUBLE

SURGEONFISH

CC ID: 259978
Seq. Order: 22
Data Storage Type: BINARY_DOUBLE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Surgeonfish lbs landed

General Data Type: BINARY_DOUBLE

PARROTFISH

CC ID: 259979
Seq. Order: 23
Data Storage Type: BINARY_DOUBLE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Parrotfish lbs landed

General Data Type: BINARY_DOUBLE

SHELLFISH

CC ID: 259980
Seq. Order: 24
Data Storage Type: BINARY_DOUBLE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Shellfish lbs landed (these are boxfish, trunkfish, or cowfish, not invertebrate shellfish)

General Data Type: BINARY_DOUBLE

TRIGGERFISH

CC ID: 259981
Seq. Order: 25
Data Storage Type: BINARY_DOUBLE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Triggerfish lbs landed

General Data Type: BINARY_DOUBLE

ANGELFISH

CC ID: 259982
Seq. Order: 26
Data Storage Type: BINARY_DOUBLE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Angelfish lbs landed

General Data Type: BINARY_DOUBLE

PORGY

CC ID: 259983
Seq. Order: 27
Data Storage Type: BINARY_DOUBLE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Porgy lbs landed

General Data Type: BINARY_DOUBLE

BARRACUDA

CC ID: 259984
Seq. Order: 28
Data Storage Type: BINARY_DOUBLE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Barracuda lbs landed

General Data Type: BINARY_DOUBLE

GOATFISH

CC ID: 259985
Seq. Order: 29
Data Storage Type: BINARY_DOUBLE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Goatfish lbs landed

General Data Type: BINARY_DOUBLE

MACKEREL

CC ID: 259987
Seq. Order: 30
Data Storage Type: BINARY_DOUBLE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Mackerel lbs landed

General Data Type: BINARY_DOUBLE

BAITFISH

CC ID: 259988
Seq. Order: 31
Data Storage Type: BINARY_DOUBLE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Baitfish lbs landed

General Data Type: BINARY_DOUBLE

LOBSTER

CC ID: 259989
Seq. Order: 32
Data Storage Type: BINARY_DOUBLE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Spiny lobster lbs landed

General Data Type: BINARY_DOUBLE

CONCH

CC ID: 259990
Seq. Order: 33
Data Storage Type: BINARY_DOUBLE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Queen conch lbs landed

General Data Type: BINARY_DOUBLE

WHELK

CC ID: 259991
Seq. Order: 34
Data Storage Type: BINARY_DOUBLE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Caribbean Topsnail lbs landed

General Data Type: BINARY_DOUBLE

SHARK

CC ID: 259992
Seq. Order: 35
Data Storage Type: BINARY_DOUBLE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Shark lbs landed

General Data Type: BINARY_DOUBLE

PELAGIC

CC ID: 259993
Seq. Order: 36
Data Storage Type: BINARY_DOUBLE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Miscellaneous unknown pelagic species lbs landed

General Data Type: BINARY_DOUBLE

TUNA

CC ID: 259994
Seq. Order: 37
Data Storage Type: BINARY_DOUBLE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Tuna lbs landed

General Data Type: BINARY_DOUBLE

DOLPHIN

CC ID: 259995
Seq. Order: 38
Data Storage Type: BINARY_DOUBLE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Dolphin fish (mahi) lbs landed

General Data Type: BINARY_DOUBLE

WAHOO

CC ID: 259996
Seq. Order: 39
Data Storage Type: BINARY_DOUBLE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Wahoo lbs landed

General Data Type: BINARY_DOUBLE

MARLIN_RELEASED

CC ID: 259998
Seq. Order: 40
Data Storage Type: BINARY_DOUBLE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Marlin estimated lbs released

General Data Type: BINARY_DOUBLE

GAR

CC ID: 259999
Seq. Order: 41
Data Storage Type: BINARY_DOUBLE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Houndfish or needlefish lbs landed

General Data Type: BINARY_DOUBLE

SQUIRRELFISH

CC ID: 260000
Seq. Order: 42
Data Storage Type: BINARY_DOUBLE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Squirrelfish lbs landed

General Data Type: BINARY_DOUBLE

HOGFISH

CC ID: 260001
Seq. Order: 43
Data Storage Type: BINARY_DOUBLE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Hogfish lbs landed

General Data Type: BINARY_DOUBLE

CRAB

CC ID: 260002
Seq. Order: 44
Data Storage Type: BINARY_DOUBLE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Crab lbs landed

General Data Type: BINARY_DOUBLE

LIONFISH

CC ID: 260003
Seq. Order: 45
Data Storage Type: BINARY_DOUBLE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Lionfish lbs landed

General Data Type: BINARY_DOUBLE

SPONGE

CC ID: 260004
Seq. Order: 46
Data Storage Type: BINARY_DOUBLE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Sponge lbs landed

General Data Type: BINARY_DOUBLE

OTHER_SPECIES

CC ID: 260005
Seq. Order: 47
Data Storage Type: BINARY_DOUBLE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Other species lbs landed

General Data Type: BINARY_DOUBLE

LIVE_FISH_DISCARDED

CC ID: 260006
Seq. Order: 48
Data Storage Type: BINARY_DOUBLE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Number of fish released alive

General Data Type: BINARY_DOUBLE

DEAD_FISH_DISCARDED

CC ID: 260007
Seq. Order: 49
Data Storage Type: BINARY_DOUBLE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Number of fish discarded dead

General Data Type: BINARY_DOUBLE

LIVE_LOBSTER_DISCARDED

CC ID: 260009
Seq. Order: 50
Data Storage Type: BINARY_DOUBLE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Number of spiny lobster released alive

General Data Type: BINARY_DOUBLE

DEAD_LOBSTER_DISCARDED

CC ID: 260010
Seq. Order: 51
Data Storage Type: BINARY_DOUBLE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Number of spiny lobster discarded dead

General Data Type: BINARY_DOUBLE

FAD

CC ID: 260011
Seq. Order: 52
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Code for Fish Attracting Device. Locations are in historical CCR instructions

General Data Type: VARCHAR2

ARTIFICIAL_REEF

CC ID: 260012
Seq. Order: 53
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Code for artificial reef fished

General Data Type: VARCHAR2

DISTANCE

CC ID: 260013
Seq. Order: 54
Data Storage Type: BINARY_DOUBLE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Perpendicular distance to shoreline in miles. Some fishers are said to have recorded length of miles from port to fishing grounds.

General Data Type: BINARY_DOUBLE

NO_FISHING_FOR_MONTH

CC ID: 260014
Seq. Order: 55
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Field is checked Y if no fishing occurred in the given month (see MONTH and CALENDAR YEAR)

General Data Type: VARCHAR2

NOTES

CC ID: 260015
Seq. Order: 56
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Notes made by fisher concerning the trip or days in port

General Data Type: VARCHAR2

SOURCE

CC ID: 260016
Seq. Order: 57
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

The original file name and id for record.

General Data Type: VARCHAR2

CREATED

CC ID: 260017
Seq. Order: 58
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Date of file submission

General Data Type: VARCHAR2

ISLAND

CC ID: 260018
Seq. Order: 59
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Island (or island platform) where the fish were landed

General Data Type: VARCHAR2

FISHING_YEAR

CC ID: 260020
Seq. Order: 60
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

The license issue year fished July 1 - June 30

General Data Type: VARCHAR2

CALENDAR_YEAR

CC ID: 260021
Seq. Order: 61
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

The calendar year fished

General Data Type: VARCHAR2

MONTH

CC ID: 260022
Seq. Order: 62
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

The month of the report

General Data Type: VARCHAR2

TOTAL_POUNDS

CC ID: 260023
Seq. Order: 63
Data Storage Type: BINARY_DOUBLE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Total pounds landed on trip

General Data Type: BINARY_DOUBLE

TOTAL_DISCARDS

CC ID: 260024
Seq. Order: 64
Data Storage Type: BINARY_DOUBLE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Total number of discards from fish

General Data Type: BINARY_DOUBLE

DAY

CC ID: 260025
Seq. Order: 65
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Day trip landed

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 29341
GUID: gov.noaa.nmfs.inport:29341
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2015-12-03 14:48+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-05-06
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-06