Running psrc.travelsurvey using the sqlite configuration

psrc.travelsurvey defaults to running off a SQL Server database hosted at PSRC.

If you want to run from a copy of the sqlite database:

1. Copy the sqlite database from wherever you accessed it into the local directory where you have the code that runs your analysis using psrc.travelsurvey.

2. You may need to install the RSQLite library. Once you have the RSQLite library installed, load the RSQLite library at the top of your code. library(RSQLite)

3. At the top of the code, after reading in the libraries, run this line: Sys.setenv(R_CONFIG_ACTIVE = 'shinyapps')

Then the psrc.travelsurvey package will access the data from sqlite.