IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changes between Version 17 and Version 18 of ippToPsps_Stack


Ignore:
Timestamp:
Jun 24, 2011, 9:16:49 AM (15 years ago)
Author:
rhenders
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • ippToPsps_Stack

    v17 v18  
    2929|| '''ODM attribute''' || '''units''' || '''Data type''' || '''Default''' || '''Description''' || '''IPP source''' || '''IPP variable/notes''' ||
    3030|| 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|| || ||
    32 || surveyID||unknown||TINYINT||0||survey flag identifier|| || ||
    33 || photoCalID||unknown||INT||0||photometry code numerical id|| || ||
    34 || filterID||unknown||TINYINT||0||filter identifier|| || ||
    35 || stackTypeID||unknown||TINYINT||0||stack type identifier|| || ||
    36 || magSat||unknown||REAL||-999||saturation magnitude level|| || ||
    37 || analVer||unknown||SMALLINT||-999||analysis version index|| || ||
    38 || expTime||s||REAL||-999|| exposure time|| || ||
     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] ||
     33|| 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]||
     36|| magSat||unknown||REAL||-999||saturation magnitude level|| NA || empty ||
     37|| 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 ||
    3939|| nP2Images||unknown||SMALLINT||-999||number of P2 images contributing to this cell|| || ||
    40 || completMag||unknown||REAL||-999||95% completion level in mag|| || ||
    41 || astroScat||unknown||REAL||-999||astrometric scatter for chip|| || ||
    42 || photoScat||unknown||REAL||-999||photometric scatter for chip|| || ||
    43 || nAstroRef||unknown||INT||-999||number of astrometric reference sources|| || ||
    44 || nPhoRef||unknown||INT||-999||number of photometric reference sources|| || ||
    45 || psfModelID||unknown||VARCHAR(MAX)|| ||PSF model identifier|| || ||
    46 || psfFwhm_mean||unknown||FLOAT||-999||mean PSF FWHM in the stack|| || ||
    47 || psfFwhm_max||unknown||FLOAT||-999||maximum PSF FWHM in the stack|| || ||
    48 || photoZero||unknown||REAL||-999||local derived photometric zero point|| || ||
    49 || photoColor||unknown||REAL||-999||local derived photometric color term|| || ||
    50 || ctype1||unknown||VARCHAR(MAX)|| ||name of astrometric projection in RA|| || ||
    51 || ctype2||unknown||VARCHAR(MAX)|| ||name of astrometric projection in DEC|| || ||
    52 || crval1||unknown||FLOAT||-999||RA corresponding to reference pixel|| || ||
    53 || crval2||unknown||FLOAT||-999||DEC corresponding to reference pixel|| || ||
    54 || crpix1||unknown||FLOAT||-999||reference pixel value for RA|| || ||
    55 || crpix2||unknown||FLOAT||-999||reference pixel value for DEC|| || ||
    56 || cdelt1||unknown||FLOAT||-999||scale factor for RA|| || ||
    57 || cdelt2||unknown||FLOAT||-999||scale factor for DEC|| || ||
    58 || pc001001||unknown||FLOAT||-999||elements of rotation/Dcale matrix|| || ||
    59 || pc001002||unknown||FLOAT||-999||elements of rotation/Dcale matrix|| || ||
    60 || pc002001||unknown||FLOAT||-999||elements of rotation/Dcale matrix|| || ||
    61 || pc002002||unknown||FLOAT||-999||elements of rotation/Dcale matrix|| || ||
    62 || calibModNum||unknown||SMALLINT||0||calibration modification number|| || ||
    63 || dataRelease||unknown||TINYINT||0||Data release|| || ||
     40|| completMag||unknown||REAL||-999||95% completion level in mag|| GPC1 || a count of images listed in the !StackToImage table - see below ||
     41|| astroScat||unknown||REAL||-999||astrometric scatter for chip|| NA || empty ||
     42|| photoScat||unknown||REAL||-999||photometric scatter for chip|| NA || empty ||
     43|| nAstroRef||unknown||INT||-999||number of astrometric reference sources|| NA || empty ||
     44|| nPhoRef||unknown||INT||-999||number of photometric reference sources|| NA || empty ||
     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 ||
     47|| psfFwhm_max||unknown||FLOAT||-999||maximum PSF FWHM in the stack|| NA || empty ||
     48|| photoZero||unknown||REAL||-999||local derived photometric zero point|| cmf primary header ||FPA.ZP ||
     49|| photoColor||unknown||REAL||-999||local derived photometric color term|| NA || empty ||
     50|| ctype1||unknown||VARCHAR(MAX)|| ||name of astrometric projection in RA|| cmf primary header ||CTYPE1 ||
     51|| ctype2||unknown||VARCHAR(MAX)|| ||name of astrometric projection in DEC|| cmf primary header|| CTYPE2||
     52|| crval1||unknown||FLOAT||-999||RA corresponding to reference pixel|| cmf primary header|| CRVAL1||
     53|| crval2||unknown||FLOAT||-999||DEC corresponding to reference pixel|| cmf primary header|| CRVAL2||
     54|| crpix1||unknown||FLOAT||-999||reference pixel value for RA|| cmf primary header|| CRPIX1||
     55|| crpix2||unknown||FLOAT||-999||reference pixel value for DEC|| cmf primary header||CRPIX2 ||
     56|| cdelt1||unknown||FLOAT||-999||scale factor for RA|| cmf primary header||CDELT1 ||
     57|| cdelt2||unknown||FLOAT||-999||scale factor for DEC|| cmf primary header|| CDELT2||
     58|| pc001001||unknown||FLOAT||-999||elements of rotation/Dcale matrix||cmf primary header || PC001001||
     59|| pc001002||unknown||FLOAT||-999||elements of rotation/Dcale matrix|| cmf primary header|| PC001002||
     60|| pc002001||unknown||FLOAT||-999||elements of rotation/Dcale matrix|| cmf primary header|| PC002001||
     61|| pc002002||unknown||FLOAT||-999||elements of rotation/Dcale matrix|| cmf primary header|| PC002002||
     62|| calibModNum||unknown||SMALLINT||0||calibration modification number|| NA || empty ||
     63|| dataRelease||unknown||TINYINT||0||Data release|| NA || hardcoded to 1 ||
    6464|| '''!StackDetection''' ||||||||||||||
    6565|| '''ODM attribute''' || '''units''' || '''Data type''' || '''Default''' || '''Description''' || '''IPP source''' || '''IPP variable/notes''' ||