birdscanR (version 0.3.0)

getEchoFeatures: Get BirdScan echo features

Description

load echo rffeature map from 'Birdscan MR1' 'SQL' database

Usage

getEchoFeatures(dbConnection, dbDriverChar, listOfRfFeaturesToExtract)

Value

A list of the features extracted

Arguments

dbConnection

a valid database connection

dbDriverChar

the name of the driver. If different from 'PostgreSQL' it connects to cloud.birdradar.com

listOfRfFeaturesToExtract

a list of feature to extract

Author

Fabian Hertner, ; Birgen Haest,

Examples

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

# Set list of Rf features you also want to extract
# Vector with RF features to extract. Feature IDs can be found in the  
# 'rfFeatures' table in the sql database.  
# Example: Get wing beat frequency and credibility: c(167, 168)
# Set to NULL to not extract any.
# ===========================================================================
  listOfRfFeaturesToExtract = c(167, 168) 

echoFeatures = getEchoFeatures(dbConnection, dbDriverChar, 
                               listOfRfFeaturesToExtract)
}