Skip to contents

Expand several indicators results to PostgreSQL

Usage

expand_indi_psql(
  agg,
  agg_time,
  anos,
  indi = "all",
  psql_table,
  psql_schema,
  psql_db,
  psql_host,
  psql_port,
  psql_user = NULL,
  psql_pwd = NULL
)

Arguments

agg

character vector. Spatial aggregation level. uf_res for UF of residence. uf_ocor for UF of occurrence. regsaude_res for regiao de saude of residence. regsaude_ocor for regiao de saúde of occurence. mun_res for municipality of residence. mun_ocor for municipality of ocurrence.

agg_time

character vector. Time aggregation levels. year for yearly data. month for monthly data. week for weekly data. Defaults to year.

anos

numeric vector. Years

indi

character function names vector. Defaults to all for all indi_ functions.

psql_table

character. Indicators table name.

psql_schema

character. Schema name.

psql_db

character. Database name.

psql_host

character. psql server host address.

psql_port

character. psql server port.

psql_user

character. psql user name. If not provided, the function will look for it on renviron.

psql_pwd

character. psql password. If not provided, the function will look for it on renviron.