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.

SSObject

LSST-computed per-object quantities.

Indexes
Columns Description Reference Name
MOIDEarth Index on the MOIDEarth column idx_SSObject_MOIDEarth
Column Name Data Type Unit Description UCD Order Principal
ssObjectId long Unique identifier. meta.id;src
designation char The unpacked primary provisional designation for this object. meta.id;src
nObs int Total number of LSST observations of this object. meta.number;obs
arc float d Timespan ("arc") of all LSST observations, t_{last} - t_{first} time.duration;obs
firstObservationMjdTai double d The time of the first LSST observation of this object (could be precovered), TAI. time.epoch;obs
MOIDEarth float AU Minimum orbit intersection distance to Earth. pos.distance;src.orbital
MOIDEarthDeltaV float km/s DeltaV at the MOID point. phys.veloc.orbital
MOIDEarthEclipticLongitude float deg Ecliptic longitude of the MOID point (Earth's orbit). pos.ecliptic.lon
MOIDEarthTrueAnomaly float deg True anomaly of the MOID point on Earth's orbit. pos.phaseAng
MOIDEarthTrueAnomalyObject float deg True anomaly of the MOID point on the object's orbit. pos.phaseAng;src.orbital
tisserand_J float Tisserand parameter with respect to Jupiter (T_J). src.orbital.TissJ
extendednessMax float Maximum `extendedness` value from the DiaSource.
extendednessMedian float Median `extendedness` value from the DiaSource.
extendednessMin float Minimum `extendedness` value from the DiaSource.
u_nObs int Total number of data points (u band). meta.number;obs
u_H float mag Best fit absolute magnitude (u band). phot.mag
u_HErr float mag Error in the estimate of H (u band). stat.error;phot.mag
u_G12 float Best fit G12 slope parameter (u band). stat.fit.param
u_G12Err float Error in the estimate of G12 (u band). stat.error;stat.fit.param
u_H_u_G12_Cov float mag**2 H–G12 covariance (u band). stat.covariance;phot.mag;stat.fit.param
u_nObsUsed int The number of data points used to fit the phase curve (u band). meta.number;obs
u_Chi2 float Chi^2 statistic of the phase curve fit (u band). stat.fit.chi2
u_phaseAngleMin float deg Minimum phase angle observed (u band). pos.phaseAng;stat.min
u_phaseAngleMax float deg Maximum phase angle observed (u band). pos.phaseAng;stat.max
u_slope_fit_failed boolean G12 fit failed in u band. G12 contains a fiducial value used to fit H.
g_nObs int Total number of data points (g band). meta.number;obs
g_H float mag Best fit absolute magnitude (g band). phot.mag
g_HErr float mag Error in the estimate of H (g band). stat.error;phot.mag
g_G12 float Best fit G12 slope parameter (g band). stat.fit.param
g_G12Err float Error in the estimate of G12 (g band). stat.error;stat.fit.param
g_H_g_G12_Cov float mag**2 H–G12 covariance (g band). stat.covariance;phot.mag;stat.fit.param
g_nObsUsed int The number of data points used to fit the phase curve (g band). meta.number;obs
g_Chi2 float Chi^2 statistic of the phase curve fit (g band). stat.fit.chi2
g_phaseAngleMin float deg Minimum phase angle observed (g band). pos.phaseAng;stat.min
g_phaseAngleMax float deg Maximum phase angle observed (g band). pos.phaseAng;stat.max
g_slope_fit_failed boolean G12 fit failed in g band. G12 contains a fiducial value used to fit H.
r_nObs int Total number of data points (r band). meta.number;obs
r_H float mag Best fit absolute magnitude (r band). phot.mag
r_HErr float mag Error in the estimate of H (r band). stat.error;phot.mag
r_G12 float Best fit G12 slope parameter (r band). stat.fit.param
r_G12Err float Error in the estimate of G12 (r band). stat.error;stat.fit.param
r_H_r_G12_Cov float mag**2 H–G12 covariance (r band). stat.covariance;phot.mag;stat.fit.param
r_nObsUsed int The number of data points used to fit the phase curve (r band). meta.number;obs
r_Chi2 float Chi^2 statistic of the phase curve fit (r band). stat.fit.chi2
r_phaseAngleMin float deg Minimum phase angle observed (r band). pos.phaseAng;stat.min
r_phaseAngleMax float deg Maximum phase angle observed (r band). pos.phaseAng;stat.max
r_slope_fit_failed boolean G12 fit failed in r band. G12 contains a fiducial value used to fit H.
i_nObs int Total number of data points (i band). meta.number;obs
i_H float mag Best fit absolute magnitude (i band). phot.mag
i_HErr float mag Error in the estimate of H (i band). stat.error;phot.mag
i_G12 float Best fit G12 slope parameter (i band). stat.fit.param
i_G12Err float Error in the estimate of G12 (i band). stat.error;stat.fit.param
i_H_i_G12_Cov float mag**2 H–G12 covariance (i band). stat.covariance;phot.mag;stat.fit.param
i_nObsUsed int The number of data points used to fit the phase curve (i band). meta.number;obs
i_Chi2 float Chi^2 statistic of the phase curve fit (i band). stat.fit.chi2
i_phaseAngleMin float deg Minimum phase angle observed (i band). pos.phaseAng;stat.min
i_phaseAngleMax float deg Maximum phase angle observed (i band). pos.phaseAng;stat.max
i_slope_fit_failed boolean G12 fit failed in i band. G12 contains a fiducial value used to fit H.
z_nObs int Total number of data points (z band). meta.number;obs
z_H float mag Best fit absolute magnitude (z band). phot.mag
z_HErr float mag Error in the estimate of H (z band). stat.error;phot.mag
z_G12 float Best fit G12 slope parameter (z band). stat.fit.param
z_G12Err float Error in the estimate of G12 (z band). stat.error;stat.fit.param
z_H_z_G12_Cov float mag**2 H–G12 covariance (z band). stat.covariance;phot.mag;stat.fit.param
z_nObsUsed int The number of data points used to fit the phase curve (z band). meta.number;obs
z_Chi2 float Chi^2 statistic of the phase curve fit (z band). stat.fit.chi2
z_phaseAngleMin float deg Minimum phase angle observed (z band). pos.phaseAng;stat.min
z_phaseAngleMax float deg Maximum phase angle observed (z band). pos.phaseAng;stat.max
z_slope_fit_failed boolean G12 fit failed in z band. G12 contains a fiducial value used to fit H.
y_nObs int Total number of data points (y band). meta.number;obs
y_H float mag Best fit absolute magnitude (y band). phot.mag
y_HErr float mag Error in the estimate of H (y band). stat.error;phot.mag
y_G12 float Best fit G12 slope parameter (y band). stat.fit.param
y_G12Err float Error in the estimate of G12 (y band). stat.error;stat.fit.param
y_H_y_G12_Cov float mag**2 H–G12 covariance (y band). stat.covariance;phot.mag;stat.fit.param
y_nObsUsed int The number of data points used to fit the phase curve (y band). meta.number;obs
y_Chi2 float Chi^2 statistic of the phase curve fit (y band). stat.fit.chi2
y_phaseAngleMin float deg Minimum phase angle observed (y band). pos.phaseAng;stat.min
y_phaseAngleMax float deg Maximum phase angle observed (y band). pos.phaseAng;stat.max
y_slope_fit_failed boolean G12 fit failed in y band. G12 contains a fiducial value used to fit H.

SSSource

LSST-computed per-source quantities. 1::1 relationship with DiaSource.

Indexes
Columns Description Reference Name
ssObjectId Non-unique index on the ssObjectId column; accelerates retrieval of single-epoch data for SSObjects. idx_SSSource_ssObjectId
designation Non-unique index on the designation column; accelerates retrieval of single-epoch data for SSObjects. idx_SSSource_designation
Column Name Data Type Unit Description UCD Order Principal
diaSourceId long Unique identifier of the observation (matching DiaSource.diaSourceId). meta.id;src
ssObjectId long Unique LSST identifier of the Solar System object. meta.id;src
designation char The unpacked primary provisional designation for this object. meta.id;src
eclLambda double deg Ecliptic longitude, converted from the observed coordinates. pos.ecliptic.lon
eclBeta double deg Ecliptic latitude, converted from the observed coordinates. pos.ecliptic.lat
galLon double deg Galactic longitude, converted from the observed coordinates. pos.galactic.lon
galLat double deg Galactic latitude, converted from the observed coordinates. pos.galactic.lat
elongation float deg Solar elongation of the object at the time of observation. pos.phaseAng
phaseAngle float deg Phase angle between the Sun, object, and observer. pos.phaseAng
topoRange float AU Topocentric distance (delta) at light-emission time. pos.distance
topoRangeRate float km/s Topocentric radial (line-of-sight) velocity (deldot); positive values indicate motion away from the observer. phys.veloc
helioRange float AU Heliocentric distance (r) at light-emission time. pos.distance;pos.heliocentric
helioRangeRate float km/s Heliocentric radial velocity (rdot); positive values indicate motion away from the Sun. phys.veloc;pos.heliocentric
ephRa double deg Predicted ICRS right ascension from the orbit in mpc_orbits. pos.eq.ra;meta.modelled;pos.ephem
ephDec double deg Predicted ICRS declination from the orbit in mpc_orbits. pos.eq.dec;meta.modelled;pos.ephem
ephVmag float mag Predicted magnitude in V band, computed from mpc_orbits data including the mpc_orbits-provided (H, G) estimates phot.mag;em.opt.V
ephRate float deg/d Total predicted on-sky angular rate of motion. pos.pm;pos.ephem
ephRateRa float deg/d Predicted on-sky angular rate in the R.A. direction (includes the cos(dec) factor). pos.pm;pos.eq.ra;pos.ephem
ephRateDec float deg/d Predicted on-sky angular rate in the declination direction. pos.pm;pos.eq.dec;pos.ephem
ephOffset float arcsec Total observed versus predicted angular separation on the sky. pos.angDistance;stat.fit.omc
ephOffsetRa double arcsec Offset between observed and predicted position in the R.A. direction (includes cos(dec) term). pos.eq.ra;stat.fit.omc
ephOffsetDec double arcsec Offset between observed and predicted position in declination. pos.eq.dec;stat.fit.omc
ephOffsetAlongTrack float arcsec Offset between observed and predicted position in the along-track direction on the sky. pos.angDistance;stat.fit.omc
ephOffsetCrossTrack float arcsec Offset between observed and predicted position in the cross-track direction on the sky. pos.angDistance;stat.fit.omc
helio_x float AU Cartesian heliocentric X coordinate at light-emission time (ICRS). pos.cartesian.x;pos.heliocentric
helio_y float AU Cartesian heliocentric Y coordinate at light-emission time (ICRS). pos.cartesian.y;pos.heliocentric
helio_z float AU Cartesian heliocentric Z coordinate at light-emission time (ICRS). pos.cartesian.z;pos.heliocentric
helio_vx float km/s Cartesian heliocentric X velocity at light-emission time (ICRS). phys.veloc;pos.cartesian.x
helio_vy float km/s Cartesian heliocentric Y velocity at light-emission time (ICRS). phys.veloc;pos.cartesian.y
helio_vz float km/s Cartesian heliocentric Z velocity at light-emission time (ICRS). phys.veloc;pos.cartesian.z
helio_vtot float km/s The magnitude of the heliocentric velocity vector, sqrt(vx*vx + vy*vy + vz*vz). phys.veloc;pos.heliocentric
topo_x float AU Cartesian topocentric X coordinate at light-emission time (ICRS). pos.cartesian.x
topo_y float AU Cartesian topocentric Y coordinate at light-emission time (ICRS). pos.cartesian.y
topo_z float AU Cartesian topocentric Z coordinate at light-emission time (ICRS). pos.cartesian.z
topo_vx float km/s Cartesian topocentric X velocity at light-emission time (ICRS). phys.veloc;pos.cartesian.x
topo_vy float km/s Cartesian topocentric Y velocity at light-emission time (ICRS). phys.veloc;pos.cartesian.y
topo_vz float km/s Cartesian topocentric Z velocity at light-emission time (ICRS). phys.veloc;pos.cartesian.z
topo_vtot float km/s The magnitude of the topocentric velocity vector, sqrt(vx*vx + vy*vy + vz*vz). phys.veloc
diaDistanceRank short The rank of the diaSourceId-identified source in terms of its closeness to the predicted SSO position. If diaSourceId is the nearest DiaSource to this SSO prediction, diaSourceDistanceRank=1 would be set. If it is the second nearest, it would be 2, etc.

mpc_orbits

Table of orbital elements and related information of known (sun-orbiting and unbound) Solar System objects. Replicated from the Minor Planet Center (Postgres) database. This schema will generally closely follow the schema of the upstream table, to allow end-users to rerun queries developed elsewhere on the RSP.

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

current_identifications

All single-designations, and all identifications between designations. Always uses primary provisional designation (even for numbered objects). Includes all comets and satellites. Replicated from the Minor Planet Center (Postgres) database. This schema will generally closely follow the schema of the upstream table, to allow end-users to rerun queries developed elsewhere on the RSP.

Column Name Data Type Unit Description UCD Order Principal
id int Internal ID (generally not seen/used by the user) meta.id;src
packed_primary_provisional_designation char The primary provisional designation in packed form (e.g. K08A00B) meta.id;src
packed_secondary_provisional_designation char The secondary provisional designation in packed form (e.g. K08A00B). May be the same-as (A=A) or different-to (A=B) the primary provisional designation meta.id;src
unpacked_primary_provisional_designation char The primary provisional designation in unpacked form (e.g. 2008 AB) meta.id;src
unpacked_secondary_provisional_designation char The secondary provisional designation in unpacked form (e.g. 2008 AB). May be the same-as (A=A) or different-to (A=B) the primary provisional designation meta.id;src
published boolean Has this been published yet? i.e. has it been released to the public? meta.code.status;meta.dataset
identifier_ids text This is a set of unique identifier_ids in an array that points to the identification_metadata table. meta.id;src
object_type int Integer to indicate the object type. To be linked (foreign key) to object_type lookup table
numbered boolean Has the object been numbered and hence does it appear in the numbered_objects table?
created_at timestamp When this row was created time.creation;meta.dataset
updated_at timestamp When this row was updated time.processing;meta.dataset

numbered_identifications

The numbered identification table contains all the numbered objects (minor planets, comets and natural satellites) with their primary provisional designations. The table is continously updated everytime a new object is numbered. Replicated from the Minor Planet Center (Postgres) database. This schema will generally closely follow the schema of the upstream table, to allow end-users to rerun queries developed elsewhere on the RSP.

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

DetectorVisitProcessingSummary

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

Column Name Data Type Unit Description UCD Order 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).

DiaForcedSource

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

Indexes
Columns Description Reference Name
visit, detector IDX_DiaForcedSource_visitDetector
Column Name Data Type Unit Description UCD Order 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. pos.eq.ra
dec double deg Declination coordinate of the position of the DiaObject. 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
timeProcessedMjdTai double Time when this record was generated, expressed as Modified Julian Date, International Atomic Time.
timeWithdrawnMjdTai double Time when this record was marked invalid, expressed as Modified Julian Date, International Atomic Time.

DiaObject

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

Indexes
Columns Description Reference Name
validityStartMjdTai IDX_DiaObject_validityStart
Column Name Data Type Unit Description UCD Order Principal
diaObjectId long Unique identifier of this DiaObject. meta.id;src
validityStartMjdTai double Processing time when validity of this diaObject starts, expressed as Modified Julian Date, International Atomic Time. time.epoch
validityEndMjdTai double Processing time when validity of this diaObject ends, expressed as Modified Julian Date, International Atomic Time. time.epoch
ra double deg Right ascension coordinate of the position of the object. 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. 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.
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_psfFluxNdata int The number of u-band data points.
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
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_psfFluxNdata int The number of g-band data points.
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
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_psfFluxNdata int The number of r-band data points.
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
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_psfFluxNdata int The number of i-band data points.
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
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_psfFluxNdata int The number of z-band data points.
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
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.stdev
y_psfFluxNdata int The number of y-band data points.
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
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
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
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
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
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
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
u_psfFluxMin float nJy Minimum observed u band fluxes.
u_psfFluxMax float nJy Maximum observed 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_psfFluxMin float nJy Minimum observed g band fluxes.
g_psfFluxMax float nJy Maximum observed 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_psfFluxMin float nJy Minimum observed r band fluxes.
r_psfFluxMax float nJy Maximum observed 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_psfFluxMin float nJy Minimum observed i band fluxes.
i_psfFluxMax float nJy Maximum observed 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_psfFluxMin float nJy Minimum observed z band fluxes.
z_psfFluxMax float nJy Maximum observed 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_psfFluxMin float nJy Minimum observed y band fluxes.
y_psfFluxMax float nJy Maximum observed 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.
firstDiaSourceMjdTai double Time of the first diaSource, expressed as Modified Julian Date, International Atomic Time. time.epoch
lastDiaSourceMjdTai double Time of the most recent non-forced DIASource for this object, expressed as Modified Julian Date, International Atomic Time. time.epoch
nDiaSources int Total number of DiaSources associated with this DiaObject.

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 Order Principal
diaObjectId long Unique id. meta.id;src
validityStartMjdTai double Processing time when validity of this diaObject starts, expressed as Modified Julian Date, International Atomic Time. time.epoch
lastDiaSourceMjdTai double Time of the most recent non-forced DIASource for this object, expressed as Modified Julian Date, International Atomic Time. time.epoch
ra double deg Right ascension coordinate of the position of the object. 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. 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.
firstDiaSourceMjdTai double Time of the first diaSource, expressed as Modified Julian Date, International Atomic Time. time.epoch
nDiaSources int Total number of DiaSources associated with this DiaObject.

DiaObject_To_Object_Match

The table stores mapping of diaObjects to the nearby objects.

Indexes
Columns Description Reference Name
diaObjectId IDX_DiaObjectToObjectMatch_diaObjectId
objectId IDX_DiaObjectToObjectMatch_objectId
Column Name Data Type Unit Description UCD Order 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.

DiaSource

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

Indexes
Columns Description Reference Name
visit, detector IDX_DiaSource_visitDetector
diaObjectId IDX_DiaSource_diaObjectId
ssObjectId IDX_DiaSource_ssObjectId
Column Name Data Type Unit Description UCD Order 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
ssObjectReassocTimeMjdTai double Time when this diaSource was reassociated from diaObject to ssObject, expressed as Modified Julian Date, International Atomic Time (if such reassociation happens, otherwise NULL).
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
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.
isNegative boolean Source was detected as significantly negative.
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.
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.
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
dipoleLength float arcsec Maximum likelihood value for the lobe separation in dipole model. 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
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.
templateFlux float nJy Forced photometry flux for a point source model measured on the template image centered at the DiaObject position. phot.count
templateFluxErr float nJy Uncertainty of templateFlux. stat.error;phot.count
ixx float nJy.arcsec**2 Adaptive second moment of the source intensity.
iyy float nJy.arcsec**2 Adaptive second moment of the source intensity.
ixy float nJy.arcsec**2 Adaptive second moment of the source intensity.
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 by comparing an object's moment-based traced radius to the PSF moments. extendedness = 1 implies a high degree of confidence that the source is extended. extendedness = 0 implies a high degree of confidence that the source is point-like.
reliability float Probability (0-1) that the diaSource is astrophysical, derived from a machine learning model.
band char Filter band this source was observed with.
isDipole boolean Source well fit by a dipole.
dipoleFitAttempted boolean Attempted to fit a dipole model to this source.
timeProcessedMjdTai double Time when the image was processed and this DiaSource record was generated, expressed as Modified Julian Date, International Atomic Time. time.epoch
timeWithdrawnMjdTai double Time when this record was marked invalid, expressed as Modified Julian Date, International Atomic Time. time.epoch
bboxSize int pixel Size of the square bounding box that fully contains the detection footprint.
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 centroid off image).
pixelFlags_nodata boolean NO_DATA pixel in the source footprint.
pixelFlags_nodataCenter boolean NO_DATA pixel in the 3x3 region around the centroid.
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.
glint_trail boolean This flag is set if the source is part of a glint trail.

metadata

Table containing various metadata key:value pairs for APDB.

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

SDM Schemas is maintained by Rubin Observatory.