Metadata Rubric

100%

6 / 6

SEFSC Metadata Library > Fisheries Statistics Division > FISHERIES MONITORING > Commercial Catch and Effort > Commercial Landings Project > Commercial Fisheries Landings for U.S. Caribbea... > Puerto Rico Commercial Landings Statistics 1983... >

Table: ALS_LANDINGS_PUERTO_RICO_ED

Entity (ENT) | Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:45814 | Updated: August 9, 2022 | Published / External

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

	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.

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