knitr::opts_chunk$set( collapse = TRUE, comment = "#>" )
library(fishi)
The fishi package contains a large number of sql functions. This thumbnail allows you to review them in order to understand what they are used for and which functions they are associated with.
This query is extracting information related to the spatial distribution and effort. Works for the functions catch_per_searching_day, catch_per_unit_effort, map_catch_distribution and map_effort_distribution.
This query is extracting information related to the catches by school type, for the fishery_production function.
This query is extracting information related to the sets and catches. Works for the functions : fishing_activity, set_per_searching_day, catch_per_searching_day and catch_per_unit_effort.
This query is extracting information related to the vessels, sets, catches, and effort. Works for the functions : fishing_capacity, fishing_effort and spatial_occupancy.
This query is extracting information related to the time at sea and fishing time. Works for the function fishing_time.
This query is extracting information related to vessel activities, including the ocean's ID and name, the date of the activity, vessel details (ID, type, and name), and the country associated with the activity.
The bio_tuna SQL script is used to extract information on the size and weight of tuna catches from the sardara database. It works for the functions bio_size_tuna and bio_weight_tuna.
This query is extracting information related to each biological variable sampled, for the species_biological_variable function.
This query is extracting information related to the catches by school type, for the fishery_production function.
This query is extracting information related to the fishing operations, for the fishing_activity function.
This query is extracting information related to the fishing capacity of the fleet, for the fishing_capacity function.
This query is extracting information related to the time at sea and fishing time, for the fishing_time function.
This query is extracting information related to logbook activities, for control_trip_map, control_trip and data_availability functions.
This query is extracting information related to the spatial distribution, catch and effort. It works for the functions map_catch_distribution and map_effort_distribution.
This query is extracting information related to the number of fads by year, for the number_fad function.
This query is extracting information related to observed activities, for control_trip_map, control_trip and data_availability functions.
This query is extracting information related to the trip, vessel and well sampled (logbook), for the sample_summary function.
This query is extracting information related to the trip, vessel and well sampled (observation), for the sample_summary function.
This query is extracting information related to the sets event (by wells), for the set_total and psu_toal function.
This query is extracting information related to the sets and distribution, for the set_total and psu_toal function.
This query is extracting information related to the species like the FAO code, the scientific names and the species group.
This query is extracting information related to vessel activities, including the ocean's ID and name, the date of the activity, vessel details (ID, type, and name), and the country associated with the activity.
This query is extracting information related to vms activities, including the vms'ID, the date and the time of the activity, and longitude/latitude associated with the activity, for control_trip_map and data_availability functions.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.