getEchoValidationTable {birdscanR} | R Documentation |
Get a BirdScan echo validation table
Description
gets the echoValidationTable from an already connected database
Usage
getEchoValidationTable(dbConnection, dbDriverChar)
Arguments
dbConnection |
a valid database connection |
dbDriverChar |
dbDriverChar 'SQL Server' The name of the driver. Should be either 'SQL Server' or 'PostgreSQL'. If 'PostgreSQL', it connects to cloud.birdradar.com |
Value
A dataframe called echovalidationTable
Author(s)
Fabian Hertner, fabian.hertner@swiss-birdradar.com; 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)
echovalidationTable = getEchoValidationTable(dbConnection, dbDriverChar)
## End(Not run)
[Package birdscanR version 0.3.0 Index]