Slide Menu
System Maintenance Notice, Monday, December 5, 2022 @ 1pm-5pm Eastern. The Operations Team will be performing system maintenance. During this scheduled downtime, InPort will not be available.
View All
Search Help Show/Hide Menu

Item Identification

Title: Table: ALS_LANDINGS_PUERTO_RICO_ED
Short Name: ALS_LANDINGS_PUERTO_RICO_ED
Status: Completed

Entity Information

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

This table contains edited data done at SEFSC for various fields in the ALS landings data submissions from 1983-2011. It is built from 3 tables: als.als_pr_land_1983_2011 (contains unedited landings from 1983-2011), als.als_pr_land_1983_2011_errata (contains edited data from the years 1983-2011), and als.als_landings_puerto_rico (which is extracted from the CCL (Caribbean Commercial Landings online entry data (2012-most recent) and reformatted to ALS standards.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
MONTH_LANDED VARCHAR2 The month the catch was landed
100
YEAR_LANDED VARCHAR2 The calendar year the catch was landed.
100
FISHING_CENTER_ED VARCHAR2 The fishing center where the catch was landed. Puerto Rico has municipalities which contain multiple locations of landings. These locations are known as fishing centers. Generally the first 2 digits of the fishing center code reflects the municipality code.
100
WATER_BODY VARCHAR2 This is a generic NMFS water body code (1865) which basically just indicates the area fished is Puerto Rico. More specific area descriptions are available in the area_fished columns.
100
NMFS_GEAR_ED VARCHAR2 The NMFS code for the gear used.
100
NMFS_SPECIES_ED VARCHAR2 The NMFS code for the species caught
100
POUNDS_LANDED NUMBER The reported pounds landed. (no correction factor used).
100
VALUE_IN_DOLLARS NUMBER The value of the reported landings. NO correction factor used.
100
PRICE_PER_LB NUMBER The price in dollars/pound. Some of these are calculated based on other identical or similar catch.
100
DISTANCE VARCHAR2 The perpendicular distance from shore. Caveat: Some fishers interpret this as the distance traveled from port.
100
LANDING_DATE DATE The date the catch was landed.
100
PR_ID_CODE_ED VARCHAR2 The edited fisher license number.
100
PR_GEAR_ED VARCHAR2 The edited Puerto Rico gear code.
100
NUMBER_OF_TRIPS_ED NUMBER The edited number of trips (older data had multiple trips on forms).
100
PR_SPECIES_ED VARCHAR2 The edited puerto rico species code
100
GEAR_QTY_ED NUMBER The edited gear quantity
100
GEAR_HOURS_ED NUMBER Edited gear hours (hours vessel spent actively fishing.
100
DAY_LANDED VARCHAR2 Day the catch was landed
100
MINIMUM_DEPTH_ED NUMBER Minimum depth fished in feet or fathoms
100
MAXIMUM_DEPTH_ED NUMBER Maximum depth fished in fathoms or feet
100
TRIP_TICKET_NUMBER_ED VARCHAR2 A processing number assigned by the agency when the log report form is received.
100
FISHER_FIRST_NAME VARCHAR2 The fisher first name
100
FISHER_LAST_NAME VARCHAR2 The fisher last name.
100
FISHING_CENTER_NAME VARCHAR2 The name of the edited fishing center
100
LANDING_LOCATION_COUNTY VARCHAR2 The municipality of the edited fishing center
100
COAST VARCHAR2 The coast wherein the fishing center exists. Coast was used to determine correction factor for landings from 2003 to recent.
100
CORRECTION_FACTOR NUMBER A factor calculated by Puerto Rico to account for under-reported landings. Surveys are taken periodically at dockside of vessels landing and reported landings are compared for the dates surveyed. The ratio of reported pounds/surveyed pounds is used to determine factors. Factors were calculated by entire island from 1983-2002, and by coast from 2003 - most recent. Prior to 2002 the factors were calculated based on the total number of trips (reported trips/surveyed trips). Method subject to change.
100
ADJUSTED_POUNDS NUMBER The reported pounds adjusted by the correction factor
100
DISTANCE_DESCRIBE VARCHAR2 The descriptions of the distance codes
100
ERDMAN_GEAR_NAME VARCHAR2 The name of the Puerto Rico gear code
100
ERDMAN_COMMON_NAME VARCHAR2 The Puerto Rico common name for the species landed
100
SPECIES_ITIS VARCHAR2 The ITIS species code for the species landed
100
ITIS_COMMON_NAME VARCHAR2 The ITIS common name for the species landed
100
ITIS_SCIENTIFIC_NAME VARCHAR2 The ITIS scientific name for the species landed
100
FMU VARCHAR2 The Fishery Management Unit (if any) for the species landed
100
FAMILY VARCHAR2 The common name for the family of the species landed.
100
ACL_UNIT VARCHAR2 The Allowable Catch Limit Unit (if any) for the species landed
100
AREA_FISHED1 VARCHAR2 THe Puerto Rico area fished. Has 4 entry fields. Listed in order of entry. Since 2012 coding has mostly been by 2.5 x 2.5 minute grid squares according to map of Puerto Rico waters.
100
AREA_FISHED2 VARCHAR2 The 2nd Puerto Rico fishing area entered on form.
100
AREA_FISHED3 VARCHAR2 The 3rd Puerto Rico fishing area entered on form.
100
AREA_FISHED4 VARCHAR2 The 4th Puerto Rico fishing area entered on form.
100
RECORD_ID_NUM NUMBER The record id number used for matching to the ALS.als_pr_land_1983_2011 table.
100
TRIP_MAY_BE_DUPLICATE VARCHAR2 Potential duplicate trips are flagged with a 'Y'
100
DATE_OF_EXTRACT DATE Date of last extract of these data from the CCL.

Attribute Details

MONTH_LANDED

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

The month the catch was landed

General Data Type: VARCHAR2

YEAR_LANDED

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

The calendar year the catch was landed.

General Data Type: VARCHAR2

FISHING_CENTER_ED

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

The fishing center where the catch was landed. Puerto Rico has municipalities which contain multiple locations of landings. These locations are known as fishing centers. Generally the first 2 digits of the fishing center code reflects the municipality code.

General Data Type: VARCHAR2

WATER_BODY

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

This is a generic NMFS water body code (1865) which basically just indicates the area fished is Puerto Rico. More specific area descriptions are available in the area_fished columns.

General Data Type: VARCHAR2

NMFS_GEAR_ED

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

The NMFS code for the gear used.

General Data Type: VARCHAR2

NMFS_SPECIES_ED

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

The NMFS code for the species caught

General Data Type: VARCHAR2

POUNDS_LANDED

CC ID: 565119
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

The reported pounds landed. (no correction factor used).

General Data Type: NUMBER

VALUE_IN_DOLLARS

CC ID: 565120
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

The value of the reported landings. NO correction factor used.

General Data Type: NUMBER

PRICE_PER_LB

CC ID: 565121
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

The price in dollars/pound. Some of these are calculated based on other identical or similar catch.

General Data Type: NUMBER

DISTANCE

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

The perpendicular distance from shore. Caveat: Some fishers interpret this as the distance traveled from port.

General Data Type: VARCHAR2

LANDING_DATE

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

The date the catch was landed.

General Data Type: DATE

PR_ID_CODE_ED

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

The edited fisher license number.

General Data Type: VARCHAR2

PR_GEAR_ED

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

The edited Puerto Rico gear code.

General Data Type: VARCHAR2

NUMBER_OF_TRIPS_ED

CC ID: 565126
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

The edited number of trips (older data had multiple trips on forms).

General Data Type: NUMBER

PR_SPECIES_ED

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

The edited puerto rico species code

General Data Type: VARCHAR2

GEAR_QTY_ED

CC ID: 565128
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

The edited gear quantity

General Data Type: NUMBER

GEAR_HOURS_ED

CC ID: 565129
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Edited gear hours (hours vessel spent actively fishing.

General Data Type: NUMBER

DAY_LANDED

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

Day the catch was landed

General Data Type: VARCHAR2

MINIMUM_DEPTH_ED

CC ID: 565131
Seq. Order: 19
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Minimum depth fished in feet or fathoms

General Data Type: NUMBER

MAXIMUM_DEPTH_ED

CC ID: 565132
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Maximum depth fished in fathoms or feet

General Data Type: NUMBER

TRIP_TICKET_NUMBER_ED

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

A processing number assigned by the agency when the log report form is received.

General Data Type: VARCHAR2

FISHER_FIRST_NAME

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

The fisher first name

General Data Type: VARCHAR2

FISHER_LAST_NAME

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

The fisher last name.

General Data Type: VARCHAR2

FISHING_CENTER_NAME

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

The name of the edited fishing center

General Data Type: VARCHAR2

LANDING_LOCATION_COUNTY

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

The municipality of the edited fishing center

General Data Type: VARCHAR2

COAST

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

The coast wherein the fishing center exists. Coast was used to determine correction factor for landings from 2003 to recent.

General Data Type: VARCHAR2

CORRECTION_FACTOR

CC ID: 565139
Seq. Order: 27
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

A factor calculated by Puerto Rico to account for under-reported landings. Surveys are taken periodically at dockside of vessels landing and reported landings are compared for the dates surveyed. The ratio of reported pounds/surveyed pounds is used to determine factors. Factors were calculated by entire island from 1983-2002, and by coast from 2003 - most recent. Prior to 2002 the factors were calculated based on the total number of trips (reported trips/surveyed trips). Method subject to change.

General Data Type: NUMBER

ADJUSTED_POUNDS

CC ID: 565140
Seq. Order: 28
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

The reported pounds adjusted by the correction factor

General Data Type: NUMBER

DISTANCE_DESCRIBE

CC ID: 565141
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

The descriptions of the distance codes

General Data Type: VARCHAR2

ERDMAN_GEAR_NAME

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

The name of the Puerto Rico gear code

General Data Type: VARCHAR2

ERDMAN_COMMON_NAME

CC ID: 565143
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

The Puerto Rico common name for the species landed

General Data Type: VARCHAR2

SPECIES_ITIS

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

The ITIS species code for the species landed

General Data Type: VARCHAR2

ITIS_COMMON_NAME

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

The ITIS common name for the species landed

General Data Type: VARCHAR2

ITIS_SCIENTIFIC_NAME

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

The ITIS scientific name for the species landed

General Data Type: VARCHAR2

FMU

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

The Fishery Management Unit (if any) for the species landed

General Data Type: VARCHAR2

FAMILY

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

The common name for the family of the species landed.

General Data Type: VARCHAR2

ACL_UNIT

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

The Allowable Catch Limit Unit (if any) for the species landed

General Data Type: VARCHAR2

AREA_FISHED1

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

THe Puerto Rico area fished. Has 4 entry fields. Listed in order of entry. Since 2012 coding has mostly been by 2.5 x 2.5 minute grid squares according to map of Puerto Rico waters.

General Data Type: VARCHAR2

AREA_FISHED2

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

The 2nd Puerto Rico fishing area entered on form.

General Data Type: VARCHAR2

AREA_FISHED3

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

The 3rd Puerto Rico fishing area entered on form.

General Data Type: VARCHAR2

AREA_FISHED4

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

The 4th Puerto Rico fishing area entered on form.

General Data Type: VARCHAR2

RECORD_ID_NUM

CC ID: 565154
Seq. Order: 42
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

The record id number used for matching to the ALS.als_pr_land_1983_2011 table.

General Data Type: NUMBER

TRIP_MAY_BE_DUPLICATE

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

Potential duplicate trips are flagged with a 'Y'

General Data Type: VARCHAR2

DATE_OF_EXTRACT

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

Date of last extract of these data from the CCL.

General Data Type: DATE

Catalog Details

Catalog Item ID: 45814
GUID: gov.noaa.nmfs.inport:45814
Metadata Record Created By: Joshua Bennett
Metadata Record Created: 2017-04-21 14:49+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