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
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	long		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	double	nJy	Point Source model flux.	phot.count
psfFluxErr	double	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	double	nJy	Forced photometry flux for a point source model measured on the visit image centered at the DiaObject position.	phot.count
scienceFluxErr	double	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

Astronomical objects detected on one or more difference images

Column Name	Data Type	Unit	Description	UCD
diaObjectId	long		Unique identifier of this DiaObject.	meta.id;src
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	double	deg	Uncertainty of ra.	stat.error;pos.eq.ra
dec	double	deg	Declination coordinate of the position of the object.	pos.eq.dec
decErr	double	deg	Uncertainty of dec.	stat.error;pos.eq.dec
ra_dec_Cov	double	deg**2	Covariance between ra and dec.
u_psfFluxMean	double	nJy	Weighted mean point-source model magnitude for u filter.	phot.count
u_psfFluxMeanErr	double	nJy	Standard error of u_psfFluxMean.	stat.error
u_psfFluxSigma	double	nJy	Standard deviation of the distribution of u_psfFlux.	stat.stdev
u_psfFluxNdata	long		The number of u-band data points.
u_fpFluxMean	double	nJy	Weighted mean forced photometry flux for u filter.	phot.count
u_fpFluxMeanErr	double	nJy	Standard error of u_fpFluxMean.	stat.error
g_psfFluxMean	double	nJy	Weighted mean point-source model magnitude for g filter.	phot.count
g_psfFluxMeanErr	double	nJy	Standard error of g_psfFluxMean.	stat.error
g_psfFluxSigma	double	nJy	Standard deviation of the distribution of g_psfFlux.	stat.stdev
g_psfFluxNdata	long		The number of g-band data points.
g_fpFluxMean	double	nJy	Weighted mean forced photometry flux for g filter.	phot.count
g_fpFluxMeanErr	double	nJy	Standard error of g_fpFluxMean.	stat.error
r_psfFluxMean	double	nJy	Weighted mean point-source model magnitude for r filter.	phot.count
r_psfFluxMeanErr	double	nJy	Standard error of r_psfFluxMean.	stat.error
r_psfFluxSigma	double	nJy	Standard deviation of the distribution of r_psfFlux.	stat.stdev
r_psfFluxNdata	long		The number of r-band data points.
r_fpFluxMean	double	nJy	Weighted mean forced photometry flux for r filter.	phot.count
r_fpFluxMeanErr	double	nJy	Standard error of r_fpFluxMean.	stat.error
i_psfFluxMean	double	nJy	Weighted mean point-source model magnitude for i filter.	phot.count
i_psfFluxMeanErr	double	nJy	Standard error of i_psfFluxMean.	stat.error
i_psfFluxSigma	double	nJy	Standard deviation of the distribution of i_psfFlux.	stat.stdev
i_psfFluxNdata	long		The number of i-band data points.
i_fpFluxMean	double	nJy	Weighted mean forced photometry flux for i filter.	phot.count
i_fpFluxMeanErr	double	nJy	Standard error of i_fpFluxMean.	stat.error
z_psfFluxMean	double	nJy	Weighted mean point-source model magnitude for z filter.	phot.count
z_psfFluxMeanErr	double	nJy	Standard error of z_psfFluxMean.	stat.error
z_psfFluxSigma	double	nJy	Standard deviation of the distribution of z_psfFlux.	stat.stdev
z_psfFluxNdata	long		The number of z-band data points.
z_fpFluxMean	double	nJy	Weighted mean forced photometry flux for z filter.	phot.count
z_fpFluxMeanErr	double	nJy	Standard error of z_fpFluxMean.	stat.error
y_psfFluxMean	double	nJy	Weighted mean point-source model magnitude for y filter.	phot.count
y_psfFluxMeanErr	double	nJy	Standard error of y_psfFluxMean.	stat.error
y_psfFluxSigma	double	nJy	Standard deviation of the distribution of y_psfFlux.	stat.stdev
y_psfFluxNdata	long		The number of y-band data points.
y_fpFluxMean	double	nJy	Weighted mean forced photometry flux for y filter.	phot.count
y_fpFluxMeanErr	double	nJy	Standard error of y_fpFluxMean.	stat.error
u_scienceFluxMean	double	nJy	Weighted mean forced photometry flux for u filter.	phot.count
u_scienceFluxMeanErr	double	nJy	Standard error of u_scienceFluxMean.	stat.error
g_scienceFluxMean	double	nJy	Weighted mean forced photometry flux for g filter.	phot.count
g_scienceFluxMeanErr	double	nJy	Standard error of g_scienceFluxMean.	stat.error
r_scienceFluxMean	double	nJy	Weighted mean forced photometry flux for r filter.	phot.count
r_scienceFluxMeanErr	double	nJy	Standard error of r_scienceFluxMean.	stat.error
i_scienceFluxMean	double	nJy	Weighted mean forced photometry flux for i filter.	phot.count
i_scienceFluxMeanErr	double	nJy	Standard error of i_scienceFluxMean.	stat.error
z_scienceFluxMean	double	nJy	Weighted mean forced photometry flux for z filter.	phot.count
z_scienceFluxMeanErr	double	nJy	Standard error of z_scienceFluxMean.	stat.error
y_scienceFluxMean	double	nJy	Weighted mean forced photometry flux for y filter.	phot.count
y_scienceFluxMeanErr	double	nJy	Standard error of y_scienceFluxMean.	stat.error
u_psfFluxMin	double	nJy	Minimum observed u band fluxes.
u_psfFluxMax	double	nJy	Maximum observed u band fluxes.
u_psfFluxMaxSlope	double	nJy/d	Maximum slope between u band flux obsevations max(delta_flux/delta_time).
u_psfFluxErrMean	double	nJy	Mean of the u band flux errors.
g_psfFluxMin	double	nJy	Minimum observed g band fluxes.
g_psfFluxMax	double	nJy	Maximum observed g band fluxes.
g_psfFluxMaxSlope	double	nJy/d	Maximum slope between g band flux obsevations max(delta_flux/delta_time).
g_psfFluxErrMean	double	nJy	Mean of the g band flux errors.
r_psfFluxMin	double	nJy	Minimum observed r band fluxes.
r_psfFluxMax	double	nJy	Maximum observed r band fluxes.
r_psfFluxMaxSlope	double	nJy/d	Maximum slope between r band flux obsevations max(delta_flux/delta_time).
r_psfFluxErrMean	double	nJy	Mean of the r band flux errors.
i_psfFluxMin	double	nJy	Minimum observed i band fluxes.
i_psfFluxMax	double	nJy	Maximum observed i band fluxes.
i_psfFluxMaxSlope	double	nJy/d	Maximum slope between i band flux obsevations max(delta_flux/delta_time).
i_psfFluxErrMean	double	nJy	Mean of the i band flux errors.
z_psfFluxMin	double	nJy	Minimum observed z band fluxes.
z_psfFluxMax	double	nJy	Maximum observed z band fluxes.
z_psfFluxMaxSlope	double	nJy/d	Maximum slope between z band flux obsevations max(delta_flux/delta_time).
z_psfFluxErrMean	double	nJy	Mean of the z band flux errors.
y_psfFluxMin	double	nJy	Minimum observed y band fluxes.
y_psfFluxMax	double	nJy	Maximum observed y band fluxes.
y_psfFluxMaxSlope	double	nJy/d	Maximum slope between y band flux obsevations max(delta_flux/delta_time).
y_psfFluxErrMean	double	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	long		Total number of DiaSources associated with this DiaObject.

DiaSource

Difference image sources detected on difference images

Column Name	Data Type	Unit	Description	UCD
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	long		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	double	deg	Uncertainty of ra.	stat.error;pos.eq.ra
dec	double	deg	Declination coordinate of the center of this diaSource.	pos.eq.dec
decErr	double	deg	Uncertainty of dec.	stat.error;pos.eq.dec
ra_dec_Cov	double	deg**2	Covariance between ra and dec.	stat.covariance
x	double	pixel	x position computed by a centroiding algorithm.	pos.cartesian.x
xErr	double	pixel	Uncertainty of x.	stat.error;pos.cartesian.x
y	double	pixel	y position computed by a centroiding algorithm.	pos.cartesian.y
yErr	double	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	double	nJy	Flux in a 12 pixel radius aperture on the difference image.	phot.count
apFluxErr	double	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	double		The signal-to-noise ratio at which this source was detected in the difference image.	stat.snr
psfFlux	double	nJy	Flux for Point Source model. Note this actually measures the flux difference between the template and the visit image.	phot.count
psfFluxErr	double	nJy	Uncertainty of psfFlux.
psfLnL	double		Natural log likelihood of the observed data given the point source model.	stat.likelihood
psfChi2	double		Chi^2 statistic of the point source model fit.	stat.fit.chi2
psfNdata	long		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	double	nJy	Flux for a trailed source model. Note this actually measures the flux difference between the template and the visit image.
trailFluxErr	double	nJy	Uncertainty of trailFlux.
trailRa	double	deg	Right ascension coordinate of centroid for trailed source model.	pos.eq.ra
trailRaErr	double	deg	Uncertainty of trailRa.	stat.error;pos.eq.ra
trailDec	double	deg	Declination coordinate of centroid for trailed source model.	pos.eq.dec
trailDecErr	double	deg	Uncertainty of trailDec.	stat.error;pos.eq.dec
trailLength	double	arcsec	Maximum likelihood fit of trail length.
trailLengthErr	double	nJy	Uncertainty of trailLength.
trailAngle	double	deg	Maximum likelihood fit of the angle between the meridian through the centroid and the trail direction (bearing).
trailAngleErr	double	nJy	Uncertainty of trailAngle.
trailChi2	double		Chi^2 statistic of the trailed source model fit.	stat.fit.chi2
trailNdata	long		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	double	nJy	Maximum likelihood value for the mean absolute flux of the two lobes for a dipole model.
dipoleMeanFluxErr	double	nJy	Uncertainty of dipoleMeanFlux.	stat.error
dipoleFluxDiff	double	nJy	Maximum likelihood value for the difference of absolute fluxes of the two lobes for a dipole model.
dipoleFluxDiffErr	double	nJy	Uncertainty of dipoleFluxDiff.	stat.error
dipoleLength	double	arcsec	Maximum likelihood value for the lobe separation in dipole model.	pos.angDistance
dipoleAngle	double	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	double		Chi^2 statistic of the model fit.	stat.fit.chi2
dipoleNdata	long		The number of data points (pixels) used to fit the model.
scienceFlux	double	nJy	Forced photometry flux for a point source model measured on the visit image centered at DiaSource position.	phot.count
scienceFluxErr	double	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	double	nJy	Forced photometry flux for a point source model measured on the template image centered at the DiaObject position.	phot.count
templateFluxErr	double	nJy	Uncertainty of templateFlux.	stat.error;phot.count
ixx	double	nJy.arcsec**2	Adaptive second moment of the source intensity.
iyy	double	nJy.arcsec**2	Adaptive second moment of the source intensity.
ixy	double	nJy.arcsec**2	Adaptive second moment of the source intensity.
ixxPSF	double	nJy.arcsec**2	Adaptive second moment for the PSF.
iyyPSF	double	nJy.arcsec**2	Adaptive second moment for the PSF.
ixyPSF	double	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	double		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	double		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	long	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.

SDM Schemas is maintained by Rubin Observatory.