1919 Puerto Rico Commercial Landings 1983 and more recent Data Set Published / External 20884 Commercial Fisheries Landings for U.S. Caribbean Project In Work This data set contains multi-trip and single trip level quantities and value for all seafood products that are landed and sold by established seafood dealers and brokers as well as by the fishers themselves at fishing centers in the Commonwealth of Puerto Rico. These landings statistics include all commercially landed marine species and are identified by species (usually the local or common name). These data are collected by field samplers employed by the Department of Natural Resources through a trip ticket program. The program also collects data on the number of trips, type and amount of gear, the fishing location, hours fished, and the fishing center where the catches are landed. Data for the individual trip reports are provided to the Southeast Fisheries Science Center (SEFSC). These data are formatted to be consistent with other landings statistics stored in the Accumulative Landings System; however, they are not summarized trips unless originally reported that way. By and large these are trip level data. The Puerto Rico codes are converted to the standard National Marine Fisheries Service (NMFS) codes. Not all fishers comply with reporting requirements. The amount varies from year to year. For this reason these data are subject to correction by dockside survey data obtained by the PR DPNR several times a year at various coastal locations. The surveys originally determined the number of trips at the location but since 2003 they have collected the total pounds landed. These data are applied to the reported data to obtain a ratio of reported/survey data which is then divided into the reported data to correct for under-reporting on a coastal basis. One of the original purposes for these data was to provide estimates of the quantities and value of the marine commercial fishing industries sector in the gross national product for the Commonwealth of Puerto Rico. This time series, which began in 1983, corrected by the coastal dockside survey factors provides the best data on total landings for the commercial fisheries in the Commonwealth. Puerto Rico Landings data entered and submitted in raw format. Editing was done to landings data at SEFSC which is reflected in the table ALS. als_landings_puerto_rico_ed. Original unedited data submissions can be found in the ALS.als_landings_puerto_rico table. This covers the years 1983-2011 where the PC batch out program was in effect prior to the establishment of the online data entry system (CCL). Edits can be determined by joining the unedited als.als_land_pr_1983_2011 to the als.als_land_pr_1983_2011 errata table on record id and comparing the values. The edited table contains primarily edits to gear fished but also to permit information by fisher where it could be resolved. The edited table is built from an errata table containing the edits combined with the als.als_land_pr_1983_2011 table. Also added to the records from 1983-2011 are the records from the on-line data entry system from 2012 and more recent. These are reported landings and have not been altered to include estimates of unreported landings. These are fishery dependent data reported by industry. Better representation of actual landings depends upon application of the coastal survey factors (see abstract). Several trip ticket changes have occurred over time which affect the species data entered on the forms. The forms are pre-printed with multiple species and species groups under which catch is recorded. If a species group is not there the catch may not be included. Also if the species is known by the fisher, but only the group is on the form, the species definition may be lost as the catch is recorded under that group. Data are in flat-file format. Care should be taken when summarizing data. Data elements in the form headers should be grouped, not summarized by trip. Theme Commercial Landings Theme Fisheries Theme fishdep Theme fishery-dependent Theme fishing Theme trip ticket Temporal 1983-present Spatial Carribbean Spatial Puerto Rico Stratum fish species Stratum fishing gear Stratum fishing location Southeast Fisheries Science Center Miami FL USA 75 Virginia Beach Drive Miami, FL 33149 Data Set Database Continually Table (digital) Entities described in 'Children' of item. Caribbean Commercial Landings web-based data entry application with format modification by SEFSC to comply with historical ALS format. Oracle Various Gears used by fishers in the US Caribbean 5444 ALS_LANDINGS_PUERTO_RICO Published / External Completed Master Table For Landings From Puerto Rico. Though this table does have some effort data in it as well. Price data are also available in this table. Loaded by batch 1725, 10-16-2007 05:43 These are the original data sent by PR DNER. Another table: ALS.ALS_LANDINGS_PUERTO_RICO_ED, contains proposed edits to the data made at SEFSC. Data Table Yes ALS Master Table For Landings From Puerto Rico. Though this table does have some effort data in it as well 1 MONTH_LANDED VARCHAR2 2 No No Active Two Character Month Landed VARCHAR2 2 YEAR_LANDED VARCHAR2 4 No No Active 4 character Year Landed VARCHAR2 3 STATE_LANDED VARCHAR2 2 No No Active State Code Landed. This is always loaded with the NMFS State Code For Puerto Rico ('55'). VARCHAR2 4 FISHING_CENTER VARCHAR2 3 No No Active Fishing Center Code. Generally, these are ordered by the geography of Puerto Rico from North > East > South > West around the island. VARCHAR2 5 DEALER VARCHAR2 9 No No Active Dealer Code. Added For compatibility with other ALS Tables. This is column is always filled with all 9s as the Dealer is unknown. VARCHAR2 6 WATER_BODY VARCHAR2 4 No No Active Water Body Code. This table only shows the water_body as '1866' for Puerto Rico waters. More detail can be found in the table jbennett.als_landings_puerto_rico_ed in the 'area fished' columns. VARCHAR2 7 GEAR VARCHAR2 3 No No Active NMFS Gear Code (If One exists. It is generated between a cross table Of Erdman Gear Codes to NMFS Gear Code) VARCHAR2 8 SPECIES VARCHAR2 4 No No Active NMFS Species Code (If One exists. It is generated between a cross table Of Erdman Species Codes to NMFS Species Codes) VARCHAR2 9 SHELL_OR_FINFISH VARCHAR2 1 No No Active Finfish or shell fish code. VARCHAR2 10 POUNDS NUMBER 22 No No 9 0 Active Pounds Caught. (Whole weight). These are the pounds reported by the fishers. Adjustment (Correction) factors are supplied annually by Puerto Rico to account for those licensed Permit holders who did not report. These adjusted pounds are reported in the als_landings_puerto_rico_ed. NUMBER 11 VALUE NUMBER 22 No No 9 0 Active Value in dollars. This is the value of the reported landings (without adjusting for non-compliance. NUMBER 12 SECTION VARCHAR2 1 No No Active Section Code, Added for compatibility with ALS.ALS_LANDINGS VARCHAR2 13 PRICE NUMBER 22 No No 7 3 Active Price payed for fish. (In dollars). These prices are collected from the fishers on the logbook reporting forms. NUMBER 14 DISTANCE VARCHAR2 1 No No Active Distance From Shore Code. Added for compatibility with ALS.ALS_LANDINGS. VARCHAR2 15 STATE_CAUGHT VARCHAR2 2 No No Active State Caught. Added For compatibility WIth ALS.ALS_LANDINGS VARCHAR2 16 LANDING_DATE DATE 7 No No Active Actual Date animal was landed. DATE 17 PR_ID_CODE VARCHAR2 6 No No Active Identification Code assigned to Fisher by Puerto Rico DNER. Sometimes the code is manufactured by the port agent and does not reflect the actual permit number. This is usually for permit holders who have recently been added to the licensing but for whom the agent did not yet have a code. The data manager has resolved these where possible. VARCHAR2 18 PR_GEAR VARCHAR2 3 No No Active Erdman Gear Code. Erdman was the last name of the marine biologist responsible for cataloging the various species in the PR area. This particular list has been limited in scope. In 2012 the CCL gear list became available with more detail. VARCHAR2 19 NUMBER_OF_TRIPS NUMBER 22 No No 2 0 Active Number Of Trips. Prior to 2012, the forms could be used to report multiple trips, although fishers generally reported single trips. After 2012 only single trips could be reported. NUMBER 20 PR_SPECIES VARCHAR2 3 No No Active Erdman Species Code VARCHAR2 21 GEAR_QTY NUMBER 22 No No 4 0 Active Number or size Of Gear. The combined field descriptors (quantity and size) has led to some confusion within this column (number of nets vs mesh size for instance). NUMBER 22 GEAR_HOURS NUMBER 22 No No 3 0 Active Soak Time for gear in hours. Traps are considered to have a soak time of 168 hours for a week of soaking without being hauled. This is not the same as the time the vessel is on the fishing grounds. NUMBER 23 DAY_LANDED VARCHAR2 2 No No Active Day landed. Derived from landing date VARCHAR2 24 USERID VARCHAR2 30 No No Active Oracle Id Of The Person Loading The Data VARCHAR2 25 SOURCE_FILE VARCHAR2 20 No No Active Source File used to load data. VARCHAR2 26 MINIMUM_DEPTH NUMBER 22 No No 4 0 Active Minimum Depth Fished during the trip. This is intended to be recorded in fathoms (6 feet = 1 fathom). NUMBER 27 MAXIMUM_DEPTH NUMBER 22 No No 4 0 Active Maximum Depth Fished during the trip (recorded in fathoms). NUMBER 28 TRIP_TICKET_NUMBER VARCHAR2 11 No No Active Trip Ticket Number. This number is assigned by Puerto Rico Fisheries Statistics group upon receiving the submitted forms on a form to form basis. VARCHAR2 5445 ALS_LAND_PUERTO_RICO_BAD Published / External Completed To Hold Puerto Rico Landings data that did not pass validation. Loaded by batch 1725, 10-16-2007 05:43 Data Table Yes ALS To Hold Puerto Rico Landings data that did not pass validation. 1 MONTH_LANDED VARCHAR2 2 No No Active wo Character Month Landed VARCHAR2 2 YEAR_LANDED VARCHAR2 4 No No Active 4 character Year Landed VARCHAR2 3 STATE_LANDED VARCHAR2 2 No No Active State Code Landed. This is laways loaded with the NMFS STate Code For Puerto Rico. VARCHAR2 4 FISHING_CENTER VARCHAR2 3 No No Active Fishing Center Code. VARCHAR2 5 DEALER VARCHAR2 9 No No Active Dealer Code. Added For compatibility with other ALS Tables. This is column is always filled with all 9s as the Dealer is unknown. VARCHAR2 6 WATER_BODY VARCHAR2 4 No No Active Water Body Code VARCHAR2 7 GEAR VARCHAR2 3 No No Active NMFS Gear Code (If One exists. It is generated between a cross table Of Erdman Gear Codes to NMFS Gear Code) VARCHAR2 8 SPECIES VARCHAR2 4 No No Active NMFS Species Code (If One exists. It is generated between a cross table Of Erdman Speciesr Codes to NMFS Species Codes) VARCHAR2 9 SHELL_OR_FINFISH VARCHAR2 1 No No Active Finfish or shell fish code. VARCHAR2 10 POUNDS NUMBER 22 No No 9 0 Active Pounds Caught. (Whole weight) NUMBER 11 VALUE NUMBER 22 No No 9 0 Active Value in dollars NUMBER 12 SECTION VARCHAR2 1 No No Active Section Code, Added for compatibility with ALS.ALS_LANDINGS VARCHAR2 13 PRICE NUMBER 22 No No 7 3 Active Price payed for fish. (In dollars) NUMBER 14 DISTANCE VARCHAR2 1 No No Active Distance From Shore Code. Added for compatibility with ALS.ALS_LANDINGS. VARCHAR2 15 STATE_CAUGHT VARCHAR2 2 No No Active State Caught. Added For compatibility WIth ALS.ALS_LANDINGS VARCHAR2 16 LANDING_DATE DATE 7 No No Active Actual Date animal was landed. DATE 17 PR_ID_CODE VARCHAR2 6 No No Active Identification Code asigned to Record by Puerto Rico data manager VARCHAR2 18 PR_GEAR VARCHAR2 3 No No Active Erdman Gear Code VARCHAR2 19 NUMBER_OF_TRIPS NUMBER 22 No No 2 0 Active Number Of Trips NUMBER 20 PR_SPECIES VARCHAR2 3 No No Active Erdman Species Code VARCHAR2 21 GEAR_QTY NUMBER 22 No No 4 0 Active Number Of Gear NUMBER 22 GEAR_HOURS NUMBER 22 No No 3 0 Active Soak Time NUMBER 23 DAY_LANDED VARCHAR2 2 No No Active Day landed. Derived from landing date VARCHAR2 24 RNUMBER NUMBER 22 No No 6 0 Active Record Number NUMBER 25 FILE_NAME VARCHAR2 30 No No Active Sorce File used to load records VARCHAR2 26 USERID VARCHAR2 30 No No Active Oracle Id Of The Person Loading The Data VARCHAR2 27 MINIMUM_DEPTH NUMBER 22 No No 4 0 Active Minimum Depth Fished NUMBER 28 MAXIMUM_DEPTH NUMBER 22 No No 4 0 Active Maximum Depth Fished NUMBER 29 TRIP_TICKET_NUMBER VARCHAR2 11 No No Active Trip Ticket Number VARCHAR2 5446 ALS_TEMP_LAND_PUERTO_RICO Published / External Completed Pre-validation table for processing the load of Puerto RIco landings data. Loaded by batch 1725, 10-16-2007 05:43 Data Table Yes ALS Pre-validation table for processing the load of Puerto RIco landings data. 1 MONTH_LANDED VARCHAR2 2 No No Active Two Character Month Landed VARCHAR2 2 YEAR_LANDED VARCHAR2 4 No No Active 4 character Year Landed VARCHAR2 3 STATE_LANDED VARCHAR2 2 No No Active State Code Landed. This is laways loaded with the NMFS STate Code For Puerto Rico. VARCHAR2 4 FISHING_CENTER VARCHAR2 3 No No Active Fishing Center Code. VARCHAR2 5 DEALER VARCHAR2 9 No No Active Dealer Code. Added For compatibility with other ALS Tables. This is column is always filled with all 9s as the Dealer is unknown. VARCHAR2 6 WATER_BODY VARCHAR2 4 No No Active Water Body Code VARCHAR2 7 GEAR VARCHAR2 3 No No Active NMFS Gear Code (If One exists. It is generated between a cross table Of Erdman Gear Codes to NMFS Gear Code) VARCHAR2 8 SPECIES VARCHAR2 4 No No Active NMFS Species Code (If One exists. It is generated between a cross table Of Erdman Species Codes to NMFS Species Codes) VARCHAR2 9 SHELL_OR_FINFISH VARCHAR2 1 No No Active Finfish or shell fish code. VARCHAR2 10 POUNDS NUMBER 22 No No 9 0 Active Pounds Caught. (Whole weight) NUMBER 11 VALUE NUMBER 22 No No 9 0 Active Value in dollars NUMBER 12 SECTION VARCHAR2 1 No No Active Section Code, Added for compatibility with ALS.ALS_LANDINGS VARCHAR2 13 PRICE NUMBER 22 No No 7 3 Active Price payed for fish. (In dollars) NUMBER 14 DISTANCE VARCHAR2 1 No No Active Distance From Shore Code. Added for compatibility with ALS.ALS_LANDINGS. VARCHAR2 15 STATE_CAUGHT VARCHAR2 2 No No Active State Caught. Added For compatibility WIth ALS.ALS_LANDINGS VARCHAR2 16 LANDING_DATE DATE 7 No No Active Actual Date animal was landed. DATE 17 PR_ID_CODE VARCHAR2 6 No No Active Identification Code asigned to Record by Puerto Rico data manager VARCHAR2 18 PR_GEAR VARCHAR2 3 No No Active Erdman Gear Code VARCHAR2 19 NUMBER_OF_TRIPS NUMBER 22 No No 2 0 Active Number Of Trips NUMBER 20 PR_SPECIES VARCHAR2 3 No No Active Erdman Species Code VARCHAR2 21 GEAR_QTY NUMBER 22 No No 4 0 Active Number Of Gear NUMBER 22 GEAR_HOURS NUMBER 22 No No 3 0 Active Soak Time NUMBER 23 DAY_LANDED VARCHAR2 2 No No Active Day landed. Derived from landing date VARCHAR2 24 RNUMBER NUMBER 22 No No 6 0 Active Record Number of Record In Question In file loaded NUMBER 25 USERID VARCHAR2 30 No No Active Oracle Id Of The Person Loading The Data VARCHAR2 26 SOURCE_FILE VARCHAR2 20 No No Active Source File used to load data. VARCHAR2 27 MINIMUM_DEPTH NUMBER 22 No No 4 0 Active Minimum Depth Fished NUMBER 28 MAXIMUM_DEPTH NUMBER 22 No No 4 0 Active Maximum Depth Fished NUMBER 29 TRIP_TICKET_NUMBER VARCHAR2 11 No No Active Trip Ticket Number VARCHAR2 6421 FISHING_CENTER_CODE_PR Published / External Completed Lookup table Of Valid Fishing Center Codes and fishing center names for the island of Puerto Rico. Loaded by batch 1924, 11-09-2007 10:56 Fishing centers have been added through the course of time. Many were added with the onset of the new Caribbean Commercial Landings reporting system in 2012 which is based on the USGS place location coding. Codes are translated from that system into ALS coding. Data Table Yes SEFSC Table Of Valid Fishing Center Codes 1 FISHING_CENTER_CODE VARCHAR2 3 Yes Yes Active Fishing Center Code VARCHAR2 2 DESCRIPTION VARCHAR2 25 Yes No Active Fishing Center Name VARCHAR2 6424 PORT_CODE_PR Published / External Completed This table is obsolete. It has been replaced by ALS.fishing center_pr. Loaded by batch 1924, 11-09-2007 10:56 Data Table Yes SEFSC Table of Valid Puerto Rico Port Codes 1 PORT_CODE VARCHAR2 3 No No Active Port Code VARCHAR2 2 NAME VARCHAR2 25 No No Active Port Name VARCHAR2 6427 PR_MUNI Published / External Completed Table Of Valid Puerto Rico Municipality Code Loaded by batch 1924, 11-09-2007 10:56 Data Table Yes SEFSC Table Of Valid Puerto Rico Municipality Code 1 CODE VARCHAR2 2 Yes Yes Active Municipality Code VARCHAR2 2 NAME VARCHAR2 14 No No Active Municipality Name VARCHAR2 6430 SPECIES_CODE_NMFS_XERDMAN Published / External Completed Cross Table Between NMFS, ERDMAN, and NODC Species Code. This was put together by IRM staff in the mid 1990s. Actually it is a cross reference going from erdman code (pr_species) to NMFS_CODE and to NODC code. This table is now obsolete as it was replaced by the more comprehensive als.PR_SPECIES_ERDMAN_ITIS_XREF table. Loaded by batch 1924, 11-09-2007 10:56 Data Table Yes SEFSC Cross Table Between NMFS, ERDMAN, and NODC Species Code. This was put together by IRM staff in the mid 1990s 1 SCIENTIFIC_NAME VARCHAR2 24 No No Active Scientific Name VARCHAR2 2 COMMON_NAME VARCHAR2 21 No No Active Common Name VARCHAR2 3 ERDMAN_CODE VARCHAR2 3 No No Active Erdman Species Code VARCHAR2 4 NMFS_CODE VARCHAR2 4 No No Active NMFS Species Code VARCHAR2 5 NODC_CODE VARCHAR2 10 No No Active NODC Species Code VARCHAR2 29945 ALS_LAND_PR_1983_2011 Published / External Completed The unedited Puerto Rico ALS table from 1983-2011 with primary key (record_number_id) added to link with edited errata table ALS.als_land_pr_1983-2011_errata. This is a copy of ALS.ALS_LANDINGS_PUERTO_RICO for the years 1983-2011. This copy was assigned a record id number for each record linking it to the errata file als.als_land_pr_1983_2011_errata for the corresponding record. Loaded by batch 7906, 12-22-2015 14:11 Data Table Yes ALS The unedited Puerto Rico ALS table from 1983-2011 with primary key (record_number_id) added to link with edited errata table ALS.als_land_pr_1983-2011_errata. 1 MONTH_LANDED VARCHAR2 2 No No Active Month of landing VARCHAR2 2 YEAR_LANDED VARCHAR2 4 No No Active 4 character Year Landed VARCHAR2 3 STATE_LANDED VARCHAR2 2 No No Active State Code Landed. Currently is defaulted to 55. VARCHAR2 4 FISHING_CENTER VARCHAR2 3 No No Active Areas of fishing activity in Puerto Rico, the 1st 2 characters represent the NMFS code for the municipality the fishing center occurs in. VARCHAR2 5 DEALER VARCHAR2 14 No No Active Dealer information not present here. Code is currently filled with 9s. VARCHAR2 6 WATER_BODY VARCHAR2 4 No No Active Column normally contains area of catch. Defaulted to 9s. VARCHAR2 7 GEAR VARCHAR2 3 No No Active The NMFS gear code as determined by the submitted Puerto Rico (Erdman) gear code. Multiple gears may occur within a trip. VARCHAR2 8 SPECIES VARCHAR2 4 No No Active The NMFS Species Code as best determined by the submitted Puerto Rico (Erdman) species code. Some NMFS species codes are more general where the Erdman codes are specific. VARCHAR2 9 SHELL_OR_FINFISH VARCHAR2 1 No No Active 1 is finfish and 2 is shellfish. For general extractions. VARCHAR2 10 POUNDS NUMBER 22 No No 38 0 Active The landed pounds. Currently the landed conditions vary according to fishery. Trap and net fish are whole weight, fish caught with hooks or speared are typically gutted. Sharks are typically dressed weight. For Conchs, (prior to 2003, all landings presumably are reported as uncleaned (including head and viscera). In 2003 aproximately 50% of meats were cleaned and by 2004 all conch was reported in cleaned condition - SEDAR 14). No adjustments have been made for any landed condtions in these data. NUMBER 11 VALUE NUMBER 22 No No 9 0 Active Value in dollars. Dollars are rounded to integers in data. NUMBER 12 SECTION VARCHAR2 1 No No Active Section Code, Added for compatibility with ALS.ALS_LANDINGS VARCHAR2 13 PRICE NUMBER 22 No No 38 3 Active Price payed for fish. (In dollars) Used with landings to calculate value. NUMBER 14 DISTANCE VARCHAR2 1 No No Active Distance From Shore Code. EEZ begins at 9 miles out to sea in Puerto Rico. Data in this column are incomplete. 9s used as placeholders. VARCHAR2 15 STATE_CAUGHT VARCHAR2 2 No No Active State Caught. No meaning to this column here. Added For compatibility WIth ALS.ALS_LANDINGS VARCHAR2 16 LANDING_DATE DATE 7 No No Active The date the vessel arrived back at dock with landings. DATE 17 PR_ID_CODE VARCHAR2 6 No No Active Code assigned to individual or other entity when permit is issued. Coding is inconsistent. 1st 3 characters appear to represent fishing center of permit holder for earlier years until 1998. VARCHAR2 18 PR_GEAR VARCHAR2 3 No No Active The Puerto Rico gear code (Developed by Donald S. Erdman). VARCHAR2 19 NUMBER_OF_TRIPS NUMBER 22 No No 38 0 Active Number Of Trips NUMBER 20 PR_SPECIES VARCHAR2 3 No No Active The Puerto Rico species code (Developed by Donald S. Erdman). VARCHAR2 21 GEAR_QTY NUMBER 22 No No 38 0 Active Represents the maximum number of gear in use at any one time during the trip. NUMBER 22 GEAR_HOURS NUMBER 22 No No 3 0 Active Soak Time - Amount of time the gear is in the water. Likely to exceed trip duration in the case of traps. NUMBER 23 DAY_LANDED VARCHAR2 2 No No Active Day landed. Derived from landing date VARCHAR2 24 USERID VARCHAR2 30 No No Active Oracle Id Of The Person Loading The Data VARCHAR2 25 SOURCE_FILE VARCHAR2 20 No No Active Source File used to load data. VARCHAR2 26 MINIMUM_DEPTH NUMBER 22 No No 38 0 Active Minimum Depth Fished in fathoms - data are incomplete. NUMBER 27 MAXIMUM_DEPTH NUMBER 22 No No 4 0 Active Maximum Depth Fished in fathoms. Data are incomplete. NUMBER 28 TRIP_TICKET_NUMBER VARCHAR2 11 No No Active Trip Ticket Number. Currently assigned after PRDNR receives trip ticket from fisher (not preprinted). VARCHAR2 29 RECORD_NUMBER_ID NUMBER 22 No No 38 Active Primary Key to the table. Foreign Key to als.als_land_pr_1983_2011_errata NUMBER 29946 ALS_LAND_PR_1983_2011_ERRATA Published / External 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 29947 ALS_PR_CORRECTION_FACTORS Published / External Completed This table contains the correction factors used to adjust the Puerto Rico commercial landings rerported landings for non-reporting or under-reporting. Data taken several times a year at various coastal landing locations, by fisher until 2003 but afterwards by pounds landed copmared to reported landings are used to make correction. Loaded by batch 7906, 12-22-2015 14:11 Data Table Yes ALS This table contains the correction factors used to adjust the Puerto Rico commercial landings rerported landings for non-reporting or under-reporting. Data taken several times a year at various coastal landing locations, by fisher until 2003 but afterwards by pounds landed copmared to reported landings are used to make correction. 1 YEARLAND VARCHAR2 4 No No Active The year in which the landings took place. VARCHAR2 2 COAST VARCHAR2 10 No No Active The coast (east, south, west, north) containing the fishing center in which the landings (and surveys) took place. VARCHAR2 3 CORRECTION_FACTOR NUMBER 22 No No Active The factor used to adjust the reported landings by year and coast. Obtained by number of pounds reported/number of pounds surveyed. NUMBER 29948 ALS_PR_FISHING_CTR_MUNI_COAST Published / External Completed Table is a lookup for fishing center codes used in the ALS_landings_puerto_rico table. Provides fishing center name, as well as coast and municipality in which center is located. Loaded by batch 7906, 12-22-2015 14:11 Data Table Yes ALS Table is a lookup for fishing center codes used in the ALS_landings_puerto_rico table. Provides fishing center name, as well as coast and municipality in which center is located. 1 FISHING_CENTER VARCHAR2 3 No No Active The code for the fishing center. VARCHAR2 2 FISHING_CENTER_NAME VARCHAR2 25 No No Active The name of the Puerto Rico fishing center represented by the code. VARCHAR2 3 LANDING_LOCATION_COUNTY VARCHAR2 29 No No Active The municipality in which the fishing center is located. VARCHAR2 4 COAST VARCHAR2 20 No No Active The coast in which the fishing center is located. VARCHAR2 29949 ALS_PR_SPECIES_GEAR_VALIDATE Published / External Completed Loaded by batch 7906, 12-22-2015 14:11 Data Table Yes ALS 1 PR_GEAR VARCHAR2 3 No No Active VARCHAR2 2 GEAR_NAME VARCHAR2 15 No No Active VARCHAR2 3 PR_SPECIES VARCHAR2 3 No No Active VARCHAR2 4 ITIS_COMMON_NAME VARCHAR2 28 No No Active VARCHAR2 5 SPECIES_ITIS VARCHAR2 6 No No Active VARCHAR2 6 POUNDS VARCHAR2 7 No No Active VARCHAR2 7 RECORDS VARCHAR2 6 No No Active VARCHAR2 8 INVALID_GEAR VARCHAR2 1 No No Active VARCHAR2 9 INVALID_SPECIES VARCHAR2 1 No No Active VARCHAR2 10 INVALID_GEAR_SPEC_COMBINATION VARCHAR2 1 No No Active VARCHAR2 29950 ALS_PUERTO_RICO_FISHERS_LOOKUP Published / External Completed The lookup table for FISHER NAMES for data from ALS.ALS_LANDINGS_PUERTO_RICO. Lookup is based on primary key of first six columns of tables. Table is updated bi-weekly for fisher data. Loaded by batch 7906, 12-22-2015 14:11 Data Table Yes ALS The lookup table for FISHER NAMES for data from ALS.ALS_LANDINGS_PUERTO_RICO. Lookup is based on primary key of first six columns of tables. Table is updated bi-weekly for fisher data. 1 YEAR_LANDED VARCHAR2 4 No No Active The year the catch was landed. VARCHAR2 2 MONTH_LANDED VARCHAR2 2 No No Active The month the catch was landed. VARCHAR2 3 DAY_LANDED VARCHAR2 2 No No Active The calendar day the catch was landed. VARCHAR2 4 FISHING_CENTER VARCHAR2 3 No No Active The code for the fishing center wherein the catch was landed. VARCHAR2 5 PR_ID_CODE VARCHAR2 6 No No Active The permit code for the primary fisher landing the catch. VARCHAR2 6 TRIP_TICKET_NUMBER VARCHAR2 11 No No Active The trip ticket number assigned to the trip. VARCHAR2 7 MUNICIPALITY_NAME VARCHAR2 50 No No Active The name of the municipality containing the fishing center in which the landings occurred. VARCHAR2 8 FISHER_FIRST_NAME VARCHAR2 50 No No Active The fishers first name. VARCHAR2 9 FISHER_LAST_NAME VARCHAR2 50 No No Active The fisher last name. VARCHAR2 29951 AREA_CODE_LOOKUP_25X25_PR Published / External Completed Loaded by batch 7906, 12-22-2015 14:11 Data Table Yes ALS 1 ID NUMBER 22 No No 8 2 Active The numeric area id for the 2.5x2.5 minute grids as coded in the trip interview program area codes. Primary Key. NUMBER 2 AREA_CODE VARCHAR2 4 No No Active The alpha-numeric codes for the 2.5x2.5 minute grid areas in the Puerto Rico Fishing area map. Foreign key to Puerto Rico Landings area_codes 1-4. VARCHAR2 3 STATUS VARCHAR2 40 No No Active The type of fishing area contained in the grid: inland, marine reserve, natural resouce, near-shore, offshore, special fishing zone, or not recorded. VARCHAR2 4 AREA_NAME VARCHAR2 30 No No Active The name of the fishing area(s). If the grid is within a fishing area named in the regulations, that area name is supplied here. VARCHAR2 5 JURISDICTION VARCHAR2 15 No No Active What jurisdiction does the area fall within? VARCHAR2 6 LATITUDE_DEGREES NUMBER 22 No No 2 0 Active The latitude in degrees for the southeast corner of the area grid. NUMBER 7 LATITUDE_MINUTES NUMBER 22 No No 2 0 Active The latitude in minutes for the southeast corner of the area grid. NUMBER 8 LATITUDE_SECONDS NUMBER 22 No No 2 0 Active The latitude in seconds for the southeast corner of the grid. NUMBER 9 LONGITUDE_DEGREES NUMBER 22 No No 2 0 Active The longitude in degrees for the southeast corner of the grid. NUMBER 10 LONGITUDE_MINUTES NUMBER 22 No No 2 0 Active The longitude in minutes at the southeast corner of the area grid. NUMBER 11 LONGITUDE_SECONDS NUMBER 22 No No 2 0 Active The longitude in seconds for the southeast corner of the grid. NUMBER 12 LAT_HEMI VARCHAR2 1 No No Active Always North for purpose of these data VARCHAR2 13 LONG_HEMI VARCHAR2 1 No No Active Always West for the purpose of these data. VARCHAR2 29953 DISTANCE_CODE_ALS Published / External Completed The one digit NMFS code for the perpendicular distance from the fishing grounds to shore. Loaded by batch 7906, 12-22-2015 14:11 Data Table Yes ALS The one digit NMFS code for the perpendicular distance from the fishing grounds to shore. 1 DISTANCE VARCHAR2 1 No No Active The NMFS distance code VARCHAR2 2 DESCRIBE VARCHAR2 50 No No Active The distance description VARCHAR2 29954 GEAR_ERDMAN_NMFS_FIN_XREF Published / External Completed Table is lookup for Puerto Rico gear codes. It also cross-references the PR codes to the NMFS gear codes and the FIN gear codes. The Puerto Rico gear coding is limited and general concerning the gears used in their fisheries. For this reason, this table may soon be updated with more descriptive codes and definitions Loaded by batch 7906, 12-22-2015 14:11 Data Table Yes ALS Table is lookup for Puerto Rico gear codes. It also cross-references the PR codes to the NMFS gear codes and the FIN gear codes. The Puerto Rico gear coding is limited and general concerning the gears used in their fisheries. For this reason, this table may soon be updated with more descriptive codes and definitions 1 ERDMAN_GEAR_CODE VARCHAR2 3 No No Active The Puerto Rico gear code. VARCHAR2 2 ERDMAN_GEAR_NAME VARCHAR2 50 No No Active The Puerto RIco gear name. VARCHAR2 3 NMFS_GEAR_CODE VARCHAR2 3 No No Active The NMFS gear code. VARCHAR2 4 NMFS_GEAR_NAME VARCHAR2 50 No No Active Thee NMFS gear name. VARCHAR2 5 FIN_GEAR_CODE VARCHAR2 3 No No Active The FIN (GSMFC) gear code VARCHAR2 6 FIN_GEAR_NAME VARCHAR2 50 No No Active The FIN gear name VARCHAR2 7 FIN_CATEGORY_CODE VARCHAR2 3 No No Active The FIN gear category code (good for rollup of confidential gears). VARCHAR2 8 FIN_CATEGORY_NAME VARCHAR2 50 No No Active The FIN gear category name VARCHAR2 9 FIN_TYPE_CODE VARCHAR2 3 No No Active The code for FIN gear type (good for rollup of confidential gears). VARCHAR2 10 FIN_TYPE_NAME VARCHAR2 50 No No Active The FIN gear type name. VARCHAR2 11 FIN_DESCRIPTION VARCHAR2 1000 No No Active The FIN gear description VARCHAR2 29956 PR_SPECIES_ERDMAN_ITIS_XREF Published / External Completed This is the primary species or species group lookup table for Puerto Rico commercial landings data. It uses the code developed by Erdman (1987) as its primary key. Table cross-reference ITIS coding at various taxonomic levels as well as NMFS coding and Caribbean ACL Unit. Loaded by batch 7906, 12-22-2015 14:11 Data Table Yes ALS This is the primary species or species group lookup table for Puerto Rico commercial landings data. It uses the code developed by Erdman (1987) as its primary key. Table cross-reference ITIS coding at various taxonomic levels as well as NMFS coding and Caribbean ACL Unit. 1 ERDMAN_CODE VARCHAR2 3 No No Active This is the primary index based on species coding (Erdman 1987). VARCHAR2 2 ERDMAN_COMMON_NAME VARCHAR2 22 No No Active The species or species group common name (Erdman 1987) VARCHAR2 3 ERDMAN_SCIENTIFIC_NAME VARCHAR2 28 No No Active The species or species group scientific name (Erdman 1987). VARCHAR2 4 SPECIES_ITIS VARCHAR2 6 No No Active The International Taxonomic Information System (ITIS) code for the species or species group. This is the standard code. VARCHAR2 5 ITIS_COMMON_NAME VARCHAR2 28 No No Active The ITIS common name for the species or species group. This is the standard common name. VARCHAR2 6 ITIS_SCIENTIFIC_NAME VARCHAR2 28 No No Active The scientific name for species or species group. VARCHAR2 7 GENUS_ITIS VARCHAR2 6 No No Active The standard ITIS code for the genus. Is null if species group classed higher than genus. VARCHAR2 8 GENUS_NAME VARCHAR2 17 No No Active The scientific name for the genus. Is null if initial species group classed higher than genus. VARCHAR2 9 FAMILY_ITIS VARCHAR2 6 No No Active The standard ITIS code for family. Is null if initial species group is classed higher than family VARCHAR2 10 FAMILY_NAME VARCHAR2 18 No No Active The scientific name for the family. Is null if species group initially classed higher than family. VARCHAR2 11 ORDER_ITIS VARCHAR2 6 No No Active The standard ITIS code for order. Is null if species or species group initally classed higher than order. VARCHAR2 12 ORDER_NAME VARCHAR2 18 No No Active The scientific name for the order. Is null if species group initially classed higher than order. VARCHAR2 13 NMFS_CODE VARCHAR2 4 No No Active The National Marine Fisheries (NMFS) code for the species or species group. The NMFS codes are replaced by the ITIS system as the coding standard for NOAA. VARCHAR2 14 NMFS_COMMON_NAME VARCHAR2 33 No No Active The NMFS common name for the species or species group. VARCHAR2 15 FMU VARCHAR2 14 No No Active The Caribbean Fishery Management Unit for the species or species group. VARCHAR2 16 FAMILY VARCHAR2 20 No No Active The common family name for species or species group. VARCHAR2 17 T_LEVEL VARCHAR2 1 No No Active The first initial for the taxonomic level of the species or species group. VARCHAR2 18 ACL_UNIT VARCHAR2 28 No No Active The current ACL (Allowable Catch Level) unit for the species or species group. VARCHAR2 19 ACL_YEAR VARCHAR2 4 No No Active The year that the ACL was established. VARCHAR2 20 SERO_SAS_COMMON_NAME VARCHAR2 26 No No Active The common name for the species or species goup as extracted by the NOAA-SERO. VARCHAR2 21 SERO_SAS_ACL_UNIT VARCHAR2 20 No No Active The name for the original NOAA-SERO ACL Unit for the species or species group. VARCHAR2 22 FISHERY_TYPE VARCHAR2 24 No No Active The general fishery type for the species or species group. VARCHAR2 45814 ALS_LANDINGS_PUERTO_RICO_ED Published / External 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 Data Steward 2017 Person Gloeckner, David David.Gloeckner@noaa.gov 75 Virginia Beach Drive Miami FL 33139 305-361-4257 305-361-4460 Data Steward 2006-07-31 2017 Person Bennett, Joshua Metadata Contact 2017 Person Chau, Jade jade.chau@noaa.gov 263 13th Avenue South Room 201 St Petersburg FL 33701 727-824-5373 8:00 AM - 4:30 PM EST/EDT Metadata Contact 2015-11-12 2017 Person Bennett, Joshua Point of Contact 2017 Person Chau, Jade jade.chau@noaa.gov 263 13th Avenue South Room 201 St Petersburg FL 33701 727-824-5373 8:00 AM - 4:30 PM EST/EDT Point of Contact 2015-11-12 2017 Person Bennett, Joshua -68.16666666667 -64.83333333333 19.25 17.25 Waters surrounding the island of Puerto Rico. Boundaries describe area on Puerto Rico fishing area map of 2.5 x 2.5 minute grids. Map is available under the URLs section link to the Caribbean Reporting forms. Continuing 1983-01-01 Reported Commercial Landings from Puerto Rico. Sensitive User ID/Password restricted. Rule of 3: Data summaries must include at least 3 entities to be considered non-confidential. See: NOAA FORM 58-5 (1-84) TRANSMITTAL 127, National Oceanic and Atmospheric Administration NOAA Administrative Order 216-100 NOAA ADMINISTRATIVE ORDER SERIES Date of Issuance: July 26, 1994 User ID/Password restricted. Confidential data may only be released to entities having a signed non-disclosure agreement on file with the Director of the Information Resources Management Division (IRMD). Otherwise, confidentiality may be suppressed by the following methods used for aggregation of confidential data: Data that are submitted as confidential can be released to the public under the following circumstances: 1. Combined or aggregated data. Confidential data can be released if the data are aggregated or summarized in a manner that prevents the identification of the person or organization that submitted the data. The "rule of three" and identification of majority allocations" are the primary data suppression methods. 2. Obscure (scramble) or remove the data identifier. For some types of data, confidential data Can be released as non-confidential if the identity of the person, vessel, company, etc. that submitted the data is not included or is scrambled as part of the data that are released. 3. Submitter. Confidential data collected under federal authority Can be released to the original entity (person, vessel, business, etc.) that sUbmitted the data. 4. Confidential data waived. The protection of confidential data can be waived by the person or business that submitted the data. See NOAA Administrative Order 216-100 NOAA ADMINISTRATIVE ORDER SERIES Date of Issuance: July 26, 1994 These standards and procedures apply to all employees of the SEFSC that need access to confidential fisheries statistics. This includes full time or term employees, contractors, volunteers, and/or other employees associated with the SEFSC, but not directly employed by either organization. Any SEFSC employee that needs or desires access to confidential data must have read NOA 216-100 and submitted a signed nondisclosure statement to the Director, Information Resources Management Division (IRMD). The non-disclosure statement must be approved by the Director of IRMD and maintained on file by IRMD. It is the responsibility of the Director of IRMD to certifY upon request, that a person or organization that requests access to confidential data is authorized access to those data. All employees that have access to and/or use confidential data (federal and nonfederal) are responsible to protect those data from unauthorized access or release. Contractors or grantees that have an agreement with NMFS can be granted access to confidential data as an authorized user (See NOA 216-100 1 Section 6.03e). It should be clearly understood that confidential data cannot be released simply by an individual signing a nondisclosure statement. There must be a clear and demonstrable need for the confidential data that are requested as part of a contract or grant. Confidential data can only be released for the specific contract or grant. Upon completion of the contract or grant, the recipient must either return the data or state that it has been destroyed. The contractor or grantee cannot use the data for any purpose other than the uses stated in the agreement. The Contracting Officers Technical Representative (COTR) or the Technical Monitor (TM) that has been assigned to the contract or grant, respectively, has the following? responsibilities: 1. The COTR/TM has the responsibility to determine whether the contractor/grantee is eligible to receive the confidential data that are requested in the agreement. 2. The COTR/TM has the responsibility to assure that all persons included in the agreement have read NOA 2l6-l00 and have signed a nondisclosure statement. A statement must be signed by each person that will have access to the confidential data under the agreement, i.e., a blanket statement cannot be used for the company or firm. The COTR/TM also has the responsibility to make sure that the Director, IRMD has signed and approved the nondisclosure statement and the statement is on file with IRMD. 3. The COTR/TM has the responsibility to assure that confidential data are not released in any publication, report, oral presentation, or other means to the public by the contractor or grantee. To access confidential data a completed non-disclosure agreement must be on file with NOAA-SEFSC. Otherwise Data that are submitted as confidential can be released to the public under the following circumstances: 1. Combined or aggregated data. Confidential data can be released if the data are aggregated or summarized in a manner that prevents the identification of the person or organization that submitted the data. The "rule of three" and identification of majority allocations" are the primary data suppression methods. 2. Obscure (scramble) or remove the data identifier. For some types of data, confidential data Can be released as non-confidential if the identity of the person, vessel, company, etc. that submitted the data is not included or is scrambled as part of the data that are released. 3. Submitter. Confidential data collected under federal authority Can be released to the original entity (person, vessel, business, etc.) that sUbmitted the data. 4. Confidential data waived. The protection of confidential data can be waived by the person or business that submitted the data. Confidential data are not to be released in any publication, report, oral presentation, or other means to the public. Non-published Metadata access is restricted. Published Metadata is available to the public. Only published metadata are to be used. http://sedarweb.org/ South East Data Assessment and Review page. The SEDAR documents may be found here. 2002-07-22 Drop Duplicate Records Bennett, Joshua It was discovered that Puerto Rico data contained duplicate records. A program was created to identify and drop duplicates. Files were put through program and resubmitted by Puerto Rico. New files loaded to system. 2008-01-16 Column Alteration Bennett, Joshua Changed width of DEALER column from 9 to 10. This was to accommodate new 10 digit codes from South Carolina. Changes were made to all ALS tables for uniformity. 2006-07-31 These are reported landings. They have not been altered to include estimates for non-reported landings. Such estimates are included in the Cooperative Statistics Reports to NOAA/SEFSC from Puerto Rico DPNR. 2006-07-31 These data are primarily trip based, especially in more recent years; however, they also include some summary data. 2006-07-31 The table contains 2 sets of codes for species and gear. One set are the NOAA/NMFS codes and the other are the Puerto Rico codes. The Puerto Rico (Erdman) coding contains more detail in some cases. 2017-03-28 Bennett, Joshua Historical catch report forms in the 1980's sometimes listed several species on the same line with the intent that the correct species be circled. This may have led to clerical error especially if none or more than one species was circled. At least one of these examples: Hogfish Capitan (189) and Loro (190) also had a mis-coding where 190 (the code for Spanish Hogfish - Loro Capitan) was intended to be coded as (192) for Parrotfishes - Loro. Thus significant amounts of Parrotfish catch was recorded as spanish hogfish (an infrequent portion of the catch). Oracle database. Data provided by industry - fishers - Canvass of landings of all species in SE US and US Caribbean, State or Federally Managed . These are raw data. Data quality parameters vary by individual species and are determined during Stock Assessment. They may be found in the Stock Assessment Reports. Look-up tables upon data entry. Edit checks for high/low pounds and prices along with monthly compliance report made available to Puerto Rico Fisheries Statistics by the SEFSC. Yes Unknown Yes Yes No 2 months Fishers have 45 days to report a trip. Data entries may be delayed due to manpower considerations and possibly speed of connectivity. Reformat and load of Caribbean Commercial Landings data (listed separately) is done every 2 weeks. To Be Determined TBD User id and password. Industry generated report by permitted commercial fishers are collected by Puerto Rico DNRA Fisheries Statistics and processed for data entry into web-based data application. Edit checks are performed on entry by look-up tables and high/low pounds and prices along with compliance report are made available to PR-DNRA by SEFSC. 5444 Entity 45814 Entity 29945 Entity 29946 Entity 5445 Entity 29947 Entity 29948 Entity 29949 Entity 29950 Entity 5446 Entity 29951 Entity 29953 Entity 6421 Entity 29954 Entity 6424 Entity 6427 Entity 29956 Entity 6430 Entity 1917 Data Set Cross Reference 1916 Data Set Cross Reference 1918 Data Set Cross Reference 2201 Data Set Cross Reference 1920 Data Set Cross Reference US Virgin Islands Landings. gov.noaa.nmfs.inport:1919 Lee Weinberger 2006-06-13T12:35:48 Bryson Anderson 2023-01-27T17:11:41 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 No 2021-05-06 1 Year 2022-05-06