Back to ippToPsps main page

Outline

Object batches are generated from IPP for objects that have set for the year and that have been fully processed by the IPP.

PSPS tables

1 Object extension

The full table definitions can be seen here

Current IPP to PSPS mappings[edit]

Object
ODM attribute	units	Data type	Default	Description	IPP source	IPP variable/notes
objID	unknown	BIGINT	0	ODM object identifier index
ippObjID	unknown	BIGINT	0	IPP object number
projectionCellID	unknown	INT	-999	projection cell identifier at discovery time
htmID	unknown	BIGINT	0	HTM index
zoneID	unknown	INT	0	Zone index
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
ra	degree	FLOAT	0	Right Ascension
dec	degree	FLOAT	0	Declination
raErr	arcsec	REAL	0.0	Right Ascension error
decErr	arcsec	REAL	0.0	Declination error
cx	unknown	FLOAT	0	Cartesian x
cy	unknown	FLOAT	0	Cartesian y
cz	unknown	FLOAT	0	Cartesian z
lambda	degree	FLOAT	-999	ecliptic longitude
beta	degree	FLOAT	-999	ecliptic latitude
l	degree	FLOAT	-999	galactic longitude
b	degree	FLOAT	-999	galactic latitude
lsg	unknown	FLOAT	-999	supergalactic longitude
bsg	unknown	FLOAT	-999	supergalactic latitude
nDetections	unknown	SMALLINT	-999	total number of detection measurements in all filters
raMean	degree	FLOAT	-999	mean RA of object
decMean	degree	FLOAT	-999	mean DEC of object
raMeanErr	arcsec	REAL	-999	estimated error in raMean
decMeanErr	arcsec	REAL	-999	estimated error in decMean
ng	unknown	SMALLINT	-999	number of measures in g filter
gMeanMag	mag	REAL	-999	mean g magnitude
gMeanFlux	mag	REAL	-999	mean g flux
gMeanMagErr	mag	REAL	-999	estimated error of g magnitude mean
gMeanFluxErr	mag	REAL	-999	estimated error of g flux mean
gMin	mag	REAL	-999	minimum g magnitide
gMax	mag	REAL	-999	maximum g magnitude
nr	unknown	SMALLINT	-999	number of measures in r filter
rMeanMag	mag	REAL	-999	mean r magnitude
rMeanFlux	mag	REAL	-999	mean r flux
rMeanMagErr	mag	REAL	-999	estimated error of r magnitude mean
rMeanFluxErr	mag	REAL	-999	estimated error of r flux mean
rMin	mag	REAL	-999	minimum r magnitude
rMax	mag	REAL	-999	maximum r magnitude
ni	unknown	SMALLINT	-999	number of measures in i filter
iMeanMag	mag	REAL	-999	mean i magnitude
iMeanFlux	mag	REAL	-999	mean i flux
iMeanMagErr	mag	REAL	-999	estimated error of i magitude mean
iMeanFluxErr	mag	REAL	-999	estimated error of i flux mean
iMin	mag	REAL	-999	minimum i magniutde
iMax	mag	REAL	-999	maximum i magnitude
nz	mag	SMALLINT	-999	number of measures in z filter
zMeanMag	mag	REAL	-999	mean z magnitude
zMeanFlux	mag	REAL	-999	mean z flux
zMeanMagErr	mag	REAL	-999	estimated error of z magnitude mean
zMeanFluxErr	mag	REAL	-999	estimated error of z flux mean
zMin	mag	REAL	-999	minimum z magnitude
zMax	mag	REAL	-999	maximum z magnitude
ny	unknown	SMALLINT	-999	number of measures in y filter
yMeanMag	mag	REAL	-999	mean y magnitude
yMeanFlux	mag	REAL	-999	mean y flux
yMeanMagErr	mag	REAL	-999	estimated error of y magnitude mean
yMeanFluxErr	mag	REAL	-999	estimated error of y flux mean
yMin	mag	REAL	-999	minimum y magnitude
yMax	mag	REAL	-999	maximum y magnitude
nw	unknown	SMALLINT	-999	number of measures in the wide (w) solar system filter
wMeanMag	mag	REAL	-999	mean w magnitude
wMeanFlux	mag	REAL	-999	mean w flux
wMeanMagErr	mag	REAL	-999	estimated error of w magnitude mean
wMeanFluxErr	mag	REAL	-999	estimated error of w flux mean
wMin	mag	REAL	-999	minimum w magnitude
wMax	mag	REAL	-999	maximum w magnitude
grMeanColor	mag	REAL	-999	g-r color from gMean & rMean
riMeanColor	mag	REAL	-999	r-i color from rMean & iMean
izMeanColor	mag	REAL	-999	i-z color from iMean & zMean
zyMeanColor	mag	REAL	-999	z-y color from zMean & yMean
grMeanColorErr	mag	REAL	-999	Estimated error in g-r color from gMean & rMean
riMeanColorErr	mag	REAL	-999	Estimated error in r-i color from rMean & iMean
izMeanColorErr	mag	REAL	-999	Estimated error in i-z color from iMean & zMean
zyMeanColorErr	mag	REAL	-999	Estimated error in z-y color from zMean & yMean
gMagBest	mag	REAL	-999	g magnitude from stack frames
gModID	unknown	SMALLINT	-999	index of which g model magnitude was used from stack
rMagBest	mag	REAL	-999	r magnitude from stack frames
rModID	unknown	SMALLINT	-999	index of which r model magnitude was used from stack
iMagBest	mag	REAL	-999	i magnitude from stack frames
iModID	unknown	SMALLINT	-999	index of which i model magnitude was used from stack
zMagBest	mag	REAL	-999	z magnitude from stack frames
zModID	unknown	SMALLINT	-999	index of which z model magnitude was used from stack
yMagBest	mag	REAL	-999	y magnitude from stack frames
yModID	unknown	SMALLINT	-999	index of which y model magnitude was used from stack
grColor	unknown	REAL	-999	g-r color from gmag and rmag
riColor	unknown	REAL	-999	r-i color from rmag and imag
izColor	unknown	REAL	-999	i-z color from imag and zmag
zyColor	unknown	REAL	-999	z-y color from zmag and ymag
sgSep	unknown	REAL	-999	star/galaxy separator - true if any one color is
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