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

Constraints

Constraint Type Definition Description
unique_mpc_orbits_unpacked_primary_provisional_designation Unique unpacked_primary_provisional_designation Uniqueness of unpacked_primary_provisional_designation
unique_mpc_orbits_designation Unique designation Uniqueness of designation
unique_mpc_orbits_packed_primary_provisional_designation Unique packed_primary_provisional_designation Uniqueness of packed_primary_provisional_designation