45814 ALS_LANDINGS_PUERTO_RICO_ED Entity Published / External 1919 Puerto Rico Commercial Landings Statistics 1983 and more recent in Accumulated Landings System (ALS) Compatible Format Data Set Completed Data Table Yes ALS 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. 1 MONTH_LANDED VARCHAR2 2 No No Active The month the catch was landed VARCHAR2 2 YEAR_LANDED VARCHAR2 4 No No Active The calendar year the catch was landed. VARCHAR2 3 FISHING_CENTER_ED VARCHAR2 3 No No Active 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. VARCHAR2 4 WATER_BODY VARCHAR2 4 No No Active 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. VARCHAR2 5 NMFS_GEAR_ED VARCHAR2 3 No No Active The NMFS code for the gear used. VARCHAR2 6 NMFS_SPECIES_ED VARCHAR2 4 No No Active The NMFS code for the species caught VARCHAR2 7 POUNDS_LANDED NUMBER 22 No No Active The reported pounds landed. (no correction factor used). NUMBER 8 VALUE_IN_DOLLARS NUMBER 22 No No Active The value of the reported landings. NO correction factor used. NUMBER 9 PRICE_PER_LB NUMBER 22 No No Active The price in dollars/pound. Some of these are calculated based on other identical or similar catch. NUMBER 10 DISTANCE VARCHAR2 1 No No Active The perpendicular distance from shore. Caveat: Some fishers interpret this as the distance traveled from port. VARCHAR2 11 LANDING_DATE DATE 7 No No Active The date the catch was landed. DATE 12 PR_ID_CODE_ED VARCHAR2 6 No No Active The edited fisher license number. VARCHAR2 13 PR_GEAR_ED VARCHAR2 3 No No Active The edited Puerto Rico gear code. VARCHAR2 14 NUMBER_OF_TRIPS_ED NUMBER 22 No No Active The edited number of trips (older data had multiple trips on forms). NUMBER 15 PR_SPECIES_ED VARCHAR2 3 No No Active The edited puerto rico species code VARCHAR2 16 GEAR_QTY_ED NUMBER 22 No No Active The edited gear quantity NUMBER 17 GEAR_HOURS_ED NUMBER 22 No No Active Edited gear hours (hours vessel spent actively fishing. NUMBER 18 DAY_LANDED VARCHAR2 2 No No Active Day the catch was landed VARCHAR2 19 MINIMUM_DEPTH_ED NUMBER 22 No No Active Minimum depth fished in feet or fathoms NUMBER 20 MAXIMUM_DEPTH_ED NUMBER 22 No No Active Maximum depth fished in fathoms or feet NUMBER 21 TRIP_TICKET_NUMBER_ED VARCHAR2 11 No No Active A processing number assigned by the agency when the log report form is received. VARCHAR2 22 FISHER_FIRST_NAME VARCHAR2 30 No No Active The fisher first name VARCHAR2 23 FISHER_LAST_NAME VARCHAR2 40 No No Active The fisher last name. VARCHAR2 24 FISHING_CENTER_NAME VARCHAR2 25 No No Active The name of the edited fishing center VARCHAR2 25 LANDING_LOCATION_COUNTY VARCHAR2 29 No No Active The municipality of the edited fishing center VARCHAR2 26 COAST VARCHAR2 20 No No Active The coast wherein the fishing center exists. Coast was used to determine correction factor for landings from 2003 to recent. VARCHAR2 27 CORRECTION_FACTOR NUMBER 22 No No Active 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. NUMBER 28 ADJUSTED_POUNDS NUMBER 22 No No Active The reported pounds adjusted by the correction factor NUMBER 29 DISTANCE_DESCRIBE VARCHAR2 50 No No Active The descriptions of the distance codes VARCHAR2 30 ERDMAN_GEAR_NAME VARCHAR2 50 No No Active The name of the Puerto Rico gear code VARCHAR2 31 ERDMAN_COMMON_NAME VARCHAR2 22 No No Active The Puerto Rico common name for the species landed VARCHAR2 32 SPECIES_ITIS VARCHAR2 6 No No Active The ITIS species code for the species landed VARCHAR2 33 ITIS_COMMON_NAME VARCHAR2 28 No No Active The ITIS common name for the species landed VARCHAR2 34 ITIS_SCIENTIFIC_NAME VARCHAR2 28 No No Active The ITIS scientific name for the species landed VARCHAR2 35 FMU VARCHAR2 14 No No Active The Fishery Management Unit (if any) for the species landed VARCHAR2 36 FAMILY VARCHAR2 20 No No Active The common name for the family of the species landed. VARCHAR2 37 ACL_UNIT VARCHAR2 28 No No Active The Allowable Catch Limit Unit (if any) for the species landed VARCHAR2 38 AREA_FISHED1 VARCHAR2 4 No No Active 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. VARCHAR2 39 AREA_FISHED2 VARCHAR2 4 No No Active The 2nd Puerto Rico fishing area entered on form. VARCHAR2 40 AREA_FISHED3 VARCHAR2 4 No No Active The 3rd Puerto Rico fishing area entered on form. VARCHAR2 41 AREA_FISHED4 VARCHAR2 4 No No Active The 4th Puerto Rico fishing area entered on form. VARCHAR2 42 RECORD_ID_NUM NUMBER 22 No No Active The record id number used for matching to the ALS.als_pr_land_1983_2011 table. NUMBER 43 TRIP_MAY_BE_DUPLICATE VARCHAR2 1 No No Active Potential duplicate trips are flagged with a 'Y' VARCHAR2 44 DATE_OF_EXTRACT DATE 7 No No Active Date of last extract of these data from the CCL. DATE gov.noaa.nmfs.inport:45814 Joshua Bennett 2017-04-21T14:49:14 SysAdmin InPortAdmin 2022-08-09T17:11:20 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