Get BirdScan site table

Load site table from an already connected 'Birdscan MR1' 'SQL' database.

Usage

getSiteTable(dbConnection, dbDriverChar)

Arguments

dbConnection

A valid database connection.

dbDriverChar

This was the name of the driver, and is now automatically detected, therefore it should be omitted into the future.

Value

A data.frame with the site table

See also

Other read SQL database functions: QUERY(), extractDbData(), getBatClassification(), getCollectionTable(), getEchoFeatures(), getEchoValidationTable(), getProtocolTable(), getRadarTable(), getRfClassification(), getTimeBinsTable(), getVisibilityTable()

Author

Fabian Hertner, Birgen Haest

Examples

if (FALSE) { # \dontrun{
# 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)

siteTable <- getSiteTable(dbConnection)
} # }