getManualVisibilityTable {birdscanR} | R Documentation |
Get manual visibility table
Description
load visibility table from an already connected 'Birdscan MR1' 'SQL' database
Usage
getManualVisibilityTable(dbConnection, dbDriverChar)
Arguments
dbConnection |
a valid database connection |
dbDriverChar |
the name of the driver. If different from 'PostgreSQL' it connects to cloud.birdradar.com |
Value
A dataframe with the manual visibility table
Author(s)
Baptiste Schmid baptiste.schmid@vogelwarte.ch; Birgen Haest birgen.haest@vogelwarte.ch
Examples
## Not run:
# Set server and database settings
# ===========================================================================
dbServer = "MACHINE\\SERVERNAME" # Set the name of your SQL server
dbName = "db_Name" # Set the name of your database
dbDriverChar = "SQL Server" # Set either "SQL Server" or "PostgreSQL"
# Open the connection with the database
# ===========================================================================
dsn = paste0("driver=", dbDriverChar, ";server=", dbServer,
";database=", dbName,
";uid=", rstudioapi::askForPassword("Database user"),
";pwd=", rstudioapi::askForPassword("Database password"))
dbConnection = RODBC::odbcDriverConnect(dsn)
manualVisibilityTable = getManualVisibilityTable(dbConnection, dbDriverChar)
## End(Not run)
[Package birdscanR version 0.3.0 Index]