getMOVESInputTable: getMOVESInputTable

In hlinak/R-for-MOVES: R4MOVES

getMOVESInputTable

Description

Gets the results of a table in a MOVES database and all associated lookup tables.

Usage

getMOVESInputTable(
  dbconn,
  movesdb_name,
  countydb_name,
  table_name,
  get_query_string = FALSE
)

Arguments

dbconn	MySQL db connection
movesdb_name	MySQL default database to be updated as string
countydb_name	MySQL county database to be updated as string
table_name	MySQL table to be updated as string
get_query_string	TRUE/FALSE if TRUE the query string is returned instead of the results, defaults to FALSE

Value

Either a dataframe with the result from dbSendQuery() or FALSE

Examples

getMOVESInputTable(dbconn, movesdb_name, countydb_name, "averagespeeddistribution")
getMOVESInputTable(dbconn, movesdb_name, countydb_name, "imcoverage")

hlinak/R-for-MOVES documentation built on Jan. 31, 2023, 2:03 p.m.