IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changes between Version 19 and Version 20 of ippToPsps_Stack


Ignore:
Timestamp:
Jun 24, 2011, 10:03:21 AM (15 years ago)
Author:
rhenders
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • ippToPsps_Stack

    v19 v20  
    3333|| photoCalID||unknown||INT||0||photometry code numerical id|| DVO ||image->photcode from Image structure ||
    3434|| filterID||unknown||TINYINT||0||filter identifier|| cmf primary header || FPA.FILTER. This single character filter (grizy) is then used to get the PSPS ID from Filter table [browser:trunk/ippToPsps/config/init/tables.vot here] ||
    35 || stackTypeID||unknown||TINYINT||0||stack type identifier|| DVO || Currently we have either DEEP_STACK or NIGHTLY_STACK, which we know when queuing up stacks. This is then used to get the PSPS ID from StackType table [browser:trunk/ippToPsps/config/init/tables.vot here]||
     35|| stackTypeID||unknown||TINYINT||0||stack type identifier|| DVO || Currently we have either DEEP_STACK or NIGHTLY_STACK, which we know when queuing up stacks. This is then used to get the PSPS ID from !StackType table [browser:trunk/ippToPsps/config/init/tables.vot here]||
    3636|| magSat||unknown||REAL||-999||saturation magnitude level|| NA || empty ||
    3737|| analVer||unknown||SMALLINT||-999||analysis version index|| NA || empty ||
    38 || expTime||s||REAL||-999|| exposure time|| GPC1 || SELECT SUM(exp_time) * (COUNT(warp_id) - reject_images) / COUNT(warp_id) as EXPTIME FROM staticskyRun. JOINed through numerous tables using stack_id starting point ||
     38|| expTime||s||REAL||-999|| exposure time|| GPC1 || SELECT SUM(exp_time) * (COUNT(warp_id) - reject_images) / COUNT(warp_id) as EXPTIME FROM staticskyRun. JOIN-ed through numerous tables using stack_id starting point ||
    3939|| nP2Images||unknown||SMALLINT||-999||number of P2 images contributing to this cell||GPC1 ||a count of images listed in the !StackToImage table - see below ||
    4040|| completMag||unknown||REAL||-999||95% completion level in mag|| NA || empty  ||
    … …  
    6464|| '''!StackDetection''' ||||||||||||||
    6565|| '''ODM attribute''' || '''units''' || '''Data type''' || '''Default''' || '''Description''' || '''IPP source''' || '''IPP variable/notes''' ||
    66 || objID||unknown||BIGINT||0||ODM object identifier|| || ||
    67 || stackDetectID||unknown||BIGINT||0||ODM detection identifier|| || ||
    68 || ippObjID||unknown||BIGINT||0||IPP object identifier|| || ||
    69 || ippDetectID||unknown||BIGINT||0||detection ID generated by IPP|| || ||
    70 || filterID||unknown||TINYINT||0||filter identifier|| || ||
    71 || stackTypeID||unknown||TINYINT||0||stack type identifier|| || ||
    72 || surveyID||unknown||TINYINT||0||survey flag identifier|| || ||
     66|| objID||unknown||BIGINT||0||ODM object identifier||DVO ||ave.extID from dvoDetection structure ||
     67|| stackDetectID||unknown||BIGINT||0||ODM detection identifier|| DVO ||meas.extID from dvoDetection structure ||
     68|| ippObjID||unknown||BIGINT||0||IPP object identifier||DVO || ave.catID*1000000000 + ave.objID from dvoDetection structure ||
     69|| ippDetectID||unknown||BIGINT||0||detection ID generated by IPP|| cmf SkyChip.psf table ||IPP_IDET ||
     70|| filterID||unknown||TINYINT||0||filter identifier||cmf primary header || Same as !StackMeta. See above. ||
     71|| stackTypeID||unknown||TINYINT||0||stack type identifier|| DVO|| Same as !StackMeta. See above. ||
     72|| surveyID||unknown||TINYINT||0||survey flag identifier|| GPC1 database/DVO|| Same as !StackMeta. See above. ||
    7373|| primaryF||unknown||TINYINT||255||identifies best stack detection for Stacks overlapping the same region of the sky.|| || ||
    74 || stackMetaID||unknown||BIGINT||0||stack identifier|| || ||
    75 || skyCellID||unknown||INT||-999||skycell identifier|| || ||
    76 || projectionCellID||unknown||INT||-999||projection cell identifier|| || ||
    77 || obsTime||day||FLOAT||-999|| Time of mid observation|| || ||
    78 || xPos||unknown||REAL||-999||measured x on CCD from PSF fit|| || ||
    79 || yPos||unknown||REAL||-999||measured y on CCD from PSF fit|| || ||
    80 || xPosErr||unknown||REAL||-999||estimated error in x|| || ||
    81 || yPosErr||unknown||REAL||-999||estimated error in y|| || ||
    82 || instFlux||unknown||REAL||-999||PSF instrumental flux|| || ||
     74|| stackMetaID||unknown||BIGINT||0||stack identifier|| NA || hardcoded to 0 ||
     75|| skyCellID||unknown||INT||-999||skycell identifier|| GPC1 database|| Same as !StackMeta. See above.||
     76|| projectionCellID||unknown||INT||-999||projection cell identifier|| NA || empty ||
     77|| obsTime||day||FLOAT||-999|| Time of mid observation|| cmf primary header || MJD-OBS ||
     78|| xPos||unknown||REAL||-999||measured x on CCD from PSF fit|| cmf SkyChip.psf table||X_PSF ||
     79|| yPos||unknown||REAL||-999||measured y on CCD from PSF fit|| cmf SkyChip.psf table||Y_PSF ||
     80|| xPosErr||unknown||REAL||-999||estimated error in x|| cmf SkyChip.psf table||X_PSF_SIG ||
     81|| yPosErr||unknown||REAL||-999||estimated error in y||cmf SkyChip.psf table ||Y_PSF_SIG ||
     82|| instFlux||unknown||REAL||-999||PSF instrumental flux|| cmf SkyChip.psf table and GPC1 || POW(10.0, (-0.4*PSF_INST_MAG)) / expTime (where expTime is as derived in !StackMeta, see above) ||
    8383|| instFluxErr||unknown||REAL||-999||estimated error in instrumental flux|| || ||
    8484|| peakFlux||unknown||REAL||-999||ratio of peak flux to total flux|| || ||