[wiki:ippToPsps Back to ippToPsps main page]

[[PageOutline]]

= 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 [browser:trunk/Ohana/src/libautocode/def/average.d here]
 * {{{cps}}} file: contains mean mags etc definition [browser:trunk/Ohana/src/libautocode/def/secfilt.d 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[[BR]]

The full table definitions can be seen [browser:trunk/ippToPsps/config/OB/tables.vot 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 object~~r stack psf flux err|| || ~~if only found in a stack, then left unpopulated~~ '''rStackPSFFluxErr'''||
|| raMeanErr||arcsec||REAL||-999|| ~~estimated error in raMean~~i stack psf flux err|| || ~~see above~~ '''iStackPSFFluxErr''' ||
|| decMeanErr||arcsec||REAL||-999|| ~~estimated error in decMean~~z 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 ||   '''gStackKronMagErr''', StackKronMagErr = KRON_FLUX_ERR /KRON_FLUX ||
|| riMeanColorErr||mag||REAL||-999|| ~~Estimated error in r-i color from rMean & iMean~~ r stack kron mag err|| cps file ||   '''rStackKronMagErr''', StackKronMagErr = KRON_FLUX_ERR /KRON_FLUX ||
|| izMeanColorErr||mag||REAL||-999|| ~~Estimated error in i-z color from iMean & zMean~~ i stack kron mag err||cps file  ||  '''iStackKronMagErr''' , StackKronMagErr = KRON_FLUX_ERR /KRON_FLUX ||
|| zyMeanColorErr||mag||REAL||-999|| ~~Estimated error in z-y color from zMean & yMean~~ z stack kron mag err ||cps file  || '''zStackKronMagErr''', StackKronMagErr = KRON_FLUX_ERR /KRON_FLUX ||
|| gMagBest||mag||REAL||-999|| g kron magnitude from stack frames|| cps || to be renamed '''gStackKronMag''', calculated from stackKronMag (AB mag) = -2.5 * log(KRON_FLUX) - 8.9||
|| 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''', calculated from stackKronMag (AB mag) = -2.5 * log(KRON_FLUX) - 8.9 ||
|| rModID||unknown||SMALLINT||-999||~~index of which r model magnitude was used from stack~~flags || 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''', calculated from stackKronMag (AB mag) = -2.5 * log(KRON_FLUX) - 8.9||
|| 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''', calculated from stackKronMag (AB mag) = -2.5 * log(KRON_FLUX) - 8.9||
|| 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''', calculated from stackKronMag (AB mag) = -2.5 * log(KRON_FLUX) - 8.9 ||
|| 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''', StackKronMagErr = KRON_FLUX_ERR /KRON_FLUX  ||
|| 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|| || ||


[wiki:ippToPspsSchemaChangePlan201207 Schema Change Plan (July 2012)]