IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changes between Version 83 and Version 84 of ippToPsps_Stack


Ignore:
Timestamp:
Nov 15, 2012, 3:29:16 PM (13 years ago)
Author:
conradh
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • ippToPsps_Stack

    v83 v84  
    3232|| '''!StackMeta''' ||||||||||||||
    3333|| '''ODM attribute''' || '''units''' || '''Data type''' || '''Default''' || '''Description''' || '''IPP source''' || '''IPP variable/notes''' ||
    34 || stackMetaID||unknown||BIGINT||0||stack identifier|| GPC1 database || stackRun.stack_id using sky_id and filter via staticskyInput, staticskyRun, and staticskyResult tables. ||
    35 || 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  ||
    36 || 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] ||
    37 || photoCalID||unknown||INT||0||photometry code numerical id|| DVO ||image->photcode from Image structure ||
    38 || 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] ||
    39 || 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/IN/tables.vot here]||
    40 || magSat||unknown||REAL||-999||saturation magnitude level|| cmf primary header || FSATUR (not set?) ||
    41 || analVer||unknown||SMALLINT||-999||analysis version index|| NA || empty CZW: header PHOT_V||
    42 || expTime||s||REAL||-999|| exposure time|| cmf primary header || EXPTIME ||
     34|| stackMetaID||dimensionless||BIGINT||0||stack identifier|| GPC1 database || stackRun.stack_id using sky_id and filter via staticskyInput, staticskyRun, and staticskyResult tables. ||
     35|| skycellID||dimensionless||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  ||
     36|| surveyID||dimensionless||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] ||
     37|| photoCalID||dimensionless||INT||0||photometry code numerical id|| DVO ||image->photcode from Image structure ||
     38|| filterID||dimensionless||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] ||
     39|| stackTypeID||dimensionless||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/IN/tables.vot here]||
     40|| magSat||dimensionless||REAL||-999||saturation magnitude level|| cmf primary header || FSATUR (not set?) ||
     41|| analVer||dimensionless||SMALLINT||-999||analysis version index|| NA || empty CZW: header PHOT_V||
     42|| expTime||seconds||REAL||-999|| exposure time|| cmf primary header || EXPTIME ||
    4343|| nP2Images||unknown||SMALLINT||-999||number of P2 images contributing to this cell||GPC1 ||a count of images listed in the !StackToImage table - see below ||
    4444|| completMag||unknown||REAL||-999||95% completion level in mag|| cmf primary header || FLIMIT (not set?) or from the deteff extension or the detection efficiency server? ||
    … …  
    5252|| photoZero||unknown||REAL||-999||local derived photometric zero point|| cmf primary header ||FPA.ZP  ||
    5353|| photoColor||unknown||REAL||-999||local derived photometric color term|| NA || empty ||
    54 || ctype1||unknown||VARCHAR(MAX)|| ||name of astrometric projection in RA|| cmf primary header ||CTYPE1 ||
    55 || ctype2||unknown||VARCHAR(MAX)|| ||name of astrometric projection in DEC|| cmf primary header|| CTYPE2||
    56 || crval1||unknown||FLOAT||-999||RA corresponding to reference pixel|| cmf primary header|| CRVAL1||
    57 || crval2||unknown||FLOAT||-999||DEC corresponding to reference pixel|| cmf primary header|| CRVAL2||
    58 || crpix1||unknown||FLOAT||-999||reference pixel value for RA|| cmf primary header|| CRPIX1||
    59 || crpix2||unknown||FLOAT||-999||reference pixel value for DEC|| cmf primary header||CRPIX2 ||
    60 || cdelt1||unknown||FLOAT||-999||scale factor for RA|| cmf primary header||CDELT1 ||
    61 || cdelt2||unknown||FLOAT||-999||scale factor for DEC|| cmf primary header|| CDELT2||
    62 || pc001001||unknown||FLOAT||-999||elements of rotation/Dcale matrix||cmf primary header || PC001001||
    63 || pc001002||unknown||FLOAT||-999||elements of rotation/Dcale matrix|| cmf primary header|| PC001002||
    64 || pc002001||unknown||FLOAT||-999||elements of rotation/Dcale matrix|| cmf primary header|| PC002001||
    65 || pc002002||unknown||FLOAT||-999||elements of rotation/Dcale matrix|| cmf primary header|| PC002002||
    66 || calibModNum||unknown||SMALLINT||0||calibration modification number|| NA || empty ||
    67 || dataRelease||unknown||TINYINT||0||Data release|| NA || hardcoded to 1 ||
     54|| ctype1||dimensionsless||VARCHAR(MAX)|| ||name of astrometric projection in RA|| cmf primary header ||CTYPE1 ||
     55|| ctype2||dimensionsless||VARCHAR(MAX)|| ||name of astrometric projection in DEC|| cmf primary header|| CTYPE2||
     56|| crval1||dimensionsless||FLOAT||-999||RA corresponding to reference pixel|| cmf primary header|| CRVAL1||
     57|| crval2||dimensionsless||FLOAT||-999||DEC corresponding to reference pixel|| cmf primary header|| CRVAL2||
     58|| crpix1||dimensionsless||FLOAT||-999||reference pixel value for RA|| cmf primary header|| CRPIX1||
     59|| crpix2||dimensionsless||FLOAT||-999||reference pixel value for DEC|| cmf primary header||CRPIX2 ||
     60|| cdelt1||dimensionsless||FLOAT||-999||scale factor for RA|| cmf primary header||CDELT1 ||
     61|| cdelt2||dimensionsless||FLOAT||-999||scale factor for DEC|| cmf primary header|| CDELT2||
     62|| pc001001||dimensionsless||FLOAT||-999||elements of rotation/Dcale matrix||cmf primary header || PC001001||
     63|| pc001002||dimensionsless||FLOAT||-999||elements of rotation/Dcale matrix|| cmf primary header|| PC001002||
     64|| pc002001||dimensionsless||FLOAT||-999||elements of rotation/Dcale matrix|| cmf primary header|| PC002001||
     65|| pc002002||dimensionsless||FLOAT||-999||elements of rotation/Dcale matrix|| cmf primary header|| PC002002||
     66|| calibModNum||dimensionsless||SMALLINT||0||calibration modification number|| NA || empty ||
     67|| dataRelease||dimensionsless||TINYINT||0||Data release|| NA || hardcoded to 1 ||
    6868|| '''!StackDetection''' ||||||||||||||
    6969|| '''ODM attribute''' || '''units''' || '''Data type''' || '''Default''' || '''Description''' || '''IPP source''' || '''IPP variable/notes''' ||
    … …  
    7979|| skyCellID||dimensionless||INT||-999||skycell identifier|| GPC1 database|| Same as !StackMeta. See above.||
    8080|| projectionCellID||dimensionless||INT||-999||projection cell identifier|| NA || from, eg skycell.1133.081, use 1133 ||
    81 || ~~~obsTime~~~||~~~day~~~||~~~FLOAT~~~||~~~-999~~~|| ~~~Time of mid observation~~~|| ~~~cmf primary header~~~ || ~~~MJD-OBS~~~ - relabeled and moved down below to be qf_perfect ||
    8281|| xPos||pixels||REAL||-999||measured x on '''skycell''' from PSF fit - '''warped pixels = 0.25 arcsec'''|| cmf !SkyChip.psf table||X_PSF ||
    8382|| yPos||pixels||REAL||-999||measured y on '''skycell''' from PSF fit|| cmf !SkyChip.psf table||Y_PSF ||
    8483|| xPosErr||pixels||REAL||-999||estimated error in x|| cmf !SkyChip.psf table||X_PSF_SIG ||
    8584|| yPosErr||pixels||REAL||-999||estimated error in y||cmf !SkyChip.psf table ||Y_PSF_SIG ||
    86 || ~~~instFlux~~~ '''psfFlux'''||~~~unknown~~~ '''adu/sec'''||REAL||-999||PSF instrumental flux|| cmf !SkyChip.psf table and GPC1 || POW(10.0, (-0.4*PSF_INST_MAG)) / expTime (where expTime is from !StackMeta, see above) ||
    87 || ~~~instFluxErr~~~ '''psfFluxErr'''||~~~unknown~~~ '''adu/sec'''||REAL||-999||estimated error in instrumental flux||cmf !SkyChip.psf table and GPC1 || ABS((PSF_INST_MAG_SIG*(POW(10.0, (-0.4*PSF_INST_MAG)) / expTime)) / 1.085736) (where expTime from  !StackMeta, see above)||
    88 || peakFlux||~~~unknown~~~ '''adu'''||REAL||-999||ratio of peak flux to total flux|| cmf !SkyChip.psf table and GPC1||POW(10.0, (-0.4*PEAK_FLUX_AS_MAG)) / expTime (where expTime is from !StackMeta, see above)||
    89 || sky||~~~unknown~~~ '''adu/sec/pixel''' ||REAL||-999||PSF sky level at source (adu)|| cmf !SkyChip.psf table||SKY ||
    90 || skyErr||~~~unknown~~~ '''adu/sec/pixel''' ||REAL||-999||estimated error in sky||cmf !SkyChip.psf table ||SKY_SIGMA ||
     85|| psfFlux||adu/sec||REAL||-999||PSF instrumental flux|| cmf !SkyChip.psf table and GPC1 || POW(10.0, (-0.4*PSF_INST_MAG)) / expTime (where expTime is from !StackMeta, see above) ||
     86|| psfFluxErr||adu/sec||REAL||-999||estimated error in instrumental flux||cmf !SkyChip.psf table and GPC1 || ABS((PSF_INST_MAG_SIG*(POW(10.0, (-0.4*PSF_INST_MAG)) / expTime)) / 1.085736) (where expTime from  !StackMeta, see above)||
     87|| peakFlux||adu||REAL||-999||ratio of peak flux to total flux|| cmf !SkyChip.psf table and GPC1||POW(10.0, (-0.4*PEAK_FLUX_AS_MAG)) / expTime (where expTime is from !StackMeta, see above)||
     88|| sky||adu/sec/pixel ||REAL||-999||PSF sky level at source (adu)|| cmf !SkyChip.psf table||SKY ||
     89|| skyErr|| adu/sec/pixel ||REAL||-999||estimated error in sky||cmf !SkyChip.psf table ||SKY_SIGMA ||
    9190|| sgSep||dimensionless||REAL||-999||star/galaxy separator||cmf !SkyChip.psf table ||~~~EXT_NSIGMA~~~ '''TBD''' ||
    9291|| psfWidMajor||pixels||REAL||-999||PSF width in major axis||cmf !SkyChip.psf table || PSF_MAJOR||
    … …  
    9493|| psfTheta||degrees East of North||REAL||-999||PSF orientation angle||cmf !SkyChip.psf table ||PSF_THETA ||
    9594|| psfLikelihood||dimensionless||REAL||-999||PSF likelihood|| cmf !SkyChip.psf table || ~~~erfc(abs(EXT_NSIGMA) / sqrt(2))~~~ '''sign(EXT_NSIGMA)*erfc(abs(EXT_NSIGMA) / sqrt(2))'''||
    96 || ~~~psfCf~~~ '''psfQf'''||dimensionless||REAL||-999||PSF coverage factor|| cmf !SkyChip.psf table||PSF_QF ||
    97 || '''psfQfPerfect''' ||dimensionless ||REAL ||-999|| PSF QF Perfect || cmf !SkyChip.psf table || PSF_QF_PERFECT ||
     95|| psfQf||dimensionless||REAL||-999||PSF coverage factor|| cmf !SkyChip.psf table||PSF_QF ||
     96|| psfQfPerfect ||dimensionless ||REAL ||-999|| PSF QF Perfect || cmf !SkyChip.psf table || PSF_QF_PERFECT ||
    9897|| momentXX||pixels||REAL||-999|| moment XX||cmf !SkyChip.psf table ||MOMENTS_XX ||
    9998|| momentXY||pixels||REAL||-999|| moment XY|| cmf !SkyChip.psf table||MOMENTS_XY ||
    … …  
    105104|| momentR1||pixels||REAL||-999|| moment R1|| cmf !SkyChip.psf table|| MOMENTS_R1||
    106105|| momentRH||sqrt pixels||REAL||-999|| moment RH||cmf !SkyChip.psf table || MOMENTS_RH||
    107 || ~~~apMag~~~'''apFlux'''||~~~magnitude~~~'''adu/sec'''||REAL||-999|| Aperture magnitude||cmf !SkyChip.psf table || AP_MAG converted to flux||
    108 || ~~~apMagErr~~~'''apFluxErr'''||~~~magnitude~~~'''adu/sec'''||REAL||-999|| Aperture magnitude error|| NA || empty ||
    109 || kronFlux||~~~magnitude~~~'''adu/sec'''||REAL||-999|| Kron flux||cmf !SkyChip.psf table ||KRON_FLUX / expTime ||
    110 || kronFluxErr||~~~magnitude~~~'''adu/sec'''||REAL||-999|| Kron flux error||cmf !SkyChip.psf table ||KRON_FLUX_ERR / expTime  ||
     106|| apFlux||adu/sec||REAL||-999|| Aperture magnitude||cmf !SkyChip.psf table || AP_MAG converted to flux||
     107|| apFluxErr||adu/sec||REAL||-999|| Aperture magnitude error|| NA || empty ||
     108|| kronFlux||adu/sec||REAL||-999|| Kron flux||cmf !SkyChip.psf table ||KRON_FLUX / expTime ||
     109|| kronFluxErr|| adu/sec||REAL||-999|| Kron flux error||cmf !SkyChip.psf table ||KRON_FLUX_ERR / expTime  ||
    111110|| kronRad||arcsecs||REAL||-999|| Kron radius|| NA|| ~~empty CZW: generally 2.5 * MOMENTS_R1, except when MOMENTS_R1 is large or small~~  set to MOMENTS_R1 * 2.5||
    112 || ~~~kronRadErr~~~ '''psfChiSq'''||~~~arcsecs~~~||REAL||-999|| ~~~Kron radius error~~~||from cmf !SkyChip.psf table || ~~~empty~~~ psf_chisq||
     111|| psfChiSq||~~~arcsecs~~~||REAL||-999|| ~~~Kron radius error~~~||from cmf !SkyChip.psf table || ~~~empty~~~ psf_chisq||
    113112|| infoFlag||dimensionless||BIGINT||-999||detection properties||cmf !SkyChip.psf table || old (everything prior to SAS9:FLAGS << 32 | FLAGS2)sa9: FLAGS2 <<32 | FLAGS  sa10: dbflags <<45 |FLAGS2 <<32 |FLAGS   ||
    114113|| nFrames||dimensionless||INT||-999||number of frames contributing to source||cmf !SkyChip.psf table ||N_FRAMES ||
    … …  
    119118|| '''!StackApFlx''' ||||||||||||||
    120119|| '''ODM attribute''' || '''units''' || '''Data type''' || '''Default''' || '''Description''' || '''IPP source''' || '''IPP variable/notes''' ||
    121 || objID||dimensionless - ditto for IDs||BIGINT||0||ODM object identifier||DVO || same as !StackDetection - see above ||
    122 || stackDetectID||unknown||BIGINT||0||ODM detection identifier|| DVO || same as !StackDetection - see above ||
    123 || ippObjID||unknown||BIGINT||0||IPP object identifier|| DVO || same as !StackDetection - see above ||
    124 || ippDetectID||unknown||BIGINT||0||detection ID generated by IPP|| cmf !SkyChip.xrad extension ||IPP_IDET ||
    125 || filterID||unknown||TINYINT||0||filter identifier|| cmf primary header || Same as !StackMeta. See above. ||
    126 || stackTypeID||unknown||TINYINT||0||stack type identifier|| DVO|| Same as !StackMeta. See above. ||
    127 || surveyID||unknown||TINYINT||0||survey flag identifier|| GPC1 database/DVO|| Same as !StackMeta. See above. ||
     120|| objID||dimensionless ||BIGINT||0||ODM object identifier||DVO || same as !StackDetection - see above ||
     121|| stackDetectID||dimensionsless||BIGINT||0||ODM detection identifier|| DVO || same as !StackDetection - see above ||
     122|| ippObjID||dimensionsless||BIGINT||0||IPP object identifier|| DVO || same as !StackDetection - see above ||
     123|| ippDetectID||dimensionsless||BIGINT||0||detection ID generated by IPP|| cmf !SkyChip.xrad extension ||IPP_IDET ||
     124|| filterID||dimensionsless||TINYINT||0||filter identifier|| cmf primary header || Same as !StackMeta. See above. ||
     125|| stackTypeID||dimensionsless||TINYINT||0||stack type identifier|| DVO|| Same as !StackMeta. See above. ||
     126|| surveyID||dimensionsless||TINYINT||0||survey flag identifier|| GPC1 database/DVO|| Same as !StackMeta. See above. ||
    128127|| primaryF||unknown||TINYINT||255||identifies best stack detection for Stacks overlapping the same region of the sky.|| NA || hardcoded to 0 ||
    129128|| stackMetaID||unknown||BIGINT||0||stack identifier|| GPC1 database|| Same as !StackMeta. See above.||
    130 || ~~~isophotMag~~~ '''isophotFlux'''||adu/sec||REAL||-999||isophotal magnitude|| NA || empty ||
    131 || ~~~isophotMagErr~~~ '''isophotFluxErr'''||adu/sec||REAL||-999||estimated error in isophotal magnitude||  NA || empty ||
     129|| isophotFlux||adu/sec||REAL||-999||isophotal magnitude|| NA || empty ||
     130|| isophotFluxErr||adu/sec||REAL||-999||estimated error in isophotal magnitude||  NA || empty ||
    132131|| isophotMajAxis||pixels||REAL||-999||isophotal Major Axis||  NA || empty ||
    133132|| isophotMajAxisErr||pixels||REAL||-999||estimated error in isophotal Major Axis||  NA || empty ||
    … …  
    141140|| petRadius||pixels||REAL||-999||Petrosian radius|| cmf !SkyChip.xsrc extension || PETRO_RADIUS ||
    142141|| petRadiusErr||pixels||REAL||-999||estimated error inPetrosian radius||cmf !SkyChip.xsrc extension  ||PETRO_RADIUS_ERR ||
    143 || ~~~petMag~~~ '''petFlux'''||adu/sec||REAL||-999||Petrosian magntiude||cmf !SkyChip.xsrc extension  || PETRO_MAG||
    144 || ~~~petMagErr~~~ '''petFluxErr'''||adu/sec||REAL||-999||estimated error in petMag||cmf !SkyChip.xsrc extension  ||PETRO_MAG_ERR ||
     142|| petFlux||adu/sec||REAL||-999||Petrosian magntiude||cmf !SkyChip.xsrc extension  || PETRO_MAG||
     143|| petFluxErr||adu/sec||REAL||-999||estimated error in petMag||cmf !SkyChip.xsrc extension  ||PETRO_MAG_ERR ||
    145144|| petR50||pixels||REAL||-999||Petrosian radius at 50% light||cmf !SkyChip.xsrc extension  || PETRO_RADIUS_50||
    146145|| petR50Err||pixels||REAL||-999||estimated error inPetrosian radius at 50% light||cmf !SkyChip.xsrc extension  || PETRO_RADIUS_50_ERR||
    … …  
    169168|| '''!StackModelFit''' ||||||||||||||
    170169|| '''ODM attribute''' || '''units''' || '''Data type''' || '''Default''' || '''Description''' || '''IPP source''' || '''IPP variable/notes''' ||
    171 || objID||unknown||BIGINT||0||ODM object identifier|| DVO || same as !StackDetection - see above ||
     170|| objID||dimensionless||BIGINT||0||ODM object identifier|| DVO || same as !StackDetection - see above ||
    172171|| stackDetectID||dimensionless||BIGINT||0||ODM detection identifier|| DVO || same as !StackDetection - see above ||
    173172|| ippObjID||dimensionless||BIGINT||0||IPP object identifier|| DVO || same as !StackDetection - see above ||
    … …  
    180179|| deVRadius||arcsec||REAL||-999||deVaucouleurs radius|| cmf !SkyChip.xfit extension || EXT_WIDTH_MAJ where MODEL_TYPE = PS_MODEL_DEV ||
    181180|| deVRadiusErr||arcsec||REAL||-999||estimated error in deVaucouleurs radius|| NA || empty ||
    182 || ~~~deVMag~~~'''deVFlux'''||~~~unknown~~~ '''adu/sec'''||REAL||-999||deVaucouleurs magntiude||cmf !SkyChip.xfit extension ||EXT_INST_MAG where MODEL_TYPE = PS_MODEL_DEV ||
    183 || ~~~deVMagErr~~~'''deVFluxErr'''||~~~unknown~~~ '''adu/sec'''||REAL||-999||estimated error in deV_mag|| cmf !SkyChip.xfit extension ||EXT_INST_MAG_SIG where MODEL_TYPE = PS_MODEL_DEV ||
     181|| deVFlux||adu/sec||REAL||-999||deVaucouleurs magntiude||cmf !SkyChip.xfit extension ||EXT_INST_MAG where MODEL_TYPE = PS_MODEL_DEV ||
     182|| deVFluxErr||adu/sec||REAL||-999||estimated error in deV_mag|| cmf !SkyChip.xfit extension ||EXT_INST_MAG_SIG where MODEL_TYPE = PS_MODEL_DEV ||
    184183|| deVAb||dimensionless||REAL||-999||deVaucoulerus axis ratio|| cmf !SkyChip.xfit extension || EXT_WIDTH_MAJ/b.EXT_WIDTH_MIN where MODEL_TYPE = PS_MODEL_DEV ||
    185184|| deVAbErr||dimensionless||REAL||-999||estimated error in deVaucoulerus axis ratio|| NA || empty ||
    … …  
    197196|| expRadius||pixels||REAL||-999||Exponential fit radius|| cmf !SkyChip.xfit extension || EXT_WIDTH_MAJ where MODEL_TYPE = PS_MODEL_EXP ||
    198197|| expRadiusErr||pixels||REAL||-999||estimated error in Exponential fit radius|| NA || empty ||
    199 || ~~~expMag~~~'''expFlux'''||~~~unknown~~~ '''adu/s'''||REAL||-999||Exponential fit magntiude|| cmf !SkyChip.xfit extension ||EXT_INST_MAG where MODEL_TYPE = PS_MODEL_EXP ||
    200 || ~~~expMagErr~~~'''expFluxErr'''||~~~unknown~~~ '''adu/s'''||REAL||-999||estimated error in expMag|| cmf !SkyChip.xfit extension ||EXT_INST_MAG_SIG where MODEL_TYPE = PS_MODEL_EXP ||
     198|| expFlux||adu/seconds||REAL||-999||Exponential fit magntiude|| cmf !SkyChip.xfit extension ||EXT_INST_MAG where MODEL_TYPE = PS_MODEL_EXP ||
     199|| expFluxErr||adu/seconds||REAL||-999||estimated error in expMag|| cmf !SkyChip.xfit extension ||EXT_INST_MAG_SIG where MODEL_TYPE = PS_MODEL_EXP ||
    201200|| expAb||dimensionless||REAL||-999||Exponential fit axis ratio|| cmf !SkyChip.xfit extension || EXT_WIDTH_MAJ/b.EXT_WIDTH_MIN where MODEL_TYPE = PS_MODEL_EXP ||
    202201|| expAbErr||dimensionless||REAL||-999||estimated error in Exponential fit axis ratio|| NA || empty ||
    … …  
    214213|| serRadius||pixels||REAL||-999||Sersic radius|| cmf !SkyChip.xfit extension || EXT_WIDTH_MAJ where MODEL_TYPE = PS_MODEL_SERSIC ||
    215214|| serRadiusErr||pixels||REAL||-999||estimated error in Sersic radius|| NA || empty ||
    216 || ~~~serMag~~~'''serFlux'''||~~~unknown~~~ '''adu/s'''||REAL||-999||Sersic magntiude|| cmf !SkyChip.xfit extension ||EXT_INST_MAG where MODEL_TYPE = PS_MODEL_SERSIC ||
    217 || ~~~serMagErr~~~'''serFluxErr'''||~~~unknown~~~ '''adu/s'''||REAL||-999||estimated error in serMag|| cmf !SkyChip.xfit extension ||EXT_INST_MAG_SIG where MODEL_TYPE = PS_MODEL_SERSIC ||
     215|| serFlux||adu/seconds||REAL||-999||Sersic magntiude|| cmf !SkyChip.xfit extension ||EXT_INST_MAG where MODEL_TYPE = PS_MODEL_SERSIC ||
     216|| serFluxErr||adu/seconds||REAL||-999||estimated error in serMag|| cmf !SkyChip.xfit extension ||EXT_INST_MAG_SIG where MODEL_TYPE = PS_MODEL_SERSIC ||
    218217|| serAb||dimensionless||REAL||-999||Sersic axis ratio|| cmf !SkyChip.xfit extension || EXT_WIDTH_MAJ/b.EXT_WIDTH_MIN where MODEL_TYPE = PS_MODEL_SERSIC ||
    219218|| serAbErr||dimensionless||REAL||-999||estimated error in Sersic axis ratio|| cmf !SkyChip.xfit extension ||EXT_INST_MAG_SIG where MODEL_TYPE = PS_MODEL_SERSIC ||
    … …  
    235234|| '''!StackToImage''' ||||||||||||||
    236235|| '''ODM attribute''' || '''units''' || '''Data type''' || '''Default''' || '''Description''' || '''IPP source''' || '''IPP variable/notes''' ||
    237 || stackMetaID||unknown||BIGINT||0||stack identifier|| GPC1 database|| Same as !StackMeta. See above.||
     236|| stackMetaID||dimensionless||BIGINT||0||stack identifier|| GPC1 database|| Same as !StackMeta. See above.||
    238237|| imageID||unknown||BIGINT||0||hashed exposure-ccdID identifier|| GPC1 database || SELECT DISTINCT CONCAT(exp_id, SUBSTR(class_id, 3, 4)) FROM ( SELECT DISTINCT exp_id,class_id FROM warpSkyCellMap ... JOIN-ed using stack_id ||
    239238|| '''!SkinnyObject''' ||||||||||||||
    240239|| '''ODM attribute''' || '''units''' || '''Data type''' || '''Default''' || '''Description''' || '''IPP source''' || '''IPP variable/notes''' ||
    241 || objID||unknown||BIGINT||0||ODM object identifier index|| DVO || same as !StackDetection - see above ||
    242 || ippObjID||unknown||BIGINT||0||IPP object number|| DVO || same as !StackDetection - see above ||
    243 || projectionCellID||unknown||INT||-999||projection cell identifier at discovery time|| NA || same as !StackDetection - see above||
    244 || dataRelease||unknown||TINYINT||0||Data release to propagate to the object|| NA || hardcoded to 1 ||
    245 || surveyID||unknown||TINYINT||255||surveyID </coluumn>|| GPC1 database/DVO|| Same as !StackMeta. See above. ||
     240|| objID||dimensionless||BIGINT||0||ODM object identifier index|| DVO || same as !StackDetection - see above ||
     241|| ippObjID||dimensionless||BIGINT||0||IPP object number|| DVO || same as !StackDetection - see above ||
     242|| projectionCellID||dimensionless||INT||-999||projection cell identifier at discovery time|| NA || same as !StackDetection - see above||
     243|| dataRelease||dimensionless||TINYINT||0||Data release to propagate to the object|| NA || hardcoded to 1 ||
     244|| surveyID||dimensionless||TINYINT||255||surveyID </coluumn>|| GPC1 database/DVO|| Same as !StackMeta. See above. ||
    246245|| '''!ObjectCalColor''' ||||||||||||||
    247246|| '''ODM attribute''' || '''units''' || '''Data type''' || '''Default''' || '''Description''' || '''IPP source''' || '''IPP variable/notes''' ||
    248 || objID||unknown||BIGINT||0||ODM object identifier|| DVO || same as !StackDetection - see above ||
    249 || ippObjID||unknown||BIGINT||0||ipp object identifier|| DVO || same as !StackDetection - see above ||
    250 || filterID||unknown||TINYINT||0||filter identifier|| cmf primary header || Same as !StackMeta. See above. ||
     247|| objID||dimensionless||BIGINT||0||ODM object identifier|| DVO || same as !StackDetection - see above ||
     248|| ippObjID||dimensionless||BIGINT||0||ipp object identifier|| DVO || same as !StackDetection - see above ||
     249|| filterID||dimensionless||TINYINT||0||filter identifier|| cmf primary header || Same as !StackMeta. See above. ||
    251250|| calColor||mag||REAL||0|| color adopted for magnitude calculation||NA || empty ||
    252251|| calColorErr||mag||REAL||0|| error in calibrating color|| NA|| empty ||
    253 || calibModNum||unknown||SMALLINT||0||calibration modification number||NA || empty ||
    254 || dataRelease||unknown||TINYINT||0||Data release when this color calibration was established|| NA || hardcoded to 1 ||
     252|| calibModNum||dimensionless||SMALLINT||0||calibration modification number||NA || empty ||
     253|| dataRelease||dimensionless||TINYINT||0||Data release when this color calibration was established|| NA || hardcoded to 1 ||
    255254|| '''!StackDetectionCalib''' ||||||||||||- previously all done by psps||
    256255|| '''ODM attribute''' || '''units''' || '''Data type''' || '''Default''' || '''Description''' || '''IPP source''' || '''IPP variable/notes''' ||
    257 ||objID         ||||    BIGINT  8 ||    NA  ||  ODM object identifier ||dvo ||  ||
    258 ||stackDetectID         || ||   BIGINT  8 ||    NA ||   ODM detection identifier || dvo ||  ||
    259 ||ippObjID      ||  ||  BIGINT  8 ||    NA ||   IPP object identifier||dvo  ||  ||
    260 ||ippDetectID   || ||   BIGINT  8 ||    NA ||   detection ID generated by IPP|| dvo||  ||
    261 ||filterID      || ||   TINYINT 1||     NA ||   filter identifier|| dvo ||  ||
    262 ||surveyID      || ||   TINYINT 1||     NA ||   survey flag identifier|| dvo||  ||
    263 ||ra    ||degree ||     FLOAT   8 ||    NA ||   Right Ascension||dvo ||  ||
    264 ||dec   ||      ||FLOAT         8 ||    NA ||   No comment||dvo ||  ||
    265 ||raErr ||arcsec||REAL  4 ||    0.0 ||  Right Ascension error|| dvo||  ||
    266 ||decErr ||     ||REAL  4 ||    NA      ||No comment|| dvo||  ||
    267 ||~~~calMag~~~ '''zp''' ||      '''mag''' ||    REAL    4 ||    NA ||   ~~~Observed, calibrated magnitude~~~ zeropoint|| dvo||  ||
    268 ||~~~calMagErr~~~ '''zpErr'''|| '''mag''' ||    REAL    4 ||    0.0 ||  ~~~Error in the observed, calibrated magnitude~~~ zeropoint err|| dvo||  ||
    269 ||~~~calFlux~~~ '''expTime'''|| '''s''' ||      REAL    4 ||    NA      ||~~~Calculated flux~~~ exptime ||dvo ||  ||
    270 ||~~~calFluxErr~~~ '''airMass'''||       ||     REAL    4 ||    0.0     ||~~~Error in the calculated flux~~~ airmass|| dvo||  ||
    271 ||dataRelease ||        ||      TINYINT 1 ||    NA ||   Data release when this detection was processed ||  ||  ||
    272 
    273 
    274 
     256||objID         ||dimensionless||    BIGINT  8 ||    NA  ||  ODM object identifier ||dvo ||  ||
     257||stackDetectID         ||dimensionless ||   BIGINT  8 ||    NA ||   ODM detection identifier || dvo ||  ||
     258||ippObjID      || dimensionless ||  BIGINT  8 ||    NA ||   IPP object identifier||dvo  ||  ||
     259||ippDetectID   ||dimensionless ||   BIGINT  8 ||    NA ||   detection ID generated by IPP|| dvo||  ||
     260||filterID      ||dimensionless ||   TINYINT 1||     NA ||   filter identifier|| dvo ||  ||
     261||surveyID      ||dimensionless ||   TINYINT 1||     NA ||   survey flag identifier|| dvo||  ||
     262||ra    ||degrees ||     FLOAT   8 ||    NA ||   Right Ascension||dvo ||  ||
     263||dec   ||degrees      ||FLOAT         8 ||    NA ||   No comment||dvo ||  ||
     264||raErr ||arcsec||REAL  4 ||    0.0 ||  Right Ascension error|| dvo||  ||
     265||decErr ||arcsec     ||REAL  4 ||    NA      ||No comment|| dvo||  ||
     266||zp ||  magnitude ||    REAL    4 ||    NA ||    zeropoint|| dvo||  ||
     267||zpErr|| magnitude ||    REAL    4 ||    0.0 || zeropoint err|| dvo||  ||
     268||expTime|| seconds ||      REAL    4 ||    NA      || exptime ||dvo ||  ||
     269||airMass|| dimensionless      ||     REAL    4 ||    0.0     || airmass|| dvo||  ||
     270||dataRelease || dimensionless       ||      TINYINT 1 ||    NA ||   Data release when this detection was processed ||  ||  ||
     271
     272
     273