Our Work: Electronic Fish Ticket Application

Screenshot of search results within the electronic fish ticket application displayed in a tabular format with search parameters defined above the table.

The Pacific States Marine Fisheries Commission (PSMFC) helps regulate individual fishing quotas (IFQs) along the West Coast by providing tools to submit commercial fish tickets. The existing system was in Microsoft Access with disconnected, distributed databases, and limited functionality. The technical constraints were compounded by frequent regulatory changes that required corresponding updates to the application.

The application was deemed ineffective; PSMFC needed something new, easily scalable and adaptable to future legislative requirements.

The Solution

Working with PSMFC, the National Marine Fisheries Service (NMFS), and Finsight LLC, Resource Data designed and built a new web-based system for commercial fish buyers to submit, review, and manage their data in a central database and print receipts for fishermen.

We also developed web services to include automatic interfaces between all three of the West Coast Fish and Wildlife management agencies (Oregon, California, and Washington), the West Coast Regional Office of NMFS, as well as to the PacFIN data warehouse also maintained by PSMFC. These agencies can review data on licenses, vessels, operators, commercial buyers, and more for reporting purposes. These services provide a single, standard login; reporting functions; and enhanced security.

The new system has reduced the time it takes to submit fish tickets and reduced submission errors. It also helps regulatory agencies manage fisheries and monitor available quota on specific species.

Our Approach

To make this project a success, we needed to keep the technical work moving forward and still adapt to the needs of a diverse group of stakeholders and end users. To do this, we implemented a phased approach and an agile-based development methodology. Working collaboratively and iteratively, the new web-based system was designed using the original system as a prototype. We eliminated the need for disruptive, automatic updates by moving the system to a new SQL Server Instance involving multiple databases. Our work included

  • Business and requirements analysis
  • Web and database design and implementation
  • Data migration
  • User and technical support
  • Project management

We also continue to provide ongoing support and maintenance for the Electronic Fish Ticket System.