Back to ippToPsps main page

Object batches

Object batches are generated from the IPP for objects that have set for the year and that have been fully processed by the IPP. Data is taken entirely from DVO FITS files, specifically:

• cpt file: contains ..., definition here​
• cps file: contains mean mags etc definition here​

One PSPS batch represents one DVO 'region', eg these files

s3000/7471.10.cps
s3000/7471.10.cpt

would be used to create an object batch for this DVO region.

PSPS tables

1 Object extension

The full table definitions can be seen here

Current IPP to PSPS mappings

Object
ODM attribute	units	Data type	Default	Description	IPP source	IPP variable/notes
objID	unknown	BIGINT	0	ODM object identifier index	cpt file	EXT_ID
ippObjID	unknown	BIGINT	0	IPP object number	cpt file	CAT_ID*1000000000 + OBJ_ID
projectionCellID	unknown	INT	-999	projection cell identifier at discovery time
htmID	unknown	BIGINT	0	HTM index		to be DROPPED from table
zoneID	unknown	INT	0	Zone index		to be DROPPED from table
stackVer	unknown	SMALLINT	-999 -	static stack version number
objInfoFlag	unknown	BIGINT	-999	flag indicating odd properties
varFlag	unknown	TINYINT	0	variable in difference image detections
surveyID	unknown	TINYINT	255	Survey ID	config	as set in the ippToPsps config
ra	degree	FLOAT	0	Right Ascension	cpt file	RA - where this is the RA at the reference epoch. Defaults to RA in stack if not seen in frames
dec	degree	FLOAT	0	Declination	cpt file	DEC - where this is the Dec at the reference epoch. Defaults to Dec in stack if not seen in frames
raErr	arcsec	REAL	0.0	Right Ascension error	cpt file	RA_ERR
decErr	arcsec	REAL	0.0	Declination error	cpt file	DEC_ERR
~cx~ gStackMetaId	unknown	INT 8	0	~Cartesian x~		~populated during PSPS merge~ to be gstackmetaid
~cy~ rStackMetaId	unknown	INT 8	0	~Cartesian y~		~populated during PSPS merge~ to be rstackmetaid
~cz~ iStackMetaId	unknown	INT 8	0	~Cartesian z~		~populated during PSPS merge~ to be istackmetaid
lambda	degree	FLOAT	-999	ecliptic longitude		populated during PSPS merge
beta	degree	FLOAT	-999	ecliptic latitude		populated during PSPS merge
l	degree	FLOAT	-999	galactic longitude		populated during PSPS merge
b	degree	FLOAT	-999	galactic latitude		populated during PSPS merge
~lsg~ zStackMetaId	unknown	INT 8	-999	~supergalactic longitude~		~populated during PSPS merge~ to be zstackmetaid
~bsg~ yStackMetaId	unknown	INT 8	-999	~supergalactic latitude~		~populated during PSPS merge~ to be ystackmetaid
nDetections	unknown	SMALLINT	-999	total number of detection measurements in all filters	cpt file	sum of NCODE for different filters in dvo
gStackPSFFluxErr	degree	FLOAT	-999	gstack psf flux err	cps	FLUX_PSF_ERR -flux error for psf g stack measurements
rStackPSFFluxErr	degree	FLOAT	-999	r stack psf flux err	cps	FLUX_PSF_ERR -flux error for psf r stack measurements
iStackPSFFluxErr	arcsec	REAL	-999	i stack psf flux err	cps	FLUX_PSF_ERR -flux error for psf i stack measurements
zStackPSFFluxErr	arcsec	REAL	-999	z stack psf flux err	cps	FLUX_PSF_ERR -flux error for psf z stack measurements
ng	unknown	SMALLINT	-999	number of measures in g filter	cps file	NCODE ("number of detections in band")
The block below is repeated for filters r, i, z, y and w
gMeanPSFMag	mag	REAL	-999	mean g magnitude	cps file	MAG (the AB magnitude) (from exp,psf), set to null where MeanMagErr > 0.5
gMeanKronMag	mag	REAL	-999	mean g kron mag from smfs	cps file	MAG_KRON mean kron mag from exp, psf
gMeanPSFMagErr	mag	REAL	-999	estimated error of g magnitude mean (psf)	cps file	MAG_ERR
gMeanKronMagErr	mag	REAL	-999	g mean Kron mag err	cps	MAG_KRON_ERR
g20pct	mag	REAL	-999	minimum g magnitide	cps file	MAG_20/1000
g80pct	mag	REAL	-999	maximum g magnitude	cps file	MAG_80/1000
end repeat of block
gStackPSFFlux	mag	REAL	-999	g psf flux stack	cps file	FLUX_PSF
rStackPSFFlux	mag	REAL	-999	r psf flux stack	cps file	FLUX_PSF
iStackPSFFlux	mag	REAL	-999	i psf flux stack	cps file	FLUX_PSF
zStackPSFFlux	mag	REAL	-999	z psf flux stack	cps file	FLUX_PSF
gStackKronMagErr	mag	REAL	-999	g stack kron mag err	cps file	FLUX_KRON_ERR /FLUX_KRON
rStackKronMagErr	mag	REAL	-999	r stack kron mag err	cps file	FLUX_KRON_ERR /FLUX_KRON
iStackKronMagErr	mag	REAL	-999	i stack kron mag err	cps file	FLUX_KRON_ERR /FLUX_KRON
zStackKronMagErr	mag	REAL	-999	z stack kron mag err	cps file	FLUX_KRON_ERR /FLUX_KRON
gStackKronMag	mag	REAL	-999	g kron magnitude from stack frames	cps	calculated from stackKronMag (AB mag) = -2.5 * log(FLUX_KRON) + 8.9
gFlags	unknown	SMALLINT	-999	g flags	cps	flags
rStackKronMag	mag	REAL	-999	r kron magnitude from stack frames	cps	calculated from stackKronMag (AB mag) = -2.5 * log(FLUX_KRON) + 8.9
rFlags	unknown	SMALLINT	-999	r flags	cps	flags
iStackKronMag	mag	REAL	-999	i kron magnitude from stack frames	cps	calculated from stackKronMag (AB mag) = -2.5 * log(FLUX_KRON) + 8.9
iFlags	unknown	SMALLINT	-999	i flags	cps	flags
zStackKronMag	mag	REAL	-999	z kron magnitude from stack frames	cps	calculated from stackKronMag (AB mag) = -2.5 * log(FLUX_KRON) + 8.9
zFlags	unknown	SMALLINT	-999	z flags	cps	flags
yStackKronMag	mag	REAL	-999	y kron magnitude from stack frames	cps	calculated from stackKronMag (AB mag) = -2.5 * log(FLUX_KRON) + 8.9
yFlags	unknown	SMALLINT	-999	y flags	cps	flags
yStackPSFFLux	unknown	REAL	-999	y psf flux stack	cps	FLUX_PSF
yStackKronMagErr	unknown	REAL	-999	y stack kron flux err	cps	FLUX_KRON_ERR /FLUX_KRON
yStackPSFFluxErr	unknown	REAL	-999	y stack psf flux err	cps	FLUX_PSF_ERR
~extra~ qf_perfect	unknown	REAL	-999	qf_perfect	cpt	PSF_QF_PERFECT rename it qf_perfect
sgSep	unknown	REAL	-999	star/galaxy separator - true if any one color is	cpt	STARGAL_SEPrepresents fraction of time detections were 'extended' in P2s
consistencyFlag	unknown	SMALLINT	0	Value computed from associated detections, it is originally given by IPP and should agree with the ODM validation
dataRelease	unknown	TINYINT	0	Data release
updated	unknown	INT	-999	MJD of last update

Schema Change Plan (July 2012)