Changes between Version 43 and Version 44 of ippToPsps_Stack
- Timestamp:
- Sep 26, 2011, 11:58:38 AM (15 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
ippToPsps_Stack
v43 v44 35 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]|| 36 36 || magSat||unknown||REAL||-999||saturation magnitude level|| cmf primary header || FSATUR (not set?) || 37 || analVer||unknown||SMALLINT||-999||analysis version index|| NA || empty ||37 || analVer||unknown||SMALLINT||-999||analysis version index|| NA || empty CZW: header PHOT_V|| 38 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 || 39 39 || nP2Images||unknown||SMALLINT||-999||number of P2 images contributing to this cell||GPC1 ||a count of images listed in the !StackToImage table - see below || … … 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 ||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 ||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: header FWHM_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: 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 || … … 89 89 || psfWidMinor||unknown||REAL||-999||PSF width in minor axis||cmf !SkyChip.psf table ||PSF_MINOR || 90 90 || psfTheta||unknown||REAL||-999||PSF orientation angle||cmf !SkyChip.psf table ||PSF_THETA || 91 || psfLikelihood||unknown||REAL||-999||PSF likelihood|| NA || empty ||91 || psfLikelihood||unknown||REAL||-999||PSF likelihood|| NA || empty CZW: CMF EXP_NSIGMA as with chip stage|| 92 92 || psfCf||unknown||REAL||-999||PSF coverage factor|| cmf !SkyChip.psf table||PSF_QF || 93 93 || momentXX||arcsec||REAL||-999|| moment XX||cmf !SkyChip.psf table ||MOMENTS_XX ||
