Function reference • fpr

All functions

fpr_appendix_title(): Build the title for the appendices

fpr_create_hydrograph(): Creates hydrograph and hydrology stats figures for a given station.

fpr_dat_w_rows(): Test if a dataframe has rows

fpr_db_conn(): Connect to postgres database

fpr_db_query(): Query a postgres database

fpr_dbq_clip(): Clips a point layer by a filtered polygon layer

fpr_dbq_lscols(): List names of all columns in a postgres table

fpr_dbq_lstables(): List all tables and their sizes

fpr_dbq_subset(): Build query to read in subset table from postgres database.

fpr_import_hab_con(): Import provincial fish data submission template

fpr_import_hab_prior(): Import habitat priorities csv and assign aggregated crossing id

fpr_import_pscis(): Import the pscis template

fpr_import_pscis_all(): Import All PSCIS Sheets at Once and backup

fpr_kable(): Custom kable settings

fpr_make_geopackage(): Make geopackage from an sf object. Create directory to burn it to if it doesn't exist.

fpr_make_html_tbl(): Make html table from dataframe

fpr_my_bcfishpass(): Filter table by a value. Commopnly used to filter bcfishpass.crossings table export by PSCIS stream_crossing_id

fpr_my_channel_sentence(): Sentence to describe the widths and gradient

fpr_my_cost_estimate(): Extact cost to fix site

fpr_my_cover_sentence(): Sentence to describe the dominant and subdominant cover types

fpr_my_fish_sp(): Pull out fish species long form names from our fish species codes in bcfishpass export

fpr_my_habitat_cover(): Pull out dominant and subdominant cover types

fpr_my_habitat_info(): Extract habitat details from hab_site dataframe

fpr_my_habitat_paragraph(): Paragraph to describe the cover, widths, gradient and substrates.

fpr_my_mapsheet(): Print link to map based on watershed name and 50k grid found in bcfishpass

fpr_my_priority_info(): Extract info from habitat_confirmations_priorities spreadsheet

fpr_my_pscis_info(): Pull info about a site

fpr_my_substrate_sentence(): Sentence to describe the dominant and sub-dominant substrate

fpr_my_survey_dist(): Sentence to describe survey length of your site.

fpr_my_wshd(): PUll out watershed characteristics

fpr_photo_amalg_cv(): Amalgamate 6 PSCIS photos into 1

fpr_photo_change_ext(): Rename file extensions to what they will be after the change

fpr_photo_document_all(): Document all the photos that are in the directories to csv as a bay to track changes after scripted organization

fpr_photo_ext_to_change(): Find photos that should be converted to another file extension

fpr_photo_folders(): Build directories where the photos will be placed based on a list of site ids

fpr_photo_interval_idx(): Get the index of a time according to which interval it falls within

fpr_photo_paths_to_copy(): Identify photos that should be copied over into file to upload to PSCIS. See fpr_xref_photo_order to reference the sort order for some of the common photo tag names. The first six photos are for upstream, downstream, inlet, outlet and barrel as those are required by PSCIS (all except road anyway).

fpr_photo_paths_to_copy_phase2(): Untested!! Identify photos that should be copied over into a file to upload to the phase 2 PSCIS interface This is every photo not moved by fpr_photo_paths_to_copy adapted from https://stackoverflow.com/questions/56160445/how-to-pass-multiple-necessary-patterns-to-str-subset

fpr_photo_pull_by_str(): Pull names of a photo based on a string in the file name

fpr_photo_qa(): Helper function to QA Photos

fpr_photo_qa_df(): QA photos

fpr_photo_qa_missing_all(): Find sites missing all photos

fpr_photo_remove_dupes(): Remove duplicated photos before or after photo name appended to end of photo file name by fpr_photo_rename

fpr_photo_rename(): Sort in directories and rename photos base on field form column or photo tag.

fpr_photo_rename_ext(): Rename photos

fpr_photo_resize_batch(): Resize batch of images and convert JPG

fpr_photo_resize_convert(): Resize images and convert JPG

fpr_photo_rotate(): Rotate an image

fpr_photo_sort_metadat(): Get photo sorting specific metadata from the photos in the file

fpr_photo_sort_plan(): Make plan for which folder to put each photo in based on surveyor and time

fpr_photo_time_prep(): Make dataframe of all the data necessary to sort photos into site folders based on time.

fpr_plot_fish_box(): Generate boxplot for individual site showing densities of fish captured from electrofishing

fpr_pscis_wkb_paths(): Get Names of PSCIS Files

fpr_sheet_trim(): Trim up an excel worksheet - usually during import

fpr_sp_assign_latlong(): Extract latitude and longitude from sf object

fpr_sp_assign_sf_from_utm(): Assign a spatial data frame from UTM coordinates

fpr_sp_assign_utm(): Import sf object (point) and assign utm zone, easting and northing

fpr_sp_gpkg_backup(): Backup a geopackage point file to a .csv and .RData file

fpr_sp_watershed(): Retrieve watershed geometry using fwapgr

fpr_sp_wshd_stats(): Get elevation statistics.

fpr_table_bcfp(): Summary table of bcfishpass modelling outputs

fpr_table_bcfp_html(): Write bcfishpass model summaries to html files

fpr_table_cv_detailed(): Make two column dataframe of PSCIS info with parameter on left and value on right within each column.

fpr_table_cv_detailed_comments(): Make table for the comments to be appended to

fpr_table_cv_detailed_print(): Print out a list of fpr_table_cv_detailed tables showing PSCIS data in untidy table in either gitbook or pdf versions.

fpr_table_cv_html(): Make html tables that link to interactive map

fpr_table_cv_summary(): Make table with summary of culvert details for results section of report

fpr_table_cv_summary_memo(): Summary table of culvert info with photo to place in memos.

fpr_table_fish_density(): Summary table for fish densities within individual sites

fpr_table_fish_site(): Summary table for fish sampling sites

fpr_table_wshd_sum(): Summary stats for each watershed

fpr_test(): Print out test table

fpr_tidy_assign_site_id(): Function to process site ID value from pscis_crossing_id and my_crossing_reference

fpr_xref_crossings: Table used to crosswalk bcfishpass column names and comments to report table column names

fpr_xref_template_pscis(): Create blank PSCIS submission template