Slide Menu
InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.2.3. Downtime Schedule Tuesday, November 29, 2022 12:00pm - 1:30pm Eastern / 10:00am - 11:30pm Pacific / 7:00am - 8:30pm Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: https://www.fisheries.noaa.gov/inportserve/waf What's...
View All
Search Help Show/Hide Menu

Item Identification

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

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.

Notes:

Loaded by batch 7843, 12-10-2015 14:56

Entity Information

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

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).

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
MONTHLAND VARCHAR2 The month in which the catch was landed.
100
YEARLAND VARCHAR2 The year in which the catch was landed.
100
ALSSTATE VARCHAR2 The NMFS state code for the USVI (54).
100
NMFSCOUNTY VARCHAR2 The NMFS code for USVI by Island.
100
DEALER VARCHAR2 This field is defaulted to 9s.
100
WATERBODY VARCHAR2 Defaulted to the NMFS code of 1865.
100
NMFSGEAR VARCHAR2 The NMFS gear code as listed in the als.gear_code_nmfs table.
100
NMFS_CODE VARCHAR2 The NMFS species code as listed in the als.species_code_nmfs table.
100
POUNDS NUMBER Pounds landed as reported by the fisher. May be estimates based on hold capacity.
100
VALUE NUMBER Historically determined by USVI DFW price survey. Survey not done since 2012. USVI DFW reported prices as stable since then.
100
PRICE NUMBER USVI DFW price surveys not taken since 2012 but reported to be stable since then.
100
DISTANCE VARCHAR2 The NMFS perpendicular distance from shore code. May have been reported as distance from port to fishing grounds.
100
PRICE_SOURCE VARCHAR2 Price from USVI DFW survey, or estimated based on linear trend of prices, or averaged from like species prices.
100
ORIGINAL_RECORD_ID VARCHAR2 Traces trip id back to original data submission by filename and id number.
100
ISLAND VARCHAR2 Island in USVI. St. Croix, St. Thomas, or St. John. Historically St. Thomas and St. John are combined.
100
FORM_TYPE VARCHAR2 Was original form reported on gear-based, species group based, or from latest form in CCL?
100
FISHING_AREA VARCHAR2 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.
100
GEAR_TYPE1 VARCHAR2 The primary gear used on the trip
100
GEAR_TYPE2 VARCHAR2 The secondary gear used on the trip.
100
GEAR_TYPE3 VARCHAR2 The third ranked gear used on the trip
100
GEAR_TYPE4 VARCHAR2 The 4th gear used during the trip
100
VI_SPECIES VARCHAR2 The common name of the species or species group.
100
VI_DISTANCE NUMBER Distance from shore in miles or distance to fishing grounds from port
100
FISHED_3MI_OR_MORE VARCHAR2 Did fishing occur 3 miles or more from shore (Y/N)?
100
DAY VARCHAR2 The day the catch was landed.
100
FISHER_KEY VARCHAR2 The key to the fisher look up table.
100
GEAR_NUM1 NUMBER Quantity of gear fished (or hauled for traps).
100
GEAR_NUM2 NUMBER Quantity of gear fished (or hauled for traps).
100
LOAD_DATE DATE The date the original file was submitted.
100
LOAD_FILE_NAME VARCHAR2 The name of the original loaded file.
100
TIP_TRIP_TICKET_KEY VARCHAR2 An unused field. Designed to link to the TIP database.

Attribute Details

MONTHLAND

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

The month in which the catch was landed.

General Data Type: VARCHAR2

YEARLAND

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

The year in which the catch was landed.

General Data Type: VARCHAR2

ALSSTATE

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

The NMFS state code for the USVI (54).

General Data Type: VARCHAR2

NMFSCOUNTY

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

The NMFS code for USVI by Island.

General Data Type: VARCHAR2

DEALER

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

This field is defaulted to 9s.

General Data Type: VARCHAR2

WATERBODY

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

Defaulted to the NMFS code of 1865.

General Data Type: VARCHAR2

NMFSGEAR

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

The NMFS gear code as listed in the als.gear_code_nmfs table.

General Data Type: VARCHAR2

NMFS_CODE

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

The NMFS species code as listed in the als.species_code_nmfs table.

General Data Type: VARCHAR2

POUNDS

CC ID: 261929
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Pounds landed as reported by the fisher. May be estimates based on hold capacity.

General Data Type: NUMBER

VALUE

CC ID: 261900
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Historically determined by USVI DFW price survey. Survey not done since 2012. USVI DFW reported prices as stable since then.

General Data Type: NUMBER

PRICE

CC ID: 261901
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

USVI DFW price surveys not taken since 2012 but reported to be stable since then.

General Data Type: NUMBER

DISTANCE

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

The NMFS perpendicular distance from shore code. May have been reported as distance from port to fishing grounds.

General Data Type: VARCHAR2

PRICE_SOURCE

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

Price from USVI DFW survey, or estimated based on linear trend of prices, or averaged from like species prices.

General Data Type: VARCHAR2

ORIGINAL_RECORD_ID

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

Traces trip id back to original data submission by filename and id number.

General Data Type: VARCHAR2

ISLAND

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

Island in USVI. St. Croix, St. Thomas, or St. John. Historically St. Thomas and St. John are combined.

General Data Type: VARCHAR2

FORM_TYPE

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

Was original form reported on gear-based, species group based, or from latest form in CCL?

General Data Type: VARCHAR2

FISHING_AREA

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

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.

General Data Type: VARCHAR2

GEAR_TYPE1

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

The primary gear used on the trip

General Data Type: VARCHAR2

GEAR_TYPE2

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

The secondary gear used on the trip.

General Data Type: VARCHAR2

GEAR_TYPE3

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

The third ranked gear used on the trip

General Data Type: VARCHAR2

GEAR_TYPE4

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

The 4th gear used during the trip

General Data Type: VARCHAR2

VI_SPECIES

CC ID: 261913
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

The common name of the species or species group.

General Data Type: VARCHAR2

VI_DISTANCE

CC ID: 261914
Seq. Order: 23
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Distance from shore in miles or distance to fishing grounds from port

General Data Type: NUMBER

FISHED_3MI_OR_MORE

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

Did fishing occur 3 miles or more from shore (Y/N)?

General Data Type: VARCHAR2

DAY

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

The day the catch was landed.

General Data Type: VARCHAR2

FISHER_KEY

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

The key to the fisher look up table.

General Data Type: VARCHAR2

GEAR_NUM1

CC ID: 261918
Seq. Order: 27
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Quantity of gear fished (or hauled for traps).

General Data Type: NUMBER

GEAR_NUM2

CC ID: 261919
Seq. Order: 28
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Quantity of gear fished (or hauled for traps).

General Data Type: NUMBER

LOAD_DATE

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

The date the original file was submitted.

General Data Type: DATE

LOAD_FILE_NAME

CC ID: 261922
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

The name of the original loaded file.

General Data Type: VARCHAR2

TIP_TRIP_TICKET_KEY

CC ID: 261923
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

An unused field. Designed to link to the TIP database.

General Data Type: VARCHAR2

Activity Log

Activity Log 1

CC ID: 350217
Activity Date/Time: 2016-09-15
Activity Type: Add records
Responsible Party: Joshua Bennett
Description:

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.

Catalog Details

Catalog Item ID: 29685
GUID: gov.noaa.nmfs.inport:29685
Metadata Record Created By: Joshua Bennett
Metadata Record Created: 2015-12-10 14:56+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