Extract NM point profile trajectories from PRISME database
Usage
export_model_trajectory(
wef,
til,
model = "CTFM",
bbox = NULL,
lobt_buffer = c(before = 28, after = 24),
timeover_buffer = NULL
)
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 instant (excluded)
- model
the model of the profile: one of CPF, CTFM, DCT, FTFM, SCR, SRR, SUR [default: "CFTM"].
- bbox
(Optional) axis aligned bounding box (xmin, ymin, xmax, ymax)
- lobt_buffer
(Optional) number of (portion of) hours buffer for LOBT before/after
wef
andtil
(before, after). This is to cater for flights crossingwef
andtil
. For examplec(before = 24, after = 2.25)
allows to retrieve flights with LOBT 24H beforewef
and 1H15M aftertil
and then potentially crossing the interval.- timeover_buffer
(Optional) number of (portion of) hours buffer for
time_over
before/afterwef
andtil
(before, after). This is to cater for flights crossingwef
andtil
. For examplec(before = 2, after = 0.25)
allows to retrieve points 2H beforewef
and 15M aftertil
.
Details
You need to store your credentials to access the PRU tables in the following environment variables:
PRU_DEV_USR
for the user idPRU_DEV_PWD
for the passwordPRU_DEV_DBNAME
for the database name
See also
Other read/export:
export_allft_so6()
,
export_apds()
,
export_event_so6()
,
export_event_trajectory()
,
export_flight_info()
,
export_flights_at_airport_fr24()
,
export_flights_fr24()
,
export_hourly_adsb()
,
export_movements()
,
export_positions_at_airport_fr24()
,
export_positions_fr24()
,
generate_so6()
,
parse_airspace_prisme()
,
read_cpr()
,
read_flights_fr24()
,
read_positions_fr24()
,
read_so6()
Examples
if (FALSE) {
# export 1 day worth of NM (planned) trajectories
export_model_trajectory("2019-07-14", "2019-07-15", model = "FTFM")
# export 2 hours of NM (flown) trajectories
export_model_trajectory("2019-07-14 22:00", "2019-07-15")
# export 1 day of NM (flown) trajectories
export_model_trajectory("2019-07-14", "2019-07-15", lobt_buffer = c(before = 24, after = 1.25))
# export all CTFM trajectories within a bounding box 40 NM around EDDF
bb <- c(xmin = 7.536746, xmax = 9.604390, ymin = 49.36732, ymax = 50.69920)
export_model_trajectory("2019-01-01 00:00", "2019-01-02 00:00", bbox = bb)
}