eppo_names_tables {pestr} | R Documentation |
EPPO Data Services SQLite Database search tools
Description
eppo_names_table
checks if string (names or parts of the names)
provided by user match any name in the EPPO database. If strings match any
name in database, data frame with all names matching codeid, as well as
preferred (binary), language and EPPOcode is returned.
Arguments
names_vector |
A vector with organism or viruses names (or part of the names) to be checked for existence in EPPO SQLite Database. |
sqlConnection |
connection to SQLite EPPO Database. By default NULL; function will automatically connect to database with default credentials. |
Value
Check if provided names are present in EPPO SQLite Database. Creates
list which contains: data frame with matching names in database and their
codeids, character vector of names from names_vector
which do not
match any entry in database, data frame with preferred names and their
codeids, and data frame containing all names matching codeids of preferred
names. Last data frame contains also column with preferred (binary),
codelang (two letter character with language code), and EPPOcode.
Using with other functions
Output of the function might be passed to functions:
-
eppo_tabletools_names
-
eppo_tabletools_cat
-
eppo_tabletools_hosts
-
eppo_tabletools_distribution
Examples
## Not run:
##This code needs SQLite dabatase in working directory
test_names <- c("Xylella", "dog", "leafhopper")
test_names_table <- eppo_names_table(test_names)
## End(Not run)