Project Information

Title: Database Management FS30 1992

Project Year and Number: 1992: FS30

Other Fiscal Years and Numbers for this Project: 1991: FS30, 1990: FS30

Principal Investigator (PI): Carmine DiCostanzo (Alaska Department of Fish & Game)

Managing Agency: ADFG

Assisting Personnel: Bruce Simonson

Research Location: All Spill Affected Areas

Restoration Category: Damage Assessment

Injured Resources Addressed: Not Specified

Abstract: FS-30 addresses the need to catalog and maintain the principal electronic copies of raw data collected by the ADF&G Natural Resource Damage Assessment & Restoration (NRDA) Fish/Shellfish and Subtidal projects. Assessment of injuries, successful restoration, and ongoing monitoring efforts ultimately are grounded in the data sets generated by NRDA studies. Because of the fundamental role these data play in determining the effectiveness of any restoration program, it is important that care be taken to adequately document, archive, and maintain these principal electronic data sets. In addition, the ADF&G personnel associated with FS-30 are directly responsible for the maintenance of critical historical fisheries databases referenced by many NRDA projects. This connection provides several added benefits to the NRDA effort, including direct access to historical data, technical expertise, and the use of the ADF&G Commercial Fisheries Wide Area Network (WAN) for electronic correspondence and transfer of data. Principal Copy of Electronic Data Sets: NRDA: FS-1, 2~ 3, 4A, 11, 13, 27, 28, ST-5, (FS-5, ST-2AB, ST-6). Historical Data: Commercial fisheries harvest, Fisheries escapement data Restoration Projects: R-53, 58, 59, 60ABC, 105, and 113, (R-90, 106). Documentation (DOCS) Database Management System (DBMS) FS-30 supports 17 NRDA and restoration projects, with ancillary support to an additional 6 projects. Including historical data sets, the current amount of raw electronic data involved is estimated to be between 1,500,000,000 and 1,800,000,000 bytes. Tracking this volume of information requires significant time and effort; leaving it to Principal Investigators (PIs) would severely limit their ability to focus on project work. Ignoring data management entirely would ultimately lead to the loss of millions of dollars in data collection effort as projects complete or personnel transition to other projects. In brief, this project: 1. Catalogs, archives, and maintains the principal copy of raw electronic data sets for FS-1, 2, 3, 4A, 11, 13, 27, 28, ST-5, (FS-5, ST-2AB, ST-6). 2. Facilitates direct access by PIs to historical fisheries data sets essential to NRDA studies. Historical data includes commercial fisheries catch and escapement figures. 3. Provides data processing and technical support for PIs and NRDA functions, including the use of ADF&G Commercial Fisheries WAN. 4. Proposes to unify the data catalogs and maintenance of principal data sets for continuing ADF&G fisheries assessment, restoration, monitoring projects. This should facilitate sharing raw data between agencies and the ability to provide this information to the public. 5. Proposes to catalog, archive, and maintain the principal electronic data sets for R-53, 58, 59, 60ABC, 105, 113, (R-90 and 106). Demonstration of the success of restoration effort depends directly on measurable results. Any restoration assertion is ultimately linked to principal assessment, restoration, and historical data sets. For this reason, it is important that principal data sets of NRDA studies be documented, archived, and maintained.


Proposal: View (53 KB)

Reports:
Final Report: View (908 KB)

Publications from this Project: None Available

Datasets:
EVOSTC Data Archive: Software was written to provide access to fish harvest database using the ADFG commercial fisheries Wide-Area Network (WAN). Procedures were implemented to provide reports in numerous database, spreadsheet, and statistical formats. Documentation and guidelines for using the harvest database were completed. WAN capability is now available between Juneau, Cordova, Anchorage, Kodiak, Soldotna and Homer. Network database