A Long-Term Partnership Strengthening Fisheries Management

A fisheries commission can modernize complex data collection by treating each program as part of a shared data ecosystem rather than a separate software problem. Commercial fishery data, recreational harvest data, economic reporting, fish ticket submissions, and at-sea observer records each have different workflows, but they all need reliable collection, validation, reporting, and access models. 

In Resource Data’s case study, the Pacific States Marine Fisheries Commission (PSMFC) worked with Resource Data across multiple major systems, including PacFIN, RecFIN, E-Tix, Economic Data Reporting, AKFIN, and ORCA. Each system addressed a distinct fisheries management need, but together they strengthened how PSMFC collects, manages, analyzes, and shares fisheries data across California, Oregon, Washington, Idaho, and Alaska. 

In this case study, fisheries modernization works best when technology decisions support the full operating environment. That leads to better data quality, faster reporting, less duplication, and stronger decision support for agencies, fishery managers, scientists, economists, observers, and industry stakeholders. 

A fisheries organization may need a long-term technology partner because fisheries data systems evolve with regulations, programs, reporting requirements, scientific needs, and technology standards. One-time software delivery may solve an immediate problem; however, it often leaves agencies struggling to maintain, adapt, and integrate systems as requirements change. 

PSMFC has partnered with Resource Data since 2000. Over more than 25 years, Resource Data has supported major fisheries systems including PacFIN, RecFIN, E-Tix, EDR, AKFIN, and ORCA, and helped PSMFC prepare for future work such as migrating Oracle-based, on-premises data warehouses to a high-performance cloud platform.

This case study shows the value of continuity in complex public-sector and natural resource technology environments. There is reduced implementation risk, stronger institutional knowledge, and better long-term maintainability. A partner that understands the mission, data, users, and regulatory context can help systems evolve without forcing each project to start from scratch. 

Better fisheries data infrastructure helps agencies make more defensible decisions by improving the accuracy, accessibility, timeliness, and consistency of the data behind policy and resource management. When fisheries data is fragmented, delayed, or difficult to validate, managers have less confidence in the information used to assess catches, economic effects, recreational harvests, stock conditions, and regulatory impacts. 

PSMFC supports government resource agencies and the fishing industry by maintaining central repositories on critical fishing industry data. Resource Data’s work strengthened the systems PSMFC uses to collect, validate, analyze, and report commercial, recreational, economic, and observer data. 

This Resource Data case study demonstrates that data modernization is tied directly to conservation and management outcomes. Reliable data gives managers and regulators a clearer foundation for policies affecting harvesters, processors, coastal communities, agencies, and marine resources. 

Redesigning a fisheries data warehouse can improve reporting by updating the architecture, schemas, data flows, and data models that determine how information is collected, stored, validated, and accessed. For fisheries programs, these improvements matter because managers and agencies may rely on decades of historical data and ongoing submissions from multiple jurisdictions. 

In Resource Data’s case study, Resource Data completely redesigned the PacFIN data warehouse, the nation’s first regional fisheries data network. The work included an in-depth analysis of user reporting needs, a new architecture, updated schemas, data flows, and models, the migration and audit of more than 30 years of historical data, and a web portal for state agencies to submit data more easily. 

This example shows that a data warehouse redesign is not only a technical upgrade. Benefits include improved accuracy, better data accessibility, and stronger support for fishery managers, state agencies, and the Pacific Fishery Management Council as they track catches and respond to increasing demands on West Coast fishery resources. 

Integrating recreational fisheries data from state and federal sources requires standardized data structures, reliable ETL processes, a modern data warehouse, and analyst-ready data marts. Recreational fisheries data can come from different programs, collection methods, and jurisdictions, so integration depends on technical design and a clear understanding of how managers use the information. 

In Resource Data’s case study, RecFIN unites state and federal efforts to monitor recreational fishing harvests, effort, and distribution. Resource Data modernized RecFIN’s outdated data storage system by creating a robust data warehouse, designing and implementing a new database, migrating existing data, developing standardized ETL processes, and introducing comprehensive data marts for analysts. 

This example illustrates that integration is most valuable when it makes data easier to use, not just easier to store. That can lead to faster analysis, more consistent reporting, and better support for fisheries management and stock assessment needs. 

ETL, data validation, and custom database structures improve fisheries reporting by making large, complex datasets more accurate, traceable, and useful for analysis. In North Pacific and Alaska fisheries, data should support economists, scientists, managers, and communities trying to understand the effects of management decisions. 

In Resource Data’s case study, AKFIN consolidates essential commercial fisheries data for North Pacific and Alaskan fisheries. Resource Data helped design and developed AKFIN’s data warehouse using advanced ETL, data validation, and custom database structures for precise reporting. The team also collaborated with AKFIN to develop datamarts and evolve the system from raw data queries to a dimensional warehouse with a business intelligence repository and end-user query tools. 

This example shows how mature data engineering improves technical performance and decision support.  

Electronic fish ticket reporting can reduce errors by replacing fragmented and manual reporting processes with a unified online system that sends submitted data more directly into the database. The shorter and more consistent with the path from data entry to storage, the fewer opportunities there are for transcription mistakes, delayed reporting, lost paperwork, or inconsistent formats. 

In Resource Data’s case study, PSMFC needed to replace disparate, error-prone fish ticket reporting systems along the West Coast. Resource Data developed E-Tix, the first web-based electronic fish ticket reporting system in the region. It helped fish dealers in Oregon, Washington, and California submit fish ticket data online through a unified web portal and database. 

This case study demonstrates that electronic reporting improves efficiency and data quality. Some of its benefits are faster submissions, fewer errors, stronger compliance support, and more reliable information for fisheries managers. By continuing to enhance E-Tix for regulation changes and feature improvements, Resource Data also helped the system remain useful as reporting needs evolved. 

A tablet-based observer app can improve data quality by replacing difficult paper-based field workflows with a tool designed for real at-sea conditions. Observers working on fishing vessels need to collect scientific data accurately while dealing with motion, weather, water exposure, limited space, and time-sensitive biological sampling responsibilities. 

In Resource Data’s case study, the West Coast Region Observer Program and Resource Data developed the Onboard Record Collection App (ORCA). ORCA was designed for temperamental at-sea conditions where paper forms could get wet, damaged, or difficult to manage. The case study notes that ORCA saves time and improves data quality for precise reporting. 

This Resource Data example shows that field applications must fit the environment where the work actually happens. They can improve operations with less time spent managing forms, more time available for biological sampling, and better data quality for sustainable fisheries reporting. ORCA’s success also supported new versions for longline fishery observer programs for NMFS Pacific Island and West Coast regional offices. 

Shortening the path between fisheries’ data entry and the database improves reporting accuracy because it reduces the number of handoffs, re-entry steps, and quality control gaps where errors can occur. The closer the data capture method is to the final database, the less likely information will be lost, misread, delayed, or changed unintentionally. 

In Resource Data’s case study, this principle appears across multiple systems. E-Tix allows fish dealers to submit fish ticket data online. ORCA helps observers collect at-sea data electronically rather than relying on paper forms. PacFIN and RecFIN modernization improved data submission, integration, and reporting workflows. 

This case study shows that data quality is partly a workflow design problem. For fisheries management, the improvements from Resource Data’s work matter because decisions about harvests, conservation, economic impacts, and policy depend on trustworthy data. 

Fisheries’ economic reporting systems help regulators understand program impacts by collecting and organizing data on costs, revenues, ownership, employment, and related economic factors. With these details, regulators assess how fisheries programs affect the people, businesses, and communities connected to the industry. 

In Resource Data’s case study, PSMFC oversees Economic Data Reporting (EDR) collections to analyze the economic effects of fisheries programs. Since 2009, Resource Data has supported the EDR database with programming and maintenance, including tailored data collection solutions such as fillable PDFs, Oracle APEX applications, and .NET XML forms. Resource Data also adapted those tools to meet evolving needs and new program amendments. 

This example shows that economic reporting modernization supports more data-driven regulation. There is better visibility into program effects, more reliable data storage and reporting, and more cost-effective fisheries management across the region. 

Fisheries organizations should consider system compatibility, reporting continuity, performance, data quality, user access, migration risk, and long-term maintainability before moving on-premises data warehouses to the cloud. The goal should be to modernize infrastructure without disrupting the systems that agencies, analysts, managers, and program teams rely on. 

In Resource Data’s case study, PSMFC and Resource Data are focused on migrating Oracle-based, on-premises data warehouses to a high-performance cloud platform while maintaining compatibility with existing systems. That compatibility requirement is important because PSMFC’s data warehouses support critical fisheries management workflows for different programs and jurisdictions. 

As this case study shows, cloud migration leads to better efficiency, improved scalability, and a stronger foundation for future modernization. When done carefully, cloud modernization can reduce infrastructure constraints while preserving the trust and continuity needed for mission-critical fisheries data systems. 

Fisheries’ technology modernization can support a new state or region by bringing its data collection and management systems into alignment with established infrastructure, reporting standards, and analytical workflows. This is important when a new participant joins a broader regional mission and needs to coordinate with existing state, federal, and commission-level systems. 

In Resource Data’s case study, Hawaii recently joined PSMFC. The next phase of work is modernizing Hawaii’s fisheries management and data collection systems to bring them in line with the advanced infrastructure used across the West Coast. Resource Data’s long-term work with PacFIN, RecFIN, E-Tix, AKFIN, EDR, and ORCA gives the partnership a strong foundation for this kind of regional expansion. 

This example shows that modernization can improve consistency across jurisdictions and preserve program-specific needs. As a result, there is stronger coordination, more comparable data, and better support for the unified mission of Pacific states working to conserve, develop, and manage fisheries resources.