Search Help Show/Hide Menu
Summary
Item Identification
Physical Location
Data Set Info
Support Roles
URLs
Child Items
Catalog Details

Summary

Short Citation
Pacific States Marine Fisheries Commission, 2024: RecFIN_MARTS Schema, https://www.fisheries.noaa.gov/inport/item/55991.
Full Citation Examples

Abstract

RecFIN_MARTS is a schema of the RecFIN database that contains the RecFIN comprehensive tables, a set of flat tables that provide standardized data for marine recreational fisheries data from California, Oregon, and Washington.

Distribution Information

No Distributions available.

Contact Information

Metadata Contact
Jason Edwards
jedwards@psmfc.org

Item Identification

Title: RecFIN_MARTS Schema
Short Name: RecFIN_MARTS Schema
Status: In Work
Abstract:

RecFIN_MARTS is a schema of the RecFIN database that contains the RecFIN comprehensive tables, a set of flat tables that provide standardized data for marine recreational fisheries data from California, Oregon, and Washington.

Purpose:

The RecFIN_MARTS schema stores the RecFIN comprehensive data tables. These tables combine multiple relational data tables into a flat structure for more efficient data querying and reporting. The comprehensive tables also standardize disparate data codes and structures provided by the sampling programs from each state, creating a consistent, intuitive data structure. The comprehensive tables in the RecFIN_MARTS schema server as the basis for reporting data from the RecFIN database to end users.

Physical Location

Organization: Pacific States Marine Fisheries Commission
City: Portland
State/Province: OR
Country: United States of America

Data Set Information

Data Set Scope Code: Data Set
Data Set Type: Oracle Database
Maintenance Frequency: Monthly

Support Roles

Metadata Contact

CC ID: 832133
Date Effective From: 2019-04-01
Date Effective To:
Contact (Person): Edwards, Jason
Email Address: jedwards@psmfc.org

URLs

URL 1

CC ID: 832134
URL: https://www.recfin.org/
Name: Recreational Fisheries Information Network
URL Type:
Online Resource

Child Items

Catalog Details

Catalog Item ID: 55991
GUID: gov.noaa.nmfs.inport:55991
Metadata Record Created By: Jason Edwards
Metadata Record Created: 2019-04-01 23:39+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2019-04-02
Owner Org: PSMFC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2019-04-02
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2020-04-02