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	unknown	FLOAT	0	Cartesian x		populated during PSPS merge
cy	unknown	FLOAT	0	Cartesian y		populated during PSPS merge
cz	unknown	FLOAT	0	Cartesian z		populated during PSPS merge
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	unknown	FLOAT	-999	supergalactic longitude		populated during PSPS merge
bsg	unknown	FLOAT	-999	supergalactic latitude		populated during PSPS merge
nDetections	unknown	SMALLINT	-999	total number of detection measurements in all filters	cpt file	NMEASURE
raMean	degree	FLOAT	-999	mean RA of object gstack psf flux err		if only found in a stack, then left unpopulated gStackPSFFluxErr
decMean	degree	FLOAT	-999	mean DEC of objectr stack psf flux err		if only found in a stack, then left unpopulated rStackPSFFluxErr
raMeanErr	arcsec	REAL	-999	estimated error in raMeani stack psf flux err		see above iStackPSFFluxErr
decMeanErr	arcsec	REAL	-999	estimated error in decMeanz stack psf flux err		see above zStackPSFFluxErr
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
gMeanMag	mag	REAL	-999	mean g magnitude	cps file	MAG (the AB magnitude) (from exp,psf) to be renamed gMeanPSFMag
gMeanFlux	mag	REAL	-999	mean g flux mean g kron mag from smfs	cps file	3631 * POW(10.0, (-0.4*MAG)) mean kron mag from exp, psf to be renamed gMeanKronMag
gMeanMagErr	mag	REAL	-999	estimated error of g magnitude mean	cps file	MAG_ERR, set to NULL if MAG_ERR > 0.5 (Gene's cut as of 2012-04-13) to be renamed gMeanPSFMagErr
gMeanFluxErr	mag	REAL	-999	estimated error of g mean g mean Kron mag err	cps	STACK_KRON_MAG_ERR to be renamed gMeanKronMagErr
gMin	mag	REAL	-999	minimum g magnitide	cps file	MAG_20/1000 need a name-change in PSPS schema - g20pct
gMax	mag	REAL	-999	maximum g magnitude	cps file	MAG_80/1000 need a name-change in PSPS schema - g80pct
end repeat of block
grMeanColor	mag	REAL	-999	g-r color from gMean & rMean g psf flux stack	cps file	gMeanMag - rMeanMag to be renamed gStackPSFFlux
riMeanColor	mag	REAL	-999	r-i color from rMean & iMean r psf flux stack	cps file	rMeanMag - iMeanMag to be renamed rStackPSFFlux
izMeanColor	mag	REAL	-999	i-z color from iMean & zMean i psf flux stack	cps file	iMeanMag - zMeanMag to be renamed iStackPSFFlux
zyMeanColor	mag	REAL	-999	z-y color from zMean & yMean z psf flux stack	cps file	zMeanMag - yMeanMag to be renamed zStackPSFFlux
grMeanColorErr	mag	REAL	-999	Estimated error in g-r color from gMean & rMean g stack kron mag err	cps file	SQRT(POW(gMeanMagErr,2) + POW(rMeanMagErr,2)) gStackKronMagErr
riMeanColorErr	mag	REAL	-999	Estimated error in r-i color from rMean & iMean r stack kron mag err	cps file	SQRT(POW(rMeanMagErr,2) + POW(iMeanMagErr,2)) rStackKronMagErr
izMeanColorErr	mag	REAL	-999	Estimated error in i-z color from iMean & zMean i stack kron mag err	cps file	SQRT(POW(iMeanMagErr,2) + POW(zMeanMagErr,2)) iStackKronMagErr
zyMeanColorErr	mag	REAL	-999	Estimated error in z-y color from zMean & yMean z stack kron mag err	cps file	SQRT(POW(zMeanMagErr,2) + POW(yMeanMagErr,2)) zStackKronMagErr
gMagBest	mag	REAL	-999	g kron magnitude from stack frames	cps	to be renamed gStackKronMag
gModID	unknown	SMALLINT	-999	index of which g model magnitude was used from stack flags	cps	flags (including one from ipptopsps if forced/limit) to be renamed gFlags
rMagBest	mag	REAL	-999	r kron magnitude from stack frames	cps	to be renamed rStackKronMag
rModID	unknown	SMALLINT	-999	index of which r model magnitude was used from stackflags	cps	flags (including one from ipptopsps if forced/limit) to be renamed rFlags
iMagBest	mag	REAL	-999	i kron magnitude from stack frames	cps	to be renamed iStackKronMag
iModID	unknown	SMALLINT	-999	index of which i model magnitude was used from stack flags	cps	flags (including one from ipptopsps if forced/limit) to be renamed iFlags
zMagBest	mag	REAL	-999	z kron magnitude from stack frames	cps	to be renamed zStackKronMag
zModID	unknown	SMALLINT	-999	index of which z model magnitude was used from stack flags	cps	flags (including one from ipptopsps if forced/limit) to be renamed zFlags
yMagBest	mag	REAL	-999	y kron magnitude from stack frames	cps	to be renamed yStackKronMag
yModID	unknown	SMALLINT	-999	index of which y model magnitude was used from stack flags	cps	flags (including one from ipptopsps if forced/limit) to be renamed yFlags
grColor	unknown	REAL	-999	g-r color from gmag and rmag y psf flux stack	cps	yStackPSFFlux
riColor	unknown	REAL	-999	r-i color from rmag and imag y stack kron flux err	cps	yStackKronMagErr
izColor	unknown	REAL	-999	i-z color from imag and zmag y stack psf flux err	cps	yStackPSFFluxErr
zyColor	unknown	REAL	-999	z-y color from zmag and ymag		rename it extra
sgSep	unknown	REAL	-999	star/galaxy separator - true if any one color is		represents 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)