A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|

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 | TABLE | MPCORB | 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 | HEADERS | Column name | Type | Not NULL | unit | UCD | Description | Origin | Unique | Bytes | ||||||||||||||||||

10 | COLUMN | mpcDesignation | VARCHAR(8) | y | meta.id;src | MPCORB: Number or provisional designation (in packed form) | MPC | 8 | ||||||||||||||||||||

11 | COLUMN | mpcNumber | INTEGER | MPC number (if the asteroid has been numbered; NULL otherwise). Provided for convenience. | MPC | 4 | ||||||||||||||||||||||

12 | COLUMN | ssObjectId | BIGINT | y | meta.id;src | LSST unique identifier (if observed by LSST) | MOPS-PP | 8 | ||||||||||||||||||||

13 | COLUMN | mpcH | FLOAT | mag | MPCORB: Absolute magnitude, H | MPC | 4 | |||||||||||||||||||||

14 | COLUMN | mpcG | FLOAT | MPCORB: Slope parameter, G | MPC | 4 | ||||||||||||||||||||||

15 | COLUMN | epoch | DOUBLE | MJD | MPCORB: Epoch (in MJD, .0 TT) | MPC | 8 | |||||||||||||||||||||

16 | COLUMN | M | DOUBLE | degrees | MPCORB: Mean anomaly at the epoch, in degrees | MPC | 8 | |||||||||||||||||||||

17 | COLUMN | peri | DOUBLE | degrees | MPCORB: Argument of perihelion, J2000.0 (degrees) | MPC | 8 | |||||||||||||||||||||

18 | COLUMN | node | DOUBLE | degrees | MPCORB: Longitude of the ascending node, J2000.0 (degrees) | MPC | 8 | |||||||||||||||||||||

19 | COLUMN | incl | DOUBLE | degrees | MPCORB: Inclination to the ecliptic, J2000.0 (degrees) | MPC | 8 | |||||||||||||||||||||

20 | COLUMN | e | DOUBLE | MPCORB: Orbital eccentricity | MPC | 8 | ||||||||||||||||||||||

21 | COLUMN | n | DOUBLE | degrees/day | MPCORB: Mean daily motion (degrees per day) | MPC | 8 | |||||||||||||||||||||

22 | COLUMN | a | DOUBLE | AU | MPCORB: Semimajor axis (AU) | MPC | 8 | |||||||||||||||||||||

23 | COLUMN | uncertaintyParameter | VARCHAR(1) | MPCORB: Uncertainty parameter, U | MPC | 1 | ||||||||||||||||||||||

24 | COLUMN | reference | VARCHAR(9) | MPCORB: Reference | MPC | 9 | ||||||||||||||||||||||

25 | COLUMN | nobs | INTEGER | MPCORB: Number of observations | MPC | 4 | ||||||||||||||||||||||

26 | COLUMN | nopp | INTEGER | MPCORB: Number of oppositions | MPC | 4 | ||||||||||||||||||||||

27 | COLUMN | arc | FLOAT | days | MPCORB: Arc (days), for single-opposition objects | MPC | 4 | |||||||||||||||||||||

28 | COLUMN | arcStart | DATETIME | MPCORB: Year of first observation (for multi-opposition objects) | MPC | 8 | ||||||||||||||||||||||

29 | COLUMN | arcEnd | DATETIME | MPCORB: Year of last observation (for multi-opposition objects) | MPC | 8 | ||||||||||||||||||||||

30 | COLUMN | rms | FLOAT | arcsec | MPCORB: r.m.s residual (") | MPC | 4 | |||||||||||||||||||||

31 | COLUMN | pertsShort | VARCHAR(3) | MPCORB: Coarse indicator of perturbers (blank if unperturbed one-opposition object) | MPC | 3 | ||||||||||||||||||||||

32 | COLUMN | pertsLong | VARCHAR(3) | MPCORB: Precise indicator of perturbers (blank if unperturbed one-opposition object) | MPC | 3 | ||||||||||||||||||||||

33 | COLUMN | computer | VARCHAR(10) | MPCORB: Computer name | MPC | 10 | ||||||||||||||||||||||

34 | COLUMN | flags | INTEGER | MPCORB: 4-hexdigit flags. See https://minorplanetcenter.net//iau/info/MPOrbitFormat.html for details | MPC | 4 | ||||||||||||||||||||||

35 | COLUMN | fullDesignation | VARCHAR(26) | MPCORB: Readable designation | MPC | 26 | ||||||||||||||||||||||

36 | COLUMN | lastIncludedObservation | FLOAT | MJD | MPCORB: Date of last observation included in orbit solution | MPC | 4 | |||||||||||||||||||||

37 | COLUMN | covariance | FLOAT[21] | MPCORB: Covariances, details TBD | MPC | 84 | ||||||||||||||||||||||

38 | 184 | |||||||||||||||||||||||||||

39 | ||||||||||||||||||||||||||||

40 | TABLE | MPCORBDESIGMAP | 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 | HEADERS | Column name | Type | Not NULL | unit | UCD | Description | Origin | Unique | |||||||||||||||||||

42 | COLUMN | mpcDesignation | VARCHAR(8) | meta.id;src | Either the MPC provisional or permanent designation | MPC | ||||||||||||||||||||||

43 | COLUMN | mpcNumber | INTEGER | MPC number (if the asteroid has been numbered) | MPC | |||||||||||||||||||||||

44 | COLUMN | otherDesignation | VARCHAR(8) | Other designation by which this object is known | MPC | Note: this structure could be reworked to allow simple querying on any designation | ||||||||||||||||||||||

45 | COLUMN | ssObjectId | BIGINT | meta.id;src | LSST unique identifier (if observed by LSST) | MOPS-PP | ||||||||||||||||||||||

46 | ||||||||||||||||||||||||||||

47 | TABLE | SSObject | 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 | HEADERS | Column name | Type | Not NULL | unit | UCD | Description | Origin | Unique | |||||||||||||||||||

49 | COLUMN | ssObjectId | BIGINT | y | meta.id;src | Unique identifier. | MOPS-PP | 8 | ||||||||||||||||||||

50 | COLUMN | discoverySubmissionDate | DOUBLE | date | 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). | SSOCP | 8 | Use case: assess whether this is a "fresh" object and worth following up immediately. | ||||||||||||||||||||

51 | COLUMN | firstObservationDate | DOUBLE | date | The time of the first LSST observation of this object (could be precovered) | SSOCP | 8 | |||||||||||||||||||||

52 | COLUMN | arc | FLOAT | y | days | Arc of LSST observations | SSOCP | 4 | ||||||||||||||||||||

53 | COLUMN | numObs | INTEGER | y | Number of LSST observations of this object | SSOCP | 4 | |||||||||||||||||||||

54 | COLUMN | lcPeriodic | BLOB(768) | Periodic light curve features computed on phase/distance-corrected magnitudes (H), 6x32 floats | SSOCP | 768 | 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 | COLUMN | MOID | FLOAT | AU | Minimum orbit intersection distance to Earth | SSOCP | 4 | 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 | COLUMN | MOIDTrueAnomaly | FLOAT | deg | True anomaly of the MOID point | SSOCP | 4 | |||||||||||||||||||||

57 | COLUMN | MOIDEclipticLongitude | FLOAT | deg | Ecliptic longitude of the MOID point | SSOCP | 4 | |||||||||||||||||||||

58 | COLUMN | MOIDDeltaV | FLOAT | km/s | DeltaV at the MOID point | SSOCP | 4 | |||||||||||||||||||||

59 | COLUMN | uH | FLOAT | mag | Best fit absolute magnitude (u band) | SSOCP | 4 | 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 | COLUMN | uG12 | FLOAT | mag | Best fit G12 slope parameter (u band) | SSOCP | 4 | https://hal.archives-ouvertes.fr/hal-00676207/document | ||||||||||||||||||||

61 | COLUMN | uHErr | FLOAT | mag | stat.error | Uncertainty of H (u band) | SSOCP | 4 | Note: All H/G12 values will be maximum likelihood estimates (Gaussian likelihoods, point estimates, flat priors) | |||||||||||||||||||

62 | COLUMN | uG12Err | FLOAT | mag | stat.error | Uncertainty of G12 (u band) | SSOCP | 4 | ||||||||||||||||||||

63 | COLUMN | uH_uG12_Cov | FLOAT | mag^2 | stat.covariance | H-G12 covariance (u band) | SSOCP | 4 | ||||||||||||||||||||

64 | COLUMN | uChi2 | FLOAT | stat.fit.chi2 | Chi^2 statistic of the phase curve fit (u band) | SSOCP | 4 | |||||||||||||||||||||

65 | COLUMN | uNdata | INTEGER | y | The number of data points used to fit the phase curve (u band) | SSOCP | 4 | |||||||||||||||||||||

66 | COLUMN | gH | FLOAT | mag | Best fit absolute magnitude (g band) | SSOCP | 4 | |||||||||||||||||||||

67 | COLUMN | gG12 | FLOAT | mag | Best fit G12 slope parameter (g band) | SSOCP | 4 | 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 | COLUMN | gHErr | FLOAT | mag | stat.error | Uncertainty of H (g band) | SSOCP | 4 | ||||||||||||||||||||

69 | COLUMN | gG12Err | FLOAT | mag | stat.error | Uncertainty of G12 (g band) | SSOCP | 4 | ||||||||||||||||||||

70 | COLUMN | gH_gG12_Cov | FLOAT | mag^2 | stat.covariance | H-G12 covariance (g band) | SSOCP | 4 | ||||||||||||||||||||

71 | COLUMN | gChi2 | FLOAT | stat.fit.chi2 | Chi^2 statistic of the phase curve fit (g band) | SSOCP | 4 | |||||||||||||||||||||

72 | COLUMN | gNdata | INTEGER | y | The number of data points used to fit the phase curve (g band) | SSOCP | 4 | |||||||||||||||||||||

73 | COLUMN | rH | FLOAT | mag | Best fit absolute magnitude (r band) | SSOCP | 4 | |||||||||||||||||||||

74 | COLUMN | rG12 | FLOAT | mag | Best fit G12 slope parameter (r band) | SSOCP | 4 | 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 | COLUMN | rHErr | FLOAT | mag | stat.error | Uncertainty of H (r band) | SSOCP | 4 | ||||||||||||||||||||

76 | COLUMN | rG12Err | FLOAT | mag | stat.error | Uncertainty of G12 (r band) | SSOCP | 4 | ||||||||||||||||||||

77 | COLUMN | rH_rG12_Cov | FLOAT | mag^2 | stat.covariance | H-G12 covariance (r band) | SSOCP | 4 | ||||||||||||||||||||

78 | COLUMN | rChi2 | FLOAT | stat.fit.chi2 | Chi^2 statistic of the phase curve fit (r band) | SSOCP | 4 | |||||||||||||||||||||

79 | COLUMN | rNdata | INTEGER | y | The number of data points used to fit the phase curve (r band) | SSOCP | 4 | |||||||||||||||||||||

80 | COLUMN | iH | FLOAT | mag | Best fit absolute magnitude (i band) | SSOCP | 4 | |||||||||||||||||||||

81 | COLUMN | iG12 | FLOAT | mag | Best fit G12 slope parameter (i band) | SSOCP | 4 | 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 | COLUMN | iHErr | FLOAT | mag | stat.error | Uncertainty of H (i band) | SSOCP | 4 | ||||||||||||||||||||

83 | COLUMN | iG12Err | FLOAT | mag | stat.error | Uncertainty of G12 (i band) | SSOCP | 4 | ||||||||||||||||||||

84 | COLUMN | iH_iG12_Cov | FLOAT | mag^2 | stat.covariance | H-G12 covariance (i band) | SSOCP | 4 | ||||||||||||||||||||

85 | COLUMN | iChi2 | FLOAT | stat.fit.chi2 | Chi^2 statistic of the phase curve fit (i band) | SSOCP | 4 | |||||||||||||||||||||

86 | COLUMN | iNdata | INTEGER | y | The number of data points used to fit the phase curve (i band) | SSOCP | 4 | |||||||||||||||||||||

87 | COLUMN | zH | FLOAT | mag | Best fit absolute magnitude (z band) | SSOCP | 4 | |||||||||||||||||||||

88 | COLUMN | zG12 | FLOAT | mag | Best fit G12 slope parameter (z band) | SSOCP | 4 | |||||||||||||||||||||

89 | COLUMN | zHErr | FLOAT | mag | stat.error | Uncertainty of H (z band) | SSOCP | 4 | ||||||||||||||||||||

90 | COLUMN | zG12Err | FLOAT | mag | stat.error | Uncertainty of G12 (z band) | SSOCP | 4 | ||||||||||||||||||||

91 | COLUMN | zH_zG12_Cov | FLOAT | mag^2 | stat.covariance | H-G12 covariance (z band) | SSOCP | 4 | ||||||||||||||||||||

92 | COLUMN | zChi2 | FLOAT | stat.fit.chi2 | Chi^2 statistic of the phase curve fit (z band) | SSOCP | 4 | |||||||||||||||||||||

93 | COLUMN | zNdata | INTEGER | y | The number of data points used to fit the phase curve (z band) | SSOCP | 4 | |||||||||||||||||||||

94 | COLUMN | yH | FLOAT | mag | Best fit absolute magnitude (y band) | SSOCP | 4 | |||||||||||||||||||||

95 | COLUMN | yG12 | FLOAT | mag | Best fit G12 slope parameter (y band) | SSOCP | 4 | |||||||||||||||||||||

96 | COLUMN | yHErr | FLOAT | mag | stat.error | Uncertainty of H (y band) | SSOCP | 4 | ||||||||||||||||||||

97 | COLUMN | yG12Err | FLOAT | mag | stat.error | Uncertainty of G12 (y band) | SSOCP | 4 | ||||||||||||||||||||

98 | COLUMN | yH_yG12_Cov | FLOAT | mag^2 | stat.covariance | H-G12 covariance (y band) | SSOCP | 4 | ||||||||||||||||||||

99 | COLUMN | yChi2 | FLOAT | stat.fit.chi2 | Chi^2 statistic of the phase curve fit (y band) | SSOCP | 4 | |||||||||||||||||||||

100 | COLUMN | yNdata | INTEGER | y | The number of data points used to fit the phase curve (y band) | SSOCP | 4 |