Alert Production Database
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 | Index | Principal |
---|---|---|---|---|---|---|
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 | Index | Principal |
---|---|---|---|---|---|---|
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 | ||
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. | |||
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 | Index | Principal |
---|---|---|---|---|---|---|
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. |
DiaSource
Table to store 'difference image sources'; - sources detected at SNR >=5 on difference images.
Column Name | Data Type | Unit | Description | UCD | Index | Principal |
---|---|---|---|---|---|---|
diaSourceId | long | Unique identifier of this DiaSource. | meta.id;obs.image | |||
visit | long | Id of the visit where this diaSource was measured. | meta.id;obs.image | |||
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 | |||
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 | ||
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. | ||||
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 | ||
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. | ||||
apFlux_flag_apertureTruncated | boolean | Aperture did not fit within measurement image. | ||||
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. | ||||
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. | ||||
psfFlux_flag_edge | boolean | Object was too close to the edge of the image to use the full PSF model. | ||||
psfFlux_flag_noGoodPixels | boolean | Not enough non-rejected pixels in data to attempt the fit. | ||||
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. | ||||
trail_flag_edge | boolean | This flag is set if a trailed source extends onto or past edge pixels. | ||||
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 | ||
forced_PsfFlux_flag | boolean | Forced PSF photometry on science image failed. Another forced_PsfFlux flag field should also be set to provide more information. | ||||
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. | ||||
forced_PsfFlux_flag_noGoodPixels | boolean | Forced PSF flux not enough non-rejected pixels in data to attempt the fit. | ||||
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. | |||
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. | ||||
shape_flag_no_pixels | boolean | No pixels to measure shape. | ||||
shape_flag_not_contained | boolean | Center not contained in footprint bounding box. | ||||
shape_flag_parent_source | boolean | This source is a parent source; we should only be measuring on deblended children in difference imaging. | ||||
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.). | ||||
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 | |||||
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. | ||||
pixelFlags_bad | boolean | Bad pixel in the DiaSource footprint. | ||||
pixelFlags_cr | boolean | Cosmic ray in the DiaSource footprint. | ||||
pixelFlags_crCenter | boolean | Cosmic ray in the 3x3 region around the centroid. | ||||
pixelFlags_edge | boolean | Some of the source footprint is outside usable exposure region (masked EDGE or NO_DATA, or centroid off image). | ||||
pixelFlags_interpolated | boolean | Interpolated pixel in the DiaSource footprint. | ||||
pixelFlags_interpolatedCenter | boolean | Interpolated pixel in the 3x3 region around the centroid. | ||||
pixelFlags_offimage | boolean | DiaSource center is off image. | ||||
pixelFlags_saturated | boolean | Saturated pixel in the DiaSource footprint. | ||||
pixelFlags_saturatedCenter | boolean | Saturated pixel in the 3x3 region around the centroid. | ||||
pixelFlags_suspect | boolean | DiaSource's footprint includes suspect pixels. | ||||
pixelFlags_suspectCenter | boolean | Suspect pixel in the 3x3 region around the centroid. | ||||
pixelFlags_streak | boolean | Streak in the DiaSource footprint. | ||||
pixelFlags_streakCenter | boolean | Streak in the 3x3 region around the centroid. | ||||
pixelFlags_injected | boolean | Injection in the DiaSource footprint. | ||||
pixelFlags_injectedCenter | boolean | Injection in the 3x3 region around the centroid. | ||||
pixelFlags_injected_template | boolean | Template injection in the DiaSource footprint. | ||||
pixelFlags_injected_templateCenter | boolean | Template injection in the 3x3 region around the centroid. |
DiaForcedSource
Forced-photometry source measurement on an individual difference Exposure for all objects in the DiaObject table.
Column Name | Data Type | Unit | Description | UCD | Index | Principal |
---|---|---|---|---|---|---|
diaForcedSourceId | long | Unique id. | ||||
diaObjectId | long | Id of the DiaObject that this DiaForcedSource was associated with. | meta.id;src | |||
ra | double | deg | Right ascension coordinate of the position of the DiaObject at time radecMjdTai. | pos.eq.ra | ||
dec | double | deg | Declination coordinate of the position of the DiaObject at time radecMjdTai. | pos.eq.dec | ||
visit | long | Id of the visit where this forcedSource was measured. | meta.id;obs.image | |||
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 | |||
psfFlux | float | nJy | Point Source model flux. | phot.count | ||
psfFluxErr | float | nJy | Uncertainty of psfFlux. | stat.error;phot.count | ||
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 | Index | Principal |
---|---|---|---|---|---|---|
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 | Index | Principal |
---|---|---|---|---|---|---|
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 | Index | Principal |
---|---|---|---|---|---|---|
mpcDesignation | char | 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 | Absolute magnitude, H. | |||
mpcG | float | Slope parameter, G. | ||||
epoch | double | d | Epoch (in MJD, .0 TT). | |||
M | double | deg | Mean anomaly at the epoch, in degrees. | |||
peri | double | deg | Argument of perihelion, J2000.0 (degrees). | |||
node | double | deg | Longitude of the ascending node, J2000.0 (degrees). | |||
incl | double | deg | Inclination to the ecliptic, J2000.0 (degrees). | |||
e | double | Orbital eccentricity. | ||||
n | double | deg/d | Mean daily motion (degrees per day). | |||
a | double | AU | Semimajor axis (AU). | |||
uncertaintyParameter | char | Uncertainty parameter, U. | ||||
reference | char | Reference. | ||||
nobs | int | Number of observations. | ||||
nopp | int | Number of oppositions. | ||||
arc | float | d | Arc (days), for single-opposition objects. | |||
arcStart | timestamp | Year of first observation (for multi-opposition objects). | ||||
arcEnd | timestamp | Year of last observation (for multi-opposition objects). | ||||
rms | float | arcsec | r.m.s residual (arcsec). | |||
pertsShort | char | Coarse indicator of perturbers (blank if unperturbed one-opposition. object)' | ||||
pertsLong | char | Precise indicator of perturbers (blank if unperturbed one-opposition. object)' | ||||
computer | char | Computer name. | ||||
flags | int | 4-hexdigit flags. See https://minorplanetcenter.net//iau/info/MPOrbitFormat.html. for details' | ||||
fullDesignation | char | Readable designation. | ||||
lastIncludedObservation | float | d | 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 | Index | Principal |
---|---|---|---|---|---|---|
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 | Index | Principal |
---|---|---|---|---|---|---|
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 | Index | Principal |
---|---|---|---|---|---|---|
visit | long | Id of the visit this visit was a part of. | meta.id;obs.image | |||
detector | short | Id of the detector on the instrument that took this visit. Datatype short instead of byte because of DB concerns about unsigned bytes. | meta.id;obs.image | |||
ra | double | deg | Right Ascension of detector center. | |||
dec | double | deg | Declination of detector center. | |||
pixelScale | float | arcsec/pixel | Measured detector pixel scale. | |||
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). | |||
psfApFluxDelta | double | Delta (max - min) of model psf aperture flux (with aperture radius of max(2, 3*psfSigma)) values evaluated on a grid of unmasked pixels | ||||
psfApCorrSigmaScaledDelta | double | Delta (max - min) of psf flux aperture correction factors scaled (divided) by the psfSigma evaluated on a grid of unmasked pixels | ||||
maxDistToNearestPsf | double | pixel | Maximum distance of an unmasked pixel to its nearest model psf star (pixel). |
SDM Schemas is maintained by Rubin Observatory.