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	BIGINT 8	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 + 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
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.