Prompt Products Database

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.

Column Name Data Type Unit Description UCD Order Principal
id int Internal ID (generally not seen/used by the user) meta.id;src 10
designation char The primary provisional designation in unpacked form (e.g. 2008 AB). meta.id;src 20
packed_primary_provisional_designation char The primary provisional designation in packed form (e.g. K08A00B) meta.id;src 30
unpacked_primary_provisional_designation char The primary provisional designation in unpacked form (e.g. 2008 AB) meta.id;src 40
mpc_orb_jsonb text Details of the orbit solution in JSON form 50
created_at timestamp When this row was created time.creation;meta.dataset 60
updated_at timestamp When this row was updated time.processing;meta.dataset 70
orbit_type_int int Orbit Type (Integer) 80
u_param int U parameter 90
nopp int number of oppositions 100
arc_length_total double d Arc length over total observations [days] 110
arc_length_sel double d Arc length over total observations *selected* [days] 120
nobs_total int Total number of all observations (optical + radar) available 130
nobs_total_sel int Total number of all observations (optical + radar) selected for use in orbit fitting 140
a double AU Semi Major Axis [au] pos.distance;src.orbital 150
q double AU Pericenter Distance [au] pos.distance;src.orbital 160
e double Eccentricity src.orbital.eccentricity 170
i double deg Inclination [degrees] src.orbital.inclination 180
node double deg Longitude of Ascending Node [degrees] src.orbital.node 190
argperi double deg Argument of Pericenter [degrees] src.orbital.periastron 200
peri_time double d Time from Pericenter Passage [days] 210
yarkovsky double 1e-10.au.d-2 Yarkovsky Component [10^(-10)*au/day^2] 220
srp double m2.t-1 Solar-Radiation Pressure Component [m^2/ton] 230
a1 double m2.t-1 A1 non-grav components [m^2/ton] 240
a2 double m2.t-1 A2 non-grav components [m^2/ton] 250
a3 double m2.t-1 A3 non-grav components [m^2/ton] 260
dt double DT non-grav component 270
mean_anomaly double deg Mean Anomaly [degrees] src.orbital.meanAnomaly 280
period double d Orbital Period [days] time.period.revolution;src.orbital 290
mean_motion double deg.d-1 Orbital Mean Motion [degrees per day] src.orbital.meanMotion 300
a_unc double AU Uncertainty on Semi Major Axis [au] stat.error;pos.distance;src.orbital 310
q_unc double AU Uncertainty on Pericenter Distance [au] stat.error;pos.distance;src.orbital 320
e_unc double Uncertainty on Eccentricity stat.error;src.orbital.eccentricity 330
i_unc double deg Uncertainty on Inclination [degrees] stat.error;src.orbital.inclination 340
node_unc double deg Uncertainty on Longitude of Ascending Node [degrees] stat.error;src.orbital.node 350
argperi_unc double deg Uncertainty on Argument of Pericenter [degrees] stat.error;src.orbital.periastron 360
peri_time_unc double d Uncertainty on Time from Pericenter Passage [days] 370
yarkovsky_unc double 1e-10.au.d-2 Uncertainty on Yarkovsky Component [10^(-10)*au/day^2] 380
srp_unc double m2.t-1 Uncertainty on Solar-Radiation Pressure Component [m^2/ton] 390
a1_unc double m2.t-1 Uncertainty on A1 non-grav components [m^2/ton] 400
a2_unc double m2.t-1 Uncertainty on A2 non-grav components [m^2/ton] 410
a3_unc double m2.t-1 Uncertainty on A3 non-grav components [m^2/ton] 420
dt_unc double Uncertainty on DT non-grav component 430
mean_anomaly_unc double deg Uncertainty on Mean Anomaly [degrees] stat.error;src.orbital.meanAnomaly 440
period_unc double d Uncertainty on Orbital Period [days] stat.error;time.period.revolution;src.orbital 450
mean_motion_unc double deg.d-1 Uncertainty on Orbital Mean Motion [degrees per day] stat.error;src.orbital.meanMotion 460
epoch_mjd double d Epoch of the Orbfit-Solution in MJD time.epoch;src.orbital 470
h double mag H-Magnitude phys.magAbs 480
g double G-Slope Parameter 490
not_normalized_rms double arcsec unnormalized rms of the fit [arcsec] stat.rms;stat.fit 500
normalized_rms double rms of the fit [unitless] stat.rms;stat.fit 510
earth_moid double AU Minimum Orbit Intersection Distance [au] with respect to the Earths Orbit pos.distance;src.orbital 520
fitting_datetime timestamp Date of the last orbit fit 530

SSObject

LSST-computed per-object quantities.

Column Name Data Type Unit Description UCD Order Principal
ssObjectId long Unique identifier. meta.id;src 10
designation char The unpacked primary provisional designation for this object. meta.id;src 20
nObs int Total number of LSST observations of this object. meta.number;obs 30
arc float d Timespan ("arc") of all LSST observations, t_{last} - t_{first} time.duration;obs 40
firstObservationMjdTai double d The time of the first LSST observation of this object (could be precovered), TAI. time.epoch;obs 50
MOIDEarth float AU Minimum orbit intersection distance to Earth. pos.distance;src.orbital 60
MOIDEarthDeltaV float km/s DeltaV at the MOID point. phys.veloc.orbital 70
MOIDEarthEclipticLongitude float deg Ecliptic longitude of the MOID point (Earth's orbit). pos.ecliptic.lon 80
MOIDEarthTrueAnomaly float deg True anomaly of the MOID point on Earth's orbit. pos.phaseAng 90
MOIDEarthTrueAnomalyObject float deg True anomaly of the MOID point on the object's orbit. pos.phaseAng;src.orbital 100
tisserand_J float Tisserand parameter with respect to Jupiter (T_J). src.orbital.TissJ 110
extendednessMax float Maximum `extendedness` value from the DiaSource. 120
extendednessMedian float Median `extendedness` value from the DiaSource. 130
extendednessMin float Minimum `extendedness` value from the DiaSource. 140
u_nObs int Total number of data points (u band). meta.number;obs 150
u_H float mag Best fit absolute magnitude (u band). phot.mag 160
u_HErr float mag Error in the estimate of H (u band). stat.error;phot.mag 170
u_G12 float Best fit G12 slope parameter (u band). stat.fit.param 180
u_G12Err float Error in the estimate of G12 (u band). stat.error;stat.fit.param 190
u_H_u_G12_Cov float mag**2 H–G12 covariance (u band). stat.covariance;phot.mag;stat.fit.param 200
u_nObsUsed int The number of data points used to fit the phase curve (u band). meta.number;obs 210
u_Chi2 float Chi^2 statistic of the phase curve fit (u band). stat.fit.chi2 220
u_phaseAngleMin float deg Minimum phase angle observed (u band). pos.phaseAng;stat.min 230
u_phaseAngleMax float deg Maximum phase angle observed (u band). pos.phaseAng;stat.max 240
u_slope_fit_failed boolean G12 fit failed in u band. G12 contains a fiducial value used to fit H. 250
g_nObs int Total number of data points (g band). meta.number;obs 260
g_H float mag Best fit absolute magnitude (g band). phot.mag 270
g_HErr float mag Error in the estimate of H (g band). stat.error;phot.mag 280
g_G12 float Best fit G12 slope parameter (g band). stat.fit.param 290
g_G12Err float Error in the estimate of G12 (g band). stat.error;stat.fit.param 300
g_H_g_G12_Cov float mag**2 H–G12 covariance (g band). stat.covariance;phot.mag;stat.fit.param 310
g_nObsUsed int The number of data points used to fit the phase curve (g band). meta.number;obs 320
g_Chi2 float Chi^2 statistic of the phase curve fit (g band). stat.fit.chi2 330
g_phaseAngleMin float deg Minimum phase angle observed (g band). pos.phaseAng;stat.min 340
g_phaseAngleMax float deg Maximum phase angle observed (g band). pos.phaseAng;stat.max 350
g_slope_fit_failed boolean G12 fit failed in g band. G12 contains a fiducial value used to fit H. 360
r_nObs int Total number of data points (r band). meta.number;obs 370
r_H float mag Best fit absolute magnitude (r band). phot.mag 380
r_HErr float mag Error in the estimate of H (r band). stat.error;phot.mag 390
r_G12 float Best fit G12 slope parameter (r band). stat.fit.param 400
r_G12Err float Error in the estimate of G12 (r band). stat.error;stat.fit.param 410
r_H_r_G12_Cov float mag**2 H–G12 covariance (r band). stat.covariance;phot.mag;stat.fit.param 420
r_nObsUsed int The number of data points used to fit the phase curve (r band). meta.number;obs 430
r_Chi2 float Chi^2 statistic of the phase curve fit (r band). stat.fit.chi2 440
r_phaseAngleMin float deg Minimum phase angle observed (r band). pos.phaseAng;stat.min 450
r_phaseAngleMax float deg Maximum phase angle observed (r band). pos.phaseAng;stat.max 460
r_slope_fit_failed boolean G12 fit failed in r band. G12 contains a fiducial value used to fit H. 470
i_nObs int Total number of data points (i band). meta.number;obs 480
i_H float mag Best fit absolute magnitude (i band). phot.mag 490
i_HErr float mag Error in the estimate of H (i band). stat.error;phot.mag 500
i_G12 float Best fit G12 slope parameter (i band). stat.fit.param 510
i_G12Err float Error in the estimate of G12 (i band). stat.error;stat.fit.param 520
i_H_i_G12_Cov float mag**2 H–G12 covariance (i band). stat.covariance;phot.mag;stat.fit.param 530
i_nObsUsed int The number of data points used to fit the phase curve (i band). meta.number;obs 540
i_Chi2 float Chi^2 statistic of the phase curve fit (i band). stat.fit.chi2 550
i_phaseAngleMin float deg Minimum phase angle observed (i band). pos.phaseAng;stat.min 560
i_phaseAngleMax float deg Maximum phase angle observed (i band). pos.phaseAng;stat.max 570
i_slope_fit_failed boolean G12 fit failed in i band. G12 contains a fiducial value used to fit H. 580
z_nObs int Total number of data points (z band). meta.number;obs 590
z_H float mag Best fit absolute magnitude (z band). phot.mag 600
z_HErr float mag Error in the estimate of H (z band). stat.error;phot.mag 610
z_G12 float Best fit G12 slope parameter (z band). stat.fit.param 620
z_G12Err float Error in the estimate of G12 (z band). stat.error;stat.fit.param 630
z_H_z_G12_Cov float mag**2 H–G12 covariance (z band). stat.covariance;phot.mag;stat.fit.param 640
z_nObsUsed int The number of data points used to fit the phase curve (z band). meta.number;obs 650
z_Chi2 float Chi^2 statistic of the phase curve fit (z band). stat.fit.chi2 660
z_phaseAngleMin float deg Minimum phase angle observed (z band). pos.phaseAng;stat.min 670
z_phaseAngleMax float deg Maximum phase angle observed (z band). pos.phaseAng;stat.max 680
z_slope_fit_failed boolean G12 fit failed in z band. G12 contains a fiducial value used to fit H. 690
y_nObs int Total number of data points (y band). meta.number;obs 700
y_H float mag Best fit absolute magnitude (y band). phot.mag 710
y_HErr float mag Error in the estimate of H (y band). stat.error;phot.mag 720
y_G12 float Best fit G12 slope parameter (y band). stat.fit.param 730
y_G12Err float Error in the estimate of G12 (y band). stat.error;stat.fit.param 740
y_H_y_G12_Cov float mag**2 H–G12 covariance (y band). stat.covariance;phot.mag;stat.fit.param 750
y_nObsUsed int The number of data points used to fit the phase curve (y band). meta.number;obs 760
y_Chi2 float Chi^2 statistic of the phase curve fit (y band). stat.fit.chi2 770
y_phaseAngleMin float deg Minimum phase angle observed (y band). pos.phaseAng;stat.min 780
y_phaseAngleMax float deg Maximum phase angle observed (y band). pos.phaseAng;stat.max 790
y_slope_fit_failed boolean G12 fit failed in y band. G12 contains a fiducial value used to fit H. 800

SSSource

Solar System source measurements: one row per Rubin observation submitted to and accepted by the MPC (obs_sbn), with the measurement it was submitted from (a DiaSource or a Source, see measuredOn) and its ephemeris from mpc_orbits. Built from the record of submitted measurements, independent of the PPDB DiaSource table (RFC-1188).

Column Name Data Type Unit Description UCD Order Principal
obsid char MPC's unique identifier of the observation (obs_sbn.obsid): the obs_sbn row this SSSource row is. The primary key. meta.id;meta.main 10
trksub char Observer-assigned tracklet identifier, as submitted (obs_sbn.trksub). meta.id 20
trkid char MPC-assigned tracklet identifier (obs_sbn.trkid). meta.id 30
submission_id char Identifier of the MPC submission this observation arrived in (obs_sbn.submission_id). meta.id 40
status char MPC status of the observation (obs_sbn.status). 'I' marks observations in the Isolated Tracklet File: accepted as valid, but not identified with a known object. meta.code.status 50
primary boolean True on exactly one row per measurement (processing, diaSourceId/sourceId): the '-A' row of a trail pair, else the row from the earliest submission. A measurement submitted more than once has several rows; count only primary rows when counting detections. meta.code 60
matchMethod char How the measurement this observation was submitted from was found: 'obssubid' (its obsSubID, LSST-<processing>-<id> or a bare id, looked up and verified by position and time), 'obssubid_trail' (a trailed source submitted as two obs_sbn rows, '-A' and '-B', one per trail end, verified at their midpoint) or 'position' (a position and time search, where the obsSubID didn't parse or verify). meta.code 70
ssObjectId long Unique LSST identifier of the Solar System object (SSObject.ssObjectId). NULL when this observation is not identified with an object that has an SSObject row: Isolated Tracklet File observations (status 'I'), and designated objects missing from mpc_orbits. meta.id;src 80
designation char The unpacked primary provisional designation of the object the MPC identified this observation with; NULL if none. meta.id;src 90
measuredOn char Kind of image the row was measured on: 'difference' for DiaSource rows, 'science' for Source rows. meta.code 100
processing char Processing label, e.g. AP-DS, pDP2-DS or NV-S: which (re)processing the row belongs to. (processing, id) is the key, and obsSubID is LSST-<processing>-<id>. Named collection in v1. meta.id 110
processingTable char Fully qualified ssp table the row came from, e.g. ssp.dia_source_ppdb_rel2; provenance runs from there to the table's ingest YAML and acid manifests. meta.ref 120
diaSourceId long Identifier of the DiaSource this observation was measured as (DiaSource.diaSourceId in its processing); NULL on Source rows (measuredOn = 'science'). meta.id;obs.image 130
sourceId long Identifier of the Source this observation was measured as (Source.sourceId in its processing); NULL on DiaSource rows (measuredOn = 'difference'). meta.id;obs.image 140
parentDiaSourceId long Id of the parent DiaSource this one was deblended from, if any; NULL on Source rows. meta.id.parent;src 150
parentSourceId long Id of the parent Source this one was deblended from, if any; NULL on DiaSource rows. meta.id.parent;src 160
visit long Visit id. DiaSource visit; Source visit. meta.id;obs.image 170
detector short Detector id. DiaSource detector; Source detector. meta.id;obs.image 180
midpointMjdTai double d Exposure midpoint, TAI MJD. DiaSource midpointMjdTai; on Source rows the visit's exposure midpoint (the export's mjd column). Named mjd_tai in v1. time.epoch 190
exposureTime float s Measured exposure (shutter-open) time of the visit, s: ConsDB exposure.shut_time (= Butler visitInfo.exposureTime), looked up by visit in ssp.visit_exposure on every branch. NULL where ConsDB has no value or the table lacks the visit; never the requested or nominal time. time.interval 200
ra double deg Right ascension of the centroid, degrees. DiaSource ra; Source ra (AP-S: coord_ra). pos.eq.ra 210
raErr float deg Uncertainty of ra (of RA*cos(Dec)), degrees. DiaSource raErr; Source raErr (AP-S: coord_raErr). stat.error;pos.eq.ra 220
dec double deg Declination of the centroid, degrees. DiaSource dec; Source dec (AP-S: coord_dec). pos.eq.dec 230
decErr float deg Uncertainty of dec, degrees. DiaSource decErr; Source decErr (AP-S: coord_decErr). stat.error;pos.eq.dec 240
ra_dec_Cov float deg**2 Covariance of ra (RA*cos(Dec)) and dec, degrees^2. DiaSource ra_dec_Cov; Source ra_dec_Cov (AP-S: coord_ra_dec_Cov). NULL on 001-DS. stat.covariance 250
x float pixel Centroid x on the detector, pixels. DiaSource x; Source x (AP-S: slot_Centroid_x). pos.cartesian.x 260
xErr float pixel Uncertainty of x, pixels. DiaSource xErr; Source xErr (AP-S: slot_Centroid_xErr). stat.error;pos.cartesian.x 270
y float pixel Centroid y on the detector, pixels. DiaSource y; Source y (AP-S: slot_Centroid_y). pos.cartesian.y 280
yErr float pixel Uncertainty of y, pixels. DiaSource yErr; Source yErr (AP-S: slot_Centroid_yErr). stat.error;pos.cartesian.y 290
centroid_flag boolean General centroid failure flag. DiaSource centroid_flag; Source centroid_flag (AP-S: slot_Centroid_flag). 300
apFlux float nJy Flux in the 12 pixel (2.4 arcsec) radius circular aperture, nJy, not aperture-corrected. DiaSource apFlux (difference image); Source ap12Flux (AP-S: base_CircularApertureFlux_12_0_instFlux calibrated with base_LocalPhotoCalib). phot.count 310
apFluxErr float nJy Uncertainty of apFlux, nJy. DiaSource apFluxErr; Source ap12FluxErr (AP-S: calibrated in full quadrature with base_LocalPhotoCalibErr). stat.error;phot.count 320
apMag float mag AB magnitude of apFlux: 31.4 - 2.5*log10(apFlux/nJy), NULL when apFlux <= 0; computed on read, never stored. DiaSource (ppdb) apMag; Source ap12Mag. phot.mag 330
apMagErr float mag Uncertainty of apMag: 1.0857*apFluxErr/apFlux, NULL when apFlux <= 0; computed on read. DiaSource (ppdb) apMagErr; Source ap12MagErr. stat.error;phot.mag 340
apFlux_flag boolean Failure flag of the 12 px aperture flux. DiaSource apFlux_flag; Source ap12Flux_flag (AP-S: base_CircularApertureFlux_12_0_flag). 350
apFlux_flag_apertureTruncated boolean The 12 px aperture did not fit within the image. DiaSource apFlux_flag_apertureTruncated; Source apFlux_12_0_flag_apertureTruncated (AP-S: base_CircularApertureFlux_12_0_flag_apertureTruncated). 360
ap03Flux float nJy Flux in the 3 pixel (0.6 arcsec) radius circular aperture, nJy, not aperture-corrected. Source ap03Flux (AP-S: base_CircularApertureFlux_3_0_instFlux calibrated with base_LocalPhotoCalib). Source-only extra: DiaSource measures only the 12 px aperture, so NULL on DiaSource rows. phot.flux 370
ap03FluxErr float nJy Uncertainty of ap03Flux, nJy. Source ap03FluxErr (AP-S: calibrated in full quadrature with base_LocalPhotoCalibErr). Source-only extra: DiaSource measures only the 12 px aperture, so NULL on DiaSource rows. stat.error;phot.flux 380
ap03Mag float mag AB magnitude of ap03Flux: 31.4 - 2.5*log10(ap03Flux/nJy), NULL when ap03Flux <= 0; computed on read, never stored. Source ap03Mag. Source-only extra: DiaSource measures only the 12 px aperture, so NULL on DiaSource rows. phot.mag 390
ap03MagErr float mag Uncertainty of ap03Mag: 1.0857*ap03FluxErr/ap03Flux, NULL when ap03Flux <= 0; computed on read. Source ap03MagErr. Source-only extra: DiaSource measures only the 12 px aperture, so NULL on DiaSource rows. stat.error;phot.mag 400
ap03Flux_flag boolean Failure flag of the 3 px aperture flux. Source ap03Flux_flag (AP-S: base_CircularApertureFlux_3_0_flag). Source-only extra: DiaSource measures only the 12 px aperture, so NULL on DiaSource rows. meta.code 410
ap03Flux_flag_apertureTruncated boolean The 3 px aperture did not fit within the image. AP-S base_CircularApertureFlux_3_0_flag_apertureTruncated; NULL on NV-S and DP2-S, whose catalogs carry a truncation flag for the 12 px aperture only. Source-only extra: DiaSource measures only the 12 px aperture, so NULL on DiaSource rows. meta.code 420
ap06Flux float nJy Flux in the 6 pixel (1.2 arcsec) radius circular aperture, nJy, not aperture-corrected. Source ap06Flux (AP-S: base_CircularApertureFlux_6_0_instFlux calibrated with base_LocalPhotoCalib). Source-only extra: DiaSource measures only the 12 px aperture, so NULL on DiaSource rows. phot.flux 430
ap06FluxErr float nJy Uncertainty of ap06Flux, nJy. Source ap06FluxErr (AP-S: calibrated in full quadrature with base_LocalPhotoCalibErr). Source-only extra: DiaSource measures only the 12 px aperture, so NULL on DiaSource rows. stat.error;phot.flux 440
ap06Mag float mag AB magnitude of ap06Flux: 31.4 - 2.5*log10(ap06Flux/nJy), NULL when ap06Flux <= 0; computed on read, never stored. Source ap06Mag. Source-only extra: DiaSource measures only the 12 px aperture, so NULL on DiaSource rows. phot.mag 450
ap06MagErr float mag Uncertainty of ap06Mag: 1.0857*ap06FluxErr/ap06Flux, NULL when ap06Flux <= 0; computed on read. Source ap06MagErr. Source-only extra: DiaSource measures only the 12 px aperture, so NULL on DiaSource rows. stat.error;phot.mag 460
ap06Flux_flag boolean Failure flag of the 6 px aperture flux. Source ap06Flux_flag (AP-S: base_CircularApertureFlux_6_0_flag). Source-only extra: DiaSource measures only the 12 px aperture, so NULL on DiaSource rows. meta.code 470
ap06Flux_flag_apertureTruncated boolean The 6 px aperture did not fit within the image. AP-S base_CircularApertureFlux_6_0_flag_apertureTruncated; NULL on NV-S and DP2-S, whose catalogs carry a truncation flag for the 12 px aperture only. Source-only extra: DiaSource measures only the 12 px aperture, so NULL on DiaSource rows. meta.code 480
ap25Flux float nJy Flux in the 25 pixel (5.0 arcsec) radius circular aperture, nJy, not aperture-corrected. Source ap25Flux (AP-S: base_CircularApertureFlux_25_0_instFlux calibrated with base_LocalPhotoCalib). Source-only extra: DiaSource measures only the 12 px aperture, so NULL on DiaSource rows. phot.flux 490
ap25FluxErr float nJy Uncertainty of ap25Flux, nJy. Source ap25FluxErr (AP-S: calibrated in full quadrature with base_LocalPhotoCalibErr). Source-only extra: DiaSource measures only the 12 px aperture, so NULL on DiaSource rows. stat.error;phot.flux 500
ap25Mag float mag AB magnitude of ap25Flux: 31.4 - 2.5*log10(ap25Flux/nJy), NULL when ap25Flux <= 0; computed on read, never stored. Source ap25Mag. Source-only extra: DiaSource measures only the 12 px aperture, so NULL on DiaSource rows. phot.mag 510
ap25MagErr float mag Uncertainty of ap25Mag: 1.0857*ap25FluxErr/ap25Flux, NULL when ap25Flux <= 0; computed on read. Source ap25MagErr. Source-only extra: DiaSource measures only the 12 px aperture, so NULL on DiaSource rows. stat.error;phot.mag 520
ap25Flux_flag boolean Failure flag of the 25 px aperture flux. Source ap25Flux_flag (AP-S: base_CircularApertureFlux_25_0_flag). Source-only extra: DiaSource measures only the 12 px aperture, so NULL on DiaSource rows. meta.code 530
ap25Flux_flag_apertureTruncated boolean The 25 px aperture did not fit within the image. AP-S base_CircularApertureFlux_25_0_flag_apertureTruncated; NULL on NV-S and DP2-S, whose catalogs carry a truncation flag for the 12 px aperture only. Source-only extra: DiaSource measures only the 12 px aperture, so NULL on DiaSource rows. meta.code 540
isNegative boolean Detected as significantly negative on the difference image. DiaSource isNegative; no Source equivalent (NULL on Source rows). 550
snr float Signal-to-noise ratio of the detection on the difference image. DiaSource snr; no Source equivalent. stat.snr 560
psfFlux float nJy PSF-model flux, nJy. DiaSource psfFlux (on the difference image, the visit-minus-template flux); Source psfFlux (AP-S: base_PsfFlux_instFlux calibrated with base_LocalPhotoCalib). phot.count 570
psfFluxErr float nJy Uncertainty of psfFlux, nJy. DiaSource psfFluxErr; Source psfFluxErr (AP-S: calibrated in full quadrature with base_LocalPhotoCalibErr). 580
psfMag float mag AB magnitude of psfFlux: 31.4 - 2.5*log10(psfFlux/nJy), NULL when psfFlux <= 0; computed on read, never stored. DiaSource (ppdb) psfMag; Source psfMag. On 001-DS psfFlux was rebuilt from the submitted magnitude, so the two agree only to submission rounding. phot.mag 590
psfMagErr float mag Uncertainty of psfMag: 1.0857*psfFluxErr/psfFlux, NULL when psfFlux <= 0; computed on read. DiaSource (ppdb) psfMagErr; Source psfMagErr. stat.error;phot.mag 600
psfLnL float Natural log-likelihood of the PSF-model fit. DiaSource psfLnL (prompt and PPDB tables only); no Source equivalent. stat.likelihood 610
psfChi2 float Chi^2 of the PSF-model fit. DiaSource psfChi2; AP-S base_PsfFlux_chi2; NULL on NV-S and DP2-S. stat.fit.chi2 620
psfNdata int Number of pixels used in the PSF-model fit. DiaSource psfNdata; AP-S base_PsfFlux_npixels; NULL on NV-S and DP2-S. 630
psfFlux_flag boolean PSF-flux fit failure flag. DiaSource psfFlux_flag; Source psfFlux_flag (AP-S: base_PsfFlux_flag). 640
psfFlux_flag_edge boolean Too close to the image edge for the full PSF model. DiaSource psfFlux_flag_edge; Source psfFlux_flag_edge (AP-S: base_PsfFlux_flag_edge). 650
psfFlux_flag_noGoodPixels boolean Not enough non-rejected pixels to fit the PSF model. DiaSource psfFlux_flag_noGoodPixels; Source psfFlux_flag_noGoodPixels (AP-S: base_PsfFlux_flag_noGoodPixels). 660
trailFlux float nJy Flux of the trailed-source model fit, nJy (visit-minus-template). DiaSource trailFlux; no Source equivalent. 670
trailFluxErr float nJy Uncertainty of trailFlux, nJy. DiaSource trailFluxErr (not in the RFL and DP1 tables); no Source equivalent. 680
trailMag float mag AB magnitude of trailFlux: 31.4 - 2.5*log10(trailFlux/nJy), NULL when trailFlux <= 0; computed on read, never stored. DiaSource (ppdb) trailMag; no Source equivalent. phot.mag 690
trailMagErr float mag Uncertainty of trailMag: 1.0857*trailFluxErr/trailFlux, NULL when trailFlux <= 0; computed on read. DiaSource (ppdb) trailMagErr; no Source equivalent. stat.error;phot.mag 700
trailRa double deg Right ascension of the trailed-model centroid, degrees. DiaSource trailRa; no Source equivalent. pos.eq.ra 710
trailRaErr float deg Uncertainty of trailRa (of RA*cos(Dec)), degrees. DiaSource trailRaErr (prompt and PPDB tables only); no Source equivalent. stat.error;pos.eq.ra 720
trailDec double deg Declination of the trailed-model centroid, degrees. DiaSource trailDec; no Source equivalent. pos.eq.dec 730
trailDecErr float deg Uncertainty of trailDec, degrees. DiaSource trailDecErr (prompt and PPDB tables only); no Source equivalent. stat.error;pos.eq.dec 740
trailLength float arcsec Maximum-likelihood trail length, arcsec. DiaSource trailLength; no Source equivalent. 750
trailLengthErr float arcsec Uncertainty of trailLength, arcsec. DiaSource trailLengthErr (prompt and PPDB tables only); no Source equivalent. 760
trailAngle float deg Maximum-likelihood angle between the meridian through the centroid and the trail (bearing), degrees. DiaSource trailAngle; no Source equivalent. 770
trailAngleErr float deg Uncertainty of trailAngle, degrees. DiaSource trailAngleErr (prompt and PPDB tables only); no Source equivalent. 780
trailChi2 float Chi^2 of the trailed-source model fit. DiaSource trailChi2 (prompt and PPDB tables only); no Source equivalent. stat.fit.chi2 790
trailNdata int Number of pixels used in the trailed-source fit. DiaSource trailNdata (prompt and PPDB tables only); no Source equivalent. 800
trailAlgorithm int Trail-fit algorithm key, 1=SDSSShape, 2=HSMShape (DiaSource trailAlgorithm, new in ApdbSchema 10.0.0). Filled on dia_source_prompt_20260708 (Prompt Processing from 20260708); NULL on every other table. 810
trail_flag_edge boolean The trailed source extends onto or past edge pixels. DiaSource trail_flag_edge; no Source equivalent. 820
trail_flag boolean The trailed-source fit failed (DiaSource trail_flag, new in ApdbSchema 10.0.0). Filled on dia_source_prompt_20260708 (Prompt Processing from 20260708); NULL on every other table. 830
dipoleMeanFlux float nJy Maximum-likelihood mean absolute flux of the two lobes of a dipole model, nJy. DiaSource dipoleMeanFlux; no Source equivalent. 840
dipoleMeanFluxErr float nJy Uncertainty of dipoleMeanFlux, nJy. DiaSource dipoleMeanFluxErr; no Source equivalent. stat.error 850
dipoleMeanMag float mag AB magnitude of dipoleMeanFlux: 31.4 - 2.5*log10(dipoleMeanFlux/nJy), NULL when dipoleMeanFlux <= 0; computed on read, never stored. DiaSource (ppdb) dipoleMeanMag; no Source equivalent. phot.mag 860
dipoleMeanMagErr float mag Uncertainty of dipoleMeanMag: 1.0857*dipoleMeanFluxErr/dipoleMeanFlux, NULL when dipoleMeanFlux <= 0; computed on read. DiaSource (ppdb) dipoleMeanMagErr; no Source equivalent. stat.error;phot.mag 870
dipoleFluxDiff float nJy Maximum-likelihood difference of the absolute fluxes of the two dipole lobes, nJy. DiaSource dipoleFluxDiff; no Source equivalent. 880
dipoleFluxDiffErr float nJy Uncertainty of dipoleFluxDiff, nJy. DiaSource dipoleFluxDiffErr; no Source equivalent. stat.error 890
dipoleLength float arcsec Maximum-likelihood lobe separation of the dipole model, arcsec. DiaSource dipoleLength; no Source equivalent. pos.angDistance 900
dipoleAngle float deg Maximum-likelihood bearing of the dipole, negative to positive lobe, degrees. DiaSource dipoleAngle; no Source equivalent. pos.posAng 910
dipoleChi2 float Chi^2 of the dipole model fit. DiaSource dipoleChi2; no Source equivalent. stat.fit.chi2 920
dipoleNdata int Number of pixels used in the dipole fit. DiaSource dipoleNdata; no Source equivalent. 930
scienceFlux float nJy Forced PSF flux on the science (visit) image at the DiaSource position, nJy. DiaSource scienceFlux; NULL on Source rows (never filled from psfFlux). phot.count 940
scienceFluxErr float nJy Uncertainty of scienceFlux, nJy. DiaSource scienceFluxErr; NULL on Source rows. stat.error;phot.count 950
scienceMag float mag AB magnitude of scienceFlux: 31.4 - 2.5*log10(scienceFlux/nJy), NULL when scienceFlux <= 0; computed on read, never stored. DiaSource (ppdb) scienceMag; NULL on Source rows. phot.mag 960
scienceMagErr float mag Uncertainty of scienceMag: 1.0857*scienceFluxErr/scienceFlux, NULL when scienceFlux <= 0; computed on read. DiaSource (ppdb) scienceMagErr; NULL on Source rows. stat.error;phot.mag 970
forced_PsfFlux_flag boolean Forced PSF photometry on the science image (scienceFlux) failed. DiaSource forced_PsfFlux_flag; no Source equivalent. 980
forced_PsfFlux_flag_edge boolean scienceFlux was too close to the image edge for the full PSF model. DiaSource forced_PsfFlux_flag_edge; no Source equivalent. 990
forced_PsfFlux_flag_noGoodPixels boolean Not enough non-rejected pixels for scienceFlux. DiaSource forced_PsfFlux_flag_noGoodPixels; no Source equivalent. 1000
templateFlux float nJy Forced PSF flux on the template image at the DiaObject position, nJy. DiaSource templateFlux (DP2 and PPDB tables; prompt eras from 20250905); no Source equivalent. phot.count 1010
templateFluxErr float nJy Uncertainty of templateFlux, nJy. DiaSource templateFluxErr; no Source equivalent. stat.error;phot.count 1020
templateMag float mag AB magnitude of templateFlux: 31.4 - 2.5*log10(templateFlux/nJy), NULL when templateFlux <= 0; computed on read, never stored. DiaSource (ppdb) templateMag; no Source equivalent. phot.mag 1030
templateMagErr float mag Uncertainty of templateMag: 1.0857*templateFluxErr/templateFlux, NULL when templateFlux <= 0; computed on read. DiaSource (ppdb) templateMagErr; no Source equivalent. stat.error;phot.mag 1040
ixx float arcsec**2 Adaptive second moment xx of the source, arcsec^2. DiaSource ixx; AP-S ext_shapeHSM_HsmSourceMoments_xx converted from pixels^2 with the local WCS (base_LocalWcs_CDMatrix_*) exactly as pipe_tasks ConvertPixelSqToArcsecondsSq does for DiaSource; NULL on NV-S and DP2-S, whose moments are in pixels^2 with no local WCS. 1050
iyy float arcsec**2 Adaptive second moment yy of the source, arcsec^2. DiaSource iyy; AP-S ext_shapeHSM_HsmSourceMoments_yy converted from pixels^2 with the local WCS (base_LocalWcs_CDMatrix_*) exactly as pipe_tasks ConvertPixelSqToArcsecondsSq does for DiaSource; NULL on NV-S and DP2-S, whose moments are in pixels^2 with no local WCS. 1060
ixy float arcsec**2 Adaptive second moment xy of the source, arcsec^2. DiaSource ixy; AP-S ext_shapeHSM_HsmSourceMoments_xy converted from pixels^2 with the local WCS (base_LocalWcs_CDMatrix_*) exactly as pipe_tasks ConvertPixelSqToArcsecondsSq does for DiaSource; NULL on NV-S and DP2-S, whose moments are in pixels^2 with no local WCS. 1070
ixxPSF float arcsec**2 Adaptive second moment xx of the PSF, arcsec^2. DiaSource ixxPSF; AP-S ext_shapeHSM_HsmPsfMoments_xx converted from pixels^2 with the local WCS (base_LocalWcs_CDMatrix_*) exactly as pipe_tasks ConvertPixelSqToArcsecondsSq does for DiaSource; NULL on NV-S and DP2-S, whose moments are in pixels^2 with no local WCS. 1080
iyyPSF float arcsec**2 Adaptive second moment yy of the PSF, arcsec^2. DiaSource iyyPSF; AP-S ext_shapeHSM_HsmPsfMoments_yy converted from pixels^2 with the local WCS (base_LocalWcs_CDMatrix_*) exactly as pipe_tasks ConvertPixelSqToArcsecondsSq does for DiaSource; NULL on NV-S and DP2-S, whose moments are in pixels^2 with no local WCS. 1090
ixyPSF float arcsec**2 Adaptive second moment xy of the PSF, arcsec^2. DiaSource ixyPSF; AP-S ext_shapeHSM_HsmPsfMoments_xy converted from pixels^2 with the local WCS (base_LocalWcs_CDMatrix_*) exactly as pipe_tasks ConvertPixelSqToArcsecondsSq does for DiaSource; NULL on NV-S and DP2-S, whose moments are in pixels^2 with no local WCS. 1100
shape_flag boolean Source-moment failure flag. DiaSource shape_flag; AP-S ext_shapeHSM_HsmSourceMoments_flag; NULL on NV-S and DP2-S. 1110
shape_flag_no_pixels boolean No pixels to measure the moments. DiaSource shape_flag_no_pixels; AP-S ext_shapeHSM_HsmSourceMoments_flag_no_pixels; NULL on NV-S and DP2-S. 1120
shape_flag_not_contained boolean Centroid not contained in the footprint's bounding box. DiaSource shape_flag_not_contained; AP-S ext_shapeHSM_HsmSourceMoments_flag_not_contained; NULL on NV-S and DP2-S. 1130
shape_flag_parent_source boolean A deblend parent; moments are measured on children only. DiaSource shape_flag_parent_source; AP-S ext_shapeHSM_HsmSourceMoments_flag_parent_source; NULL on NV-S and DP2-S. 1140
extendedness float Size-based extendedness classifier (moment-based traced radius vs the PSF's). DiaSource extendedness; Source sizeExtendedness (AP-S: base_ClassificationSizeExtendedness_value), NOT Source extendedness, which is the model-based classifier. 1150
reliability float Probability (0-1) that the detection is astrophysical, from a machine-learning model. DiaSource reliability; no Source equivalent. 1160
reliabilityVersion string Version of the reliability model (DiaSource reliabilityVersion, new in ApdbSchema 10.0.0). Filled on dia_source_prompt_20260708 (Prompt Processing from 20260708); NULL on every other table. 1170
band char Filter band. DiaSource band; Source band (from the data id). 1180
isDipole boolean Well fit by a dipole model. DiaSource isDipole; no Source equivalent. 1190
dipoleFitAttempted boolean A dipole fit was attempted. DiaSource dipoleFitAttempted; no Source equivalent. 1200
bboxSize int pixel Side of the square bounding box containing the footprint, pixels. DiaSource bboxSize; no Source equivalent. 1210
pixelFlags boolean Failure flag of the pixel-flag measurement: when set, the other pixelFlags_* may be wrongly False. DiaSource pixelFlags; AP-S base_PixelFlags_flag; NULL on NV-S and DP2-S. 1220
pixelFlags_bad boolean Bad pixel in the footprint. DiaSource pixelFlags_bad; Source pixelFlags_bad (AP-S: base_PixelFlags_flag_bad). 1230
pixelFlags_cr boolean Cosmic ray in the footprint. DiaSource pixelFlags_cr; Source pixelFlags_cr (AP-S: base_PixelFlags_flag_cr). 1240
pixelFlags_crCenter boolean Cosmic ray in the 3x3 region around the centroid. DiaSource pixelFlags_crCenter; Source pixelFlags_crCenter (AP-S: base_PixelFlags_flag_crCenter). 1250
pixelFlags_edge boolean Some of the footprint is outside the usable exposure region (masked EDGE, or centroid off image). DiaSource pixelFlags_edge; Source pixelFlags_edge (AP-S: base_PixelFlags_flag_edge). 1260
pixelFlags_nodata boolean NO_DATA pixel in the footprint. DiaSource pixelFlags_nodata (not in pDP1-DS); Source pixelFlags_nodata (AP-S: base_PixelFlags_flag_nodata). 1270
pixelFlags_nodataCenter boolean NO_DATA pixel in the 3x3 region around the centroid. DiaSource pixelFlags_nodataCenter (not in pDP1-DS); AP-S base_PixelFlags_flag_nodataCenter; NULL on NV-S and DP2-S, whose catalogs do not carry it. 1280
pixelFlags_interpolated boolean Interpolated pixel in the footprint. DiaSource pixelFlags_interpolated; Source pixelFlags_interpolated (AP-S: base_PixelFlags_flag_interpolated). 1290
pixelFlags_interpolatedCenter boolean Interpolated pixel in the 3x3 region around the centroid. DiaSource pixelFlags_interpolatedCenter; Source pixelFlags_interpolatedCenter (AP-S: base_PixelFlags_flag_interpolatedCenter). 1300
pixelFlags_offimage boolean Source center is off image. DiaSource pixelFlags_offimage; Source pixelFlags_offimage (AP-S: base_PixelFlags_flag_offimage). 1310
pixelFlags_saturated boolean Saturated pixel in the footprint. DiaSource pixelFlags_saturated; Source pixelFlags_saturated (AP-S: base_PixelFlags_flag_saturated). 1320
pixelFlags_saturatedCenter boolean Saturated pixel in the 3x3 region around the centroid. DiaSource pixelFlags_saturatedCenter; Source pixelFlags_saturatedCenter (AP-S: base_PixelFlags_flag_saturatedCenter). 1330
pixelFlags_suspect boolean Suspect pixel in the footprint. DiaSource pixelFlags_suspect; Source pixelFlags_suspect (AP-S: base_PixelFlags_flag_suspect). 1340
pixelFlags_suspectCenter boolean Suspect pixel in the 3x3 region around the centroid. DiaSource pixelFlags_suspectCenter; Source pixelFlags_suspectCenter (AP-S: base_PixelFlags_flag_suspectCenter). 1350
pixelFlags_streak boolean Streak in the footprint. DiaSource pixelFlags_streak; no Source equivalent. 1360
pixelFlags_streakCenter boolean Streak in the 3x3 region around the centroid. DiaSource pixelFlags_streakCenter; no Source equivalent. 1370
pixelFlags_injected boolean Injection in the footprint. DiaSource pixelFlags_injected; no Source equivalent. 1380
pixelFlags_injectedCenter boolean Injection in the 3x3 region around the centroid. DiaSource pixelFlags_injectedCenter; no Source equivalent. 1390
pixelFlags_injected_template boolean Template injection in the footprint. DiaSource pixelFlags_injected_template; no Source equivalent. 1400
pixelFlags_injected_templateCenter boolean Template injection in the 3x3 region around the centroid. DiaSource pixelFlags_injected_templateCenter; no Source equivalent. 1410
glint_trail boolean Part of a satellite glint trail. DiaSource glint_trail (DP2 and PPDB tables; prompt eras from 20250905); no Source equivalent. 1420
eclLambda double deg Ecliptic longitude, converted from the observed coordinates. pos.ecliptic.lon 1430
eclBeta double deg Ecliptic latitude, converted from the observed coordinates. pos.ecliptic.lat 1440
galLon double deg Galactic longitude, converted from the observed coordinates. pos.galactic.lon 1450
galLat double deg Galactic latitude, converted from the observed coordinates. pos.galactic.lat 1460
elongation float deg Solar elongation of the object at the time of observation. pos.phaseAng 1470
phaseAngle float deg Phase angle between the Sun, object, and observer. pos.phaseAng 1480
topoRange float AU Topocentric distance (delta) at light-emission time. pos.distance 1490
topoRangeRate float km/s Topocentric radial (line-of-sight) velocity (deldot); positive values indicate motion away from the observer. phys.veloc 1500
helioRange float AU Heliocentric distance (r) at light-emission time. pos.distance;pos.heliocentric 1510
helioRangeRate float km/s Heliocentric radial velocity (rdot); positive values indicate motion away from the Sun. phys.veloc;pos.heliocentric 1520
ephRa double deg Predicted ICRS right ascension from the orbit in mpc_orbits. pos.eq.ra;meta.modelled;pos.ephem 1530
ephRaErr float deg 1-sigma uncertainty of ephRa (on the sky, i.e. including the cos(dec) factor), propagated from the mpc_orbits covariance. stat.error;pos.eq.ra;pos.ephem 1540
ephDec double deg Predicted ICRS declination from the orbit in mpc_orbits. pos.eq.dec;meta.modelled;pos.ephem 1550
ephDecErr float deg 1-sigma uncertainty of ephDec, propagated from the mpc_orbits covariance. stat.error;pos.eq.dec;pos.ephem 1560
ephRa_ephDec_Cov float deg**2 Covariance between ephRa (on the sky) and ephDec; with ephRaErr and ephDecErr, the predicted position's error ellipse, in the convention of raErr, decErr and ra_dec_Cov. stat.covariance;pos.eq;pos.ephem 1570
ephVmag float mag Predicted magnitude in V band, computed from mpc_orbits data including the mpc_orbits-provided (H, G) estimates phot.mag;em.opt.V 1580
ephRate float deg/d Total predicted on-sky angular rate of motion. pos.pm;pos.ephem 1590
ephRateRa float deg/d Predicted on-sky angular rate in the R.A. direction (includes the cos(dec) factor). pos.pm;pos.eq.ra;pos.ephem 1600
ephRateDec float deg/d Predicted on-sky angular rate in the declination direction. pos.pm;pos.eq.dec;pos.ephem 1610
ephOffset float arcsec Total observed versus predicted angular separation on the sky. pos.angDistance;stat.fit.omc 1620
ephOffsetRa double arcsec Offset between observed and predicted position in the R.A. direction (includes cos(dec) term). pos.eq.ra;stat.fit.omc 1630
ephOffsetDec double arcsec Offset between observed and predicted position in declination. pos.eq.dec;stat.fit.omc 1640
ephOffsetAlongTrack float arcsec Offset between observed and predicted position in the along-track direction on the sky. pos.angDistance;stat.fit.omc 1650
ephOffsetCrossTrack float arcsec Offset between observed and predicted position in the cross-track direction on the sky. pos.angDistance;stat.fit.omc 1660
helio_x float AU Cartesian heliocentric X coordinate at light-emission time (ICRS). pos.cartesian.x;pos.heliocentric 1670
helio_y float AU Cartesian heliocentric Y coordinate at light-emission time (ICRS). pos.cartesian.y;pos.heliocentric 1680
helio_z float AU Cartesian heliocentric Z coordinate at light-emission time (ICRS). pos.cartesian.z;pos.heliocentric 1690
helio_vx float km/s Cartesian heliocentric X velocity at light-emission time (ICRS). phys.veloc;pos.cartesian.x 1700
helio_vy float km/s Cartesian heliocentric Y velocity at light-emission time (ICRS). phys.veloc;pos.cartesian.y 1710
helio_vz float km/s Cartesian heliocentric Z velocity at light-emission time (ICRS). phys.veloc;pos.cartesian.z 1720
helio_vtot float km/s The magnitude of the heliocentric velocity vector, sqrt(vx*vx + vy*vy + vz*vz). phys.veloc;pos.heliocentric 1730
topo_x float AU Cartesian topocentric X coordinate at light-emission time (ICRS). pos.cartesian.x 1740
topo_y float AU Cartesian topocentric Y coordinate at light-emission time (ICRS). pos.cartesian.y 1750
topo_z float AU Cartesian topocentric Z coordinate at light-emission time (ICRS). pos.cartesian.z 1760
topo_vx float km/s Cartesian topocentric X velocity at light-emission time (ICRS). phys.veloc;pos.cartesian.x 1770
topo_vy float km/s Cartesian topocentric Y velocity at light-emission time (ICRS). phys.veloc;pos.cartesian.y 1780
topo_vz float km/s Cartesian topocentric Z velocity at light-emission time (ICRS). phys.veloc;pos.cartesian.z 1790
topo_vtot float km/s The magnitude of the topocentric velocity vector, sqrt(vx*vx + vy*vy + vz*vz). phys.veloc 1800

NearbySSO

For each DiaSource, the nearest known Solar System object whose predicted position (from mpc_orbits) is within the matching radius, and whose predicted 1-sigma uncertainty is small enough for the association to be meaningful. Regenerated daily (RFC-1188).

Column Name Data Type Unit Description UCD Order Principal
diaSourceId long Unique identifier of the DiaSource. meta.id;obs.image 10
ssObjectId long Id of the SSObject found within a matching radius of this source, if any; NULL if the object has no SSObject row. meta.id;src 20
designation char The primary provisional designation in unpacked form (e.g. 2008 AB). meta.id;src 30
ephRa double deg Predicted ICRS right ascension from the orbit in mpc_orbits. pos.eq.ra;meta.modelled;pos.ephem 40
ephRaErr float deg 1-sigma uncertainty of ephRa (on the sky, i.e. including the cos(dec) factor), propagated from the mpc_orbits covariance. stat.error;pos.eq.ra;pos.ephem 50
ephDec double deg Predicted ICRS declination from the orbit in mpc_orbits. pos.eq.dec;meta.modelled;pos.ephem 60
ephDecErr float deg 1-sigma uncertainty of ephDec, propagated from the mpc_orbits covariance. stat.error;pos.eq.dec;pos.ephem 70
ephRa_ephDec_Cov float deg**2 Covariance between ephRa (on the sky) and ephDec; with ephRaErr and ephDecErr, the predicted position's error ellipse, in the convention of raErr, decErr and ra_dec_Cov. stat.covariance;pos.eq;pos.ephem 80
ephOffset float arcsec Total observed versus predicted angular separation on the sky. pos.angDistance;stat.fit.omc 90
diaDistanceRank short Rank of this DiaSource by its separation from the object's predicted position, among all DiaSources of the same visit within the matching radius of that prediction: 1 for the nearest, 2 for the next, and so on (ties broken by the lower diaSourceId). A rank above 1 means a closer DiaSource exists, which may be attributed to another object. meta.number 100
ephVmag float mag Predicted magnitude in V band, computed from mpc_orbits data including the mpc_orbits-provided (H, G) estimates. phot.mag;em.opt.V 110
ephRateRa float deg/d Predicted on-sky angular rate in the R.A. direction (includes the cos(dec) factor). pos.pm;pos.eq.ra;pos.ephem 120
ephRateDec float deg/d Predicted on-sky angular rate in the declination direction. pos.pm;pos.eq.dec;pos.ephem 130

current_identifications

All single-designations, and all identifications between designations. Always uses primary provisional designation (even for numbered objects). Includes all comets and satellites. 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.

Column Name Data Type Unit Description UCD Order Principal
id int Internal ID (generally not seen/used by the user) meta.id;src 10
packed_primary_provisional_designation char The primary provisional designation in packed form (e.g. K08A00B) meta.id;src 20
packed_secondary_provisional_designation char The secondary provisional designation in packed form (e.g. K08A00B). May be the same-as (A=A) or different-to (A=B) the primary provisional designation meta.id;src 30
unpacked_primary_provisional_designation char The primary provisional designation in unpacked form (e.g. 2008 AB) meta.id;src 40
unpacked_secondary_provisional_designation char The secondary provisional designation in unpacked form (e.g. 2008 AB). May be the same-as (A=A) or different-to (A=B) the primary provisional designation meta.id;src 50
published int Publication status of this identification, as the integer code in the MPC's table (not a boolean; the values 0, 1, 2 and 4 occur). meta.code.status;meta.dataset 60
object_type int Integer to indicate the object type. To be linked (foreign key) to object_type lookup table 70
numbered boolean Has the object been numbered and hence does it appear in the numbered_objects table? 80
created_at timestamp When this row was created time.creation;meta.dataset 90
updated_at timestamp When this row was updated time.processing;meta.dataset 100

numbered_identifications

The numbered identification table contains all the numbered objects (minor planets, comets and natural satellites) with their primary provisional designations. The table is continously updated everytime a new object is numbered. 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.

Column Name Data Type Unit Description UCD Order Principal
id int Internal ID (generally not seen/used by the user) meta.id;src 10
packed_primary_provisional_designation char The primary provisional designation in packed form (e.g. K08A00B) meta.id;src 20
unpacked_primary_provisional_designation char The primary provisional designation in unpacked form (e.g. 2008 AB) meta.id;src 30
permid char Permanent designation (number) meta.id;src 40
iau_designation text IAU-approved designation (not filled at the moment) meta.id;src 50
iau_name char IAU-approved name (not filled at the moment) meta.id;src 60
naming_credit text Credit for suggesting the name 70
created_at timestamp When this row was created time.creation;meta.dataset 80
updated_at timestamp When this row was updated time.processing;meta.dataset 90

DiaForcedSource

Forced-photometry source measurement on an individual difference Exposure for all objects in the DiaObject table

Column Name Data Type Unit Description UCD Order Principal
diaForcedSourceId long Unique id. 10
diaObjectId long Id of the DiaObject that this DiaForcedSource was associated with. meta.id;src 20
ra double deg Right ascension coordinate of the position of the DiaObject. pos.eq.ra 30
dec double deg Declination coordinate of the position of the DiaObject. pos.eq.dec 40
visit long Id of the visit where this forcedSource was measured. meta.id;obs.image 50
detector short Id of the detector where this forcedSource was measured. Datatype short instead of byte because of DB concerns about unsigned bytes. meta.id;obs.image 60
psfFlux float nJy Point Source model flux. phot.count 70
psfFluxErr float nJy Uncertainty of psfFlux. stat.error;phot.count 80
midpointMjdTai double d Effective mid-visit time for this diaForcedSource, expressed as Modified Julian Date, International Atomic Time. time.epoch 90
scienceFlux float nJy Forced photometry flux for a point source model measured on the visit image centered at the DiaObject position. phot.count 100
scienceFluxErr float nJy Uncertainty of scienceFlux. stat.error;phot.count 110
band char Filter band this source was observed with. meta.id;instr.filter 120
timeProcessedMjdTai double Time when this record was generated, expressed as Modified Julian Date, International Atomic Time. 130
timeWithdrawnMjdTai double Time when this record was marked invalid, expressed as Modified Julian Date, International Atomic Time. 140

DiaObject

Astronomical objects detected on one or more difference images, containing only the latest version of each record (i.e., with an open validity interval)

Column Name Data Type Unit Description UCD Order Principal
diaObjectId long Unique identifier of this DiaObject. meta.id;src 10
validityStartMjdTai double Processing time when validity of this diaObject starts, expressed as Modified Julian Date, International Atomic Time. time.epoch 20
ra double deg Right ascension coordinate of the position of the object. pos.eq.ra 30
raErr float deg Angular error of Right Ascension (dRA*cos(Dec)). stat.error;pos.eq.ra 40
dec double deg Declination coordinate of the position of the object. pos.eq.dec 50
decErr float deg Angular error of dec. stat.error;pos.eq.dec 60
ra_dec_Cov float deg**2 Covariance between Right Ascension (RA*cos(Dec)) and dec. 70
u_psfFluxMean float nJy Weighted mean point-source model magnitude for u filter. phot.count 80
u_psfFluxMeanErr float nJy Standard error of u_psfFluxMean. stat.error 90
u_psfFluxSigma float nJy Standard deviation of the distribution of u_psfFlux. stat.stdev 100
u_psfFluxNdata int The number of u-band data points. 110
u_fpFluxMean float nJy Weighted mean forced photometry flux for u filter. phot.count 120
u_fpFluxMeanErr float nJy Standard error of u_fpFluxMean. stat.error 130
g_psfFluxMean float nJy Weighted mean point-source model magnitude for g filter. phot.count 140
g_psfFluxMeanErr float nJy Standard error of g_psfFluxMean. stat.error 150
g_psfFluxSigma float nJy Standard deviation of the distribution of g_psfFlux. stat.stdev 160
g_psfFluxNdata int The number of g-band data points. 170
g_fpFluxMean float nJy Weighted mean forced photometry flux for g filter. phot.count 180
g_fpFluxMeanErr float nJy Standard error of g_fpFluxMean. stat.error 190
r_psfFluxMean float nJy Weighted mean point-source model magnitude for r filter. phot.count 200
r_psfFluxMeanErr float nJy Standard error of r_psfFluxMean. stat.error 210
r_psfFluxSigma float nJy Standard deviation of the distribution of r_psfFlux. stat.stdev 220
r_psfFluxNdata int The number of r-band data points. 230
r_fpFluxMean float nJy Weighted mean forced photometry flux for r filter. phot.count 240
r_fpFluxMeanErr float nJy Standard error of r_fpFluxMean. stat.error 250
i_psfFluxMean float nJy Weighted mean point-source model magnitude for i filter. phot.count 260
i_psfFluxMeanErr float nJy Standard error of i_psfFluxMean. stat.error 270
i_psfFluxSigma float nJy Standard deviation of the distribution of i_psfFlux. stat.stdev 280
i_psfFluxNdata int The number of i-band data points. 290
i_fpFluxMean float nJy Weighted mean forced photometry flux for i filter. phot.count 300
i_fpFluxMeanErr float nJy Standard error of i_fpFluxMean. stat.error 310
z_psfFluxMean float nJy Weighted mean point-source model magnitude for z filter. phot.count 320
z_psfFluxMeanErr float nJy Standard error of z_psfFluxMean. stat.error 330
z_psfFluxSigma float nJy Standard deviation of the distribution of z_psfFlux. stat.stdev 340
z_psfFluxNdata int The number of z-band data points. 350
z_fpFluxMean float nJy Weighted mean forced photometry flux for z filter. phot.count 360
z_fpFluxMeanErr float nJy Standard error of z_fpFluxMean. stat.error 370
y_psfFluxMean float nJy Weighted mean point-source model magnitude for y filter. phot.count 380
y_psfFluxMeanErr float nJy Standard error of y_psfFluxMean. stat.error 390
y_psfFluxSigma float nJy Standard deviation of the distribution of y_psfFlux. stat.stdev 400
y_psfFluxNdata int The number of y-band data points. 410
y_fpFluxMean float nJy Weighted mean forced photometry flux for y filter. phot.count 420
y_fpFluxMeanErr float nJy Standard error of y_fpFluxMean. stat.error 430
u_scienceFluxMean float nJy Weighted mean forced photometry flux for u filter. phot.count 440
u_scienceFluxMeanErr float nJy Standard error of u_scienceFluxMean. stat.error 450
g_scienceFluxMean float nJy Weighted mean forced photometry flux for g filter. phot.count 460
g_scienceFluxMeanErr float nJy Standard error of g_scienceFluxMean. stat.error 470
r_scienceFluxMean float nJy Weighted mean forced photometry flux for r filter. phot.count 480
r_scienceFluxMeanErr float nJy Standard error of r_scienceFluxMean. stat.error 490
i_scienceFluxMean float nJy Weighted mean forced photometry flux for i filter. phot.count 500
i_scienceFluxMeanErr float nJy Standard error of i_scienceFluxMean. stat.error 510
z_scienceFluxMean float nJy Weighted mean forced photometry flux for z filter. phot.count 520
z_scienceFluxMeanErr float nJy Standard error of z_scienceFluxMean. stat.error 530
y_scienceFluxMean float nJy Weighted mean forced photometry flux for y filter. phot.count 540
y_scienceFluxMeanErr float nJy Standard error of y_scienceFluxMean. stat.error 550
u_psfFluxMin float nJy Minimum observed u band fluxes. 560
u_psfFluxMax float nJy Maximum observed u band fluxes. 570
u_psfFluxMaxSlope float nJy/d Maximum slope between u band flux obsevations max(delta_flux/delta_time). 580
u_psfFluxErrMean float nJy Mean of the u band flux errors. 590
g_psfFluxMin float nJy Minimum observed g band fluxes. 600
g_psfFluxMax float nJy Maximum observed g band fluxes. 610
g_psfFluxMaxSlope float nJy/d Maximum slope between g band flux obsevations max(delta_flux/delta_time). 620
g_psfFluxErrMean float nJy Mean of the g band flux errors. 630
r_psfFluxMin float nJy Minimum observed r band fluxes. 640
r_psfFluxMax float nJy Maximum observed r band fluxes. 650
r_psfFluxMaxSlope float nJy/d Maximum slope between r band flux obsevations max(delta_flux/delta_time). 660
r_psfFluxErrMean float nJy Mean of the r band flux errors. 670
i_psfFluxMin float nJy Minimum observed i band fluxes. 680
i_psfFluxMax float nJy Maximum observed i band fluxes. 690
i_psfFluxMaxSlope float nJy/d Maximum slope between i band flux obsevations max(delta_flux/delta_time). 700
i_psfFluxErrMean float nJy Mean of the i band flux errors. 710
z_psfFluxMin float nJy Minimum observed z band fluxes. 720
z_psfFluxMax float nJy Maximum observed z band fluxes. 730
z_psfFluxMaxSlope float nJy/d Maximum slope between z band flux obsevations max(delta_flux/delta_time). 740
z_psfFluxErrMean float nJy Mean of the z band flux errors. 750
y_psfFluxMin float nJy Minimum observed y band fluxes. 760
y_psfFluxMax float nJy Maximum observed y band fluxes. 770
y_psfFluxMaxSlope float nJy/d Maximum slope between y band flux obsevations max(delta_flux/delta_time). 780
y_psfFluxErrMean float nJy Mean of the y band flux errors. 790
firstDiaSourceMjdTai double Time of the first diaSource, expressed as Modified Julian Date, International Atomic Time. time.epoch 800
lastDiaSourceMjdTai double Time of the most recent non-forced DIASource for this object, expressed as Modified Julian Date, International Atomic Time. time.epoch 810
nDiaSources int Total number of DiaSources associated with this DiaObject. 820

DiaSource

Difference image sources detected on difference images

Column Name Data Type Unit Description UCD Order Principal
diaSourceId long Unique identifier of this DiaSource. meta.id;obs.image 10
visit long Id of the visit where this diaSource was measured. meta.id;obs.image 20
detector short Id of the detector where this diaSource was measured. Datatype short instead of byte because of DB concerns about unsigned bytes. meta.id;obs.image 30
diaObjectId long Id of the diaObject this source was associated with, if any. If not, it is set to NULL (each diaSource will be associated with either a diaObject or ssObject). meta.id;src 40
ssObjectId long Id of the ssObject this source was associated with, if any. If not, it is set to NULL (each diaSource will be associated with either a diaObject or ssObject). meta.id;src 50
parentDiaSourceId long Id of the parent diaSource this diaSource has been deblended from, if any. meta.id;src 60
ssObjectReassocTimeMjdTai double Time when this diaSource was reassociated from diaObject to ssObject, expressed as Modified Julian Date, International Atomic Time (if such reassociation happens, otherwise NULL). 70
midpointMjdTai double d Effective mid-visit time for this diaSource, expressed as Modified Julian Date, International Atomic Time. time.epoch 80
exposureTime float s Effective exposure time for this diaSource. time.interval 90
ra double deg Right ascension coordinate of the center of this diaSource. pos.eq.ra 100
raErr float deg Angular error of Right Ascension (dRA*cos(Dec)). stat.error;pos.eq.ra 110
dec double deg Declination coordinate of the center of this diaSource. pos.eq.dec 120
decErr float deg Angular error of dec. stat.error;pos.eq.dec 130
ra_dec_Cov float deg**2 Covariance between Right Ascension (RA*cos(Dec)) and dec. stat.covariance 140
x float pixel x position computed by a centroiding algorithm. pos.cartesian.x 150
xErr float pixel Uncertainty of x. stat.error;pos.cartesian.x 160
y float pixel y position computed by a centroiding algorithm. pos.cartesian.y 170
yErr float pixel Uncertainty of y. stat.error;pos.cartesian.y 180
centroid_flag boolean General centroid algorithm failure flag; set if anything went wrong when fitting the centroid. Another centroid flag field should also be set to provide more information. 190
apFlux float nJy Flux in a 12 pixel radius aperture on the difference image. phot.count 200
apFluxErr float nJy Estimated uncertainty of apFlux. stat.error;phot.count 210
apFlux_flag boolean General aperture flux algorithm failure flag; set if anything went wrong when measuring aperture fluxes. Another apFlux flag field should also be set to provide more information. 220
apFlux_flag_apertureTruncated boolean Aperture did not fit within measurement image. 230
isNegative boolean Source was detected as significantly negative. 240
snr float The signal-to-noise ratio at which this source was detected in the difference image. stat.snr 250
psfFlux float nJy Flux for Point Source model. Note this actually measures the flux difference between the template and the visit image. phot.count 260
psfFluxErr float nJy Uncertainty of psfFlux. 270
psfLnL float Natural log likelihood of the observed data given the point source model. stat.likelihood 280
psfChi2 float Chi^2 statistic of the point source model fit. stat.fit.chi2 290
psfNdata int The number of data points (pixels) used to fit the point source model. 300
psfFlux_flag boolean Failure to derive linear least-squares fit of psf model. Another psfFlux flag field should also be set to provide more information. 310
psfFlux_flag_edge boolean Object was too close to the edge of the image to use the full PSF model. 320
psfFlux_flag_noGoodPixels boolean Not enough non-rejected pixels in data to attempt the fit. 330
trailAlgorithm int Integer key indicating which algorithm was used to measure trailed source. 1=SDSSShape, 2=HSMShape. 340
trailFlux float nJy Flux for a trailed source model. Note this actually measures the flux difference between the template and the visit image. 350
trailFluxErr float nJy Uncertainty of trailFlux. 360
trailRa double deg Right ascension coordinate of centroid for trailed source model. pos.eq.ra 370
trailRaErr float deg Angular error of trailRa (dRA*cos(Dec)). stat.error;pos.eq.ra 380
trailDec double deg Declination coordinate of centroid for trailed source model. pos.eq.dec 390
trailDecErr float deg Angular error of trailDec. stat.error;pos.eq.dec 400
trailLength float arcsec Maximum likelihood fit of trail length. 410
trailLengthErr float arcsec Uncertainty of trailLength. 420
trailAngle float deg Maximum likelihood fit of the angle between the meridian through the centroid and the trail direction (bearing). 430
trailAngleErr float deg Uncertainty of trailAngle. 440
trailChi2 float Chi^2 statistic of the trailed source model fit. stat.fit.chi2 450
trailNdata int The number of data points (pixels) used to fit the trailed source model. 460
trail_flag boolean The trailed source fitting algorithm failed. 470
trail_flag_edge boolean This flag is set if a trailed source extends onto or past edge pixels. 480
dipoleMeanFlux float nJy Maximum likelihood value for the mean absolute flux of the two lobes for a dipole model. 490
dipoleMeanFluxErr float nJy Uncertainty of dipoleMeanFlux. stat.error 500
dipoleFluxDiff float nJy Maximum likelihood value for the difference of absolute fluxes of the two lobes for a dipole model. 510
dipoleFluxDiffErr float nJy Uncertainty of dipoleFluxDiff. stat.error 520
dipoleLength float arcsec Maximum likelihood value for the lobe separation in dipole model. pos.angDistance 530
dipoleAngle float deg Maximum likelihood fit of the angle between the meridian through the centroid and the dipole direction (bearing, from negative to positive lobe). pos.posAng 540
dipoleChi2 float Chi^2 statistic of the model fit. stat.fit.chi2 550
dipoleNdata int The number of data points (pixels) used to fit the model. 560
scienceFlux float nJy Forced photometry flux for a point source model measured on the visit image centered at DiaSource position. phot.count 570
scienceFluxErr float nJy Estimated uncertainty of scienceFlux. stat.error;phot.count 580
forced_PsfFlux_flag boolean Forced PSF photometry on science image failed. Another forced_PsfFlux flag field should also be set to provide more information. 590
forced_PsfFlux_flag_edge boolean Forced PSF flux on science image was too close to the edge of the image to use the full PSF model. 600
forced_PsfFlux_flag_noGoodPixels boolean Forced PSF flux not enough non-rejected pixels in data to attempt the fit. 610
templateFlux float nJy Forced photometry flux for a point source model measured on the template image centered at the DiaObject position. phot.count 620
templateFluxErr float nJy Uncertainty of templateFlux. stat.error;phot.count 630
ixx float arcsec**2 Adaptive second moment of the source intensity. 640
iyy float arcsec**2 Adaptive second moment of the source intensity. 650
ixy float arcsec**2 Adaptive second moment of the source intensity. 660
ixxPSF float arcsec**2 Adaptive second moment for the PSF. 670
iyyPSF float arcsec**2 Adaptive second moment for the PSF. 680
ixyPSF float arcsec**2 Adaptive second moment for the PSF. 690
shape_flag boolean General source shape algorithm failure flag; set if anything went wrong when measuring the shape. Another shape flag field should also be set to provide more information. 700
shape_flag_no_pixels boolean No pixels to measure shape. 710
shape_flag_not_contained boolean Center not contained in footprint bounding box. 720
shape_flag_parent_source boolean This source is a parent source; we should only be measuring on deblended children in difference imaging. 730
extendedness float A measure of extendedness, computed by comparing an object's moment-based traced radius to the PSF moments. extendedness = 1 implies a high degree of confidence that the source is extended. extendedness = 0 implies a high degree of confidence that the source is point-like. 740
reliability float Probability (0-1) that the diaSource is astrophysical, derived from a machine learning model. 750
reliabilityVersion string Version of the reliability model. 760
band char Filter band this source was observed with. 770
isDipole boolean Source well fit by a dipole. 780
dipoleFitAttempted boolean Attempted to fit a dipole model to this source. 790
timeProcessedMjdTai double Time when the image was processed and this DiaSource record was generated, expressed as Modified Julian Date, International Atomic Time. time.epoch 800
timeWithdrawnMjdTai double Time when this record was marked invalid, expressed as Modified Julian Date, International Atomic Time. time.epoch 810
bboxSize int pixel Size of the square bounding box that fully contains the detection footprint. 820
pixelFlags boolean General pixel flags failure; set if anything went wrong when setting pixels flags from this footprint's mask. This implies that some pixelFlags for this source may be incorrectly set to False. 830
pixelFlags_bad boolean Bad pixel in the DiaSource footprint. 840
pixelFlags_cr boolean Cosmic ray in the DiaSource footprint. 850
pixelFlags_crCenter boolean Cosmic ray in the 3x3 region around the centroid. 860
pixelFlags_edge boolean Some of the source footprint is outside usable exposure region (masked EDGE or centroid off image). 870
pixelFlags_nodata boolean NO_DATA pixel in the source footprint. 880
pixelFlags_nodataCenter boolean NO_DATA pixel in the 3x3 region around the centroid. 890
pixelFlags_interpolated boolean Interpolated pixel in the DiaSource footprint. 900
pixelFlags_interpolatedCenter boolean Interpolated pixel in the 3x3 region around the centroid. 910
pixelFlags_offimage boolean DiaSource center is off image. 920
pixelFlags_saturated boolean Saturated pixel in the DiaSource footprint. 930
pixelFlags_saturatedCenter boolean Saturated pixel in the 3x3 region around the centroid. 940
pixelFlags_suspect boolean DiaSource's footprint includes suspect pixels. 950
pixelFlags_suspectCenter boolean Suspect pixel in the 3x3 region around the centroid. 960
pixelFlags_streak boolean Streak in the DiaSource footprint. 970
pixelFlags_streakCenter boolean Streak in the 3x3 region around the centroid. 980
pixelFlags_injected boolean Injection in the DiaSource footprint. 990
pixelFlags_injectedCenter boolean Injection in the 3x3 region around the centroid. 1000
pixelFlags_injected_template boolean Template injection in the DiaSource footprint. 1010
pixelFlags_injected_templateCenter boolean Template injection in the 3x3 region around the centroid. 1020
glint_trail boolean This flag is set if the source is part of a glint trail. 1030

SDM Schemas is maintained by Rubin Observatory.