== Detection (P2) Batches == There are 3 tables within P2 batches * FrameMeta * ImageMeta * Detection --------------------------- === FrameMeta VOTable description of PSPS table FrameMeta === --------------------------- ||frameID || dimensionless || INT 4 || NA ||unique exposure/frame identifier.|| ||frameName || dimensionless || VARCHAR(32) || NA ||frame name provided by camera software|| ||surveyID || dimensionless || TINYINT 1 || NA ||survey flag identifier|| ||filterID || dimensionless || TINYINT 1 || NA ||filter identifier|| ||cameraID || dimensionless || SMALLINT 2 || NA ||camera identifier|| ||cameraConfigID || dimensionless || SMALLINT 2 || NA ||camera configuration identifier|| ||telescopeID || dimensionless || SMALLINT 2 || NA ||telescope identifier|| ||analysisVer || alphanumeric || VARCHAR(100) || 8000 ||IPP software analysis release|| ||p1Recip || alphanumeric || VARCHAR(100) || 8000 ||IPP phase 1 MD5 Checksum|| ||p2Recip || alphanumeric || VARCHAR(100) || 8000 ||IPP phase 2 MD5 Checksum|| ||p3Recip || alphanumeric || VARCHAR(100) || 8000 ||IPP phase 3 MD5 Checksum|| ||nOTA || alphanumeric || SMALLINT 2 || -999 ||number of valid OTA/CCD images in this exposure|| ||photoScat || magnitude || REAL 4 || -999 || global photometric scatter|| ||numPhotoRef || dimensionless || INT 4 || -999 ||number of photometric reference sources|| ||expStart || days || FLOAT 8 || -999 || exposure start time in MJD|| ||expTime || seconds || REAL 4 || -999 || exposure time|| ||airmass || dimensionless || REAL 4 || -999 ||airmass at mid-exposure|| ||raBore || degrees || FLOAT 8 || -999 || RA of telescope boresight|| ||decBore || degrees || FLOAT 8 || -999 || DEC of telescope boresight|| ||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|| ||polyOrder || dimensionless || TINYINT 1 || 255 ||polynomial order of astrometry fit|| ||pca1x3y0 || dimensionless || FLOAT 8 || -999 ||polynomial coefficients for the astrometric fit|| ||pca1x2y1 || dimensionless || FLOAT 8 || -999 ||polynomial coefficients for the astrometric fit|| ||pca1x1y2 || dimensionless || FLOAT 8 || -999 ||polynomial coefficients for the astrometric fit|| ||pca1x0y3 || dimensionless || FLOAT 8 || -999 ||polynomial coefficients for the astrometric fit|| ||pca1x2y0 || dimensionless || FLOAT 8 || -999 ||polynomial coefficients for the astrometric fit|| ||pca1x1y1 || dimensionless || FLOAT 8 || -999 ||polynomial coefficients for the astrometric fit|| ||pca1x0y2 || dimensionless || FLOAT 8 || -999 ||polynomial coefficients for the astrometric fit|| ||pca2x3y0 || dimensionless || FLOAT 8 || -999 ||polynomial coefficients for the astrometric fit|| ||pca2x2y1 || dimensionless || FLOAT 8 || -999 ||polynomial coefficients for the astrometric fit|| ||pca2x1y2 || dimensionless || FLOAT 8 || -999 ||polynomial coefficients for the astrometric fit|| ||pca2x0y3 || dimensionless || FLOAT 8 || -999 ||polynomial coefficients for the astrometric fit|| ||pca2x2y0 || dimensionless || FLOAT 8 || -999 ||polynomial coefficients for the astrometric fit|| ||pca2x1y1 || dimensionless || FLOAT 8 || -999 ||polynomial coefficients for the astrometric fit|| ||pca2x0y2 || dimensionless || FLOAT 8 || -999 ||polynomial coefficients for the astrometric fit|| ||calibModNum || dimensionless || SMALLINT 2 || NA ||calibration modification number|| ||batchID || dimensionless || INT 4 || NA ||batchID|| ||dataRelease || dimensionless || TINYINT 1 || NA ||Data release|| --------------------------- === ImageMeta VOTable description of PSPS table ImageMeta === --------------------------- ||imageID || dimensionless || BIGINT 8 || NA ||unique ID for each image, hashed from frameID and ccdID (ALEX)|| ||frameID || dimensionless || INT 4 || NA ||frame identifier, also known as exposure number|| ||ccdID || dimensionless || SMALLINT 2 || NA ||ccd cell identifier in the focal plane|| ||photoCalID || dimensionless || INT 4 || NA ||photometry reduction code identifier|| ||filterID || dimensionless || TINYINT 1 || NA ||filter ID|| ||bias || ADU || REAL 4 || -999 || detector bias level|| ||biasScat || ADU || REAL 4 || -999 || scatter in bias level|| ||sky || ADU/pixel || REAL 4 || -999 || mean sky level|| ||skyScat || ADU/pixel || REAL 4 || -999 || scatter in mean sky level|| ||nDetect || dimensionless || INT 4 || -999 ||number of detections on CCD|| ||magSat || magnitude || REAL 4 || -999 || saturation magnitude level|| ||completMag || magnitude || REAL 4 || -999 || 95% completion level in mag|| ||astroScat || arcsec || REAL 4 || -999 || astrometric scatter for chip|| ||photoScat || magnitude || REAL 4 || -999 ||photometric scatter for chip|| ||numAstroRef || dimensionless || INT 4 || -999 ||number of astrometric reference sources|| ||numPhotoRef || dimensionless || INT 4 || -999 ||number of photometric reference sources|| ||nx || pixels || SMALLINT 2 || -999 ||chip dimension in x|| ||ny || pixels || SMALLINT 2 || -999 ||chip dimension in y|| ||psfModelID || dimensionless || INT 4 || -999 ||PSF model identifier|| ||psfFwhm || arcsec || REAL 4 || -999 || model psf full width at half maximum at chip center|| ||psfWidMajor || arcsec || REAL 4 || -999 || model PSF parameters at chip center|| ||psfWidMinor || arcsec || REAL 4 || -999 || model PSF parameters at chip center|| ||psfTheta || degrees || REAL 4 || -999 || model PSF parameters at chip center|| ||momentXX || pixels || REAL 4 || -999 || moment XX|| ||momentXY || pixels || REAL 4 || -999 || moment XY|| ||momentYY || pixels || REAL 4 || -999 || moment YY|| ||momentM3C || pixels squared || REAL 4 || -999 || moment M3C|| ||momentM3S || pixels squared || REAL 4 || -999 || moment M3S|| ||momentM4C || pixels squared || REAL 4 || -999 || moment M4C|| ||momentM4S || pixels squared || REAL 4 || -999 || moment M4S|| ||momentR1 || pixels || REAL 4 || -999 || moment R1|| ||momentRH || sqrt pixels || REAL 4 || -999 || moment RH|| ||apResid || magnitude || REAL 4 || -999 ||corrected aperture residual|| ||dapResid || magnitude || REAL 4 || -999 ||scatter of aperture corrections|| ||detectorID || alphanumeric || VARCHAR(100) || ||identifier for actual CCD chip|| ||qaFlags || alphanumeric || BIGINT 8 || -999 ||Q/A flags for this OTA|| ||detrend1 || alphanumeric || VARCHAR(100) || 8000 ||identifier of detrend image 1|| ||detrend2 || alphanumeric || VARCHAR(100) || 8000 ||identifier of detrend image 2|| ||detrend3 || alphanumeric || VARCHAR(100) || 8000 ||identifier of detrend image 3|| ||detrend4 || alphanumeric || VARCHAR(100) || 8000 ||identifier of detrend image 4|| ||detrend5 || alphanumeric || VARCHAR(100) || 8000 ||identifier of detrend image 5|| ||detrend6 || alphanumeric || VARCHAR(100) || 8000 ||identifier of detrend image 6|| ||detrend7 || alphanumeric || VARCHAR(100) || 8000 ||identifier of detrend image 7|| ||detrend8 || alphanumeric || VARCHAR(100) || 8000 ||identifier of detrend image 8|| ||photoZero || magnitude || REAL 4 || -999 || local derived photometric zero point|| ||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 || pixels || FLOAT 8 || -999 || reference pixel value for RA|| ||crpix2 || pixels || 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|| ||polyOrder || dimensionless || TINYINT 1 || 255 ||polynomial order of astrometry fit|| ||pca1x3y0 || dimensionless || FLOAT 8 || -999 ||polynomial coefficients for the astrometric fit|| ||pca1x2y1 || dimensionless || FLOAT 8 || -999 ||polynomial coefficients for the astrometric fit|| ||pca1x1y2 || dimensionless || FLOAT 8 || -999 ||polynomial coefficients for the astrometric fit|| ||pca1x0y3 || dimensionless || FLOAT 8 || -999 ||polynomial coefficients for the astrometric fit|| ||pca1x2y0 || dimensionless || FLOAT 8 || -999 ||polynomial coefficients for the astrometric fit|| ||pca1x1y1 || dimensionless || FLOAT 8 || -999 ||polynomial coefficients for the astrometric fit|| ||pca1x0y2 || dimensionless || FLOAT 8 || -999 ||polynomial coefficients for the astrometric fit|| ||pca2x3y0 || dimensionless || FLOAT 8 || -999 ||polynomial coefficients for the astrometric fit|| ||pca2x2y1 || dimensionless || FLOAT 8 || -999 ||polynomial coefficients for the astrometric fit|| ||pca2x1y2 || dimensionless || FLOAT 8 || -999 ||polynomial coefficients for the astrometric fit|| ||pca2x0y3 || dimensionless || FLOAT 8 || -999 ||polynomial coefficients for the astrometric fit|| ||pca2x2y0 || dimensionless || FLOAT 8 || -999 ||polynomial coefficients for the astrometric fit|| ||pca2x1y1 || dimensionless || FLOAT 8 || -999 ||polynomial coefficients for the astrometric fit|| ||pca2x0y2 || dimensionless || FLOAT 8 || -999 ||polynomial coefficients for the astrometric fit|| ||calibModNum || dimensionless || SMALLINT 2 || NA ||calibration modification number|| ||dataRelease || dimensionless || TINYINT 1 || NA ||Data release|| --------------------------- === Detection VOTable description of PSPS table Detection === --------------------------- ||objID || dimensionless || BIGINT 8 || NA ||ODM object identifier|| ||gcobjID || dimensionless || BIGINT 8 || NA ||galactic coordinates ODM object identifier|| ||detectID || dimensionless || BIGINT 8 || NA ||ODM detection identifier|| ||ippObjID || dimensionless || BIGINT 8 || NA ||object id generated by IPP|| ||ippDetectID || dimensionless || BIGINT 8 || NA ||detection 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|| ||imageID || dimensionless || BIGINT 8 || NA ||image id hash of frame identifier & OTA/CCD number|| ||randomDetID || dimensionless || BIGINT 8 || NA || random detection Id|| ||dvoRegionID || dimensionless || REAL 4 || -999 || identifier to dvo spacial region|| ||obsTime || MeanJulianDays || FLOAT 8 || -999 || Time of mid observation in Mean Julian Days|| ||xPos || raw pixels || REAL 4 || -999 || measured x on CCD from PSF fit|| ||yPos || raw pixels || REAL 4 || -999 || measured y on CCD from PSF fit|| ||xPosErr || raw pixels || REAL 4 || -999 || estimated error in x|| ||yPosErr || raw 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|| ||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.||