29946
Table: ALS_LAND_PR_1983_2011_ERRATA
ALS_LAND_PR_1983_2011_ERRATA
Entity
Published / External
1919
Puerto Rico Commercial Landings Statistics 1983 and more recent in Accumulated Landings System (ALS) Compatible Format
Data Set
Completed
An errata table holding Puerto Rico commercial landings which were edited by the SEFSC to correct errors and to standardize coding for the period of 1983-2011 in the table als.als_land_pr_1983_2011, the link for which is the primary key record_number_id. Records are primarily edited for invalid or highly unlikely species/gear combinations, as well as edit/standardization and resolution of fisher permits and names, as well as a limited number of fishing center and species edits.
Loaded by batch 7906, 12-22-2015 14:11
Data Table
Yes
ALS
An errata table holding Puerto Rico commercial landings which were edited by the SEFSC to correct errors and to standardize coding for the period of 1983-2011 in the table als.als_land_pr_1983_2011, the link for which is the primary key record_number_id. Records are primarily edited for invalid or highly unlikely species/gear combinations, as well as edit/standardization and resolution of fisher permits and names, as well as a limited number of fishing center and species edits.
1
RECORD_NUMBER_ID
NUMBER
22
No
No
Active
The primary key. Foreign key to als.als_land_pr_1983_2011 primary key.
NUMBER
2
FISHING_CENTER_ED
VARCHAR2
3
No
No
Active
The edited fishing_center code
VARCHAR2
3
NMFS_GEAR_ED
VARCHAR2
3
No
No
Active
The edited NMFSGEAR code
VARCHAR2
4
NMFS_SPECIES_ED
VARCHAR2
4
No
No
Active
The edited NMFS species code
VARCHAR2
5
SHELL_OR_FINFISH_ED
VARCHAR2
1
No
No
Active
The edited NMFS shellfin code
VARCHAR2
6
PR_ID_CODE_ED
VARCHAR2
6
No
No
Active
The edited fisher id code
VARCHAR2
7
FISHER_FIRST_NAME
VARCHAR2
30
No
No
Active
Fisher first name
VARCHAR2
8
FISHER_LAST_NAME
VARCHAR2
40
No
No
Active
Fisher last name
VARCHAR2
9
PR_GEAR_ED
VARCHAR2
3
No
No
Active
Edited PR_GEAR code
VARCHAR2
10
PR_SPECIES_ED
VARCHAR2
3
No
No
Active
Edited PR_SPECIES code
VARCHAR2
11
TRIP_TICKET_NUMBER_ED
VARCHAR2
11
No
No
Active
edited trip ticket number
VARCHAR2
12
DUPLICATE_RECORD
VARCHAR2
1
No
No
Active
is record a duplicate?
VARCHAR2
13
NUMBER_OF_TRIPS_ED
NUMBER
22
No
No
2
0
Active
Edited number of trips
NUMBER
14
GEAR_QTY_ED
NUMBER
22
No
No
4
0
Active
Edited gear quantity
NUMBER
15
GEAR_HOURS_ED
NUMBER
22
No
No
3
0
Active
Edited hours gear was fished
NUMBER
16
MINIMUM_DEPTH_ED
NUMBER
22
No
No
4
0
Active
Edited minimum depth (fathoms)
NUMBER
17
MAXIMUM_DEPTH_ED
NUMBER
22
No
No
4
0
Active
Edited maximum depth (fathoms)
NUMBER
18
YEAR_LANDED
VARCHAR2
4
No
No
Active
edited landing year
VARCHAR2
19
COAST
VARCHAR2
20
No
No
Active
Edited landing coast (N,E,S,W)
VARCHAR2
20
AREA_FISHED1
VARCHAR2
4
No
No
Active
The first area fished recorded on form
VARCHAR2
21
AREA_FISHED2
VARCHAR2
4
No
No
Active
The 2nd area fished recorded on form
VARCHAR2
22
AREA_FISHED3
VARCHAR2
4
No
No
Active
The 3rd area fished recorded on form.
VARCHAR2
23
AREA_FISHED4
VARCHAR2
4
No
No
Active
The 4th area fished recorded on form
VARCHAR2
gov.noaa.nmfs.inport:29946
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