5444
Table: ALS_LANDINGS_PUERTO_RICO
ALS_LANDINGS_PUERTO_RICO
Entity
Published / External
1919
Puerto Rico Commercial Landings Statistics 1983 and more recent in Accumulated Landings System (ALS) Compatible Format
Data Set
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.
Spatial
puerto rico
Stratum
dealer
Stratum
fishing center
Stratum
landings
Stratum
month
Stratum
species
Stratum
year
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
Confidential
Password Restricted. Rule of 3: Data summaries must include at least 3 dealers 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
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.
Use Published Metadata only.
2013-03-12
UPDATE
Bennett, Joshua
An update was done to the PR_ID_CODE for 1,081 records from 2008-2011 to correct improper permit ids in table. Edits were made by comparing ids to permit lists obtained from Puerto Rico and by observing sequence of trip_ticket_numbers to determine if a number had been mis-entered. Update file was PR_ID_FIX_06mar13.xlsx.
2013-06-05
UPDATE
Bennett, Joshua
An update was made to the DISTANCE column. All 'Y' (greater than 10 NM) were set to DISTANCE code 'C'. All 'N' (10 NM or less) records were set to code 'B'. 2009 distance codes were updated as they were not previously loaded. An update was also done to year 2012 from the CCL data of code '7' (9 miles to 200 miles) where the info existed in CCL. This needs to be a part of the load process from now on.
2016-11-02
Column Reformat
Bennett, Joshua
Reformatted Pounds column to accept decimals from Caribbean Commercial Logbook extracts. Previous imports had been rounding numbers leading to slight discrepancies. Data now exact match.
2013-06-06
Distance from shore data not supplied for 2010 and 2011. Distance data currently not present prior to 2003.
2016-11-03
Bennett, Joshua
Pounds column in ALS.ALS_LANDINGS_PUERTO_RICO previously formatted as NUMBER (9,0) was rounding decimals. Did not match exactly with CCL extract data. Column reformatted to NUMBER (9,3). (landings for trips do not approach 5 digits). Problem fixed.
gov.noaa.nmfs.inport:5444
Lee Weinberger
2007-10-16T05:43:40
SysAdmin InPortAdmin
2022-08-09T17:10:59
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