[wiki:ippToPsps Back to ippToPsps main page]

[[PageOutline]]

= Stack batches =

PSPS loads both nightly and deep stacks from the IPP. For deep stacks, two extra tables are produced: !StackApFlx and !StackModelFit. The input for both are IPP cmf files produced at the stack stage of the pipeline. One FITS output is generated by the interface per skycell, per filter.
= PSPS tables = 

1 '''{{{Primary}}}''' extension[[BR]]
1 '''{{{StackMeta}}}''' extension per skycell[[BR]]
1 '''{{{StackDetection}}}''' extension per skycell[[BR]]
1 '''{{{StackToImage}}}''' extension[[BR]]
1 '''{{{SkinnyObject}}}''' extension[[BR]]
1 '''{{{ObjectCalColor}}}''' extension[[BR]]

Deep stacks have two extra extensions.

1 '''{{{StackApFlx}}}''' extension per skycell[[BR]]
1 '''{{{StackModelFit}}}''' extension per skycell[[BR]]

The full table definitions can be seen [browser:trunk/ippToPsps/config/ST/tables.vot here]

= Current IPP to PSPS mappings =

The tables below detail the current mapping between IPP and PSPS. The source of cmf files queued by ippToPsps is a list of sky_ids that are loaded into the relevant DVO database. These sky_ids are then used to obtain metadata from the IPP GPC1 database, as well as the location of the cmf file themselves.  For more information on the fields listed below, see also the following links:

 * [http://ipp0222.ifa.hawaii.edu/ippData/manuals/psphot.pdf draft psphot manual]
 * [wiki:psphotStack description of psphotStack]
 * [http://svn.pan-starrs.ifa.hawaii.edu/trac/ipp/wiki/DVO_TopLevel DVO description (see section Schema for table layouts)]

|| '''!StackMeta''' ||||||||||||||
|| '''ODM attribute''' || '''units''' || '''Data type''' || '''Default''' || '''Description''' || '''IPP source''' || '''IPP variable/notes''' ||
|| stackMetaID||dimensionless||BIGINT||0||stack identifier|| GPC1 database || stackRun.stack_id using sky_id and filter via staticskyInput, staticskyRun, and staticskyResult tables. ||
|| 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  ||
|| 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] ||
|| photoCalID||dimensionless||INT||0||photometry code numerical id|| DVO ||image->photcode from Image structure ||
|| 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] ||
|| 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]||
|| magSat||dimensionless||REAL||-999||saturation magnitude level|| cmf primary header || FSATUR (not set?) ||
|| analVer||dimensionless||SMALLINT||-999||analysis version index|| NA || empty CZW: header PHOT_V||
|| expTime||seconds||REAL||-999|| exposure time|| cmf primary header || EXPTIME ||
|| nP2Images||unknown||SMALLINT||-999||number of P2 images contributing to this cell||GPC1 ||a count of images listed in the !StackToImage table - see below ||
|| 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? ||
|| astroScat||unknown||REAL||-999||astrometric scatter for chip|| NA || empty ||
|| photoScat||unknown||REAL||-999||photometric scatter for chip|| NA || empty ||
|| nAstroRef||unknown||INT||-999||number of astrometric reference sources|| NA || empty ||
|| nPhoRef||unknown||INT||-999||number of photometric reference sources|| NA || empty ||
|| psfModelID||unknown||VARCHAR(MAX)|| ||PSF model identifier|| cmf primary header || PSFMODEL ||
|| psfFwhm_mean||unknown||FLOAT||-999||mean PSF FWHM in the stack|| cmf primary header || FWHM_MAJ||
|| psfFwhm_max||unknown||FLOAT||-999||maximum PSF FWHM in the stack|| cmf primary header || FW_MJ_UQ||
|| photoZero||unknown||REAL||-999||local derived photometric zero point|| cmf primary header ||FPA.ZP  ||
|| photoColor||unknown||REAL||-999||local derived photometric color term|| NA || empty ||
|| ctype1||dimensionsless||VARCHAR(MAX)|| ||name of astrometric projection in RA|| cmf primary header ||CTYPE1 ||
|| ctype2||dimensionsless||VARCHAR(MAX)|| ||name of astrometric projection in DEC|| cmf primary header|| CTYPE2||
|| crval1||dimensionsless||FLOAT||-999||RA corresponding to reference pixel|| cmf primary header|| CRVAL1||
|| crval2||dimensionsless||FLOAT||-999||DEC corresponding to reference pixel|| cmf primary header|| CRVAL2||
|| crpix1||dimensionsless||FLOAT||-999||reference pixel value for RA|| cmf primary header|| CRPIX1||
|| crpix2||dimensionsless||FLOAT||-999||reference pixel value for DEC|| cmf primary header||CRPIX2 ||
|| cdelt1||dimensionsless||FLOAT||-999||scale factor for RA|| cmf primary header||CDELT1 ||
|| cdelt2||dimensionsless||FLOAT||-999||scale factor for DEC|| cmf primary header|| CDELT2||
|| pc001001||dimensionsless||FLOAT||-999||elements of rotation/Dcale matrix||cmf primary header || PC001001||
|| pc001002||dimensionsless||FLOAT||-999||elements of rotation/Dcale matrix|| cmf primary header|| PC001002||
|| pc002001||dimensionsless||FLOAT||-999||elements of rotation/Dcale matrix|| cmf primary header|| PC002001||
|| pc002002||dimensionsless||FLOAT||-999||elements of rotation/Dcale matrix|| cmf primary header|| PC002002||
|| calibModNum||dimensionsless||SMALLINT||0||calibration modification number|| NA || empty ||
|| batchID||dimensionsless||INT32||0||batchID|| NA || empty ||
|| dataRelease||dimensionsless||TINYINT||0||Data release|| NA || hardcoded to 1 ||
|| '''!StackDetection''' ||||||||||||||
|| '''ODM attribute''' || '''units''' || '''Data type''' || '''Default''' || '''Description''' || '''IPP source''' || '''IPP variable/notes''' ||
|| objID||dimensionless||BIGINT||0||ODM object identifier||DVO ||ave.extID from dvoDetection structure ||
|| stackDetectID||dimensionless||BIGINT||0||ODM detection identifier|| DVO ||(10 * DVO meas.extID) + filterID ||
|| ippObjID||dimensionless||BIGINT||0||IPP object identifier||DVO || ave.catID*1000000000 + ave.objID from dvoDetection structure ||
|| ippDetectID||dimensionless||BIGINT||0||detection ID generated by IPP|| cmf !SkyChip.psf table ||IPP_IDET ||
|| filterID||dimensionless||TINYINT||0||filter identifier||cmf primary header || Same as !StackMeta. See above. ||
|| stackTypeID||dimensionless||TINYINT||0||stack type identifier|| DVO|| Same as !StackMeta. See above. ||
|| surveyID||dimensionless||TINYINT||0||survey flag identifier|| GPC1 database/DVO|| Same as !StackMeta. See above. ||
|| primaryF||dimensionless||TINYINT||255||identifies best stack detection for Stacks overlapping the same region of the sky.|| NA || hardcoded to 0 ||
|| stackMetaID||dimensionless||BIGINT||0||stack identifier|| GPC1 database|| Same as !StackMeta. See above.||
|| skyCellID||dimensionless||INT||-999||skycell identifier|| GPC1 database|| Same as !StackMeta. See above.||
|| projectionCellID||dimensionless||INT||-999||projection cell identifier|| NA || from, eg skycell.1133.081, use 1133 ||
|| xPos||pixels||REAL||-999||measured x on '''skycell''' from PSF fit - '''warped pixels = 0.25 arcsec'''|| cmf !SkyChip.psf table||X_PSF ||
|| yPos||pixels||REAL||-999||measured y on '''skycell''' from PSF fit|| cmf !SkyChip.psf table||Y_PSF ||
|| xPosErr||pixels||REAL||-999||estimated error in x|| cmf !SkyChip.psf table||X_PSF_SIG ||
|| yPosErr||pixels||REAL||-999||estimated error in y||cmf !SkyChip.psf table ||Y_PSF_SIG ||
|| 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) ||
|| 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)||
|| 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)||
|| sky||adu/sec/pixel ||REAL||-999||PSF sky level at source (adu)|| cmf !SkyChip.psf table||SKY ||
|| skyErr|| adu/sec/pixel ||REAL||-999||estimated error in sky||cmf !SkyChip.psf table ||SKY_SIGMA ||
|| sgSep||dimensionless||REAL||-999||star/galaxy separator||cmf !SkyChip.psf table ||~~~EXT_NSIGMA~~~ '''TBD''' ||
|| psfWidMajor||pixels||REAL||-999||PSF width in major axis||cmf !SkyChip.psf table || PSF_MAJOR||
|| psfWidMinor||pixels||REAL||-999||PSF width in minor axis||cmf !SkyChip.psf table ||PSF_MINOR ||
|| psfTheta||degrees East of North||REAL||-999||PSF orientation angle||cmf !SkyChip.psf table ||PSF_THETA ||
|| 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))'''||
|| psfQf||dimensionless||REAL||-999||PSF coverage factor|| cmf !SkyChip.psf table||PSF_QF ||
|| psfQfPerfect ||dimensionless ||REAL ||-999|| PSF QF Perfect || cmf !SkyChip.psf table || PSF_QF_PERFECT ||
|| momentXX||pixels||REAL||-999|| moment XX||cmf !SkyChip.psf table ||MOMENTS_XX ||
|| momentXY||pixels||REAL||-999|| moment XY|| cmf !SkyChip.psf table||MOMENTS_XY ||
|| momentYY||pixels||REAL||-999|| moment YY||cmf !SkyChip.psf table || MOMENTS_YY||
|| momentM3C||pixels squared||REAL||-999|| moment M3C||cmf !SkyChip.psf table || MOMENTS_M3C||
|| momentM3S||pixels squared||REAL||-999|| moment M3S||cmf !SkyChip.psf table || MOMENTS_M3S||
|| momentM4C||pixels squared||REAL||-999|| moment M4C||cmf !SkyChip.psf table ||MOMENTS_M4C ||
|| momentM4S||pixels squared||REAL||-999|| moment M4S||cmf !SkyChip.psf table ||MOMENTS_M4S ||
|| momentR1||pixels||REAL||-999|| moment R1|| cmf !SkyChip.psf table|| MOMENTS_R1||
|| momentRH||sqrt pixels||REAL||-999|| moment RH||cmf !SkyChip.psf table || MOMENTS_RH||
|| apFlux||adu/sec||REAL||-999|| Aperture magnitude||cmf !SkyChip.psf table || AP_MAG converted to flux||
|| apFluxErr||adu/sec||REAL||-999|| Aperture magnitude error|| NA || empty ||
|| kronFlux||adu/sec||REAL||-999|| Kron flux||cmf !SkyChip.psf table ||KRON_FLUX / expTime ||
|| kronFluxErr|| adu/sec||REAL||-999|| Kron flux error||cmf !SkyChip.psf table ||KRON_FLUX_ERR / expTime  ||
|| 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||
|| psfChiSq||~~~arcsecs~~~||REAL||-999|| ~~~Kron radius error~~~||from cmf !SkyChip.psf table || ~~~empty~~~ psf_chisq||
|| 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   ||
|| nFrames||dimensionless||INT||-999||number of frames contributing to source||cmf !SkyChip.psf table ||N_FRAMES ||
|| activeFlag||dimensionless||TINYINT||-999||indicates whether this detection/orphan is still a detection/orphan|| NA || hardcoded to 0||
|| assocDate||Mean Julian Days||DATE||28881231||date object association assigned|| NA || date that batch has been prepared ||
|| historyModNum||dimensionless||SMALLINT||0||modification number in the O-D association history||NA || hardcoded to 0||
|| dataRelease||Mean Julian Days||TINYINT||0||Date release when this detection was originally taken.||NA || hardcoded to 1 ||
|| '''!StackApFlx''' ||||||||||||||
|| '''ODM attribute''' || '''units''' || '''Data type''' || '''Default''' || '''Description''' || '''IPP source''' || '''IPP variable/notes''' ||
|| objID||dimensionless ||BIGINT||0||ODM object identifier||DVO || same as !StackDetection - see above ||
|| stackDetectID||dimensionsless||BIGINT||0||ODM detection identifier|| DVO || same as !StackDetection - see above ||
|| ippObjID||dimensionsless||BIGINT||0||IPP object identifier|| DVO || same as !StackDetection - see above ||
|| ippDetectID||dimensionsless||BIGINT||0||detection ID generated by IPP|| cmf !SkyChip.xrad extension ||IPP_IDET ||
|| filterID||dimensionsless||TINYINT||0||filter identifier|| cmf primary header || Same as !StackMeta. See above. ||
|| stackTypeID||dimensionsless||TINYINT||0||stack type identifier|| DVO|| Same as !StackMeta. See above. ||
|| surveyID||dimensionsless||TINYINT||0||survey flag identifier|| GPC1 database/DVO|| Same as !StackMeta. See above. ||
|| primaryF||unknown||TINYINT||255||identifies best stack detection for Stacks overlapping the same region of the sky.|| NA || hardcoded to 0 ||
|| stackMetaID||unknown||BIGINT||0||stack identifier|| GPC1 database|| Same as !StackMeta. See above.||
|| isophotFlux||adu/sec||REAL||-999||isophotal magnitude|| NA || empty ||
|| isophotFluxErr||adu/sec||REAL||-999||estimated error in isophotal magnitude||  NA || empty ||
|| isophotMajAxis||pixels||REAL||-999||isophotal Major Axis||  NA || empty ||
|| isophotMajAxisErr||pixels||REAL||-999||estimated error in isophotal Major Axis||  NA || empty ||
|| isophotMinAxis||pixels||REAL||-999||isophotal Minor Axis||  NA || empty ||
|| isophotMinAxisErr||pixels||REAL||-999||estimated error in isophotal Minor Axis||  NA || empty ||
|| isophotMajAxisGrad||pixels||REAL||-999||isophotal major axis gradient||  NA || empty ||
|| isophotMinAxisGrad||pixels||REAL||-999||isophotal minor axis gradient||  NA || empty ||
|| isophotPA||degrees East of North||REAL||-999||isophotal position angle||  NA || empty ||
|| isophotPAErr||degrees||REAL||-999||estimated error in isophotal position angle||  NA || empty ||
|| isophotPAGrad||dimensionless||REAL||-999||isophotal position angle gradient||  NA || empty ||
|| petRadius||pixels||REAL||-999||Petrosian radius|| cmf !SkyChip.xsrc extension || PETRO_RADIUS ||
|| petRadiusErr||pixels||REAL||-999||estimated error inPetrosian radius||cmf !SkyChip.xsrc extension  ||PETRO_RADIUS_ERR ||
|| petFlux||adu/sec||REAL||-999||Petrosian magntiude||cmf !SkyChip.xsrc extension  || PETRO_MAG||
|| petFluxErr||adu/sec||REAL||-999||estimated error in petMag||cmf !SkyChip.xsrc extension  ||PETRO_MAG_ERR ||
|| petR50||pixels||REAL||-999||Petrosian radius at 50% light||cmf !SkyChip.xsrc extension  || PETRO_RADIUS_50||
|| petR50Err||pixels||REAL||-999||estimated error inPetrosian radius at 50% light||cmf !SkyChip.xsrc extension  || PETRO_RADIUS_50_ERR||
|| petR90||pixels||REAL||-999||Petrosian radius at 90% light||cmf !SkyChip.xsrc extension  || PETRO_RADIUS_90||
|| petR90Err||pixels||REAL||-999||estimated error in Petrosian radius at 90% light||cmf !SkyChip.xsrc extension  ||PETRO_RADIUS_90_ERR ||
|| petCf||dimensionless||REAL||-999||Petrosian fit coverage factor|| cmf !SkyChip.xsrc extension || PETRO_FILL||
|| flxR1||adu/sec||REAL||-999||Flux inside r = 1||  cmf !SkyChip.xrad extension || APER_FLUX_1 where PSF_FWHM IS NULL||
|| flxR1Err||adu/sec||REAL||-999||estimated error is flxR1|| cmf !SkyChip.xrad extension ||APER_FLUX_ERR_1 where PSF_FWHM IS NULL ||
|| flxR1Std||adu/sec||REAL||-999||estimated standard deviation in flxR1|| cmf !SkyChip.xrad extension || APER_FLUX_STDEV_1 where PSF_FWHM IS NULL||
|| flxR1Fill||dimensionless||REAL||-999||estimated filling factor at R1|| cmf !SkyChip.xrad extension || APER_FILL_1 where PSF_FWHM IS NULL ||
|| repeat for R=2 -> 10 ||||||||||||||
|| c1flxR1||unknown||REAL||-999||Flux inside r = 1|| cmf !SkyChip.xrad extension || APER_FLUX_1 where PSF_FWHM < 7.0||
|| c1flxR1Err||unknown||REAL||-999||estimated error is c1flxR1||cmf !SkyChip.xrad extension ||APER_FLUX_ERR_1 where PSF_FWHM < 7.0||
|| c1flxR1Std||unknown||REAL||-999||estimated standard deviation in c1flxR1||cmf !SkyChip.xrad extension || APER_FLUX_STDEV_1 where PSF_FWHM < 7.0||
|| c1flxR1Fill||unknown||REAL||-999||estimated filling factor at R1||cmf !SkyChip.xrad extension || APER_FILL_1 where PSF_FWHM < 7.0||
|| repeat for R=2 -> 10 ||||||||||||||
|| c2flxR1||unknown||REAL||-999||Flux inside r = 1||cmf !SkyChip.xrad extension ||APER_FLUX_1 where PSF_FWHM > 7.0||
|| c2flxR1Err||unknown||REAL||-999||estimated error is c2flxR1||cmf !SkyChip.xrad extension || APER_FLUX_ERR_1 where PSF_FWHM > 7.0||
|| c2flxR1Std||unknown||REAL||-999||estimated standard deviation in c2flxR1||cmf !SkyChip.xrad extension ||APER_FLUX_STDEV_1 where PSF_FWHM > 7.0 ||
|| c2flxR1Fill||unknown||REAL||-999||estimated filling factor at R1||cmf !SkyChip.xrad extension || APER_FILL_1 where PSF_FWHM > 7.0 ||
|| repeat for R=2 -> 10 ||||||||||||||
|| logC||dimensionless||REAL||-999||Abraham concentration index|| NA || empty ||
|| logA||dimensionless||REAL||-999||Abraham asymmetry index|| NA || empty ||
|| activeFlag||dimensionless||TINYINT||-999||indicates whether this detection/orphan is still a detection/orphan|| NA || hardcoded to 0||
|| dataRelease||dimensionless||TINYINT||0||Data release when this detection was taken|| NA ||hardcoded to 1 ||
|| '''!StackModelFit''' ||||||||||||||
|| '''ODM attribute''' || '''units''' || '''Data type''' || '''Default''' || '''Description''' || '''IPP source''' || '''IPP variable/notes''' ||
|| objID||dimensionless||BIGINT||0||ODM object identifier|| DVO || same as !StackDetection - see above ||
|| stackDetectID||dimensionless||BIGINT||0||ODM detection identifier|| DVO || same as !StackDetection - see above ||
|| ippObjID||dimensionless||BIGINT||0||IPP object identifier|| DVO || same as !StackDetection - see above ||
|| ippDetectID||dimensionless||BIGINT||0||detection ID generated by IPP|| from !SkyChip.xfit extension || IPP_IDET ||
|| filterID||dimensionless||TINYINT||0||filter identifier|| cmf primary header || Same as !StackMeta. See above. ||
|| stackTypeID||dimensionless||TINYINT||0||stack type identifier|| DVO|| Same as !StackMeta. See above. ||
|| surveyID||dimensionless||TINYINT||0||survey flag identifier|| GPC1 database/DVO|| Same as !StackMeta. See above. ||
|| primaryF||dimensionless||TINYINT||255||identifies best stack detection for Stacks overlapping the same region of the sky.|| NA || hardcoded to 0 ||
|| stackMetaID||dimensionless||BIGINT||0||stack identifier|| GPC1 database|| Same as !StackMeta. See above.||
|| deVRadius||arcsec||REAL||-999||deVaucouleurs radius|| cmf !SkyChip.xfit extension || EXT_WIDTH_MAJ where MODEL_TYPE = PS_MODEL_DEV ||
|| deVRadiusErr||arcsec||REAL||-999||estimated error in deVaucouleurs radius|| NA || empty ||
|| deVFlux||adu/sec||REAL||-999||deVaucouleurs magntiude||cmf !SkyChip.xfit extension ||EXT_INST_MAG where MODEL_TYPE = PS_MODEL_DEV ||
|| deVFluxErr||adu/sec||REAL||-999||estimated error in deV_mag|| cmf !SkyChip.xfit extension ||EXT_INST_MAG_SIG where MODEL_TYPE = PS_MODEL_DEV ||
|| deVAb||dimensionless||REAL||-999||deVaucoulerus axis ratio|| cmf !SkyChip.xfit extension || EXT_WIDTH_MAJ/b.EXT_WIDTH_MIN where MODEL_TYPE = PS_MODEL_DEV ||
|| deVAbErr||dimensionless||REAL||-999||estimated error in deVaucoulerus axis ratio|| NA || empty ||
|| deVPhi||degrees East of North||REAL||-999||estmated phi of deVaucouleurs axis||cmf !SkyChip.xfit extension || EXT_THETA where MODEL_TYPE = PS_MODEL_DEV ||
|| deVPhiErr||degrees||REAL||-999||estmated error of phi of deVaucouleurs axis|| NA || empty ||
|| raDeVOff||pixels||REAL||-999||Offset in RA of deVaucouleurs fit from PSF RA|| NA || empty CZW: can be calculatd from X_PSF-X_EXT and Y_PSF-Y_EXT||
|| decDeVOff||pixels||REAL||-999||Offset in DEC of deVaucouleurs fit from PSF DEC|| NA || empty CZW: can be calculatd from X_PSF-X_EXT and Y_PSF-Y_EXT||
|| raDeVOffErr||arcsec||REAL||-999||estimated error in ra offset|| NA || empty ||
|| decDeVOffErr||arcsec||REAL||-999||estimated error in dec offset|| NA || empty ||
|| deVCf||dimensionless||REAL||-999||deVaucouleurs fit coverage factor|| NA || empty ||
|| deVLikelihood||dimensionless||REAL||-999||deVaucouleurs fit likelihood factor|| NA || empty ||
|| deVCovar11||dimensionless||REAL||-999||covariance for deVaucouleurs fit||cmf !SkyChip.xfit extension ||EXT_COVAR_00_00 where MODEL_TYPE = PS_MODEL_DEV ||
|| deVCovar12||dimensionless||REAL||-999||covariance for deVaucouleurs fit|| cmf !SkyChip.xfit extension ||EXT_COVAR_00_01 where MODEL_TYPE = PS_MODEL_DEV ||
|| repeat until deVCovar77 and EXT_COVAR_06_06 ||||||||||||||
|| expRadius||pixels||REAL||-999||Exponential fit radius|| cmf !SkyChip.xfit extension || EXT_WIDTH_MAJ where MODEL_TYPE = PS_MODEL_EXP ||
|| expRadiusErr||pixels||REAL||-999||estimated error in Exponential fit radius|| NA || empty ||
|| expFlux||adu/seconds||REAL||-999||Exponential fit magntiude|| cmf !SkyChip.xfit extension ||EXT_INST_MAG where MODEL_TYPE = PS_MODEL_EXP ||
|| expFluxErr||adu/seconds||REAL||-999||estimated error in expMag|| cmf !SkyChip.xfit extension ||EXT_INST_MAG_SIG where MODEL_TYPE = PS_MODEL_EXP ||
|| 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 ||
|| expAbErr||dimensionless||REAL||-999||estimated error in Exponential fit axis ratio|| NA || empty ||
|| expPhi||degrees||REAL||-999||estmated phi of Exponential axis||cmf !SkyChip.xfit extension || EXT_THETA where MODEL_TYPE = PS_MODEL_EXP ||
|| expPhiErr||degrees||REAL||-999||estmated error of phi of Exponential axis|| NA || empty ||
|| raExpOff||arcsec||REAL||-999||Offset in RA of Exponential fit from PSF RA|| NA || empty CZW: can be calculatd from X_PSF-X_EXT and Y_PSF-Y_EXT||
|| decExpOff||arcsec||REAL||-999||Offset in DEC of Exponential fit from PSF DEC|| NA || empty CZW: can be calculatd from X_PSF-X_EXT and Y_PSF-Y_EXT||
|| raExpOffErr||arcsec||REAL||-999||estimated error in raExpOff|| NA || empty ||
|| decExpOffErr||arcsec||REAL||-999||estimated error in decExpOff|| NA || empty ||
|| expCf||dimensionless||REAL||-999||Exponential fit coverage factor|| NA || empty ||
|| expLikelihood||dimensionless||REAL||-999||Exponential fit likelihood factor|| NA || empty ||
|| expCovar11||dimensionless||REAL||-999||covariance for Exponential fit|| cmf !SkyChip.xfit extension ||EXT_COVAR_00_00 where MODEL_TYPE = PS_MODEL_EXP ||
|| expCovar12||dimensionless||REAL||-999||covariance for Exponential fit|| cmf !SkyChip.xfit extension ||EXT_COVAR_00_01 where MODEL_TYPE = PS_MODEL_EXP ||
|| repeat until expCovar77 and EXT_COVAR_06_06 ||||||||||||||
|| serRadius||pixels||REAL||-999||Sersic radius|| cmf !SkyChip.xfit extension || EXT_WIDTH_MAJ where MODEL_TYPE = PS_MODEL_SERSIC ||
|| serRadiusErr||pixels||REAL||-999||estimated error in Sersic radius|| NA || empty ||
|| serFlux||adu/seconds||REAL||-999||Sersic magntiude|| cmf !SkyChip.xfit extension ||EXT_INST_MAG where MODEL_TYPE = PS_MODEL_SERSIC ||
|| serFluxErr||adu/seconds||REAL||-999||estimated error in serMag|| cmf !SkyChip.xfit extension ||EXT_INST_MAG_SIG where MODEL_TYPE = PS_MODEL_SERSIC ||
|| serAb||dimensionless||REAL||-999||Sersic axis ratio|| cmf !SkyChip.xfit extension || EXT_WIDTH_MAJ/b.EXT_WIDTH_MIN where MODEL_TYPE = PS_MODEL_SERSIC ||
|| serAbErr||dimensionless||REAL||-999||estimated error in Sersic axis ratio|| cmf !SkyChip.xfit extension ||EXT_INST_MAG_SIG where MODEL_TYPE = PS_MODEL_SERSIC ||
|| serNu||dimensionless||REAL||-999||Sersic index|| cmf !SkyChip.xfit extension ||EXT_PAR_07 where MODEL_TYPE = PS_MODEL_SERSIC ||
|| serNuErr||dimensionless||REAL||-999||estimated error in Sersic index|| cmf !SkyChip.xfit extension || SQRT(EXT_COVAR_07_07) where MODEL_TYPE = PS_MODEL_SERSIC  ||
|| serPhi||degrees||REAL||-999||estmated phi of Sersic axis|| cmf !SkyChip.xfit extension || EXT_THETA where MODEL_TYPE = PS_MODEL_SERSIC ||
|| serPhiErr||degrees||REAL||-999||estmated error of phi of Sersic axis||  NA || empty ||
|| raSerOff||arcsed||REAL||-999||Offset in RA of Sersic fit from PSF RA||  NA || empty CZW: can be calculatd from X_PSF-X_EXT and Y_PSF-Y_EXT||
|| decSerOff||arcsec||REAL||-999||Offset in DEC of Sersic fit from PSF DEC||  NA || empty CZW: can be calculatd from X_PSF-X_EXT and Y_PSF-Y_EXT||
|| raSerOffErr||arcsec||REAL||-999||estimated error in raSerOff||  NA || empty ||
|| decSerOffErr||arcsec||REAL||-999||estimated error in decSerOff||  NA || empty ||
|| serCf||unknown||dimensionless -ditto||-999||Sersic fit coverage factor||  NA || empty ||
|| serLikelihood||unknown||REAL||-999||Sersic fit likelihood factor||  NA || empty ||
|| sersicCovar11||unknown||REAL||-999||covariance for Sersic fit|| cmf !SkyChip.xfit extension ||EXT_COVAR_00_00 where MODEL_TYPE = PS_MODEL_SERSIC ||
|| sersicCovar12||unknown||REAL||-999||covariance for Sersic fit|| cmf !SkyChip.xfit extension ||EXT_COVAR_00_01 where MODEL_TYPE = PS_MODEL_SERSIC ||
|| repeat until sersicCovar88 and EXT_COVAR_07_07 ||||||||||||||
|| activeFlag||unknown||TINYINT||-999||indicates whether this detection/orphan is still a detection/orphan|| NA || hardcoded to 0 ||
|| dataRelease||unknown||TINYINT||0||Data release when this detection was taken|| NA || hardcoded to 1 ||
|| '''!StackToImage''' ||||||||||||||
|| '''ODM attribute''' || '''units''' || '''Data type''' || '''Default''' || '''Description''' || '''IPP source''' || '''IPP variable/notes''' ||
|| stackMetaID||dimensionless||BIGINT||0||stack identifier|| GPC1 database|| Same as !StackMeta. See above.||
|| 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 ||
|| '''!SkinnyObject''' ||||||||||||||
|| '''ODM attribute''' || '''units''' || '''Data type''' || '''Default''' || '''Description''' || '''IPP source''' || '''IPP variable/notes''' ||
|| objID||dimensionless||BIGINT||0||ODM object identifier index|| DVO || same as !StackDetection - see above ||
|| ippObjID||dimensionless||BIGINT||0||IPP object number|| DVO || same as !StackDetection - see above ||
|| projectionCellID||dimensionless||INT||-999||projection cell identifier at discovery time|| NA || same as !StackDetection - see above||
|| dataRelease||dimensionless||TINYINT||0||Data release to propagate to the object|| NA || hardcoded to 1 ||
|| surveyID||dimensionless||TINYINT||255||surveyID </coluumn>|| GPC1 database/DVO|| Same as !StackMeta. See above. ||
|| '''!ObjectCalColor''' ||||||||||||||
|| '''ODM attribute''' || '''units''' || '''Data type''' || '''Default''' || '''Description''' || '''IPP source''' || '''IPP variable/notes''' ||
|| objID||dimensionless||BIGINT||0||ODM object identifier|| DVO || same as !StackDetection - see above ||
|| ippObjID||dimensionless||BIGINT||0||ipp object identifier|| DVO || same as !StackDetection - see above ||
|| filterID||dimensionless||TINYINT||0||filter identifier|| cmf primary header || Same as !StackMeta. See above. ||
|| calColor||mag||REAL||0|| color adopted for magnitude calculation||NA || empty ||
|| calColorErr||mag||REAL||0|| error in calibrating color|| NA|| empty ||
|| calibModNum||dimensionless||SMALLINT||0||calibration modification number||NA || empty ||
|| dataRelease||dimensionless||TINYINT||0||Data release when this color calibration was established|| NA || hardcoded to 1 ||
|| '''!StackDetectionCalib''' ||||||||||||- previously all done by psps||
|| '''ODM attribute''' || '''units''' || '''Data type''' || '''Default''' || '''Description''' || '''IPP source''' || '''IPP variable/notes''' ||
||objID         ||dimensionless||    BIGINT  8 ||    NA  ||  ODM object identifier ||dvo ||  || 
||stackDetectID         ||dimensionless ||   BIGINT  8 ||    NA ||   ODM detection identifier || dvo ||  || 
||ippObjID      || dimensionless ||  BIGINT  8 ||    NA ||   IPP object identifier||dvo  ||  || 
||ippDetectID   ||dimensionless ||   BIGINT  8 ||    NA ||   detection ID generated by IPP|| dvo||  || 
||filterID      ||dimensionless ||   TINYINT 1||     NA ||   filter identifier|| dvo ||  || 
||surveyID      ||dimensionless ||   TINYINT 1||     NA ||   survey flag identifier|| dvo||  || 
||ra    ||degrees ||     FLOAT   8 ||    NA ||   Right Ascension||dvo ||  || 
||dec   ||degrees      ||FLOAT         8 ||    NA ||   No comment||dvo ||  || 
||raErr ||arcsec||REAL  4 ||    0.0 ||  Right Ascension error|| dvo||  || 
||decErr ||arcsec     ||REAL  4 ||    NA      ||No comment|| dvo||  || 
||zp ||  magnitude ||    REAL    4 ||    NA ||    zeropoint|| dvo||  || 
||zpErr|| magnitude ||    REAL    4 ||    0.0 ||  zeropoint err|| dvo||  || 
||expTime|| seconds ||      REAL    4 ||    NA      || exptime ||dvo ||  || 
||airMass|| dimensionless      ||     REAL    4 ||    0.0     || airmass|| dvo||  || 
||dataRelease || dimensionless       ||      TINYINT 1 ||    NA ||   Data release when this detection was processed ||  ||  ||