db_read_density: Read 'density' from RRD database and return as an...

In LEEF-UZH/LEEF.analysis: Access Functions, Tests and Basic Analysis of the RRD Data from the LEEF Project

Read density from RRD database and return as an tbl_SQLiteConnection.

Description

This function does not actually fetch the data, but returns an tbl_SQLiteConnection object which can be further processed / filtered using dplyr. See https://db.rstudio.com/r-packages/dplyr/ for details. To fetch the actual data, execute collect().

Usage

db_read_density(
  db = getOption("RRDdb", "LEEF.RRD.sqlite"),
  from_timestamp = 20210920,
  to_timestamp = 21000101
)

Arguments

db	fully qualified path to the sqlite database. Default, read from option RRDdb. If not set, defaults to option RRDdb; if this is not set, defaults to LEEF.RRD.sqlite
from_timestamp	integer. Earliest timestamp to return. Default: 20210920
to_timestamp	integer. Latest timestamp to return. Default: 21000101

Value

Link to the table density in the RRD to be used with dplyr and friends

LEEF-UZH/LEEF.analysis documentation built on Feb. 8, 2025, 11:18 a.m.