Diff Detection (DF) batches

Diff detection batches (new for PV2) have 3 tables in them

• DiffMeta
• DiffDetection
• DiffToImage

---

DiffMeta VOTable description of PSPS table DiffMeta

---

diffMetaID	dimensionless	BIGINT 8	NA	diff identifier
batchID	dimensionless	BIGINT 8	NA	batch identifier
surveyID	dimensionless	TINYINT 1	NA	survey flag identifier
filterID	dimensionless	TINYINT 1	NA	filter identifier
diffTypeID	dimensionless	TINYINT 1	0	diff type identifier
posImageID	dimensionless	BIGINT 8	NA	positive image identifier
negImageID	dimensionless	BIGINT 8	NA	negative image identifier
skyCellID	dimensionless	REAL 4	NA	single float givijng PrimaryCell.SkyCell identifier
photoCalID	dimensionless	INT 4	NA	photometry code
magSat	dimensionless	REAL 4	-999	saturation magnitude level
analVer	dimensionless	SMALLINT 2	-999	analysis version index
expTime	seconds	REAL 4	-999	exposure time of positive image
ctype1	alphanumeric	VARCHAR(100)	8000	name of astrometric projection in RA
ctype2	alphanumeric	VARCHAR(100)	8000	name of astrometric projection in DEC
crval1	degrees	FLOAT 8	-999	RA corresponding to reference pixel
crval2	degrees	FLOAT 8	-999	DEC corresponding to reference pixel
crpix1	dimensionless	FLOAT 8	-999	reference pixel value for RA
crpix2	dimensionless	FLOAT 8	-999	reference pixel value for DEC
cdelt1	degrees/pixel	FLOAT 8	-999	scale factor for RA
cdelt2	degrees/pixel	FLOAT 8	-999	scale factor for DEC
pc001001	dimensionless	FLOAT 8	-999	elements of rotation/scale matrix
pc001002	dimensionless	FLOAT 8	-999	elements of rotation/scale matrix
pc002001	dimensionless	FLOAT 8	-999	elements of rotation/scale matrix
pc002002	dimensionless	FLOAT 8	-999	elements of rotation/scale matrix
calibModNum	dimensionless	SMALLINT 2	NA	calibration modification number
dataRelease	dimensionless	TINYINT 1	NA	Data release

---

DiffDetection VOTable description of PSPS table DiffDetection

---

diffObjID	dimensionless	BIGINT 8	NA	ODM diff object identifier
diffgcobjID	dimensionless	BIGINT 8	NA	galactic coordinates ODM object identifier
diffDetID	dimensionless	BIGINT 8	NA	ODM diff detection identifier
diffDetMetaID	dimensionless	BIGINT 8	NA	diff detection meta identifer
ippDetectID	dimensionless	BIGINT 8	NA	detection id generated by IPP
ippObjID	dimensionless	BIGINT 8	NA	object id generated by IPP
filterID	dimensionless	TINYINT 1	NA	filter ID: g=1, r=2, i=3, z=4, y=5, w=6, ...
surveyID	dimensionless	TINYINT 1	NA	survey flag identifier
randomDiffID	dimensionless	BIGINT 8	NA	random diff id
skyCellID	dimensionless	REAL 4	-999	single float givijng PrimaryCell.SkyCell identifier
dvoRegionID	dimensionless	REAL 4	-999	identifier to dvo spacial region
obsTime	MeanJulianDays	FLOAT 8	-999	Time of mid observation of positive detection in Mean Julian Days
xPos	pixels	REAL 4	-999	measured x on CCD from PSF fit
yPos	pixels	REAL 4	-999	measured y on CCD from PSF fit
xPosErr	pixels	REAL 4	-999	estimated error in x
yPosErr	pixels	REAL 4	-999	estimated error in y
pltScale	arcsec/pix	REAL 4	-999	plate scale at this location (from DVO)
posAngle	degrees	REAL 4	-999	position angle (sky-to-chip) at this location (from DVO)
ra	degrees	FLOAT 8	NA	right ascension
dec	degrees	FLOAT 8	NA	declination
raErr	arcsec	REAL 4	NA	right ascension error
decErr	arcsec	REAL 4	NA	declination error
zp	magnitude	REAL 4	0	zeropoint
telluricExt	magnitude	REAL 4	NA	estimated extinction due to non-photometric conditions
expTime	seconds	REAL 4	-999	exposure time (informational)
airMass	dimensionless	REAL 4	0	airmass (informational)
psfFlux	adu/seconds	REAL 4	-999	PSF instrumental flux (in analog-to-digital units/sec) or adu/sec
psfFluxErr	adu/seconds	REAL 4	-999	estimated error in flux
psfMajorFWHM	arcsec	REAL 4	-999	model PSF width in major axis
psfMinorFWHM	arcsec	REAL 4	-999	model PSF width in minor axis
psfTheta	degrees	REAL 4	-999	model PSF orientation angle degrees East of North
psfCore	dimensionless	REAL 4	-999	model PSF core parameter [k in (1 + kz + z1.66)]
psfQf	dimensionless	REAL 4	-999	PSF coverage factor
psfQfPerfect	dimensionless	REAL 4	-999	PSF-weighted fraction of pixels totally unmasked
psfChiSq	dimensionless	REAL 4	-999	reduced-chisq of the psf model fit. (ndof?, npix?)
psfLikelihood	dimensionless	REAL 4	-999	PSF likelihood
momentXX	raw pixels	REAL 4	-999	moment XX
momentXY	raw pixels	REAL 4	-999	moment XY
momentYY	raw pixels	REAL 4	-999	moment YY
momentR1	raw pixels	REAL 4	-999	first radial moment
momentRH	raw pixels	REAL 4	-999	half radial moment
momentM3C	raw pixels	REAL 4	-999	3rd moment cos(theta)
momentM3S	raw pixels	REAL 4	-999	3rd moment sin(theta)
momentM4C	raw pixels	REAL 4	-999	4th moment cos(theta)
momentM4S	raw pixels	REAL 4	-999	4th moment sin(theta)
apFlux	adu/seconds	REAL 4	-999	Aperture Flux
apFluxErr	adu/seconds	REAL 4	-999	Aperture Flux error
apFillF	dimensionless	REAL 4	-999	Aperture fill factor
kronFlux	adu/seconds	REAL 4	-999	Kron flux
kronFluxErr	adu/seconds	REAL 4	-999	Kron flux error
kronRad	raw pixels	REAL 4	-999	Kron radius
kronRadErr	raw pixels	REAL 4	-999	Kron radius error
diffNPos	dimensionless	INT 4	-999	NPix > 3sigma
diffFRatio	dimensionless	REAL 4	-999	fPos/(fPos + fNeg)
diffNBad	dimensionless	REAL 4	-999	nPos/(nPos + nNeg)
diffNMask	dimensionless	REAL 4	-999	nPos/(nPos + nMask)
diffNAll	dimensionless	REAL 4	-999	nPos/(nPos + nMask + nNeg)
diffPdist	pixels	REAL 4	-999	distance to positive match source
diffNdist	pixels	REAL 4	-999	distance to negative match source
diffPSN	dimensionless	REAL 4	-999	signal to noise of pos match source
diffNSN	dimensionless	REAL 4	-999	signal to noise of neg match source
sky	adu/sec/pixel	REAL 4	-999	PSF sky level at source
skyErr	adu/sec/pixel	REAL 4	-999	estimated error in sky
infoFlag	dimensionless	BIGINT 8	-999	flag indicating provenance information
dataRelease	dimensionless	TINYINT 1	NA	Data release when this detection was originally taken. Recalibrations do not affect this value.

---

DiffToImage VOTable description of PSPS table DiffToImage

---

diffMetaID	dimensionless	BIGINT 8	NA	diff identifier
imageID	dimensionless	BIGINT 8	NA	hashed exposure-ccdID identifier