IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changes between Version 42 and Version 43 of ippToPsps_Detections


Ignore:
Timestamp:
Jun 23, 2011, 12:33:54 PM (15 years ago)
Author:
rhenders
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • ippToPsps_Detections

    v42 v43  
    2929|| frameName||unknown||VARCHAR(32)|| ||frame name provided by camera software|| GPC1 database || SELECT exp_name FROM camRun JOIN chipRun USING(chip_id) JOIN rawExp USING(exp_id) WHERE camRun.cam_id = cam_id ||
    3030|| surveyID||unknown||TINYINT||0||survey flag identifier|| GPC1 database || SELECT camRun.dist_group FROM camRun JOIN chipRun USING(chip_id) JOIN rawExp USING(exp_id) WHERE camRun.cam_id = cam_id. The IPP dist_group is then used to get the surveyID from the PSPS 'Survey' table [browser:trunk/ippToPsps/config/init/tables.vot here]||
    31 || filterID||unknown||TINYINT||0||filter identifier|| smf primary header || Single character filter (grizy) is then used to get PSPS ID from Filter table [browser:trunk/ippToPsps/config/init/tables.vot here] ||
     31|| filterID||unknown||TINYINT||0||filter identifier|| smf primary header || Single character filter (grizy) is used to get PSPS ID from Filter table [browser:trunk/ippToPsps/config/init/tables.vot here] ||
    3232|| cameraID||unknown||SMALLINT||0||camera identifier|| NA || hardcoded to 1 ||
    3333|| cameraConfigID||unknown||SMALLINT||0||camera configuration identifier|| NA ||hardcoded to 1 ||
    … …  
    7676|| '''!ImageMeta''' ||||||||||||||
    7777|| '''ODM attribute''' || '''units''' || '''Data type''' || '''Default''' || '''Description''' || '''IPP source''' || '''IPP variable/notes''' ||
    78 || imageID||unknown||BIGINT||0||unique ID for each image, hashed from frameID and ccdID (ALEX)|| || ||
    79 || frameID||unknown||INT||0||frame identifier, also known as exposure number|| || ||
    80 || ccdID||unknown||SMALLINT||0||ccd cell identifier in the focal plane|| || ||
    81 || photoCalID||unknown||INT||0||photometry reduction code identifier|| || ||
    82 || filterID||unknown||TINYINT||0||filter ID|| || ||
    83 || bias||ADU||REAL||-999|| detector bias level|| || ||
    84 || biasScat||ADU||REAL||-999|| scatter in bias level|| || ||
    85 || sky||ADU||REAL||-999|| mean sky level|| || ||
    86 || skyScat||ADU||REAL||-999|| scatter in mean sky level|| || ||
    87 || nDetect||unknown||INT||-999||number of detections on CCD|| || ||
    88 || magSat||mag||REAL||-999|| saturation magnitude level|| || ||
    89 || completMag||mag||REAL||-999|| 95% completion level in mag|| || ||
    90 || astroScat||mag||REAL||-999|| astrometric scatter for chip|| || ||
    91 || photoScat||unknown||REAL||-999||photometric scatter for chip|| || ||
    92 || numAstroRef||unknown||INT||-999||number of astrometric reference sources|| || ||
    93 || numPhotoRef||unknown||INT||-999||number of photometric reference sources|| || ||
    94 || nx||unknown||SMALLINT||-999||chip dimension in x|| || ||
    95 || ny||unknown||SMALLINT||-999||chip dimension in y|| || ||
    96 || psfModelID||unknown||INT||-999||PSF model identifier|| || ||
    97 || psfFwhm||arcsec||REAL||-999|| model psf full width at half maximum at chip center|| || ||
    98 || psfWidMajor||arcsec||REAL||-999|| model PSF parameters at chip center|| || ||
    99 || psfWidMinor||arcsec||REAL||-999|| model PSF parameters at chip center|| || ||
    100 || psfTheta||deg||REAL||-999|| model PSF parameters at chip center|| || ||
    101 || momentFwhm||arcsec||REAL||-999|| average PSF full width at half maximum from moments|| || ||
    102 || momentWidMajor||arcsec||REAL||-999|| average PSF parameters from moments|| || ||
    103 || momentWidMinor||arcsec||REAL||-999|| average PSF parameters from moments|| || ||
    104 || apResid||unknown||REAL||-999||corrected aperture residual|| || ||
    105 || dapResid||unknown||REAL||-999||scatter of aperture corrections|| || ||
    106 || detectorID||unknown||VARCHAR(32)|| ||identifier for actual CCD chip|| || ||
     78|| imageID||unknown||BIGINT||0||unique ID for each image, hashed from frameID and ccdID (ALEX)|| GPC1 and smf extension name|| frameID (below) mashed together with OTA number||
     79|| frameID||unknown||INT||0||frame identifier, also known as exposure number|| GPC1 database || SELECT exp_id FROM camRun JOIN chipRun USING(chip_id) JOIN rawExp USING(exp_id) WHERE camRun.cam_id = cam_id ||
     80|| ccdID||unknown||SMALLINT||0||ccd cell identifier in the focal plane|| smf || OTA number||
     81|| photoCalID||unknown||INT||0||photometry reduction code identifier|| DVO || image->photcode from DVO Image structure ||
     82|| filterID||unknown||TINYINT||0||filter ID|| smf primary header || same as for FrameMeta (see above) ||
     83|| bias||ADU||REAL||-999|| detector bias level|| || empty ||
     84|| biasScat||ADU||REAL||-999|| scatter in bias level|| || empty ||
     85|| sky||ADU||REAL||-999|| mean sky level|| smf XYnn.hdr extension || MSKY_MN||
     86|| skyScat||ADU||REAL||-999|| scatter in mean sky level|| smf XYnn.hdr extension ||MSKY_SIG ||
     87|| nDetect||unknown||INT||-999||number of detections on CCD|| smf XYnn.psf extension || count of detections retrieved from the psf extension ||
     88|| magSat||mag||REAL||-999|| saturation magnitude level|| smf XYnn.hdr extension || FSATUR||
     89|| completMag||mag||REAL||-999|| 95% completion level in mag|| smf XYnn.hdr extension ||FLIMIT ||
     90|| astroScat||mag||REAL||-999|| astrometric scatter for chip||smf XYnn.hdr extension || CERROR||
     91|| photoScat||unknown||REAL||-999||photometric scatter for chip|| smf primary header ||ZPT_OBS ||
     92|| numAstroRef||unknown||INT||-999||number of astrometric reference sources||smf XYnn.hdr extension || NASTRO||
     93|| numPhotoRef||unknown||INT||-999||number of photometric reference sources||smf XYnn.hdr extension ||NASTRO ||
     94|| nx||unknown||SMALLINT||-999||chip dimension in x||smf XYnn.hdr extension ||CNAXIS1 ||
     95|| ny||unknown||SMALLINT||-999||chip dimension in y||smf XYnn.hdr extension || CNAXIS2||
     96|| psfModelID||unknown||INT||-999||PSF model identifier|| NA || empty ||
     97|| psfFwhm||arcsec||REAL||-999|| model psf full width at half maximum at chip center|| smf XYnn.hdr extension ||(FWHM_MAJ + FWHM_MIN) / 2.0 ||
     98|| psfWidMajor||arcsec||REAL||-999|| model PSF parameters at chip center||smf XYnn.hdr extension || FWHM_MAJ||
     99|| psfWidMinor||arcsec||REAL||-999|| model PSF parameters at chip center|| smf XYnn.hdr extension|| FWHM_MIN||
     100|| psfTheta||deg||REAL||-999|| model PSF parameters at chip center|| smf XYnn.hdr extension|| ANGLE||
     101|| momentFwhm||arcsec||REAL||-999|| average PSF full width at half maximum from moments|| smf XYnn.hdr extension || (IQ_FW1 + IQ_FW2) / 2.0 ||
     102|| momentWidMajor||arcsec||REAL||-999|| average PSF parameters from moments|| smf XYnn.hdr extension||IQ_FW1 ||
     103|| momentWidMinor||arcsec||REAL||-999|| average PSF parameters from moments|| smf XYnn.hdr extension|| IQ_FW2||
     104|| apResid||unknown||REAL||-999||corrected aperture residual||smf XYnn.hdr extension || APMIFIT||
     105|| dapResid||unknown||REAL||-999||scatter of aperture corrections||smf XYnn.hdr extension ||DAPMIFIT ||
     106|| detectorID||unknown||VARCHAR(32)|| ||identifier for actual CCD chip||smf XYnn.hdr extension ||DETECTOR ||
    107107|| qaFlags||unknown||BIGINT||-999||Q/A flags for this OTA|| || ||
    108108|| detrend1||unknown||VARCHAR(MAX)|| ||identifier of detrend image 1|| || ||