mpc_orbits

Table of orbital elements and related information of known (sun-orbiting and unbound) Solar System objects. Replicated from the Minor Planet Center (Postgres) database. This schema will generally closely follow the schema of the upstream table, to allow end-users to rerun queries developed elsewhere on the RSP.

Columns

name datatype description unit nullable ivoa:ucd votable:arraysize votable:xtype length precision
a double Semi Major Axis [au] AU true pos.distance;src.orbital
a1 double A1 non-grav components [m^2/ton] m2.t-1 true
a1_unc double Uncertainty on A1 non-grav components [m^2/ton] m2.t-1 true
a2 double A2 non-grav components [m^2/ton] m2.t-1 true
a2_unc double Uncertainty on A2 non-grav components [m^2/ton] m2.t-1 true
a3 double A3 non-grav components [m^2/ton] m2.t-1 true
a3_unc double Uncertainty on A3 non-grav components [m^2/ton] m2.t-1 true
a_unc double Uncertainty on Semi Major Axis [au] AU true stat.error;pos.distance;src.orbital
arc_length_sel double Arc length over total observations *selected* [days] d true
arc_length_total double Arc length over total observations [days] d true
argperi double Argument of Pericenter [degrees] deg true src.orbital.periastron
argperi_unc double Uncertainty on Argument of Pericenter [degrees] deg true stat.error;src.orbital.periastron
created_at timestamp When this row was created true time.creation;meta.dataset * timestamp 6
designation char The primary provisional designation in unpacked form (e.g. 2008 AB). false meta.id;src 16 16
dt double DT non-grav component true
dt_unc double Uncertainty on DT non-grav component true
e double Eccentricity true src.orbital.eccentricity
e_unc double Uncertainty on Eccentricity true stat.error;src.orbital.eccentricity
earth_moid double Minimum Orbit Intersection Distance [au] with respect to the Earths Orbit AU true pos.distance;src.orbital
epoch_mjd double Epoch of the Orbfit-Solution in MJD (TT, not TAI) d true time.epoch;src.orbital
fitting_datetime timestamp Date of the last orbit fit true * timestamp 6
g double G-Slope Parameter true
h double H-Magnitude mag true phys.magAbs
i double Inclination [degrees] deg true src.orbital.inclination
i_unc double Uncertainty on Inclination [degrees] deg true stat.error;src.orbital.inclination
id int Internal ID (generally not seen/used by the user) false meta.id;src
mean_anomaly double Mean Anomaly [degrees] deg true src.orbital.meanAnomaly
mean_anomaly_unc double Uncertainty on Mean Anomaly [degrees] deg true stat.error;src.orbital.meanAnomaly
mean_motion double Orbital Mean Motion [degrees per day] deg.d-1 true src.orbital.meanMotion
mean_motion_unc double Uncertainty on Orbital Mean Motion [degrees per day] deg.d-1 true stat.error;src.orbital.meanMotion
mpc_orb_jsonb text Details of the orbit solution in JSON form true *
nobs_total int Total number of all observations (optical + radar) available true
nobs_total_sel int Total number of all observations (optical + radar) selected for use in orbit fitting true
node double Longitude of Ascending Node [degrees] deg true src.orbital.node
node_unc double Uncertainty on Longitude of Ascending Node [degrees] deg true stat.error;src.orbital.node
nopp int number of oppositions true
normalized_rms double rms of the fit [unitless] true stat.rms;stat.fit
not_normalized_rms double unnormalized rms of the fit [arcsec] arcsec true stat.rms;stat.fit
orbit_type_int int Orbit Type (Integer) true
packed_primary_provisional_designation char The primary provisional designation in packed form (e.g. K08A00B) false meta.id;src 16 16
peri_time double Time from Pericenter Passage [days] d true
peri_time_unc double Uncertainty on Time from Pericenter Passage [days] d true
period double Orbital Period [days] d true time.period.revolution;src.orbital
period_unc double Uncertainty on Orbital Period [days] d true stat.error;time.period.revolution;src.orbital
q double Pericenter Distance [au] AU true pos.distance;src.orbital
q_unc double Uncertainty on Pericenter Distance [au] AU true stat.error;pos.distance;src.orbital
srp double Solar-Radiation Pressure Component [m^2/ton] m2.t-1 true
srp_unc double Uncertainty on Solar-Radiation Pressure Component [m^2/ton] m2.t-1 true
u_param int U parameter true
unpacked_primary_provisional_designation char The primary provisional designation in unpacked form (e.g. 2008 AB) false meta.id;src 16 16
updated_at timestamp When this row was updated true time.processing;meta.dataset * timestamp 6
yarkovsky double Yarkovsky Component [10^(-10)*au/day^2] 1e-10.au.d-2 true
yarkovsky_unc double Uncertainty on Yarkovsky Component [10^(-10)*au/day^2] 1e-10.au.d-2 true