[wiki:ippToPsps Back to ippToPsps main page]

[[PageOutline]]

= 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[[BR]]

The full table definitions can be seen [browser:trunk/ippToPsps/config/OB/tables.vot 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|| || ||