29685
Table: ALS_LANDINGS_USVI
ALS_LANDINGS_USVI
Entity
Published / External
1920
U.S. Virgin Islands Commercial Landings Statistics 1974 and more recent in compatible format with Accumulated Landings System (ALS) data
Data Set
Completed
This table is a compilation of the USVI landings data into an ALS (Accumulated Landings System) format. Tables compiled from 3 basic formats: gear-based (1974-1999), species group based (1995-2011), and the Caribbean Commercial Landings form (from 2011 and more recent). This table contains price and value data attached from USVI price surveys.
Loaded by batch 7843, 12-10-2015 14:56
Data Table
Yes
ALS
This table is a compilation of the USVI landings data into an ALS (Accumulated Landings System) format. Tables compiled from 3 basic formats: gear-based (1974-1999), species group based (1995-2011), and the Caribbean Commercial Landings form (from 2011 and more recent).
1
MONTHLAND
VARCHAR2
2
No
No
Active
The month in which the catch was landed.
VARCHAR2
2
YEARLAND
VARCHAR2
4
No
No
Active
The year in which the catch was landed.
VARCHAR2
3
ALSSTATE
VARCHAR2
2
No
No
Active
The NMFS state code for the USVI (54).
VARCHAR2
4
NMFSCOUNTY
VARCHAR2
2
No
No
Active
The NMFS code for USVI by Island.
VARCHAR2
5
DEALER
VARCHAR2
14
No
No
Active
This field is defaulted to 9s.
VARCHAR2
6
WATERBODY
VARCHAR2
4
No
No
Active
Defaulted to the NMFS code of 1865.
VARCHAR2
7
NMFSGEAR
VARCHAR2
3
No
No
Active
The NMFS gear code as listed in the als.gear_code_nmfs table.
VARCHAR2
8
NMFS_CODE
VARCHAR2
4
No
No
Active
The NMFS species code as listed in the als.species_code_nmfs table.
VARCHAR2
9
POUNDS
NUMBER
22
No
No
Active
Pounds landed as reported by the fisher. May be estimates based on hold capacity.
NUMBER
10
VALUE
NUMBER
22
No
No
38
Active
Historically determined by USVI DFW price survey. Survey not done since 2012. USVI DFW reported prices as stable since then.
NUMBER
11
PRICE
NUMBER
22
No
No
Active
USVI DFW price surveys not taken since 2012 but reported to be stable since then.
NUMBER
12
DISTANCE
VARCHAR2
1
No
No
Active
The NMFS perpendicular distance from shore code. May have been reported as distance from port to fishing grounds.
VARCHAR2
13
PRICE_SOURCE
VARCHAR2
50
No
No
Active
Price from USVI DFW survey, or estimated based on linear trend of prices, or averaged from like species prices.
VARCHAR2
14
ORIGINAL_RECORD_ID
VARCHAR2
50
No
No
Active
Traces trip id back to original data submission by filename and id number.
VARCHAR2
15
ISLAND
VARCHAR2
20
No
No
Active
Island in USVI. St. Croix, St. Thomas, or St. John. Historically St. Thomas and St. John are combined.
VARCHAR2
16
FORM_TYPE
VARCHAR2
3
No
No
Active
Was original form reported on gear-based, species group based, or from latest form in CCL?
VARCHAR2
17
FISHING_AREA
VARCHAR2
20
No
No
Active
The fishing area code as defined in the USVI 2.5x2.5 minute grid map or from the historical coding. See URLs for Caribbean forms.
VARCHAR2
18
GEAR_TYPE1
VARCHAR2
15
No
No
Active
The primary gear used on the trip
VARCHAR2
19
GEAR_TYPE2
VARCHAR2
15
No
No
Active
The secondary gear used on the trip.
VARCHAR2
20
GEAR_TYPE3
VARCHAR2
15
No
No
Active
The third ranked gear used on the trip
VARCHAR2
21
GEAR_TYPE4
VARCHAR2
15
No
No
Active
The 4th gear used during the trip
VARCHAR2
22
VI_SPECIES
VARCHAR2
30
No
No
Active
The common name of the species or species group.
VARCHAR2
23
VI_DISTANCE
NUMBER
22
No
No
Active
Distance from shore in miles or distance to fishing grounds from port
NUMBER
24
FISHED_3MI_OR_MORE
VARCHAR2
10
No
No
Active
Did fishing occur 3 miles or more from shore (Y/N)?
VARCHAR2
25
DAY
VARCHAR2
2
No
No
Active
The day the catch was landed.
VARCHAR2
26
FISHER_KEY
VARCHAR2
20
No
No
Active
The key to the fisher look up table.
VARCHAR2
27
GEAR_NUM1
NUMBER
22
No
No
Active
Quantity of gear fished (or hauled for traps).
NUMBER
28
GEAR_NUM2
NUMBER
22
No
No
Active
Quantity of gear fished (or hauled for traps).
NUMBER
29
LOAD_DATE
DATE
7
No
No
Active
The date the original file was submitted.
DATE
30
LOAD_FILE_NAME
VARCHAR2
50
No
No
Active
The name of the original loaded file.
VARCHAR2
31
TIP_TRIP_TICKET_KEY
VARCHAR2
30
No
No
Active
An unused field. Designed to link to the TIP database.
VARCHAR2
2016-09-14
Add records
Bennett, Joshua
DIscovered 195 missing records (15,034 lbs) for St. Thomas 1999 in file STT98-99_OF (old gear-based forms). Added missing records to table. Records were all for Unclassified Finfish except 1 spiny lobster record for 5 lbs.
gov.noaa.nmfs.inport:29685
Joshua Bennett
2015-12-10T14:56:31
SysAdmin InPortAdmin
2022-08-09T17:11:05
2021-05-06
Southeast Fisheries Science Center
SEFSC
75 Virginia Beach Drive
Miami
FL
33149
USA
(305)361-5761
www.sefsc.noaa.gov
8:00 a.m. - 4:30 p.m. EST
1001
Public
No
2021-05-06
1 Year
2022-05-06