Metadata Rubric

100%

6 / 6

SEFSC Metadata Library > Fisheries Statistics Division > FISHERIES MONITORING > Commercial Catch and Effort > Commercial Landings Project > Commercial Fisheries Landings for U.S. Caribbea... > U.S. Virgin Islands Commercial Landings Statist... >

Table: ALS_LANDINGS_USVI

Entity (ENT) | Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:29685 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Activity Log

Catalog Details

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.

Description

Entity Type
Data Table

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

Data Attribute / Type

Description

MONTHLAND
VARCHAR2

The month in which the catch was landed.

YEARLAND
VARCHAR2

The year in which the catch was landed.

ALSSTATE
VARCHAR2

The NMFS state code for the USVI (54).

NMFSCOUNTY
VARCHAR2

The NMFS code for USVI by Island.

DEALER
VARCHAR2

This field is defaulted to 9s.

WATERBODY
VARCHAR2

Defaulted to the NMFS code of 1865.

NMFSGEAR
VARCHAR2

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

NMFS_CODE
VARCHAR2

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

POUNDS
NUMBER

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

VALUE
NUMBER

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

PRICE
NUMBER

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

DISTANCE
VARCHAR2

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

PRICE_SOURCE
VARCHAR2

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

ORIGINAL_RECORD_ID
VARCHAR2

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

ISLAND
VARCHAR2

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

FORM_TYPE
VARCHAR2

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

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.

GEAR_TYPE1
VARCHAR2

The primary gear used on the trip

GEAR_TYPE2
VARCHAR2

The secondary gear used on the trip.

GEAR_TYPE3
VARCHAR2

The third ranked gear used on the trip

GEAR_TYPE4
VARCHAR2

The 4th gear used during the trip

VI_SPECIES
VARCHAR2

The common name of the species or species group.

VI_DISTANCE
NUMBER

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

FISHED_3MI_OR_MORE
VARCHAR2

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

DAY
VARCHAR2

The day the catch was landed.

FISHER_KEY
VARCHAR2

The key to the fisher look up table.

GEAR_NUM1
NUMBER

Quantity of gear fished (or hauled for traps).

GEAR_NUM2
NUMBER

Quantity of gear fished (or hauled for traps).

LOAD_DATE
DATE

The date the original file was submitted.

LOAD_FILE_NAME
VARCHAR2

The name of the original loaded file.

TIP_TRIP_TICKET_KEY
VARCHAR2

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

No Child Items for this record.

No contact information is available for this record.

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

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

Attribute Summary

	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.

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

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

MONTHLAND

YEARLAND

ALSSTATE

NMFSCOUNTY

DEALER

WATERBODY

NMFSGEAR

NMFS_CODE

POUNDS

VALUE

PRICE

DISTANCE

PRICE_SOURCE

ORIGINAL_RECORD_ID

ISLAND

FORM_TYPE

FISHING_AREA

GEAR_TYPE1

GEAR_TYPE2

GEAR_TYPE3

GEAR_TYPE4

VI_SPECIES

VI_DISTANCE

FISHED_3MI_OR_MORE

DAY

FISHER_KEY

GEAR_NUM1

GEAR_NUM2

LOAD_DATE

LOAD_FILE_NAME

TIP_TRIP_TICKET_KEY

Activity Log

Activity Log 1

Catalog Details