Detection Batches (PV2)

as a reference, the old (pv1) version of the tables -> ippToPsps_Detections

Proposed ippToPsps mappings

ODM attribute	units	Data type	Default	Description	IPP source	IPP variable/notes	HAFcomments
Detection
objID	dimensionless	BIGINT 8	NA	ODM object identifier
detectID	dimensionless	BIGINT 8	NA	ODM detection identifier
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
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
ra	degrees	FLOAT 8	NA	Right Ascension	was in detectionCalib before
dec	degrees	FLOAT 8	NA	Declination	was in detectionCalib before
raErr	arcsec	REAL 4	NA	Right Ascension error	was in detectionCalib before
decErr	arcsec	REAL 4	NA	Declination error	was in detectionCalib before
zp	magnitude	REAL 4	0	zeropoint (only thing needed to convert adu/sec to AB mag), note no zpErr	was in detectionCalib before
telluricExt	magnitude	REAL 4	NA	estimated extinction due to non-photometric conditions	new
expTime	seconds	REAL 4	-999	exposure time (informational)	was in detectionCalib beofre
airmass	dimensionless	REAL 4	0	airmass (informational)	was in detectionCalib before
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
peakADU	adu	REAL 4	-999	peak count in source pixel - where counts are anlog-to-digital units
psfWidMajor	arcsec	REAL 4	-999	model PSF width in major axis
psfWidMinor	arcsec	REAL 4	-999	model PSF width in minor axis
psfTheta	degrees	REAL 4	-999	model PSF orientation angle degrees East of North
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	momeny YY
momentM3C	raw pixels	REAL 4	-999	3rd moment sin(theta)	these are new
momentM3S	raw pixels	REAL 4	-999	3rd moment cos(theta)	these are new
momentM4C	raw pixels	REAL 4	-999	4th moment sin(theta)	these are new
momentM4S	raw pixels	REAL 4	-999	4th moment cos(theta)	these are new
momentR1	raw pixels	REAL 4	-999	first radial moment	these are new
momentRH	raw pixels	REAL 4	-999	half radial moment	these are new
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	these are new
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
sgSep1	dimensionless	REAL 4	-999	star/galaxy separator 1	these are new - assume this is sgSep in old
sgSep2	dimensionless	REAL 4	-999	star/galaxy separator 2	these are new
sgSep3	dimensionless	REAL 4	-999	star/galaxy separator 3	these are new
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.