29945
Table: ALS_LAND_PR_1983_2011
ALS_LAND_PR_1983_2011
Entity
Published / External
1919
Puerto Rico Commercial Landings Statistics 1983 and more recent in Accumulated Landings System (ALS) Compatible Format
Data Set
Completed
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.
Allows for display of edited records and their previous values in the raw data for 1983-2011 to account for where changes were made.
Loaded by batch 7906, 12-22-2015 14:11
Data Table
Yes
ALS
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.
1
MONTH_LANDED
VARCHAR2
2
No
No
Active
Month of landing
VARCHAR2
2
YEAR_LANDED
VARCHAR2
4
No
No
Active
4 character Year Landed
VARCHAR2
3
STATE_LANDED
VARCHAR2
2
No
No
Active
State Code Landed. Currently is defaulted to 55.
VARCHAR2
4
FISHING_CENTER
VARCHAR2
3
No
No
Active
Areas of fishing activity in Puerto Rico, the 1st 2 characters represent the NMFS code for the municipality the fishing center occurs in.
VARCHAR2
5
DEALER
VARCHAR2
14
No
No
Active
Dealer information not present here. Code is currently filled with 9s.
VARCHAR2
6
WATER_BODY
VARCHAR2
4
No
No
Active
Column normally contains area of catch. Defaulted to 9s.
VARCHAR2
7
GEAR
VARCHAR2
3
No
No
Active
The NMFS gear code as determined by the submitted Puerto Rico (Erdman) gear code. Multiple gears may occur within a trip.
VARCHAR2
8
SPECIES
VARCHAR2
4
No
No
Active
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.
VARCHAR2
9
SHELL_OR_FINFISH
VARCHAR2
1
No
No
Active
1 is finfish and 2 is shellfish. For general extractions.
VARCHAR2
10
POUNDS
NUMBER
22
No
No
38
0
Active
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.
NUMBER
11
VALUE
NUMBER
22
No
No
9
0
Active
Value in dollars. Dollars are rounded to integers in data.
NUMBER
12
SECTION
VARCHAR2
1
No
No
Active
Section Code, Added for compatibility with ALS.ALS_LANDINGS
VARCHAR2
13
PRICE
NUMBER
22
No
No
38
3
Active
Price payed for fish. (In dollars) Used with landings to calculate value.
NUMBER
14
DISTANCE
VARCHAR2
1
No
No
Active
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.
VARCHAR2
15
STATE_CAUGHT
VARCHAR2
2
No
No
Active
State Caught. No meaning to this column here. Added For compatibility WIth ALS.ALS_LANDINGS
VARCHAR2
16
LANDING_DATE
DATE
7
No
No
Active
The date the vessel arrived back at dock with landings.
DATE
17
PR_ID_CODE
VARCHAR2
6
No
No
Active
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.
VARCHAR2
18
PR_GEAR
VARCHAR2
3
No
No
Active
The Puerto Rico gear code (Developed by Donald S. Erdman).
VARCHAR2
19
NUMBER_OF_TRIPS
NUMBER
22
No
No
38
0
Active
Number Of Trips
NUMBER
20
PR_SPECIES
VARCHAR2
3
No
No
Active
The Puerto Rico species code (Developed by Donald S. Erdman).
VARCHAR2
21
GEAR_QTY
NUMBER
22
No
No
38
0
Active
Represents the maximum number of gear in use at any one time during the trip.
NUMBER
22
GEAR_HOURS
NUMBER
22
No
No
3
0
Active
Soak Time - Amount of time the gear is in the water. Likely to exceed trip duration in the case of traps.
NUMBER
23
DAY_LANDED
VARCHAR2
2
No
No
Active
Day landed. Derived from landing date
VARCHAR2
24
USERID
VARCHAR2
30
No
No
Active
Oracle Id Of The Person Loading The Data
VARCHAR2
25
SOURCE_FILE
VARCHAR2
20
No
No
Active
Source File used to load data.
VARCHAR2
26
MINIMUM_DEPTH
NUMBER
22
No
No
38
0
Active
Minimum Depth Fished in fathoms - data are incomplete.
NUMBER
27
MAXIMUM_DEPTH
NUMBER
22
No
No
4
0
Active
Maximum Depth Fished in fathoms. Data are incomplete.
NUMBER
28
TRIP_TICKET_NUMBER
VARCHAR2
11
No
No
Active
Trip Ticket Number. Currently assigned after PRDNR receives trip ticket from fisher (not preprinted).
VARCHAR2
29
RECORD_NUMBER_ID
NUMBER
22
No
No
38
Active
Primary Key to the table. Foreign Key to als.als_land_pr_1983_2011_errata
NUMBER
gov.noaa.nmfs.inport:29945
Joshua Bennett
2015-12-22T14:11:36
SysAdmin InPortAdmin
2022-08-09T17:11:13
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