Skip to contents

Export list of hourly-binned flights and aircraft info

Source: R/nm.R
export_hourly_adsb.Rd

Extract hourly-binned flights from PRISME database together with aircraft information such as registration, aircraft operator and ICAO 24-bit address

Usage

export_hourly_adsb(wef, til, model = "CTFM", bbox = 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 "FTFM", "CTFM", "CPF". [default: "CFTM"]

bbox

(Optional) axis aligned bounding box (xmin, ymin, xmax, ymax)

Value

a dataframe with trajectory data

Details

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

  • PRU_DEV_USR for the user id

  • PRU_DEV_PWD for the password

  • PRU_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_model_trajectory(), 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 all hourly CTFM flights within a bounding box 40 NM around EDDF
bb <- c(xmin = 7.536746, xmax = 9.604390, ymin = 49.36732, ymax = 50.69920)
export_hourly_adsb("2019-01-01 00:00", "2019-01-02 00:00", bbox = bb)
}