Table: ALS_LANDINGS_USVI
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:29685 | Updated: August 9, 2022 | Published / External
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |