extractLAND: Extracts commercial landings data from historic and current...

In dempseydanielle/SSdata: Extracts Fishery Independent and Commercial Landings Data for the Scotian Shelf from DFO-Maritimes Databases

Description

Extracts commercial landings data from NAFO (1968 - 1985), ZIF (1986 - 2002) and MARFIS (2003 - present) databases.

Usage

extractLAND(path, e.year)

Arguments

path	Filepath indicating where to create the folder to store the extracted data.
e.year	Year for which to end data extraction.

Details

User must define channel = odbcConnect("ptran", uid = ###, pwd = ###) in the global environment. This channel must have access to: the nafo_summary and nafo_area_codes tables from the COMLAND database, the sub_trips_XXXX and identified_catches tables from the cl database, the marfis_catch_effort table from mfd_obfmi database, and the indiseas_marfis2allcodes table from the gomezc database.

Units: tonnes

This function defines and then calls three functions: NAFO(), ZIF(), and MARFIS().

Extracts data from 1968 to e.year.

Species are assigned to commercial landings groups based on commercial_groups. Type ?commercial_groups for more information.

Value

This function creates directory path/data/landings and stores file landings.RData (object name is landings). landings has 14 columns: SPECIES, ALLNAMES, YEAR, NAFO_UNIT, CATCH (tonnes), and 9 landings groups. A value of 1 in a landings group column indicates that the corresponding SPECIES belongs to that group. Species may belong to more than one group. Species codes are the commercial landings codes.

References

Modified code from AC's ExtractIndicators/R/getLandings.R

See Also

Other LAND functions: LANDdataframe

dempseydanielle/SSdata documentation built on May 3, 2020, 5:09 p.m.