Connects to cfdbs and pulls fields from WOLANDS, WODETS, CFDETS
get_comland_data(channel, landed, endyear, out.dir)
| channel | an Object inherited from DBIConnection-class. This object is used to connect
to communicate with the database engine. (see |
|---|---|
| landed | Character String. Use landed weight ("y" - meatwt) for scallops and clams instead of live weight ("n" - livewt). |
| endyear | Numeric Scalar. Final year of query. |
| out.dir | path to directory where final output will be saved |
Data frame (data.table) (n x 10) Each row of the data.table represents a species record for a given tow/trip
Year of trip/tow
Month of trip/tow
Fishing gear used on trip/tow
Tonnage class of the fishing vessel
Species code (3 charachters)
Species code and market code (4 characters)
Statistical area in which species was reportly caught
Utilization code
live weight (landed = "n") or landed weight (landed="y") in lbs
The value of landed catch to the nearest dollar (U.S.), paid to fisherman by dealer, for a given species.
A file containing the data.table above will also be saved to the users machine in the directory provided