In MPCA-data/mpcadb: R connections to MPCA's databases: TEMPO, DELTA, EQUIS, CEDR

mpcadb

:electric_plug: :floppy_disk: Easy R connections to MPCA's databases: DELTA, TEMPO, EQUIS, RAPIDS, ONBASE.

Functions

• open_delta : Open a connection to DELTAW, MPCA's oracle database that houses TEMPO, EQUIS, RAPIDS, ONBASE and more.
• get_ai : Get all Agency Interest (AI) names from TEMPO.

library(knitr)

Install

Install mpcadb from GitHub:

# First install the 'devtools' package
library(devtools)

# Install the development pkg from GitHub
remotes::install_github("MPCA-data/mpcadb")

---

Use

Open an RODBC connection to DELTA with the open_delta() function. It will add the credentials for you.

library(mpcadb)

# Open DELTA connection and set to `deltaw`
deltaw <- open_delta()

TEMPO AI's

Get a complete list of the Agency Interests from TEMPO with get_ai():

ai_names <- get_ai(keep_alt_names = TRUE)

kable(head(ai_names, 4))

Get only a select list of TEMPO AI's:

ai_names <- get_ai(ai = c(441, 288), keep_alt_names = FALSE)

kable(ai_names)

EQUIS examples...

MPCA-data/mpcadb documentation built on March 29, 2022, 10:05 p.m.