Changes between Version 51 and Version 52 of ippToPsps_Stack
- Timestamp:
- Oct 6, 2011, 2:09:38 PM (15 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
ippToPsps_Stack
v51 v52 28 28 || '''!StackMeta''' |||||||||||||| 29 29 || '''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 ||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 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 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] || … … 44 44 || nPhoRef||unknown||INT||-999||number of photometric reference sources|| NA || empty || 45 45 || psfModelID||unknown||VARCHAR(MAX)|| ||PSF model identifier|| cmf primary header || PSFMODEL || 46 || psfFwhm_mean||unknown||FLOAT||-999||mean PSF FWHM in the stack|| NA || empty CZW: gpc1db select avg(fwhm_major) from stackRun JOIN stackInputSkyfile USING(stack_id) JOIN warpRun USING(warp_id) JOIN fakeRun USING(fake_id) JOIN camRun USING(cam_id) JOIN camProcessedExp USING(cam_id) where stack_id = XXX, alternate: headerFWHM_MAJ||47 || psfFwhm_max||unknown||FLOAT||-999||maximum PSF FWHM in the stack|| NA || empty CZW: gpc1db select max(fwhm_major) from stackRun JOIN stackInputSkyfile USING(stack_id) JOIN warpRun USING(warp_id) JOIN fakeRun USING(fake_id) JOIN camRun USING(cam_id) JOIN camProcessedExp USING(cam_id) where stack_id = XXX, alternate: headerFW_MJ_UQ||46 || psfFwhm_mean||unknown||FLOAT||-999||mean PSF FWHM in the stack|| cmf primary header || FWHM_MAJ|| 47 || psfFwhm_max||unknown||FLOAT||-999||maximum PSF FWHM in the stack|| cmf primary header || FW_MJ_UQ|| 48 48 || photoZero||unknown||REAL||-999||local derived photometric zero point|| cmf primary header ||FPA.ZP || 49 49 || photoColor||unknown||REAL||-999||local derived photometric color term|| NA || empty || … … 74 74 || stackMetaID||unknown||BIGINT||0||stack identifier|| GPC1 database|| Same as !StackMeta. See above.|| 75 75 || skyCellID||unknown||INT||-999||skycell identifier|| GPC1 database|| Same as !StackMeta. See above.|| 76 || projectionCellID||unknown||INT||-999||projection cell identifier|| NA || empty CZW: gpc1db select substr(skycell_id,1,12) from stackRun where stack_id = XXX||76 || projectionCellID||unknown||INT||-999||projection cell identifier|| NA || from, eg skycell.1133.081, use 1133 || 77 77 || obsTime||day||FLOAT||-999|| Time of mid observation|| cmf primary header || MJD-OBS || 78 78 || xPos||unknown||REAL||-999||measured x on CCD from PSF fit|| cmf !SkyChip.psf table||X_PSF ||
