Alert Production Database schema

The Alert Production Database (APDB) contains the catalogs resulting from image differencing during nightly Prompt Processing as well as the results of daily Solar System Processing.

metadata

Table containing various metadata key:value pairs for APDB.

Column Name Data Type Unit Description [UCD]
name text Name or key for a metadata item.
value text Content of the metadata item in string representation.

DiaObject

The DiaObject table contains descriptions of the astronomical objects detected on one or more difference images.

Column Name Data Type Unit Description [UCD]
diaObjectId long Unique identifier of this DiaObject. [meta.id;src]
validityStart timestamp Processing time when validity of this diaObject starts.
validityEnd timestamp Processing time when validity of this diaObject ends.
ra double deg Right ascension coordinate of the position of the object at time radecMjdTai. [pos.eq.ra]
raErr float deg Uncertainty of ra. [stat.error;pos.eq.ra]
dec double deg Declination coordinate of the position of the object at time radecMjdTai. [pos.eq.dec]
decErr float deg Uncertainty of dec. [stat.error;pos.eq.dec]
ra_dec_Cov float deg**2 Covariance between ra and dec.
radecMjdTai double Time at which the object was at a position ra/dec, expressed as Modified Julian Date, International Atomic Time. [time.epoch]
pmRa float mas/yr Proper motion in right ascension. [pos.pm]
pmRaErr float mas/yr Uncertainty of pmRa. [stat.error;pos.pm]
pmDec float mas/yr Proper motion of declination. [pos.pm]
pmDecErr float mas/yr Uncertainty of pmDec. [stat.error;pos.pm]
parallax float mas Parallax. [pos.parallax]
parallaxErr float mas Uncertainty of parallax. [stat.error;pos.parallax]
pmRa_pmDec_Cov float mas**2/yr**2 Covariance of pmRa and pmDec. [stat.covariance;pos.eq]
pmRa_parallax_Cov float mas**2/yr Covariance of pmRa and parallax. [stat.covariance]
pmDec_parallax_Cov float mas**2/yr Covariance of pmDec and parallax. [stat.covariance]
pmParallaxLnL float Natural log of the likelihood of the linear proper motion parallax fit. [stat.likelihood]
pmParallaxChi2 float Chi^2 static of the model fit. [stat.fit.chi2]
pmParallaxNdata int The number of data points used to fit the model.
u_psfFluxMean float nJy Weighted mean point-source model magnitude for u filter. [phot.count]
u_psfFluxMeanErr float nJy Standard error of u_psfFluxMean. [stat.error]
u_psfFluxSigma float nJy Standard deviation of the distribution of u_psfFlux. [stat.stdev]
u_psfFluxChi2 float Chi^2 statistic for the scatter of u_psfFlux around u_psfFluxMean. [stat.fit.chi2]
u_psfFluxNdata int The number of data points used to compute u_psfFluxChi2.
u_fpFluxMean float nJy Weighted mean forced photometry flux for u filter. [phot.count]
u_fpFluxMeanErr float nJy Standard error of u_fpFluxMean. [stat.error]
u_fpFluxSigma float nJy Standard deviation of the distribution of u_fpFlux. [stat.stdev]
g_psfFluxMean float nJy Weighted mean point-source model magnitude for g filter. [phot.count]
g_psfFluxMeanErr float nJy Standard error of g_psfFluxMean. [stat.error]
g_psfFluxSigma float nJy Standard deviation of the distribution of g_psfFlux. [stat.stdev]
g_psfFluxChi2 float Chi^2 statistic for the scatter of g_psfFlux around g_psfFluxMean. [stat.fit.chi2]
g_psfFluxNdata int The number of data points used to compute g_psfFluxChi2.
g_fpFluxMean float nJy Weighted mean forced photometry flux for g filter. [phot.count]
g_fpFluxMeanErr float nJy Standard error of g_fpFluxMean. [stat.error]
g_fpFluxSigma float nJy Standard deviation of the distribution of g_fpFlux. [stat.stdev]
r_psfFluxMean float nJy Weighted mean point-source model magnitude for r filter. [phot.count]
r_psfFluxMeanErr float nJy Standard error of r_psfFluxMean. [stat.error]
r_psfFluxSigma float nJy Standard deviation of the distribution of r_psfFlux. [stat.stdev]
r_psfFluxChi2 float Chi^2 statistic for the scatter of r_psfFlux around r_psfFluxMean. [stat.fit.chi2]
r_psfFluxNdata int The number of data points used to compute r_psfFluxChi2.
r_fpFluxMean float nJy Weighted mean forced photometry flux for r filter. [phot.count]
r_fpFluxMeanErr float nJy Standard error of r_fpFluxMean. [stat.error]
r_fpFluxSigma float nJy Standard deviation of the distribution of r_fpFlux. [stat.stdev]
i_psfFluxMean float nJy Weighted mean point-source model magnitude for i filter. [phot.count]
i_psfFluxMeanErr float nJy Standard error of i_psfFluxMean. [stat.error]
i_psfFluxSigma float nJy Standard deviation of the distribution of i_psfFlux. [stat.stdev]
i_psfFluxChi2 float Chi^2 statistic for the scatter of i_psfFlux around i_psfFluxMean. [stat.fit.chi2]
i_psfFluxNdata int The number of data points used to compute i_psfFluxChi2.
i_fpFluxMean float nJy Weighted mean forced photometry flux for i filter. [phot.count]
i_fpFluxMeanErr float nJy Standard error of i_fpFluxMean. [stat.error]
i_fpFluxSigma float nJy Standard deviation of the distribution of i_fpFlux. [stat.stdev]
z_psfFluxMean float nJy Weighted mean point-source model magnitude for z filter. [phot.count]
z_psfFluxMeanErr float nJy Standard error of z_psfFluxMean. [stat.error]
z_psfFluxSigma float nJy Standard deviation of the distribution of z_psfFlux. [stat.stdev]
z_psfFluxChi2 float Chi^2 statistic for the scatter of z_psfFlux around z_psfFluxMean. [stat.fit.chi2]
z_psfFluxNdata int The number of data points used to compute z_psfFluxChi2.
z_fpFluxMean float nJy Weighted mean forced photometry flux for z filter. [phot.count]
z_fpFluxMeanErr float nJy Standard error of z_fpFluxMean. [stat.error]
z_fpFluxSigma float nJy Standard deviation of the distribution of z_fpFlux. [stat.stdev]
y_psfFluxMean float nJy Weighted mean point-source model magnitude for y filter. [phot.count]
y_psfFluxMeanErr float nJy Standard error of y_psfFluxMean. [stat.error]
y_psfFluxSigma float nJy Standard deviation of the distribution of y_psfFlux. [stat.error]
y_psfFluxChi2 float Chi^2 statistic for the scatter of y_psfFlux around y_psfFluxMean. [stat.fit.chi2]
y_psfFluxNdata int The number of data points used to compute y_psfFluxChi2.
y_fpFluxMean float nJy Weighted mean forced photometry flux for y filter. [phot.count]
y_fpFluxMeanErr float nJy Standard error of y_fpFluxMean. [stat.error]
y_fpFluxSigma float nJy Standard deviation of the distribution of y_fpFlux. [stat.stdev]
u_lcPeriodic binary Periodic features extracted from light-curves using generalized Lomb-Scargle periodogram for u filter. [32 FLOAT].
g_lcPeriodic binary Periodic features extracted from light-curves using generalized Lomb-Scargle periodogram for g filter. [32 FLOAT].
r_lcPeriodic binary Periodic features extracted from light-curves using generalized Lomb-Scargle periodogram for r filter. [32 FLOAT].
i_lcPeriodic binary Periodic features extracted from light-curves using generalized Lomb-Scargle periodogram for i filter. [32 FLOAT].
z_lcPeriodic binary Periodic features extracted from light-curves using generalized Lomb-Scargle periodogram for z filter. [32 FLOAT].
y_lcPeriodic binary Periodic features extracted from light-curves using generalized Lomb-Scargle periodogram for y filter. [32 FLOAT].
u_lcNonPeriodic binary Non-periodic features extracted from light-curves using generalized Lomb-Scargle periodogram for u filter. [20 FLOAT].
g_lcNonPeriodic binary Non-periodic features extracted from light-curves using generalized Lomb-Scargle periodogram for g filter. [20 FLOAT].
r_lcNonPeriodic binary Non-periodic features extracted from light-curves using generalized Lomb-Scargle periodogram for r filter. [20 FLOAT].
i_lcNonPeriodic binary Non-periodic features extracted from light-curves using generalized Lomb-Scargle periodogram for i filter. [20 FLOAT].
z_lcNonPeriodic binary Non-periodic features extracted from light-curves using generalized Lomb-Scargle periodogram for z filter. [20 FLOAT].
y_lcNonPeriodic binary Non-periodic features extracted from light-curves using generalized Lomb-Scargle periodogram for y filter. [20 FLOAT].
nearbyObj1 long Id of the closest nearby object. [meta.id;src]
nearbyObj1Dist float arcsec Distance to nearbyObj1.
nearbyObj1LnP float Natural log of the probability that the observed diaObject is the same as the nearbyObj1.
nearbyObj2 long Id of the second-closest nearby object. [meta.id;src]
nearbyObj2Dist float arcsec Distance to nearbyObj2.
nearbyObj2LnP float Natural log of the probability that the observed diaObject is the same as the nearbyObj2.
nearbyObj3 long Id of the third-closest nearby object. [meta.id;src]
nearbyObj3Dist float arcsec Distance to nearbyObj3.
nearbyObj3LnP float Natural log of the probability that the observed diaObject is the same as the nearbyObj3.
nearbyExtObj1 long Id of the closest extended DR Object by second moment-based separation. [meta.id;src]
nearbyExtObj1Sep float Second moment-based separation of nearbyExtObj1 (unitless).
nearbyExtObj2 long Id of the second closest extended DR Object by second moment-based separation. [meta.id;src]
nearbyExtObj2Sep float Second moment-based separation of nearbyExtObj2 (unitless).
nearbyExtObj3 long Id of the third closest extended DR Object by second moment-based separation. [meta.id;src]
nearbyExtObj3Sep float Second moment-based separation of nearbyExtObj3 (unitless).
nearbyLowzGal string External catalog name of the nearest low-z potential host.
nearbyLowzGalSep float arcsec Separation distance of nearbyLowzGal.
u_scienceFluxMean float nJy Weighted mean forced photometry flux for u filter. [phot.count]
u_scienceFluxMeanErr float nJy Standard error of u_scienceFluxMean. [stat.error]
u_scienceFluxSigma float nJy Standard deviation of the distribution of u_scienceFlux. [stat.stdev]
g_scienceFluxMean float nJy Weighted mean forced photometry flux for g filter. [phot.count]
g_scienceFluxMeanErr float nJy Standard error of g_scienceFluxMean. [stat.error]
g_scienceFluxSigma float nJy Standard deviation of the distribution of g_scienceFlux. [stat.stdev]
r_scienceFluxMean float nJy Weighted mean forced photometry flux for r filter. [phot.count]
r_scienceFluxMeanErr float nJy Standard error of r_scienceFluxMean. [stat.error]
r_scienceFluxSigma float nJy Standard deviation of the distribution of r_scienceFlux. [stat.stdev]
i_scienceFluxMean float nJy Weighted mean forced photometry flux for i filter. [phot.count]
i_scienceFluxMeanErr float nJy Standard error of i_scienceFluxMean. [stat.error]
i_scienceFluxSigma float nJy Standard deviation of the distribution of i_scienceFlux. [stat.stdev]
z_scienceFluxMean float nJy Weighted mean forced photometry flux for z filter. [phot.count]
z_scienceFluxMeanErr float nJy Standard error of z_scienceFluxMean. [stat.error]
z_scienceFluxSigma float nJy Standard deviation of the distribution of z_scienceFlux. [stat.stdev]
y_scienceFluxMean float nJy Weighted mean forced photometry flux for y filter. [phot.count]
y_scienceFluxMeanErr float nJy Standard error of y_scienceFluxMean. [stat.error]
y_scienceFluxSigma float nJy Standard deviation of the distribution of y_scienceFlux. [stat.stdev]
u_psfFluxMAD float nJy Median absolute deviation u band fluxes.
u_psfFluxSkew float Skewness of the u band fluxes.
u_psfFluxPercentile05 float nJy Value at the 5% percentile of the u band fluxes.
u_psfFluxPercentile25 float nJy Value at the 25% percentile of the u band fluxes.
u_psfFluxPercentile50 float nJy Value at the 50% percentile (median) of the u band fluxes.
u_psfFluxPercentile75 float nJy Value at the 75% percentile of the u band fluxes.
u_psfFluxPercentile95 float nJy Value at the 95% percentile of the u band fluxes.
u_psfFluxMin float nJy Minimum observed u band fluxes.
u_psfFluxMax float nJy Maximum observed u band fluxes.
u_psfFluxStetsonJ float StetsonJ statistic for the u band fluxes.
u_psfFluxLinearSlope float nJy/d Linear best fit slope of the u band fluxes.
u_psfFluxLinearIntercept float Linear best fit Intercept of the u band fluxes.
u_psfFluxMaxSlope float nJy/d Maximum slope between u band flux obsevations max(delta_flux/delta_time).
u_psfFluxErrMean float nJy Mean of the u band flux errors.
g_psfFluxMAD float nJy Median absolute deviation g band fluxes.
g_psfFluxSkew float Skewness of the g band fluxes.
g_psfFluxPercentile05 float nJy Value at the 5% percentile of the g band fluxes.
g_psfFluxPercentile25 float nJy Value at the 25% percentile of the g band fluxes.
g_psfFluxPercentile50 float nJy Value at the 50% percentile (median) of the g band fluxes.
g_psfFluxPercentile75 float nJy Value at the 75% percentile of the g band fluxes.
g_psfFluxPercentile95 float nJy Value at the 95% percentile of the g band fluxes.
g_psfFluxMin float nJy Minimum observed g band fluxes.
g_psfFluxMax float nJy Maximum observed g band fluxes.
g_psfFluxStetsonJ float StetsonJ statistic for the g band fluxes.
g_psfFluxLinearSlope float nJy/d Linear best fit slope of the g band fluxes.
g_psfFluxLinearIntercept float nJy Linear best fit Intercept of the g band fluxes.
g_psfFluxMaxSlope float nJy/d Maximum slope between g band flux obsevations max(delta_flux/delta_time).
g_psfFluxErrMean float nJy Mean of the g band flux errors.
r_psfFluxMAD float nJy Median absolute deviation r band fluxes.
r_psfFluxSkew float Skewness of the r band fluxes.
r_psfFluxPercentile05 float nJy Value at the 5% percentile of the r band fluxes.
r_psfFluxPercentile25 float nJy Value at the 25% percentile of the r band fluxes.
r_psfFluxPercentile50 float nJy Value at the 50% percentile (median) of the r band fluxes.
r_psfFluxPercentile75 float nJy Value at the 75% percentile of the r band fluxes.
r_psfFluxPercentile95 float nJy Value at the 95% percentile of the r band fluxes.
r_psfFluxMin float nJy Minimum observed r band fluxes.
r_psfFluxMax float nJy Maximum observed r band fluxes.
r_psfFluxStetsonJ float StetsonJ statistic for the r band fluxes.
r_psfFluxLinearSlope float nJy/d Linear best fit slope of the r band fluxes.
r_psfFluxLinearIntercept float nJy Linear best fit Intercept of the r band fluxes.
r_psfFluxMaxSlope float nJy/d Maximum slope between r band flux obsevations max(delta_flux/delta_time).
r_psfFluxErrMean float nJy Mean of the r band flux errors.
i_psfFluxMAD float nJy Median absolute deviation i band fluxes.
i_psfFluxSkew float Skewness of the i band fluxes.
i_psfFluxPercentile05 float nJy Value at the 5% percentile of the i band fluxes.
i_psfFluxPercentile25 float nJy Value at the 25% percentile of the i band fluxes.
i_psfFluxPercentile50 float nJy Value at the 50% percentile (median) of the i band fluxes.
i_psfFluxPercentile75 float nJy Value at the 75% percentile of the i band fluxes.
i_psfFluxPercentile95 float nJy Value at the 95% percentile of the i band fluxes.
i_psfFluxMin float nJy Minimum observed i band fluxes.
i_psfFluxMax float nJy Maximum observed i band fluxes.
i_psfFluxStetsonJ float StetsonJ statistic for the i band fluxes.
i_psfFluxLinearSlope float nJy/d Linear best fit slope of the i band fluxes.
i_psfFluxLinearIntercept float nJy Linear best fit Intercept of the i band fluxes.
i_psfFluxMaxSlope float nJy/d Maximum slope between i band flux obsevations max(delta_flux/delta_time).
i_psfFluxErrMean float nJy Mean of the i band flux errors.
z_psfFluxMAD float nJy Median absolute deviation z band fluxes.
z_psfFluxSkew float Skewness of the z band fluxes.
z_psfFluxPercentile05 float nJy Value at the 5% percentile of the z band fluxes.
z_psfFluxPercentile25 float nJy Value at the 25% percentile of the z band fluxes.
z_psfFluxPercentile50 float nJy Value at the 50% percentile (median) of the z band fluxes.
z_psfFluxPercentile75 float nJy Value at the 75% percentile of the z band fluxes.
z_psfFluxPercentile95 float nJy Value at the 95% percentile of the z band fluxes.
z_psfFluxMin float nJy Minimum observed z band fluxes.
z_psfFluxMax float nJy Maximum observed z band fluxes.
z_psfFluxStetsonJ float StetsonJ statistic for the z band fluxes.
z_psfFluxLinearSlope float nJy/d Linear best fit slope of the z band fluxes.
z_psfFluxLinearIntercept float nJy Linear best fit Intercept of the z band fluxes.
z_psfFluxMaxSlope float nJy/d Maximum slope between z band flux obsevations max(delta_flux/delta_time).
z_psfFluxErrMean float nJy Mean of the z band flux errors.
y_psfFluxMAD float nJy Median absolute deviation y band fluxes.
y_psfFluxSkew float Skewness of the y band fluxes.
y_psfFluxPercentile05 float nJy Value at the 5% percentile of the y band fluxes.
y_psfFluxPercentile25 float nJy Value at the 25% percentile of the y band fluxes.
y_psfFluxPercentile50 float nJy Value at the 50% percentile (median) of the y band fluxes.
y_psfFluxPercentile75 float nJy Value at the 75% percentile of the y band fluxes.
y_psfFluxPercentile95 float nJy Value at the 95% percentile of the y band fluxes.
y_psfFluxMin float nJy Minimum observed y band fluxes.
y_psfFluxMax float nJy Maximum observed y band fluxes.
y_psfFluxStetsonJ float StetsonJ statistic for the y band fluxes.
y_psfFluxLinearSlope float nJy/d Linear best fit slope of the y band fluxes.
y_psfFluxLinearIntercept float nJy Linear best fit Intercept of the y band fluxes.
y_psfFluxMaxSlope float nJy/d Maximum slope between y band flux obsevations max(delta_flux/delta_time)
y_psfFluxErrMean float nJy Mean of the y band flux errors.
flags long Flags, bitwise OR tbd. [meta.code]
lastNonForcedSource timestamp Last time when non-forced DIASource was seen for this object.
nDiaSources int Total number of DiaSources associated with this DiaObject.

SSObject

LSST-computed per-object quantities. 1:1 relationship with MPCORB. Recomputed daily, upon MPCORB ingestion.

Column Name Data Type Unit Description [UCD]
ssObjectId long Unique identifier. [meta.id;src]
discoverySubmissionDate double d 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).
firstObservationDate double d The time of the first LSST observation of this object (could be precovered) as Modified Julian Date, International Atomic Time.
arc float d Arc of LSST observations.
numObs int Number of LSST observations of this object.
lcPeriodic binary Periodic light curve features computed on phase/distance-corrected magnitudes (H), 6x32 floats.
MOID float AU Minimum orbit intersection distance to Earth.
MOIDTrueAnomaly float deg True anomaly of the MOID point.
MOIDEclipticLongitude float deg Ecliptic longitude of the MOID point.
MOIDDeltaV float km/s DeltaV at the MOID point.
u_H float mag Best fit absolute magnitude (u band).
u_G12 float mag Best fit G12 slope parameter (u band).
u_HErr float mag Uncertainty of H (u band). [stat.error]
u_G12Err float mag Uncertainty of G12 (u band). [stat.error]
u_H_u_G12_Cov float mag**2 H-G12 covariance (u band). [stat.covariance]
u_Chi2 float Chi^2 statistic of the phase curve fit (u band). [stat.fit.chi2]
u_Ndata int The number of data points used to fit the phase curve (u band).
g_H float mag Best fit absolute magnitude (g band).
g_G12 float mag Best fit G12 slope parameter (g band).
g_HErr float mag Uncertainty of H (g band). [stat.error]
g_G12Err float mag Uncertainty of G12 (g band). [stat.error]
g_H_g_G12_Cov float mag**2 H-G12 covariance (g band). [stat.covariance]
g_Chi2 float Chi^2 statistic of the phase curve fit (g band). [stat.fit.chi2]
g_Ndata int The number of data points used to fit the phase curve (g band).
r_H float mag Best fit absolute magnitude (r band).
r_G12 float mag Best fit G12 slope parameter (r band).
r_HErr float mag Uncertainty of H (r band). [stat.error]
r_G12Err float mag Uncertainty of G12 (r band). [stat.error]
r_H_r_G12_Cov float mag**2 H-G12 covariance (r band). [stat.covariance]
r_Chi2 float Chi^2 statistic of the phase curve fit (r band). [stat.fit.chi2]
r_Ndata int The number of data points used to fit the phase curve (r band).
i_H float mag Best fit absolute magnitude (i band).
i_G12 float mag Best fit G12 slope parameter (i band).
i_HErr float mag Uncertainty of H (i band). [stat.error]
i_G12Err float mag Uncertainty of G12 (i band). [stat.error]
i_H_i_G12_Cov float mag**2 H-G12 covariance (i band). [stat.covariance]
i_Chi2 float Chi^2 statistic of the phase curve fit (i band). [stat.fit.chi2]
i_Ndata int The number of data points used to fit the phase curve (i band).
z_H float mag Best fit absolute magnitude (z band).
z_G12 float mag Best fit G12 slope parameter (z band).
z_HErr float mag Uncertainty of H (z band). [stat.error]
z_G12Err float mag Uncertainty of G12 (z band). [stat.error]
z_H_z_G12_Cov float mag**2 H-G12 covariance (z band). [stat.covariance]
z_Chi2 float Chi^2 statistic of the phase curve fit (z band). [stat.fit.chi2]
z_Ndata int The number of data points used to fit the phase curve (z band).
y_H float mag Best fit absolute magnitude (y band).
y_G12 float mag Best fit G12 slope parameter (y band).
y_HErr float mag Uncertainty of H (y band). [stat.error]
y_G12Err float mag Uncertainty of G12 (y band). [stat.error]
y_H_y_G12_Cov float mag**2 H-G12 covariance (y band). [stat.covariance]
y_Chi2 float Chi^2 statistic of the phase curve fit (y band). [stat.fit.chi2]
y_Ndata int The number of data points used to fit the phase curve (y band).
maxExtendedness float maximum `extendedness` value from the DIASource.
minExtendedness float minimum `extendedness` value from the DIASource.
medianExtendedness float median `extendedness` value from the DIASource.
flags long Flags, bitwise OR tbd. [meta.code]

DiaSource

Table to store 'difference image sources'; - sources detected at SNR >=5 on difference images.

Column Name Data Type Unit Description [UCD]
diaSourceId long Unique identifier of this DiaSource. [meta.id;obs.image]
ccdVisitId long Id of the ccdVisit where this diaSource was measured. [meta.id;obs.image]
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]
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]
parentDiaSourceId long Id of the parent diaSource this diaSource has been deblended from, if any. [meta.id;src]
ssObjectReassocTime timestamp Time when this diaSource was reassociated from diaObject to ssObject (if such reassociation happens, otherwise NULL).
midpointMjdTai double d Effective mid-visit time for this diaSource, expressed as Modified Julian Date, International Atomic Time. [time.epoch]
ra double deg Right ascension coordinate of the center of this diaSource. [pos.eq.ra]
raErr float deg Uncertainty of ra. [stat.error;pos.eq.ra]
dec double deg Declination coordinate of the center of this diaSource. [pos.eq.dec]
decErr float deg Uncertainty of dec. [stat.error;pos.eq.dec]
ra_dec_Cov float deg**2 Covariance between ra and dec. [stat.covariance]
x float pixel x position computed by a centroiding algorithm. [pos.cartesian.x]
xErr float pixel Uncertainty of x. [stat.error;pos.cartesian.x]
y float pixel y position computed by a centroiding algorithm. [pos.cartesian.y]
yErr float pixel Uncertainty of y. [stat.error;pos.cartesian.y]
x_y_Cov float pixel**2 Covariance between x and y. [stat.covariance]
apFlux float nJy Flux in a 12 pixel radius aperture on the difference image. [phot.count]
apFluxErr float nJy Estimated uncertainty of apFlux. [stat.error;phot.count]
snr float The signal-to-noise ratio at which this source was detected in the difference image. [stat.snr]
psfFlux float nJy Flux for Point Source model. Note this actually measures the flux difference between the template and the visit image. [phot.count]
psfFluxErr float nJy Uncertainty of psfFlux.
psfRa double deg Right ascension coordinate of centroid for point source model. [pos.eq.ra]
psfRaErr float deg Uncertainty of psfRa. [stat.error;pos.eq.ra]
psfDec double deg Declination coordinate of centroid for point source model. [pos.eq.dec]
psfDecErr float deg Uncertainty of psfDec. [stat.error;pos.eq.dec]
psfFlux_psfRa_Cov float nJy.deg Covariance between psfFlux and psfRa. [stat.covariance]
psfFlux_psfDec_Cov float nJy.deg Covariance between psfFlux and psfDec. [stat.covariance]
psfRa_psfDec_Cov float deg**2 Covariance between psfRa and psfDec. [stat.covariance]
psfLnL float Natural log likelihood of the observed data given the point source model. [stat.likelihood]
psfChi2 float Chi^2 statistic of the point source model fit. [stat.fit.chi2]
psfNdata int The number of data points (pixels) used to fit the point source model.
trailFlux float nJy Flux for a trailed source model. Note this actually measures the flux difference between the template and the visit image.
trailFluxErr float nJy Uncertainty of trailFlux.
trailRa double deg Right ascension coordinate of centroid for trailed source model. [pos.eq.ra]
trailRaErr float deg Uncertainty of trailRa. [stat.error;pos.eq.ra]
trailDec double deg Declination coordinate of centroid for trailed source model. [pos.eq.dec]
trailDecErr float deg Uncertainty of trailDec. [stat.error;pos.eq.dec]
trailLength float arcsec Maximum likelihood fit of trail length.
trailLengthErr float nJy Uncertainty of trailLength.
trailAngle float deg Maximum likelihood fit of the angle between the meridian through the centroid and the trail direction (bearing).
trailAngleErr float nJy Uncertainty of trailAngle.
trailFlux_trailRa_Cov float Covariance of trailFlux and trailRa. [stat.covariance]
trailFlux_trailDec_Cov float Covariance of trailFlux and trailDec. [stat.covariance]
trailFlux_trailLength_Cov float Covariance of trailFlux and trailLength [stat.covariance]
trailFlux_trailAngle_Cov float Covariance of trailFlux and trailAngle [stat.covariance]
trailRa_trailDec_Cov float Covariance of trailRa and trailDec. [stat.covariance]
trailRa_trailLength_Cov float Covariance of trailRa and trailLength. [stat.covariance]
trailRa_trailAngle_Cov float Covariance of trailRa and trailAngle. [stat.covariance]
trailDec_trailLength_Cov float Covariance of trailDec and trailLength. [stat.covariance]
trailDec_trailAngle_Cov float Covariance of trailDec and trailAngle. [stat.covariance]
trailLength_trailAngle_Cov float Covariance of trailLength and trailAngle [stat.covariance]
trailLnL float Natural log likelihood of the observed data given the trailed source model. [stat.likelihood]
trailChi2 float Chi^2 statistic of the trailed source model fit. [stat.fit.chi2]
trailNdata int The number of data points (pixels) used to fit the trailed source model.
dipoleMeanFlux float nJy Maximum likelihood value for the mean absolute flux of the two lobes for a dipole model.
dipoleMeanFluxErr float nJy Uncertainty of dipoleMeanFlux. [stat.error]
dipoleFluxDiff float nJy Maximum likelihood value for the difference of absolute fluxes of the two lobes for a dipole model.
dipoleFluxDiffErr float nJy Uncertainty of dipoleFluxDiff. [stat.error]
dipoleRa double deg Right ascension coordinate of centroid for dipole model. [pos.eq.ra]
dipoleRaErr float deg Uncertainty of dipoleRa. [stat.error;pos.eq.ra]
dipoleDec double deg Declination coordinate of centroid for dipole model. [pos.eq.dec]
dipoleDecErr float deg Uncertainty of dipoleDec. [stat.error;pos.eq.dec]
dipoleLength float arcsec Maximum likelihood value for the lobe separation in dipole model. [pos.angDistance]
dipoleLengthErr float arcsec Uncertainty of dipoleLength. [stat.error;pos.angDistance]
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]
dipoleAngleErr float deg Uncertainty of dipoleAngle. [stat.error;pos.posAng]
dipoleMeanFlux_dipoleFluxDiff_Cov float Covariance of dipoleMeanFlux and dipoleFluxDiff. [stat.covariance]
dipoleMeanFlux_dipoleRa_Cov float Covariance of dipoleMeanFlux and dipoleRa. [stat.covariance]
dipoleMeanFlux_dipoleDec_Cov float Covariance of dipoleMeanFlux and dipoleDec. [stat.covariance]
dipoleMeanFlux_dipoleLength_Cov float Covariance of dipoleMeanFlux and dipoleLength. [stat.covariance]
dipoleMeanFlux_dipoleAngle_Cov float Covariance of dipoleMeanFlux and dipoleAngle. [stat.covariance]
dipoleFluxDiff_dipoleRa_Cov float Covariance of dipoleFluxDiff and dipoleRa. [stat.covariance]
dipoleFluxDiff_dipoleDec_Cov float Covariance of dipoleFluxDiff and dipoleDec. [stat.covariance]
dipoleFluxDiff_dipoleLength_Cov float Covariance of dipoleFluxDiff and dipoleLength. [stat.covariance]
dipoleFluxDiff_dipoleAngle_Cov float Covariance of dipoleFluxDiff and dipoleAngle. [stat.covariance]
dipoleRa_dipoleDec_Cov float Covariance of dipoleRa and dipoleDec. [stat.covariance]
dipoleRa_dipoleLength_Cov float Covariance of dipoleRa and dipoleLength. [stat.covariance]
dipoleRa_dipoleAngle_Cov float Covariance of dipoleRa and dipoleAngle. [stat.covariance]
dipoleDec_dipoleLength_Cov float Covariance of dipoleDec and dipoleLength. [stat.covariance]
dipoleDec_dipoleAngle_Cov float Covariance of dipoleDec and dipoleAngle. [stat.covariance]
dipoleLength_dipoleAngle_Cov float Covariance of dipoleLength and dipoleAngle. [stat.covariance]
dipoleLnL float Natural log likelihood of the observed data given the dipole source model. [stat.likelihood]
dipoleChi2 float Chi^2 statistic of the model fit. [stat.fit.chi2]
dipoleNdata int The number of data points (pixels) used to fit the model.
scienceFlux float nJy Forced photometry flux for a point source model measured on the visit image centered at DiaSource position. [phot.count]
scienceFluxErr float nJy Estimated uncertainty of scienceFlux. [stat.error;phot.count]
snapDiffFlux float nJy Calibrated flux for Point Source model centered on radec but measured on the difference of snaps comprising this visit.
snapDiffFluxErr float nJy Estimated uncertainty of snapDiffFlux. [stat.error;phot.count]
fpBkgd float nJy/arcsec**2 Estimated sky background at the position (centroid) of the object.
fpBkgdErr float nJy/arcsec**2 Estimated uncertainty of fpBkgd.
ixx float nJy.arcsec**2 Adaptive second moment of the source intensity.
ixxErr float nJy.arcsec**2 Uncertainty of ixx. [stat.error]
iyy float nJy.arcsec**2 Adaptive second moment of the source intensity.
iyyErr float nJy.arcsec**2 Uncertainty of iyy. [stat.error]
ixy float nJy.arcsec**2 Adaptive second moment of the source intensity.
ixyErr float nJy.arcsec**2 Uncertainty of ixy. [stat.error]
ixx_iyy_Cov float nJy**2.arcsec**4 Covariance of ixx and iyy.
ixx_ixy_Cov float nJy**2.arcsec**4 Covariance of ixx and ixy.
iyy_ixy_Cov float nJy**2.arcsec**4 Covariance of iyy and ixy.
ixxPSF float nJy.arcsec**2 Adaptive second moment for the PSF.
iyyPSF float nJy.arcsec**2 Adaptive second moment for the PSF.
ixyPSF float nJy.arcsec**2 Adaptive second moment for the PSF.
extendedness float A measure of extendedness, Computed using a combination of available moments and model fluxes or from a likelihood ratio of point/trailed source models (exact algorithm TBD). 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.
reliability float A measure of reliability, computed using information from the source and image characterization, as well as the information on the Telescope and Camera system (e.g., ghost maps, defect maps, etc.).
flags long Flags, bitwise OR tbd. [meta.code]
band char Filter band this source was observed with.
isDipole boolean Object determined to be a dipole.
time_processed timestamp Time when the image was processed and this DiaSource record was generated.
time_withdrawn timestamp Time when this record was marked invalid.
bboxSize long

DiaForcedSource

Forced-photometry source measurement on an individual difference Exposure based on a Multifit shape model derived from a deep detection.

Column Name Data Type Unit Description [UCD]
diaForcedSourceId long Unique id.
diaObjectId long Id of the DiaObject that this DiaForcedSource was associated with. [meta.id;src]
ccdVisitId long Id of the ccdVisit where this forcedSource was measured. [meta.id;obs.image]
psfFlux float nJy Point Source model flux. [phot.count]
psfFluxErr float nJy Uncertainty of psfFlux. [stat.error;phot.count]
x float pixel x position at which psfFlux has been measured. [pos.cartesian.x]
y float pixel y position at which psfFlux has been measured. [pos.cartesian.y]
flags long Flags, bitwise OR tbd [meta.code]
midpointMjdTai double d Effective mid-visit time for this diaForcedSource, expressed as Modified Julian Date, International Atomic Time. [time.epoch]
scienceFlux float nJy Forced photometry flux for a point source model measured on the visit image centered at the DiaObject position. [phot.count]
scienceFluxErr float nJy Uncertainty of scienceFlux. [stat.error;phot.count]
band char Filter band this source was observed with. [meta.id;instr.filter]
time_processed timestamp Time when this record was generated.
time_withdrawn timestamp Time when this record was marked invalid.

DiaObject_To_Object_Match

The table stores mapping of diaObjects to the nearby objects.

Column Name Data Type Unit Description [UCD]
diaObjectId long Id of diaObject. [meta.id;src]
objectId long Id of a nearby object. [meta.id;src]
dist float arcsec The distance between the diaObject and the object.
lnP float Natural log of the probability that the observed diaObject is the same as the nearby object.

DiaObjectLast

Table with a subset of DiaObject columns used to store only the latest version of each object.

Column Name Data Type Unit Description [UCD]
diaObjectId long Unique id. [meta.id;src]
lastNonForcedSource timestamp Last time when non-forced DIASource was seen for this object.
ra double deg Right ascension coordinate of the position of the object at time radecMjdTai. [pos.eq.ra]
raErr float deg Uncertainty of ra. [stat.error;pos.eq.ra]
dec double deg Declination coordinate of the position of the object at time radecMjdTai. [pos.eq.dec]
decErr float deg Uncertainty of dec. [stat.error;pos.eq.dec]
ra_dec_Cov float deg**2 Covariance between ra and dec.
radecMjdTai double Time at which the object was at a position ra/dec, expressed as Modified Julian Date, International Atomic Time. [time.epoch]
pmRa float mas/yr Proper motion (RA). [pos.pm]
pmRaErr float mas/yr Uncertainty of pmRa. [stat.error;pos.pm]
pmDec float mas/yr Proper motion (Dec). [pos.pm]
pmDecErr float mas/yr Uncertainty of pmDec. [stat.error;pos.pm]
parallax float mas Parallax. [pos.parallax]
parallaxErr float mas Uncertainty of parallax. [stat.error;pos.parallax]
pmRa_pmDec_Cov float mas**2/yr**2 Covariance of pmRa and pmDec. [stat.covariance;pos.eq]
pmRa_parallax_Cov float mas**2/yr Covariance of pmRa and parallax. [stat.covariance]
pmDec_parallax_Cov float mas**2/yr Covariance of pmDec and parallax. [stat.covariance]

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

Column Name Data Type Unit Description [UCD]
mpcDesignation char MPCORB: Number or provisional designation (in packed form) [meta.id;src]
mpcNumber int MPC number (if the asteroid has been numbered; NULL otherwise). Provided for convenience.
ssObjectId long LSST unique identifier (if observed by LSST) [meta.id;src]
mpcH float mag MPCORB: Absolute magnitude, H
mpcG float MPCORB: Slope parameter, G
epoch double d MPCORB: Epoch (in MJD, .0 TT)
M double deg MPCORB: Mean anomaly at the epoch, in degrees
peri double deg MPCORB: Argument of perihelion, J2000.0 (degrees)
node double deg MPCORB: Longitude of the ascending node, J2000.0 (degrees)
incl double deg MPCORB: Inclination to the ecliptic, J2000.0 (degrees)
e double MPCORB: Orbital eccentricity
n double deg/d MPCORB: Mean daily motion (degrees per day)
a double AU MPCORB: Semimajor axis (AU)
uncertaintyParameter char MPCORB: Uncertainty parameter, U
reference char MPCORB: Reference
nobs int MPCORB: Number of observations
nopp int MPCORB: Number of oppositions
arc float d MPCORB: Arc (days), for single-opposition objects
arcStart timestamp MPCORB: Year of first observation (for multi-opposition objects)
arcEnd timestamp MPCORB: Year of last observation (for multi-opposition objects)
rms float arcsec MPCORB: r.m.s residual (")
pertsShort char MPCORB: Coarse indicator of perturbers (blank if unperturbed one-opposition object)
pertsLong char MPCORB: Precise indicator of perturbers (blank if unperturbed one-opposition object)
computer char MPCORB: Computer name
flags int MPCORB: 4-hexdigit flags. See https://minorplanetcenter.net//iau/info/MPOrbitFormat.html for details
fullDesignation char MPCORB: Readable designation
lastIncludedObservation float d MPCORB: Date of last observation included in orbit solution

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.

Column Name Data Type Unit Description [UCD]
mpcDesignation char Either the MPC provisional or permanent designation [meta.id;src]
mpcNumber int MPC number (if the asteroid has been numbered)
otherDesignation char Other designation by which this object is known
ssObjectId long LSST unique identifier (if observed by LSST) [meta.id;src]

SSSource

LSST-computed per-source quantities. 1:1 relationship with DIASource. Recomputed daily, upon MPCORB ingestion.

Column Name Data Type Unit Description [UCD]
ssObjectId long Unique identifier of the object. [meta.id;src]
diaSourceId long Unique identifier of the observation [meta.id;src]
mpcUniqueId long MPC unique identifier of the observation
nearbyObj1 long Closest Objects (3 stars and 3 galaxies) in Level 2 database.
nearbyObj2 long Closest Objects (3 stars and 3 galaxies) in Level 2 database.
nearbyObj3 long Closest Objects (3 stars and 3 galaxies) in Level 2 database.
nearbyObj4 long Closest Objects (3 stars and 3 galaxies) in Level 2 database.
nearbyObj5 long Closest Objects (3 stars and 3 galaxies) in Level 2 database.
nearbyObj6 long Closest Objects (3 stars and 3 galaxies) in Level 2 database.
nearbyObjDist1 float Distances to nearbyObj
nearbyObjDist2 float Distances to nearbyObj
nearbyObjDist3 float Distances to nearbyObj
nearbyObjDist4 float Distances to nearbyObj
nearbyObjDist5 float Distances to nearbyObj
nearbyObjDist6 float Distances to nearbyObj
nearbyObjLnP1 float Natural log of the probability that the observed DIAObject is the same as the nearby Object
nearbyObjLnP2 float Natural log of the probability that the observed DIAObject is the same as the nearby Object
nearbyObjLnP3 float Natural log of the probability that the observed DIAObject is the same as the nearby Object
nearbyObjLnP4 float Natural log of the probability that the observed DIAObject is the same as the nearby Object
nearbyObjLnP5 float Natural log of the probability that the observed DIAObject is the same as the nearby Object
nearbyObjLnP6 float Natural log of the probability that the observed DIAObject is the same as the nearby Object
eclipticLambda double deg Ecliptic longitude
eclipticBeta double deg Ecliptic latitude
galacticL double deg Galactic longitude
galacticB double deg Galactic latitute
phaseAngle float deg Phase angle
heliocentricDist float AU Heliocentric distance
topocentricDist float AU Topocentric distace
predictedMagnitude float mag Predicted magnitude
predictedMagnitudeSigma float mag Prediction uncertainty (1-sigma)
residualRa double deg Residual R.A. vs. ephemeris
residualDec double deg Residual Dec vs. ephemeris
predictedRaSigma float deg Predicted R.A. uncertainty
predictedDecSigma float deg Predicted Dec uncertainty
predictedRaDecCov float deg**2 Predicted R.A./Dec covariance
heliocentricX float AU Cartesian heliocentric X coordinate (at the emit time)
heliocentricY float AU Cartesian heliocentric Y coordinate (at the emit time)
heliocentricZ float AU Cartesian heliocentric Z coordinate (at the emit time)
heliocentricVX float AU Cartesian heliocentric X velocity (at the emit time)
heliocentricVY float AU Cartesian heliocentric Y velocity (at the emit time)
heliocentricVZ float AU Cartesian heliocentric Z velocity (at the emit time)
topocentricX float AU Cartesian topocentric X coordinate (at the emit time)
topocentricY float AU Cartesian topocentric Y coordinate (at the emit time)
topocentricZ float AU Cartesian topocentric Z coordinate (at the emit time)
topocentricVX float AU Cartesian topocentric X velocity (at the emit time)
topocentricVY float AU Cartesian topocentric Y velocity (at the emit time)
topocentricVZ float AU Cartesian topocentric Z velocity (at the emit time)

DetectorVisitProcessingSummary

Properties of an image from one processing of a single detector in a visit.

Column Name Data Type Unit Description [UCD]
ccdVisitId long Unique identifier.
visit long Id of the visit this visit was a part of.
detector long Id of the detector on the instrument that took this visit.
ra double deg Right Ascension of detector center.
dec double deg Declination of detector center.
zeroPoint float mag Zero-point for the detector, estimated at detector center.
psfSigma float pixel PSF model second-moments determinant radius (center of detector).
skyBg float adu Average sky background.
skyNoise float adu RMS noise of the sky background.
seeing double arcsec Mean measured FWHM of the PSF.
xSize long pixel Number of columns in the image.
ySize long pixel Number of rows in the image.
llcra double deg RA of lower left corner.
llcdec double deg Declination of lower left corner.
ulcra double deg RA of upper left corner.
ulcdec double deg Declination of upper left corner.
urcra double deg RA of upper right corner.
urcdec double deg Declination of upper right corner.
lrcra double deg RA of lower right corner.
lrcdec double deg Declination of lower right corner.
astromOffsetMean double arcsec Mean offset of astrometric calibration matches (arcsec).
astromOffsetStd double arcsec Standard deviation of offsets of astrometric calibration matches (arcsec).
nPsfStar int Number of stars used for PSF model.
psfStarDeltaE1Median double Median E1 residual (starE1 - psfE1) for psf stars.
psfStarDeltaE2Median double Median E2 residual (starE2 - psfE2) for psf stars.
psfStarDeltaE1Scatter double Scatter (via MAD) of E1 residual (starE1 - psfE1) for psf stars.
psfStarDeltaE2Scatter double Scatter (via MAD) of E2 residual (starE2 - psfE2) for psf stars.
psfStarDeltaSizeMedian double pixel Median size residual (starSize - psfSize) for psf stars (pixel).
psfStarDeltaSizeScatter double pixel Scatter (via MAD) of size residual (starSize - psfSize) for stars (pixel).
psfStarScaledDeltaSizeScatter double Scatter (via MAD) of size residual scaled by median size squared.
psfTraceRadiusDelta double pixel Delta (max - min) of model psf trace radius values evaluated on a grid of unmasked pixels (pixel).
maxDistToNearestPsf double pixel Maximum distance of an unmasked pixel to its nearest model psf star (pixel).

Instrument

The instrument that took this data.

Column Name Data Type Unit Description [UCD]
instrument string Name of the instrument that took this data.