Commercial Fisheries Landings for U.S. Caribbean

Roughly the Exclusive Economic Zone (EEZ) for the U.S. Caribbean (Puerto Rico and the U.S. Virgin Islands including their territorial waters. The British VIrgin Islands are not part of the EEZ. Some international waters also exist within these boundaries and are not part of the EEZ.

Allowed decimal places for pounds in the forms.

Automatically provide USVI with Trip Ticket Number. USVI does not assign trip ticket numbers to their records.

Increased rows for Other Species. PR has 4 manual rows for species.

Gear Code Additions and Edits Made to GEAR_LIST, DIALECT_GEAR_LIST, TRIP_GEAR_TYPE_GEAR

Gear Code HL_POW was replaced by HL_TROLL in lookups and data. (The spanish name is SILGA for trolling hook and line). HL_POW_REEL was added to (spanish name is MALACATE for hook and line, electric reel). HL_HAND code gear name ('HAND') was renamed 'HANDLINE' in lookup and 'CORDEL DE MANO' in dialect lookup. Bottom Longline (CODE HL_BLL) was renamed (PALANGRE DE FONDO)IN dialect lookup. Drift Longline (code HL_DLL) was renamed (PALANGRE horizontal DE superfecie) IN dialect lookup. Vertical Longline (code HL_VLL) was renamed (PALANGRE vertical) IN dialect lookup. HL_BUOY (yo-yo) was dropped from dialect list. New code 'HL_BOTTOM' (Bottom Fishing Hook and Line) was added to lookup and listed as 'CALA' in dialect list. Another gear code addition: GILL_NET_BOTT for Gill Nets Fished on or near the sea bottom. Translates to Trasmallo in dialect list for SP01. The code of GILL_NET, named SURFACE GILL NET, was retained for surface gill nets and translates now to FILETE in dialect list for SP01. 2011-11-23 16:21:17

A change was done for Puerto Rico's logbook, the ajax for getting the landing location was moved to the Centro de Desembarco, and the Municipio de desembarco and is now pre-filled with the landing_location_county data automatically.

Based on (changing permit numbers) a field (entity) was added to the database to keep the history linked together and the front end (user interface) could be enabled to change to change the region permit number.

New Maintain Fisher Feature: Inactivate Fisher

Detail This new feature will allow users of CCL to inactivate a fisher (e.i. expire their profile). When to do this? When a fisher is assigned a permit number which is being used by a someone else. If a permit number is reused by a different fisher, this feature allows the users to inactivate the old user and issue the permit number to a new/active fisher. System restriction: Only one ACTIVE users can have a permit number for an island.

New feature summary:

=> Ability to make a fisher inactive/active)

=> When searching, see active/inactive status of a user

=> Reuse permit numbers when prior user is inactive

Some Database changes.

p_l_fisher_permit includes: is_inactive

p_f_fisher_permit includes: is_inactive and max_trip_dt

p_u_fisher_permit input: v_is_inactive = 1 to inactivate user

Puerto Rico distance from shore default of 9 miles or less changed to null. Due to this default (9 miles or less), there was no distinction between trips where no data are recorded/entered and trips actually taking place 9 miles or less from shore. Made entry select 9 miles or less 0, greater than 9 miles 1, or null.

Puerto Rico trip ticket had discard data (bottom left of form) which had no entry options in CCL. Fields added so these data could be entered.

Puerto Rico ¿Day or Night¿ was defaulted to DAY. This was a similar issue to the distance from shore issue. New entry choices are day, night, or null.

Updated FILTER_GEAR_SPECIES_LIST-St. Croix Traps List Only. Species in the St. Croix - Traps list that were found to be improper or out of place:

1. Yellowfin Grouper (Grammanick),sequence 11 was dropped from the Traps list.

2. Yellowtail Snapper was added to Traps list at sequence 11 (replacing Yellowfin Grouper).

3. Sheepshead Porgy,sequence 36 was dropped.

4. Trunkfish was added at sequence 36 (replacing sheepshead porgy).

5. Nurse shark was added at sequence 42 (previously empty).

6. Green moray eel was added at sequence 43 (replacing lionfish)

7. Lionfish was changed from sequence 43 to 44.

8. Yellowtail snapper had been at sequence 33 prior to move to sequence 11.

9. Lionfish was moved again from sequence 44 to 33 where it is on the form (replacing where Yellowtail Snapper had been.

Incorporated Spanish translation of Help into Application.

Added Created_Date, Created_By_Userid columns to all CCL tables. Added Date Received column to CCL.TRIP. This would be the original date the record was created and would remain fixed in the data. The LU (last update) columns would remain to indicate modification dates and users. Fields were populated with the LU and LU_USER_ID for existing records.

"Logbook Received Date" added. When a logbook form is being entered, a new field is displayed to collect the date in which the office received the logbook form. It is optional.

Gear codes NET_AQUARFISH for 'AQUARIUM FISH NET' and NET_GILL_SCUBA 'GILL NET, FISHED USING SCUBA' were added to the CCL.GEAR_LIST table and to the CCL.DIALECT_GEAR_LIST as 'REDES PARA PECES ORNAMENTALES' AND 'TRASMALLO CON BUCEO CON TANQUE' respectively.

Non-compliance. Not all fishers report. Because of this 'correction factors' are issued by Puerto Rico to account for the non-reporting. These factors, even though they are applied on a detail level are only truly applicable by yearly summary from 1983 - 1992. From 1993 - 2015 they were applied by year and coast, although expansion by year and fishing center were possible from 2007 and more recent. At this time the survey method is being reviewed as well as the compliance issue which is at the root of the problem.