Package index • seatrackR

Positions

Functions for reading and writing positional data to the database.

deletePositions(): deletePositions
getPositions(): Get position data from the database. Either "GLS" data (default), "IRMA" data, or "GPS" data.
getYears(): Retrieve info on the years where we have position data
loadPosdata(): Load posdata files into R.
writePositions(): Update the positions.postable

checkMetadata() checkRetrievedMatchDeployed() checkOpenSession() checkLoggers() checkNames(): checkMetadata before import
getColonies(): Retrieve info on the registered colonies and locations within colonies in the database
getIndividInfo(): Retrieve info on the individuals
getLoggerModels(): Get logger models
getNames(): Retrieve info on the registered names (people) in the database
getRingHistory(): Retrieve info on the ring history table
getSpecies(): Retrieve info on the registered species in the database
get_responsible(): Get responsible species and colony
writeIndividInfo(): Update the individ_info table
writeMetadata(): Import metadata
writeRingHistory(): Update the ring history table

Functions for connecting to and disconnecting from the Seatrack database.

connectSeatrack() disconnectSeatrack(): Connect to seatrack database
set_credentials_renviron(): Set up SEATRACK DB credentials for this project

Functions for reading and writing activity data to the database.

deleteActivity(): Delete activity data from the database, based on subselection criteria
getRecordings(): Read logger recordings data
pruneRecordings(): pruneRecordings Prune activity, light and temperature recording data that
writeRecordings(): Update light, temperature or activity data

Functions for reading and writing logger information to the database.

Functions for reading and writing file information to the database and FTP server.

deleteFiles(): deleteFiles
downloadFiles(): Download files from the file archive
getFileArchiveSummary(): Retrieve summary info on the registered raw-files
listFileArchive(): Retrieve info on the status of files in the file archive
loadFile(): Load a single file from the file archive into R
uploadFiles(): Write files to the file archive

Various utility functions included in the package.

General functions related to the SEATRACK database.

changeSeatrackPassword(): changeSeatrackPassword
checkSeatrackRVersion(): checkSeatrackRVersion
deleteRecords(): Delete records from the database, based on subselection criteria
refreshViews(): Manually update the the materialized views in the database
viewDatabaseModel(): View the database structure in a browser

Example datasets included in the package.

Shortcuts for plotting SEATRACK data.

Functions to prepare R data for queries

R_df_to_db_values(): Convert a dataframe of R values to a string of database values for SQL insertion
R_value_to_db_value(): Convert an R value to its corresponding database representation
R_vector_to_db_values(): Convert an R vector to a string of database values