load_vmdb {vismeteor}

Loading visual meteor observations from the data base

Description

Loads the data of visual meteor observations from a data base created with imo-vmdb.

Usage

load_vmdb_rates(
  dbcon,
  shower = NULL,
  period = NULL,
  sl = NULL,
  lim.magn = NULL,
  sun.alt.max = NULL,
  moon.alt.max = NULL,
  session.id = NULL,
  rate.id = NULL,
  withSessions = FALSE,
  withMagnitudes = FALSE
)

load_vmdb_magnitudes(
  dbcon,
  shower = NULL,
  period = NULL,
  sl = NULL,
  lim.magn = NULL,
  session.id = NULL,
  magn.id = NULL,
  withSessions = FALSE,
  withMagnitudes = TRUE
)

Arguments

dbcon

database connection.

shower

character; selects by meteor shower codes. NA loads sporadic meteors.

period

time; selects a time range by minimum/maximum.

sl

numeric; selects a range of solar longitudes by minimum/maximum.

lim.magn

numeric; selects a range of limiting magnitudes by minimum/maximum.

sun.alt.max

numeric; selects the maximum altitude of the sun.

moon.alt.max

numeric; selects the maximum altitude of the moon.

session.id

integer; selects by session ids.

rate.id

integer; selects rate observations by ids.

withSessions

logical; if TRUE, also load the corresponding session data.

withMagnitudes

logical; if TRUE, also load the corresponding magnitude observations.

magn.id

integer; selects magnitude observations by ids.

Details

sl, period and lim.magn expect a vector with successive minimum and maximum values. sun.alt.max and moon.alt.max are expected to be scalar values.

Value

Both functions return a list, with

observations	data frame, rate or magnitude observations,
sessions	data frame; session data of observations,
magnitudes	table; contingency table of meteor magnitude frequencies.

observations depends on the function call. load_vmdb_rates returns a data frame, with

rate.id	unique identifier of the rate observation,
shower.code	IAU code of the shower. It is NA in case of sporadic meteors.
period.start	start of observation,
period.end	end of observation,
sl.start	solarlong at start of observation,
sl.end	solarlong at start of observation,
session.id	reference to the session,
freq	count of observed meteors,
lim.magn	limiting magnitude,
t.eff	net observed time in hours,
f	correction factor of cloud cover,
time.sidereal	sidereal time,
sun.alt	altitude of the sun,
sun.az	azimuth of the sun,
moon.alt	altitude of the moon,
moon.az	azimuth of the moon,
moon.illum	illumination of the moon (⁠0.0 .. 1.0⁠),
field.alt	altitude of the field of view (optional),
field.az	azimuth of the field of view (optional),
radiant.alt	altitude of the radiant (optional). The zenith attraction is already applied.
radiant.az	azimuth of the radiant (optional),
magn.id	reference to the magnitude observations (optional).

load_vmdb_magnitudes returns a observations data frame, with

magn.id	unique identifier of the magnitude observation,
shower.code	IAU code of the shower. It is NA in case of sporadic meteors.
period.start	start of observation,
period.end	end of observation,
sl.start	solarlong at start of observation,
sl.end	solarlong at start of observation,
session.id	reference to the session,
freq	count of observed meteors,
magn.mean	mean of magnitudes,
lim.magn	limiting magnitude (optional).

The sessions data frame contains

session.id	unique identifier of the session,
longitude	location’s longitude,
latitude	location’s latitude,
elevation	height above mean sea level in km,
country	country name,
location.name	location name,
observer.id	observer id (optional),
observer.name	observer name (optional).

magnitudes is a contingency table of meteor magnitude frequencies. The row names refer to the id of magnitude observations. The column names refer to the magnitude.

Note

Angle values are expected and returned in degrees.

References

https://pypi.org/project/imo-vmdb/

Examples

## Not run: 
# create a connection to the data base
con <- dbConnect(
    PostgreSQL(),
    dbname = "vmdb",
    host = "localhost",
    user = "vmdb"
)

# load rate observations including
# session data and magnitude observations
data <- load_vmdb_rates(
    con,
    shower = 'PER',
    sl = c(135.5, 145.5),
    period = c('2015-08-01', '2015-08-31'),
    lim.magn = c(5.3, 6.7),
    withMagnitudes = TRUE,
    withSessions = TRUE
)

# load magnitude observations including
# session data and magnitude observations
data <- load_vmdb_magnitudes(
    con,
    shower = 'PER',
    sl = c(135.5, 145.5),
    period = c('2015-08-01', '2015-08-31'),
    lim.magn = c(5.3, 6.7),
    withMagnitudes = TRUE,
    withSessions = TRUE
)

## End(Not run)