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. |
Attribute Details
MONTH_LANDED
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |