ABCDEFGHIJKLMNOPQRSTUVWXYZAAAB
1
Solar System Data Products: Tables
2
Definition of the Solar System Data Products schemas (**** DRAFT ****)
3
Baseline URL:TBD
Software Component Key:
4
Maintainers:
Mario Juric, Lynne Jones
MOPS
Moving Object Processing System (from detections to orbits)
5
SSOCP
"Solar System Object Characterization Pipeline" (quantities computed in post-processing)
6
IMPORTANT:
There are many more measurements of intrest to Solar System science in the DIASource table (see next tab). The tables presented here complement the DIASource table information with solar-system specific measurements.
MPC
Minor Planet Center upload/download software
7
EPHEM
Ephemeris computation pipeline
8
TABLEMPCORB
The orbit catalog produced by the Minor Planet Center. Ingested daily. O(10M) rows by survey end. The columns are described at https://minorplanetcenter.net//iau/info/MPOrbitFormat.html
PROMPT
Delivered by other prompt processing pipelines or services
9
HEADERSColumn nameTypeNot NULLunitUCDDescriptionOriginUniqueBytes
10
COLUMNmpcDesignationVARCHAR(8)ymeta.id;srcMPCORB: Number or provisional designation (in packed form)MPC8
11
COLUMNmpcNumberINTEGER
MPC number (if the asteroid has been numbered; NULL otherwise). Provided for convenience.
MPC4
12
COLUMNssObjectIdBIGINTymeta.id;srcLSST unique identifier (if observed by LSST)MOPS-PP8
13
COLUMNmpcHFLOATmagMPCORB: Absolute magnitude, HMPC4
14
COLUMNmpcGFLOATMPCORB: Slope parameter, GMPC4
15
COLUMNepochDOUBLEMJDMPCORB: Epoch (in MJD, .0 TT)MPC8
16
COLUMNMDOUBLEdegreesMPCORB: Mean anomaly at the epoch, in degreesMPC8
17
COLUMNperiDOUBLEdegreesMPCORB: Argument of perihelion, J2000.0 (degrees)MPC8
18
COLUMNnodeDOUBLEdegreesMPCORB: Longitude of the ascending node, J2000.0 (degrees)MPC8
19
COLUMNinclDOUBLEdegreesMPCORB: Inclination to the ecliptic, J2000.0 (degrees)MPC8
20
COLUMNeDOUBLEMPCORB: Orbital eccentricityMPC8
21
COLUMNnDOUBLE
degrees/day
MPCORB: Mean daily motion (degrees per day)MPC8
22
COLUMNaDOUBLEAUMPCORB: Semimajor axis (AU)MPC8
23
COLUMNuncertaintyParameterVARCHAR(1)MPCORB: Uncertainty parameter, UMPC1
24
COLUMNreferenceVARCHAR(9)MPCORB: ReferenceMPC9
25
COLUMNnobsINTEGERMPCORB: Number of observationsMPC4
26
COLUMNnoppINTEGERMPCORB: Number of oppositionsMPC4
27
COLUMNarcFLOATdaysMPCORB: Arc (days), for single-opposition objectsMPC4
28
COLUMNarcStartDATETIMEMPCORB: Year of first observation (for multi-opposition objects)MPC8
29
COLUMNarcEndDATETIMEMPCORB: Year of last observation (for multi-opposition objects)MPC8
30
COLUMNrmsFLOATarcsecMPCORB: r.m.s residual (")MPC4
31
COLUMNpertsShortVARCHAR(3)MPCORB: Coarse indicator of perturbers (blank if unperturbed one-opposition object)MPC3
32
COLUMNpertsLongVARCHAR(3)MPCORB: Precise indicator of perturbers (blank if unperturbed one-opposition object)MPC3
33
COLUMNcomputerVARCHAR(10)MPCORB: Computer nameMPC10
34
COLUMNflagsINTEGER
MPCORB: 4-hexdigit flags. See https://minorplanetcenter.net//iau/info/MPOrbitFormat.html for details
MPC4
35
COLUMNfullDesignationVARCHAR(26)MPCORB: Readable designationMPC26
36
COLUMNlastIncludedObservationFLOATMJDMPCORB: Date of last observation included in orbit solutionMPC4
37
COLUMNcovarianceFLOAT[21]MPCORB: Covariances, details TBDMPC84
38
184
39
40
TABLEMPCORBDESIGMAP
The mapping between old and new provisional MPC designation, produced by the Minor Planet Center. Ingested daily. O(few x 10M) rows by survey end.
41
HEADERSColumn nameTypeNot NULLunitUCDDescriptionOriginUnique
42
COLUMNmpcDesignationVARCHAR(8)meta.id;srcEither the MPC provisional or permanent designationMPC
43
COLUMNmpcNumberINTEGERMPC number (if the asteroid has been numbered)MPC
44
COLUMNotherDesignationVARCHAR(8)Other designation by which this object is knownMPC
Note: this structure could be reworked to allow simple querying on any designation
45
COLUMNssObjectIdBIGINTmeta.id;srcLSST unique identifier (if observed by LSST)MOPS-PP
46
47
TABLESSObject
LSST-computed per-object quantities. 1:1 relationship with MPCORB (w. no entries in SSObject where there are no LSST observations). Recomputed daily, upon MPCORB ingestion.
48
HEADERSColumn nameTypeNot NULLunitUCDDescriptionOriginUnique
49
COLUMNssObjectIdBIGINTymeta.id;srcUnique identifier.MOPS-PP8
50
COLUMNdiscoverySubmissionDateDOUBLEdate
The date the LSST first linked and submitted the discovery observations to the MPC. May be NULL if not an LSST discovery. The date format will follow general LSST conventions (MJD TAI, at the moment).
SSOCP8
Use case: assess whether this is a "fresh" object and worth following up immediately.
51
COLUMNfirstObservationDateDOUBLEdateThe time of the first LSST observation of this object (could be precovered)SSOCP8
52
COLUMNarcFLOATydaysArc of LSST observationsSSOCP4
53
COLUMNnumObsINTEGERyNumber of LSST observations of this objectSSOCP4
54
COLUMNlcPeriodicBLOB(768)
Periodic light curve features computed on phase/distance-corrected magnitudes (H), 6x32 floats
SSOCP768
Note: will depend on what is developed for static variable sources (re-use the same code). Note: must ensure that the amplitude of variation is included.
55
COLUMNMOIDFLOATAUMinimum orbit intersection distance to EarthSSOCP4
Note: if MOID is computationally too expensive to compute for distant objects (KBOs, etc), we may restrict this to only the near-earth-(ish) objects. (Steve C: "I would not compute it for anything but the NEO population"). Useful links: https://www.sciencedirect.com/science/article/pii/S001910351000151X?via%3Dihub, https://pdfs.semanticscholar.org/0c8c/a8b1fe0eb533c0f12e45f3d689235fbb4957.pdf, https://www.mathworks.com/matlabcentral/fileexchange/26329-determine-the-distance-between-two-ellipses-in-3d
56
COLUMNMOIDTrueAnomalyFLOATdegTrue anomaly of the MOID pointSSOCP4
57
COLUMNMOIDEclipticLongitudeFLOATdegEcliptic longitude of the MOID pointSSOCP4
58
COLUMNMOIDDeltaVFLOATkm/sDeltaV at the MOID pointSSOCP4
59
COLUMNuHFLOATmagBest fit absolute magnitude (u band)SSOCP4
Note: All H/G12 values will be computed assumin there is _no intrinsic variability_. Intrinsic variability will manifest itself as increased scatter around the best-fit phase curve. Stretch goal: explore iterative or simultaneous H/G12 - lcPeriodic fits
60
COLUMNuG12FLOATmagBest fit G12 slope parameter (u band)SSOCP4
https://hal.archives-ouvertes.fr/hal-00676207/document
61
COLUMNuHErrFLOATmagstat.errorUncertainty of H (u band)SSOCP4
Note: All H/G12 values will be maximum likelihood estimates (Gaussian likelihoods, point estimates, flat priors)
62
COLUMNuG12ErrFLOATmagstat.errorUncertainty of G12 (u band)SSOCP4
63
COLUMNuH_uG12_CovFLOATmag^2
stat.covariance
H-G12 covariance (u band)SSOCP4
64
COLUMNuChi2FLOATstat.fit.chi2Chi^2 statistic of the phase curve fit (u band)SSOCP4
65
COLUMNuNdataINTEGERyThe number of data points used to fit the phase curve (u band)SSOCP4
66
COLUMNgHFLOATmagBest fit absolute magnitude (g band)SSOCP4
67
COLUMNgG12FLOATmagBest fit G12 slope parameter (g band)SSOCP4
Note: G12 may be jointly for all bands until there's enough information to fit it separately on a per-band basis. This will be recorded in the flags.
68
COLUMNgHErrFLOATmagstat.errorUncertainty of H (g band)SSOCP4
69
COLUMNgG12ErrFLOATmagstat.errorUncertainty of G12 (g band)SSOCP4
70
COLUMNgH_gG12_CovFLOATmag^2
stat.covariance
H-G12 covariance (g band)SSOCP4
71
COLUMNgChi2FLOATstat.fit.chi2Chi^2 statistic of the phase curve fit (g band)SSOCP4
72
COLUMNgNdataINTEGERyThe number of data points used to fit the phase curve (g band)SSOCP4
73
COLUMNrHFLOATmagBest fit absolute magnitude (r band)SSOCP4
74
COLUMNrG12FLOATmagBest fit G12 slope parameter (r band)SSOCP4
Note: G12 may be jointly for all bands until there's enough information to fit it separately on a per-band basis. This will be recorded in the flags.
75
COLUMNrHErrFLOATmagstat.errorUncertainty of H (r band)SSOCP4
76
COLUMNrG12ErrFLOATmagstat.errorUncertainty of G12 (r band)SSOCP4
77
COLUMNrH_rG12_CovFLOATmag^2
stat.covariance
H-G12 covariance (r band)SSOCP4
78
COLUMNrChi2FLOATstat.fit.chi2Chi^2 statistic of the phase curve fit (r band)SSOCP4
79
COLUMNrNdataINTEGERyThe number of data points used to fit the phase curve (r band)SSOCP4
80
COLUMNiHFLOATmagBest fit absolute magnitude (i band)SSOCP4
81
COLUMNiG12FLOATmagBest fit G12 slope parameter (i band)SSOCP4
Note: G12 may be jointly for all bands until there's enough information to fit it separately on a per-band basis. This will be recorded in the flags.
82
COLUMNiHErrFLOATmagstat.errorUncertainty of H (i band)SSOCP4
83
COLUMNiG12ErrFLOATmagstat.errorUncertainty of G12 (i band)SSOCP4
84
COLUMNiH_iG12_CovFLOATmag^2
stat.covariance
H-G12 covariance (i band)SSOCP4
85
COLUMNiChi2FLOATstat.fit.chi2Chi^2 statistic of the phase curve fit (i band)SSOCP4
86
COLUMNiNdataINTEGERyThe number of data points used to fit the phase curve (i band)SSOCP4
87
COLUMNzHFLOATmagBest fit absolute magnitude (z band)SSOCP4
88
COLUMNzG12FLOATmagBest fit G12 slope parameter (z band)SSOCP4
Note: G12 may be jointly for all bands until there's enough information to fit it separately on a per-band basis. This will be recorded in the flags.
89
COLUMNzHErrFLOATmagstat.errorUncertainty of H (z band)SSOCP4
90
COLUMNzG12ErrFLOATmagstat.errorUncertainty of G12 (z band)SSOCP4
91
COLUMNzH_zG12_CovFLOATmag^2
stat.covariance
H-G12 covariance (z band)SSOCP4
92
COLUMNzChi2FLOATstat.fit.chi2Chi^2 statistic of the phase curve fit (z band)SSOCP4
93
COLUMNzNdataINTEGERyThe number of data points used to fit the phase curve (z band)SSOCP4
94
COLUMNyHFLOATmagBest fit absolute magnitude (y band)SSOCP4
95
COLUMNyG12FLOATmagBest fit G12 slope parameter (y band)SSOCP4
Note: G12 may be jointly for all bands until there's enough information to fit it separately on a per-band basis. This will be recorded in the flags.
96
COLUMNyHErrFLOATmagstat.errorUncertainty of H (y band)SSOCP4
97
COLUMNyG12ErrFLOATmagstat.errorUncertainty of G12 (y band)SSOCP4
98
COLUMNyH_yG12_CovFLOATmag^2
stat.covariance
H-G12 covariance (y band)SSOCP4
99
COLUMNyChi2FLOATstat.fit.chi2Chi^2 statistic of the phase curve fit (y band)SSOCP4
100
COLUMNyNdataINTEGERyThe number of data points used to fit the phase curve (y band)SSOCP4