Skip to contents

Extract event-based trajectories from PRISME database and convert to SO6 format

Usage

export_event_so6(wef, til)

Arguments

wef

(UTC) timestamp of LOBT With Effect From (included). Liberal format, i.e. "2019-07-14", "2019-07-14 10:21" "2019-07-14T10:21:23Z"

til

(UTC) timestamp of LOBT TILl (excluded).

Value

a dataframe of trajectory segments in SO6 format, see read_so6

for a description of the SO6 format.

Details

You need to store your credentials to access the CPLX tables in the following environment variables:

  • PRU_CPLX_USR for the user id

  • PRU_CPLX_PWD for the password

  • PRU_CPLX_DBNAME for the database name

Examples

if (FALSE) {
# BEWARE: this can take some long-ish time
export_event_so6("2010-06-16", "2010-06-17")

# reduce the time scope to get the data quicker (and smaller)
export_event_so6("2010-06-16 10:00", "2010-06-16T11:00:11")
}