== 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 + z^1.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||