Slide Menu
Search Help Show/Hide Menu

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: Lee M Weinberger
Metadata Record Last Modified: 2021-05-06 22:24+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-05-07