Prompt Products Database

DiaForcedSource

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

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

DiaObject

Astronomical objects detected on one or more difference images

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

DiaSource

Difference image sources detected on difference images

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

SDM Schemas is maintained by Rubin Observatory.