Slide Menu
System Maintenance Notice, Sunday, January 23, 2022 @ 8am-2pm Eastern. The Operations Team will be performing system maintenance on all server environments. During this scheduled downtime, InPort will not be available.
View All
Search Help Show/Hide Menu

Item Identification

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

The unedited Puerto Rico ALS table from 1983-2011 with primary key (record_number_id) added to link with edited errata table ALS.als_land_pr_1983-2011_errata. This is a copy of ALS.ALS_LANDINGS_PUERTO_RICO for the years 1983-2011. This copy was assigned a record id number for each record linking it to the errata file als.als_land_pr_1983_2011_errata for the corresponding record.

Purpose:

Allows for display of edited records and their previous values in the raw data for 1983-2011 to account for where changes were made.

Notes:

Loaded by batch 7906, 12-22-2015 14:11

Entity Information

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

The unedited Puerto Rico ALS table from 1983-2011 with primary key (record_number_id) added to link with edited errata table ALS.als_land_pr_1983-2011_errata.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
MONTH_LANDED VARCHAR2 Month of landing
100
YEAR_LANDED VARCHAR2 4 character Year Landed
100
STATE_LANDED VARCHAR2 State Code Landed. Currently is defaulted to 55.
100
FISHING_CENTER VARCHAR2 Areas of fishing activity in Puerto Rico, the 1st 2 characters represent the NMFS code for the municipality the fishing center occurs in.
100
DEALER VARCHAR2 Dealer information not present here. Code is currently filled with 9s.
100
WATER_BODY VARCHAR2 Column normally contains area of catch. Defaulted to 9s.
100
GEAR VARCHAR2 The NMFS gear code as determined by the submitted Puerto Rico (Erdman) gear code. Multiple gears may occur within a trip.
100
SPECIES VARCHAR2 The NMFS Species Code as best determined by the submitted Puerto Rico (Erdman) species code. Some NMFS species codes are more general where the Erdman codes are specific.
100
SHELL_OR_FINFISH VARCHAR2 1 is finfish and 2 is shellfish. For general extractions.
100
POUNDS NUMBER The landed pounds. Currently the landed conditions vary according to fishery. Trap and net fish are whole weight, fish caught with hooks or speared are typically gutted. Sharks are typically dressed weight. For Conchs, (prior to 2003, all landings presumably are reported as uncleaned (including head and viscera). In 2003 aproximately 50% of meats were cleaned and by 2004 all conch was reported in cleaned condition - SEDAR 14). No adjustments have been made for any landed condtions in these data.
100
VALUE NUMBER Value in dollars. Dollars are rounded to integers in data.
100
SECTION VARCHAR2 Section Code, Added for compatibility with ALS.ALS_LANDINGS
100
PRICE NUMBER Price payed for fish. (In dollars) Used with landings to calculate value.
100
DISTANCE VARCHAR2 Distance From Shore Code. EEZ begins at 9 miles out to sea in Puerto Rico. Data in this column are incomplete. 9s used as placeholders.
100
STATE_CAUGHT VARCHAR2 State Caught. No meaning to this column here. Added For compatibility WIth ALS.ALS_LANDINGS
100
LANDING_DATE DATE The date the vessel arrived back at dock with landings.
100
PR_ID_CODE VARCHAR2 Code assigned to individual or other entity when permit is issued. Coding is inconsistent. 1st 3 characters appear to represent fishing center of permit holder for earlier years until 1998.
100
PR_GEAR VARCHAR2 The Puerto Rico gear code (Developed by Donald S. Erdman).
100
NUMBER_OF_TRIPS NUMBER Number Of Trips
100
PR_SPECIES VARCHAR2 The Puerto Rico species code (Developed by Donald S. Erdman).
100
GEAR_QTY NUMBER Represents the maximum number of gear in use at any one time during the trip.
100
GEAR_HOURS NUMBER Soak Time - Amount of time the gear is in the water. Likely to exceed trip duration in the case of traps.
100
DAY_LANDED VARCHAR2 Day landed. Derived from landing date
100
USERID VARCHAR2 Oracle Id Of The Person Loading The Data
100
SOURCE_FILE VARCHAR2 Source File used to load data.
100
MINIMUM_DEPTH NUMBER Minimum Depth Fished in fathoms - data are incomplete.
100
MAXIMUM_DEPTH NUMBER Maximum Depth Fished in fathoms. Data are incomplete.
100
TRIP_TICKET_NUMBER VARCHAR2 Trip Ticket Number. Currently assigned after PRDNR receives trip ticket from fisher (not preprinted).
100
RECORD_NUMBER_ID NUMBER Primary Key to the table. Foreign Key to als.als_land_pr_1983_2011_errata

Attribute Details

MONTH_LANDED

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

Month of landing

General Data Type: VARCHAR2

YEAR_LANDED

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

4 character Year Landed

General Data Type: VARCHAR2

STATE_LANDED

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

State Code Landed. Currently is defaulted to 55.

General Data Type: VARCHAR2

FISHING_CENTER

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

Areas of fishing activity in Puerto Rico, the 1st 2 characters represent the NMFS code for the municipality the fishing center occurs in.

General Data Type: VARCHAR2

DEALER

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

Dealer information not present here. Code is currently filled with 9s.

General Data Type: VARCHAR2

WATER_BODY

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

Column normally contains area of catch. Defaulted to 9s.

General Data Type: VARCHAR2

GEAR

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

The NMFS gear code as determined by the submitted Puerto Rico (Erdman) gear code. Multiple gears may occur within a trip.

General Data Type: VARCHAR2

SPECIES

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

The NMFS Species Code as best determined by the submitted Puerto Rico (Erdman) species code. Some NMFS species codes are more general where the Erdman codes are specific.

General Data Type: VARCHAR2

SHELL_OR_FINFISH

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

1 is finfish and 2 is shellfish. For general extractions.

General Data Type: VARCHAR2

POUNDS

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

The landed pounds. Currently the landed conditions vary according to fishery. Trap and net fish are whole weight, fish caught with hooks or speared are typically gutted. Sharks are typically dressed weight. For Conchs, (prior to 2003, all landings presumably are reported as uncleaned (including head and viscera). In 2003 aproximately 50% of meats were cleaned and by 2004 all conch was reported in cleaned condition - SEDAR 14). No adjustments have been made for any landed condtions in these data.

General Data Type: NUMBER

VALUE

CC ID: 267178
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 9
Scale: 0
Status: Active
Description:

Value in dollars. Dollars are rounded to integers in data.

General Data Type: NUMBER

SECTION

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

Section Code, Added for compatibility with ALS.ALS_LANDINGS

General Data Type: VARCHAR2

PRICE

CC ID: 267180
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 3
Status: Active
Description:

Price payed for fish. (In dollars) Used with landings to calculate value.

General Data Type: NUMBER

DISTANCE

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

Distance From Shore Code. EEZ begins at 9 miles out to sea in Puerto Rico. Data in this column are incomplete. 9s used as placeholders.

General Data Type: VARCHAR2

STATE_CAUGHT

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

State Caught. No meaning to this column here. Added For compatibility WIth ALS.ALS_LANDINGS

General Data Type: VARCHAR2

LANDING_DATE

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

The date the vessel arrived back at dock with landings.

General Data Type: DATE

PR_ID_CODE

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

Code assigned to individual or other entity when permit is issued. Coding is inconsistent. 1st 3 characters appear to represent fishing center of permit holder for earlier years until 1998.

General Data Type: VARCHAR2

PR_GEAR

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

The Puerto Rico gear code (Developed by Donald S. Erdman).

General Data Type: VARCHAR2

NUMBER_OF_TRIPS

CC ID: 267186
Seq. Order: 19
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Number Of Trips

General Data Type: NUMBER

PR_SPECIES

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

The Puerto Rico species code (Developed by Donald S. Erdman).

General Data Type: VARCHAR2

GEAR_QTY

CC ID: 267189
Seq. Order: 21
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Represents the maximum number of gear in use at any one time during the trip.

General Data Type: NUMBER

GEAR_HOURS

CC ID: 267190
Seq. Order: 22
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Soak Time - Amount of time the gear is in the water. Likely to exceed trip duration in the case of traps.

General Data Type: NUMBER

DAY_LANDED

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

Day landed. Derived from landing date

General Data Type: VARCHAR2

USERID

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

Oracle Id Of The Person Loading The Data

General Data Type: VARCHAR2

SOURCE_FILE

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

Source File used to load data.

General Data Type: VARCHAR2

MINIMUM_DEPTH

CC ID: 267194
Seq. Order: 26
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Minimum Depth Fished in fathoms - data are incomplete.

General Data Type: NUMBER

MAXIMUM_DEPTH

CC ID: 267195
Seq. Order: 27
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Maximum Depth Fished in fathoms. Data are incomplete.

General Data Type: NUMBER

TRIP_TICKET_NUMBER

CC ID: 267196
Seq. Order: 28
Data Storage Type: VARCHAR2
Max Length: 11
Required: No
Primary Key: No
Status: Active
Description:

Trip Ticket Number. Currently assigned after PRDNR receives trip ticket from fisher (not preprinted).

General Data Type: VARCHAR2

RECORD_NUMBER_ID

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

Primary Key to the table. Foreign Key to als.als_land_pr_1983_2011_errata

General Data Type: NUMBER

Catalog Details

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