CAR's PostGIS database tools
# this is still in development so do the following
remove.packages("cardatdbtools", lib="~/Rlibs")
library(devtools)
install_github("cardat/cardatdbtools", build_vignettes = TRUE)
library(cardatdbtools)
vignette("cardat_ap_monitors_with_obs")