How to Use and Update the SIAtoolbox

Overviews and instructions on how to install and run the SIAtoolbox are found in the SIAtoolbox README

This page contains the notes for the How to Workshops that SIA runs.

Workshop notes

The SIAtoolbox contains various helper functions and markdown templates to help carry out a piece of analysis in R. Some functions such as the colour scheme helper functions are generic enough to be used outside of the IDI.

One of the helper functions includes a connection string to access the tables stored in the database. This string contains the server name and port number. We are working with Stats NZ to determine whether or not this can be made publicly available. Once we have an answer we can make the SIAtoolbox public and make the how to workshop markdown file available.

In the interim those who are members of the SIA IDI project can find the markdown document html output in ../github_generic/rprogs/SIAtoolbox_workshop/SIAtoolbox_workshop.html

Other notes/To Dos

• Tidy up plot themes - make it possible to choose different SIA fill and colour options (using conditional arguments)
• Add dependency w/ RODBC library
• Add argument for DB name and port nbr (for connection string function). Alternatively, ask SNZ to set up DSNs.
• Add modified SQLwrite function
• Tidy/rethink Rmarkdown template (incl. removing source(siu_setup.R) and replacing with library(SIAtoolbox))