IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changes between Version 56 and Version 57 of ippToPsps_Stack


Ignore:
Timestamp:
Jan 6, 2012, 3:12:18 PM (15 years ago)
Author:
rhenders
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • ippToPsps_Stack

    v56 v57  
    20201 '''{{{StackModelFit}}}''' extension per skycell[[BR]]
    2121
    22 The full table definitions can be seen [browser:trunk/ippToPsps/config/stack/tables.vot here]
     22The full table definitions can be seen [browser:trunk/ippToPsps/config/ST/tables.vot here]
    2323
    2424= Current IPP to PSPS mappings =
     
    2828|| '''!StackMeta''' ||||||||||||||
    2929|| '''ODM attribute''' || '''units''' || '''Data type''' || '''Default''' || '''Description''' || '''IPP source''' || '''IPP variable/notes''' ||
    30 || stackMetaID||unknown||BIGINT||0||stack identifier|| GPC1 database || stackRun.stack_id using sky_id and filter via staticskyInput, staticskyRun, and staticskyResult tables. From, eg skycell.1133.081, use 1133081 ||
    31 || skycellID||unknown||INT||0||skycell region identifier|| GPC1 database || stackRun.skycell_id using sky_id and filter via staticskyInput, staticskyRun, and staticskyResult tables ||
    32 || surveyID||unknown||TINYINT||0||survey flag identifier||GPC1 database/DVO || We know survey from the DVO database in use, we then get the surveyID from the PSPS 'Survey' table [browser:trunk/ippToPsps/config/init/tables.vot here] ||
     30|| stackMetaID||unknown||BIGINT||0||stack identifier|| GPC1 database || stackRun.stack_id using sky_id and filter via staticskyInput, staticskyRun, and staticskyResult tables. ||
     31|| skycellID||unknown||INT||0||skycell region identifier|| GPC1 database || stackRun.skycell_id using sky_id and filter via staticskyInput, staticskyRun, and staticskyResult tables From, eg skycell.1133.081, use 1133081  ||
     32|| surveyID||unknown||TINYINT||0||survey flag identifier||GPC1 database/DVO || We know survey from the DVO database in use, we then get the surveyID from the PSPS 'Survey' table [browser:trunk/ippToPsps/config/IN/tables.vot here] ||
    3333|| photoCalID||unknown||INT||0||photometry code numerical id|| DVO ||image->photcode from Image structure ||
    34 || 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]||
     34|| 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/IN/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/iIN/tables.vot here]||
    3636|| magSat||unknown||REAL||-999||saturation magnitude level|| cmf primary header || FSATUR (not set?) ||
    3737|| analVer||unknown||SMALLINT||-999||analysis version index|| NA || empty CZW: header PHOT_V||