| Version 28 (modified by , 15 years ago) ( diff ) |
|---|
Outline
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
1 StackMeta extension per skycell
1 StackDetection extension per skycell
1 StackToImage extension
1 SkinnyObject extension
1 ObjectCalColor extension
Deep stacks have two extra extensions.
1 StackApFlx extension per skycell
1 StackModelFit extension per skycell
The full table definitions can be seen here
Current IPP to PSPS mappings
The following table details 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.
| StackMeta | ||||||
| ODM attribute | units | Data type | Default | Description | IPP source | IPP variable/notes |
| stackMetaID | unknown | BIGINT | 0 | stack identifier | GPC1 database | stackRun.stack_id using sky_id and filter via staticskyInput, staticskyRun, and staticskyResult tables |
| skycellID | unknown | INT | 0 | skycell region identifier | GPC1 database | stackRun.skycell_id using sky_id and filter via staticskyInput, staticskyRun, and staticskyResult tables |
| 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 here |
| photoCalID | unknown | INT | 0 | photometry code numerical id | DVO | image->photcode from Image structure |
| 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 here |
| 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 here |
| magSat | unknown | REAL | -999 | saturation magnitude level | NA | empty |
| analVer | unknown | SMALLINT | -999 | analysis version index | NA | empty |
| 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 |
| 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 | NA | empty |
| 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 | NA | empty |
| psfFwhm_max | unknown | FLOAT | -999 | maximum PSF FWHM in the stack | NA | empty |
| 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 | unknown | VARCHAR(MAX) | name of astrometric projection in RA | cmf primary header | CTYPE1 | |
| ctype2 | unknown | VARCHAR(MAX) | name of astrometric projection in DEC | cmf primary header | CTYPE2 | |
| crval1 | unknown | FLOAT | -999 | RA corresponding to reference pixel | cmf primary header | CRVAL1 |
| crval2 | unknown | FLOAT | -999 | DEC corresponding to reference pixel | cmf primary header | CRVAL2 |
| crpix1 | unknown | FLOAT | -999 | reference pixel value for RA | cmf primary header | CRPIX1 |
| crpix2 | unknown | FLOAT | -999 | reference pixel value for DEC | cmf primary header | CRPIX2 |
| cdelt1 | unknown | FLOAT | -999 | scale factor for RA | cmf primary header | CDELT1 |
| cdelt2 | unknown | FLOAT | -999 | scale factor for DEC | cmf primary header | CDELT2 |
| pc001001 | unknown | FLOAT | -999 | elements of rotation/Dcale matrix | cmf primary header | PC001001 |
| pc001002 | unknown | FLOAT | -999 | elements of rotation/Dcale matrix | cmf primary header | PC001002 |
| pc002001 | unknown | FLOAT | -999 | elements of rotation/Dcale matrix | cmf primary header | PC002001 |
| pc002002 | unknown | FLOAT | -999 | elements of rotation/Dcale matrix | cmf primary header | PC002002 |
| calibModNum | unknown | SMALLINT | 0 | calibration modification number | NA | empty |
| dataRelease | unknown | TINYINT | 0 | Data release | NA | hardcoded to 1 |
| StackDetection | ||||||
| ODM attribute | units | Data type | Default | Description | IPP source | IPP variable/notes |
| objID | unknown | BIGINT | 0 | ODM object identifier | DVO | ave.extID from dvoDetection structure |
| stackDetectID | unknown | BIGINT | 0 | ODM detection identifier | DVO | meas.extID from dvoDetection structure |
| ippObjID | unknown | BIGINT | 0 | IPP object identifier | DVO | ave.catID*1000000000 + ave.objID from dvoDetection structure |
| ippDetectID | unknown | BIGINT | 0 | detection ID generated by IPP | cmf SkyChip.psf table | IPP_IDET |
| filterID | unknown | TINYINT | 0 | filter identifier | cmf primary header | Same as StackMeta. See above. |
| stackTypeID | unknown | TINYINT | 0 | stack type identifier | DVO | Same as StackMeta. See above. |
| surveyID | unknown | 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. |
| skyCellID | unknown | INT | -999 | skycell identifier | GPC1 database | Same as StackMeta. See above. |
| projectionCellID | unknown | INT | -999 | projection cell identifier | NA | empty |
| obsTime | day | FLOAT | -999 | Time of mid observation | cmf primary header | MJD-OBS |
| xPos | unknown | REAL | -999 | measured x on CCD from PSF fit | cmf SkyChip.psf table | X_PSF |
| yPos | unknown | REAL | -999 | measured y on CCD from PSF fit | cmf SkyChip.psf table | Y_PSF |
| xPosErr | unknown | REAL | -999 | estimated error in x | cmf SkyChip.psf table | X_PSF_SIG |
| yPosErr | unknown | REAL | -999 | estimated error in y | cmf SkyChip.psf table | Y_PSF_SIG |
| instFlux | unknown | REAL | -999 | PSF instrumental flux | cmf SkyChip.psf table and GPC1 | POW(10.0, (-0.4*PSF_INST_MAG)) / expTime (where expTime is as derived in StackMeta, see above) |
| instFluxErr | unknown | 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 is as derived in StackMeta, see above) |
| peakFlux | unknown | 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 as derived in StackMeta, see above) |
| sky | unknown | REAL | -999 | PSF sky level at source (adu) | cmf SkyChip.psf table | SKY |
| skyErr | unknown | REAL | -999 | estimated error in sky | cmf SkyChip.psf table | SKY_SIGMA |
| sgSep | unknown | REAL | -999 | star/galaxy separator | cmf SkyChip.psf table | EXT_NSIGMA |
| psfWidMajor | unknown | REAL | -999 | PSF width in major axis | cmf SkyChip.psf table | PSF_MAJOR |
| psfWidMinor | unknown | REAL | -999 | PSF width in minor axis | cmf SkyChip.psf table | PSF_MINOR |
| psfTheta | unknown | REAL | -999 | PSF orientation angle | cmf SkyChip.psf table | PSF_THETA |
| psfLikelihood | unknown | REAL | -999 | PSF likelihood | NA | empty |
| psfCf | unknown | REAL | -999 | PSF coverage factor | cmf SkyChip.psf table | PSF_QF |
| momentXX | arcsec | REAL | -999 | moment XX | cmf SkyChip.psf table | MOMENTS_XX |
| momentXY | arcsec | REAL | -999 | moment XY | cmf SkyChip.psf table | MOMENTS_XY |
| momentYY | arcsec | REAL | -999 | moment YY | cmf SkyChip.psf table | MOMENTS_YY |
| momentM3C | arcsec | REAL | -999 | moment M3C | cmf SkyChip.psf table | MOMENTS_M3C |
| momentM3S | arcsec | REAL | -999 | moment M3S | cmf SkyChip.psf table | MOMENTS_M3S |
| momentM4C | arcsec | REAL | -999 | moment M4C | cmf SkyChip.psf table | MOMENTS_M4C |
| momentM4S | arcsec | REAL | -999 | moment M4S | cmf SkyChip.psf table | MOMENTS_M4S |
| momentR1 | arcsec | REAL | -999 | moment R1 | cmf SkyChip.psf table | MOMENTS_R1 |
| momentRH | arcsec | REAL | -999 | moment RH | cmf SkyChip.psf table | MOMENTS_RH |
| apMag | magnitude | REAL | -999 | Aperture magnitude | cmf SkyChip.psf table | AP_MAG |
| apMagErr | magnitude | REAL | -999 | Aperture magnitude error | NA | empty |
| kronFlux | magnitude | REAL | -999 | Kron flux | cmf SkyChip.psf table | KRON_FLUX |
| kronFluxErr | magnitude | REAL | -999 | Kron flux error | cmf SkyChip.psf table | KRON_FLUX_ERR |
| kronRad | arcsecs | REAL | -999 | Kron radius | NA | empty |
| kronRadErr | arcsecs | REAL | -999 | Kron radius error | NA | empty |
| infoFlag | unknown | BIGINT | -999 | indicator of strange propeties | cmf SkyChip.psf table | FLAGS << 32 | FLAGS2 |
| nFrames | unknown | INT | -999 | number of frames contributing to source | cmf SkyChip.psf table | N_FRAMES |
| activeFlag | unknown | TINYINT | -999 | indicates whether this detection/orphan is still a detection/orphan | NA | hardcoded to 0 |
| assocDate | unknown | DATE | 28881231 | date object association assigned | NA | date that batch has been prepared |
| historyModNum | unknown | SMALLINT | 0 | modification number in the O-D association history | NA | hardcoded to 0 |
| dataRelease | unknown | TINYINT | 0 | Data 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 | unknown | BIGINT | 0 | ODM object identifier | DVO | same as StackDetection - see above |
| stackDetectID | unknown | BIGINT | 0 | ODM detection identifier | DVO | same as StackDetection - see above |
| ippObjID | unknown | BIGINT | 0 | IPP object identifier | DVO | same as StackDetection - see above |
| ippDetectID | unknown | BIGINT | 0 | detection ID generated by IPP | cmf SkyChip.xrad extension | IPP_IDET |
| filterID | unknown | TINYINT | 0 | filter identifier | cmf primary header | Same as StackMeta. See above. |
| stackTypeID | unknown | TINYINT | 0 | stack type identifier | DVO | Same as StackMeta. See above. |
| surveyID | unknown | 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. |
| isophotMag | unknown | REAL | -999 | isophotal magnitude | NA | empty |
| isophotMagErr | unknown | REAL | -999 | estimated error in isophotal magnitude | NA | empty |
| isophotMajAxis | unknown | REAL | -999 | isophotal Major Axis | NA | empty |
| isophotMajAxisErr | unknown | REAL | -999 | estimated error in isophotal Major Axis | NA | empty |
| isophotMinAxis | unknown | REAL | -999 | isophotal Minor Axis | NA | empty |
| isophotMinAxisErr | unknown | REAL | -999 | estimated error in isophotal Minor Axis | NA | empty |
| isophotMajAxisGrad | unknown | REAL | -999 | isophotal major axis gradient | NA | empty |
| isophotMinAxisGrad | unknown | REAL | -999 | isophotal minor axis gradient | NA | empty |
| isophotPA | unknown | REAL | -999 | isophotal position angle | NA | empty |
| isophotPAErr | unknown | REAL | -999 | estimated error in isophotal position angle | NA | empty |
| isophotPAGrad | unknown | REAL | -999 | isophotal position angle gradient | NA | empty |
| petRadius | unknown | REAL | -999 | Petrosian radius | cmf SkyChip.xsrc extension | PETRO_RADIUS |
| petRadiusErr | unknown | REAL | -999 | estimated error inPetrosian radius | cmf SkyChip.xsrc extension | PETRO_RADIUS_ERR |
| petMag | unknown | REAL | -999 | Petrosian magntiude | cmf SkyChip.xsrc extension | PETRO_MAG |
| petMagErr | unknown | REAL | -999 | estimated error in petMag | cmf SkyChip.xsrc extension | PETRO_MAG_ERR |
| petR50 | unknown | REAL | -999 | Petrosian radius at 50% light | cmf SkyChip.xsrc extension | PETRO_RADIUS_50 |
| petR50Err | unknown | REAL | -999 | estimated error inPetrosian radius at 50% light | cmf SkyChip.xsrc extension | PETRO_RADIUS_50_ERR |
| petR90 | unknown | REAL | -999 | Petrosian radius at 90% light | cmf SkyChip.xsrc extension | PETRO_RADIUS_90 |
| petR90Err | unknown | REAL | -999 | estimated error in Petrosian radius at 90% light | cmf SkyChip.xsrc extension | PETRO_RADIUS_90_ERR |
| petCf | unknown | REAL | -999 | Petrosian fit coverage factor | NA | empty |
| flxR1 | unknown | REAL | -999 | Flux inside r = 1 | ||
| flxR1Err | unknown | REAL | -999 | estimated error is flxR1 | ||
| flxR1Std | unknown | REAL | -999 | estimated standard deviation in flxR1 | ||
| flxR1Fill | unknown | REAL | -999 | estimated filling factor at R1 | ||
| flxR2 | unknown | REAL | -999 | Flux inside r = 2 | ||
| flxR2Err | unknown | REAL | -999 | estimated error is flxR2 | ||
| flxR2Std | unknown | REAL | -999 | estimated standard deviation in flxR2 | ||
| flxR2Fill | unknown | REAL | -999 | estimated filling factor at R1 | ||
| flxR3 | unknown | REAL | -999 | Flux inside r = 3 | ||
| flxR3Err | unknown | REAL | -999 | estimated error is flxR3 | ||
| flxR3Std | unknown | REAL | -999 | estimated standard deviation in flxR3 | ||
| flxR3Fill | unknown | REAL | -999 | estimated filling factor at R3 | ||
| flxR4 | unknown | REAL | -999 | Flux inside r = 4 | ||
| flxR4Err | unknown | REAL | -999 | estimated error is flxR4 | ||
| flxR4Std | unknown | REAL | -999 | estimated standard deviation in flxR4 | ||
| flxR4Fill | unknown | REAL | -999 | estimated filling factor at R4 | ||
| flxR5 | unknown | REAL | -999 | Flux inside r = 5 | ||
| flxR5Err | unknown | REAL | -999 | estimated error is flxR5 | ||
| flxR5Std | unknown | REAL | -999 | estimated standard deviation in flxR5 | ||
| flxR5Fill | unknown | REAL | -999 | estimated filling factor at R5 | ||
| flxR6 | unknown | REAL | -999 | Flux inside r = 6 | ||
| flxR6Err | unknown | REAL | -999 | estimated error is flxR6 | ||
| flxR6Std | unknown | REAL | -999 | estimated standard deviation in flxR6 | ||
| flxR6Fill | unknown | REAL | -999 | estimated filling factor at R6 | ||
| flxR7 | unknown | REAL | -999 | Flux inside r = 7 | ||
| flxR7Err | unknown | REAL | -999 | estimated error is flxR7 | ||
| flxR7Std | unknown | REAL | -999 | estimated standard deviation in flxR7 | ||
| flxR7Fill | unknown | REAL | -999 | estimated filling factor at R7 | ||
| flxR8 | unknown | REAL | -999 | Flux inside r = 8 | ||
| flxR8Err | unknown | REAL | -999 | estimated error is flxR8 | ||
| flxR8Std | unknown | REAL | -999 | estimated standard deviation in flxR8 | ||
| flxR8Fill | unknown | REAL | -999 | estimated filling factor at R8 | ||
| flxR9 | unknown | REAL | -999 | Flux inside r = 9 | ||
| flxR9Err | unknown | REAL | -999 | estimated error is flxR9 | ||
| flxR9Std | unknown | REAL | -999 | estimated standard deviation in flxR9 | ||
| flxR9Fill | unknown | REAL | -999 | estimated filling factor at R9 | ||
| flxR10 | unknown | REAL | -999 | Flux inside r = 10 | ||
| flxR10Err | unknown | REAL | -999 | estimated error is flxR10 | ||
| flxR10Std | unknown | REAL | -999 | estimated standard deviation in flxR10 | ||
| flxR10Fill | unknown | REAL | -999 | estimated filling factor at R10 | ||
| c1flxR1 | unknown | REAL | -999 | Flux inside r = 1 | ||
| c1flxR1Err | unknown | REAL | -999 | estimated error is c1flxR1 | ||
| c1flxR1Std | unknown | REAL | -999 | estimated standard deviation in c1flxR1 | ||
| c1flxR1Fill | unknown | REAL | -999 | estimated filling factor at R1 | ||
| c1flxR2 | unknown | REAL | -999 | Flux inside r = 2 | ||
| c1flxR2Err | unknown | REAL | -999 | estimated error is c1flxR2 | ||
| c1flxR2Std | unknown | REAL | -999 | estimated standard deviation in c1flxR2 | ||
| c1flxR2Fill | unknown | REAL | -999 | estimated filling factor at R1 | ||
| c1flxR3 | unknown | REAL | -999 | Flux inside r = 3 | ||
| c1flxR3Err | unknown | REAL | -999 | estimated error is c1flxR3 | ||
| c1flxR3Std | unknown | REAL | -999 | estimated standard deviation in c1flxR3 | ||
| c1flxR3Fill | unknown | REAL | -999 | estimated filling factor at R3 | ||
| c1flxR4 | unknown | REAL | -999 | Flux inside r = 4 | ||
| c1flxR4Err | unknown | REAL | -999 | estimated error is c1flxR4 | ||
| c1flxR4Std | unknown | REAL | -999 | estimated standard deviation in c1flxR4 | ||
| c1flxR4Fill | unknown | REAL | -999 | estimated filling factor at R4 | ||
| c1flxR5 | unknown | REAL | -999 | Flux inside r = 5 | ||
| c1flxR5Err | unknown | REAL | -999 | estimated error is c1flxR5 | ||
| c1flxR5Std | unknown | REAL | -999 | estimated standard deviation in c1flxR5 | ||
| c1flxR5Fill | unknown | REAL | -999 | estimated filling factor at R5 | ||
| c1flxR6 | unknown | REAL | -999 | Flux inside r = 6 | ||
| c1flxR6Err | unknown | REAL | -999 | estimated error is c1flxR6 | ||
| c1flxR6Std | unknown | REAL | -999 | estimated standard deviation in c1flxR6 | ||
| c1flxR6Fill | unknown | REAL | -999 | estimated filling factor at R6 | ||
| c1flxR7 | unknown | REAL | -999 | Flux inside r = 7 | ||
| c1flxR7Err | unknown | REAL | -999 | estimated error is c1flxR7 | ||
| c1flxR7Std | unknown | REAL | -999 | estimated standard deviation in c1flxR7 | ||
| c1flxR7Fill | unknown | REAL | -999 | estimated filling factor at R7 | ||
| c1flxR8 | unknown | REAL | -999 | Flux inside r = 8 | ||
| c1flxR8Err | unknown | REAL | -999 | estimated error is c1flxR8 | ||
| c1flxR8Std | unknown | REAL | -999 | estimated standard deviation in c1flxR8 | ||
| c1flxR8Fill | unknown | REAL | -999 | estimated filling factor at R8 | ||
| c1flxR9 | unknown | REAL | -999 | Flux inside r = 9 | ||
| c1flxR9Err | unknown | REAL | -999 | estimated error is c1flxR9 | ||
| c1flxR9Std | unknown | REAL | -999 | estimated standard deviation in c1flxR9 | ||
| c1flxR9Fill | unknown | REAL | -999 | estimated filling factor at R9 | ||
| c1flxR10 | unknown | REAL | -999 | Flux inside r = 10 | ||
| c1flxR10Err | unknown | REAL | -999 | estimated error is c1flxR10 | ||
| c1flxR10Std | unknown | REAL | -999 | estimated standard deviation in c1flxR10 | ||
| c1flxR10Fill | unknown | REAL | -999 | estimated filling factor at R10 | ||
| c2flxR1 | unknown | REAL | -999 | Flux inside r = 1 | ||
| c2flxR1Err | unknown | REAL | -999 | estimated error is c2flxR1 | ||
| c2flxR1Std | unknown | REAL | -999 | estimated standard deviation in c2flxR1 | ||
| c2flxR1Fill | unknown | REAL | -999 | estimated filling factor at R1 | ||
| c2flxR2 | unknown | REAL | -999 | Flux inside r = 2 | ||
| c2flxR2Err | unknown | REAL | -999 | estimated error is c2flxR2 | ||
| c2flxR2Std | unknown | REAL | -999 | estimated standard deviation in c2flxR2 | ||
| c2flxR2Fill | unknown | REAL | -999 | estimated filling factor at R1 | ||
| c2flxR3 | unknown | REAL | -999 | Flux inside r = 3 | ||
| c2flxR3Err | unknown | REAL | -999 | estimated error is c2flxR3 | ||
| c2flxR3Std | unknown | REAL | -999 | estimated standard deviation in c2flxR3 | ||
| c2flxR3Fill | unknown | REAL | -999 | estimated filling factor at R3 | ||
| c2flxR4 | unknown | REAL | -999 | Flux inside r = 4 | ||
| c2flxR4Err | unknown | REAL | -999 | estimated error is c2flxR4 | ||
| c2flxR4Std | unknown | REAL | -999 | estimated standard deviation in c2flxR4 | ||
| c2flxR4Fill | unknown | REAL | -999 | estimated filling factor at R4 | ||
| c2flxR5 | unknown | REAL | -999 | Flux inside r = 5 | ||
| c2flxR5Err | unknown | REAL | -999 | estimated error is c2flxR5 | ||
| c2flxR5Std | unknown | REAL | -999 | estimated standard deviation in c2flxR5 | ||
| c2flxR5Fill | unknown | REAL | -999 | estimated filling factor at R5 | ||
| c2flxR6 | unknown | REAL | -999 | Flux inside r = 6 | ||
| c2flxR6Err | unknown | REAL | -999 | estimated error is c2flxR6 | ||
| c2flxR6Std | unknown | REAL | -999 | estimated standard deviation in c2flxR6 | ||
| c2flxR6Fill | unknown | REAL | -999 | estimated filling factor at R6 | ||
| c2flxR7 | unknown | REAL | -999 | Flux inside r = 7 | ||
| c2flxR7Err | unknown | REAL | -999 | estimated error is c2flxR7 | ||
| c2flxR7Std | unknown | REAL | -999 | estimated standard deviation in c2flxR7 | ||
| c2flxR7Fill | unknown | REAL | -999 | estimated filling factor at R7 | ||
| c2flxR8 | unknown | REAL | -999 | Flux inside r = 8 | ||
| c2flxR8Err | unknown | REAL | -999 | estimated error is c2flxR8 | ||
| c2flxR8Std | unknown | REAL | -999 | estimated standard deviation in c2flxR8 | ||
| c2flxR8Fill | unknown | REAL | -999 | estimated filling factor at R8 | ||
| c2flxR9 | unknown | REAL | -999 | Flux inside r = 9 | ||
| c2flxR9Err | unknown | REAL | -999 | estimated error is c2flxR9 | ||
| c2flxR9Std | unknown | REAL | -999 | estimated standard deviation in c2flxR9 | ||
| c2flxR9Fill | unknown | REAL | -999 | estimated filling factor at R9 | ||
| c2flxR10 | unknown | REAL | -999 | Flux inside r = 10 | ||
| c2flxR10Err | unknown | REAL | -999 | estimated error is c2flxR10 | ||
| c2flxR10Std | unknown | REAL | -999 | estimated standard deviation in c2flxR10 | ||
| c2flxR10Fill | unknown | REAL | -999 | estimated filling factor at R10 | ||
| logC | unknown | REAL | -999 | Abraham concentration index | ||
| logA | unknown | REAL | -999 | Abraham asymmetry index | ||
| activeFlag | unknown | TINYINT | -999 | indicates whether this detection/orphan is still a detection/orphan | ||
| dataRelease | unknown | TINYINT | 0 | Data release when this detection was taken | ||
| StackModelFit | ||||||
| ODM attribute | units | Data type | Default | Description | IPP source | IPP variable/notes |
| objID | unknown | BIGINT | 0 | ODM object identifier | DVO | same as StackDetection - see above |
| stackDetectID | unknown | BIGINT | 0 | ODM detection identifier | DVO | same as StackDetection - see above |
| ippObjID | unknown | BIGINT | 0 | IPP object identifier | DVO | same as StackDetection - see above |
| ippDetectID | unknown | BIGINT | 0 | detection ID generated by IPP | from SkyChip.xfit extension | IPP_IDET |
| filterID | unknown | TINYINT | 0 | filter identifier | cmf primary header | Same as StackMeta. See above. |
| stackTypeID | unknown | TINYINT | 0 | stack type identifier | DVO | Same as StackMeta. See above. |
| surveyID | unknown | 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. |
| deVRadius | unknown | REAL | -999 | deVaucouleurs radius | ||
| deVRadiusErr | unknown | REAL | -999 | estimated error in deVaucouleurs radius | ||
| deVMag | unknown | REAL | -999 | deVaucouleurs magntiude | ||
| deVMagErr | unknown | REAL | -999 | estimated error in deV_mag | ||
| deVAb | unknown | REAL | -999 | deVaucoulerus axis ratio | ||
| deVAbErr | unknown | REAL | -999 | estimated error in deVaucoulerus axis ratio | ||
| deVPhi | unknown | REAL | -999 | estmated phi of deVaucouleurs axis | ||
| deVPhiErr | unknown | REAL | -999 | estmated error of phi of deVaucouleurs axis | ||
| raDeVOff | unknown | REAL | -999 | Offset in RA of deVaucouleurs fit from PSF RA | ||
| decDeVOff | unknown | REAL | -999 | Offset in DEC of deVaucouleurs fit from PSF DEC | ||
| raDeVOffErr | unknown | REAL | -999 | estimated error in ra offset | ||
| decDeVOffErr | unknown | REAL | -999 | estimated error in dec offset | ||
| deVCf | unknown | REAL | -999 | deVaucouleurs fit coverage factor | ||
| deVLikelihood | unknown | REAL | -999 | deVaucouleurs fit likelihood factor | ||
| deVCovar11 | unknown | REAL | -999 | covariance for deVaucouleurs fit | ||
| deVCovar12 | unknown | REAL | -999 | covariance for deVaucouleurs fit | ||
| deVCovar13 | unknown | REAL | -999 | covariance for deVaucouleurs fit | ||
| deVCovar14 | unknown | REAL | -999 | covariance for deVaucouleurs fit | ||
| deVCovar15 | unknown | REAL | -999 | covariance for deVaucouleurs fit | ||
| deVCovar16 | unknown | REAL | -999 | covariance for deVaucouleurs fit | ||
| deVCovar17 | unknown | REAL | -999 | covariance for deVaucouleurs fit | ||
| deVCovar22 | unknown | REAL | -999 | covariance for deVaucouleurs fit | ||
| deVCovar23 | unknown | REAL | -999 | covariance for deVaucouleurs fit | ||
| deVCovar24 | unknown | REAL | -999 | covariance for deVaucouleurs fit | ||
| deVCovar25 | unknown | REAL | -999 | covariance for deVaucouleurs fit | ||
| deVCovar26 | unknown | REAL | -999 | covariance for deVaucouleurs fit | ||
| deVCovar27 | unknown | REAL | -999 | covariance for deVaucouleurs fit | ||
| deVCovar33 | unknown | REAL | -999 | covariance for deVaucouleurs fit | ||
| deVCovar34 | unknown | REAL | -999 | covariance for deVaucouleurs fit | ||
| deVCovar35 | unknown | REAL | -999 | covariance for deVaucouleurs fit | ||
| deVCovar36 | unknown | REAL | -999 | covariance for deVaucouleurs fit | ||
| deVCovar37 | unknown | REAL | -999 | covariance for deVaucouleurs fit | ||
| deVCovar44 | unknown | REAL | -999 | covariance for deVaucouleurs fit | ||
| deVCovar45 | unknown | REAL | -999 | covariance for deVaucouleurs fit | ||
| deVCovar46 | unknown | REAL | -999 | covariance for deVaucouleurs fit | ||
| deVCovar47 | unknown | REAL | -999 | covariance for deVaucouleurs fit | ||
| deVCovar55 | unknown | REAL | -999 | covariance for deVaucouleurs fit | ||
| deVCovar56 | unknown | REAL | -999 | covariance for deVaucouleurs fit | ||
| deVCovar57 | unknown | REAL | -999 | covariance for deVaucouleurs fit | ||
| deVCovar66 | unknown | REAL | -999 | covariance for deVaucouleurs fit | ||
| deVCovar67 | unknown | REAL | -999 | covariance for deVaucouleurs fit | ||
| deVCovar77 | unknown | REAL | -999 | covariance for deVaucouleurs fit | ||
| expRadius | unknown | REAL | -999 | Exponential fit radius | ||
| expRadiusErr | unknown | REAL | -999 | estimated error in Exponential fit radius | ||
| expMag | unknown | REAL | -999 | Exponential fit magntiude | ||
| expMagErr | unknown | REAL | -999 | estimated error in expMag | ||
| expAb | unknown | REAL | -999 | Exponential fit axis ratio | ||
| expAbErr | unknown | REAL | -999 | estimated error in Exponential fit axis ratio | ||
| expPhi | unknown | REAL | -999 | estmated phi of Exponential axis | ||
| expPhiErr | unknown | REAL | -999 | estmated error of phi of Exponential axis | ||
| raExpOff | unknown | REAL | -999 | Offset in RA of Exponential fit from PSF RA | ||
| decExpOff | unknown | REAL | -999 | Offset in DEC of Exponential fit from PSF DEC | ||
| raExpOffErr | unknown | REAL | -999 | estimated error in raExpOff | ||
| decExpOffErr | unknown | REAL | -999 | estimated error in decExpOff | ||
| expCf | unknown | REAL | -999 | Exponential fit coverage factor | ||
| expLikelihood | unknown | REAL | -999 | Exponential fit likelihood factor | ||
| expCovar11 | unknown | REAL | -999 | covariance for Exponential fit | ||
| expCovar12 | unknown | REAL | -999 | covariance for Exponential fit | ||
| expCovar13 | unknown | REAL | -999 | covariance for Exponential fit | ||
| expCovar14 | unknown | REAL | -999 | covariance for Exponential fit | ||
| expCovar15 | unknown | REAL | -999 | covariance for Exponential fit | ||
| expCovar16 | unknown | REAL | -999 | covariance for Exponential fit | ||
| expCovar17 | unknown | REAL | -999 | covariance for Exponential fit | ||
| expCovar22 | unknown | REAL | -999 | covariance for Exponential fit | ||
| expCovar23 | unknown | REAL | -999 | covariance for Exponential fit | ||
| expCovar24 | unknown | REAL | -999 | covariance for Exponential fit | ||
| expCovar25 | unknown | REAL | -999 | covariance for Exponential fit | ||
| expCovar26 | unknown | REAL | -999 | covariance for Exponential fit | ||
| expCovar27 | unknown | REAL | -999 | covariance for Exponential fit | ||
| expCovar33 | unknown | REAL | -999 | covariance for Exponential fit | ||
| expCovar34 | unknown | REAL | -999 | covariance for Exponential fit | ||
| expCovar35 | unknown | REAL | -999 | covariance for Exponential fit | ||
| expCovar36 | unknown | REAL | -999 | covariance for Exponential fit | ||
| expCovar37 | unknown | REAL | -999 | covariance for Exponential fit | ||
| expCovar44 | unknown | REAL | -999 | covariance for Exponential fit | ||
| expCovar45 | unknown | REAL | -999 | covariance for Exponential fit | ||
| expCovar46 | unknown | REAL | -999 | covariance for Exponential fit | ||
| expCovar47 | unknown | REAL | -999 | covariance for Exponential fit | ||
| expCovar55 | unknown | REAL | -999 | covariance for Exponential fit | ||
| expCovar56 | unknown | REAL | -999 | covariance for Exponential fit | ||
| expCovar57 | unknown | REAL | -999 | covariance for Exponential fit | ||
| expCovar66 | unknown | REAL | -999 | covariance for Exponential fit | ||
| expCovar67 | unknown | REAL | -999 | covariance for Exponential fit | ||
| expCovar77 | unknown | REAL | -999 | covariance for Exponential fit | ||
| serRadius | unknown | REAL | -999 | Sersic radius | ||
| serRadiusErr | unknown | REAL | -999 | estimated error in Sersic radius | ||
| serMag | unknown | REAL | -999 | Sersic magntiude | ||
| serMagErr | unknown | REAL | -999 | estimated error in serMag | ||
| serAb | unknown | REAL | -999 | Sersic axis ratio | ||
| serAbErr | unknown | REAL | -999 | estimated error in Sersic axis ratio | ||
| serNu | unknown | REAL | -999 | Sersic index | ||
| serNuErr | unknown | REAL | -999 | estimated error in Sersic index | ||
| serPhi | unknown | REAL | -999 | estmated phi of Sersic axis | ||
| serPhiErr | unknown | REAL | -999 | estmated error of phi of Sersic axis | ||
| raSerOff | unknown | REAL | -999 | Offset in RA of Sersic fit from PSF RA | ||
| decSerOff | unknown | REAL | -999 | Offset in DEC of Sersic fit from PSF DEC | ||
| raSerOffErr | unknown | REAL | -999 | estimated error in raSerOff | ||
| decSerOffErr | unknown | REAL | -999 | estimated error in decSerOff | ||
| serCf | unknown | REAL | -999 | Sersic fit coverage factor | ||
| serLikelihood | unknown | REAL | -999 | Sersic fit likelihood factor | ||
| sersicCovar11 | unknown | REAL | -999 | covariance for Sersic fit | ||
| sersicCovar12 | unknown | REAL | -999 | covariance for Sersic fit | ||
| sersicCovar13 | unknown | REAL | -999 | covariance for Sersic fit | ||
| sersicCovar14 | unknown | REAL | -999 | covariance for Sersic fit | ||
| sersicCovar15 | unknown | REAL | -999 | covariance for Sersic fit | ||
| sersicCovar16 | unknown | REAL | -999 | covariance for Sersic fit | ||
| sersicCovar17 | unknown | REAL | -999 | covariance for Sersic fit | ||
| sersicCovar18 | unknown | REAL | -999 | covariance for Sersic fit | ||
| sersicCovar22 | unknown | REAL | -999 | covariance for Sersic fit | ||
| sersicCovar23 | unknown | REAL | -999 | covariance for Sersic fit | ||
| sersicCovar24 | unknown | REAL | -999 | covariance for Sersic fit | ||
| sersicCovar25 | unknown | REAL | -999 | covariance for Sersic fit | ||
| sersicCovar26 | unknown | REAL | -999 | covariance for Sersic fit | ||
| sersicCovar27 | unknown | REAL | -999 | covariance for Sersic fit | ||
| sersicCovar28 | unknown | REAL | -999 | covariance for Sersic fit | ||
| sersicCovar33 | unknown | REAL | -999 | covariance for Sersic fit | ||
| sersicCovar34 | unknown | REAL | -999 | covariance for Sersic fit | ||
| sersicCovar35 | unknown | REAL | -999 | covariance for Sersic fit | ||
| sersicCovar36 | unknown | REAL | -999 | covariance for Sersic fit | ||
| sersicCovar37 | unknown | REAL | -999 | covariance for Sersic fit | ||
| sersicCovar38 | unknown | REAL | -999 | covariance for Sersic fit | ||
| sersicCovar44 | unknown | REAL | -999 | covariance for Sersic fit | ||
| sersicCovar45 | unknown | REAL | -999 | covariance for Sersic fit | ||
| sersicCovar46 | unknown | REAL | -999 | covariance for Sersic fit | ||
| sersicCovar47 | unknown | REAL | -999 | covariance for Sersic fit | ||
| sersicCovar48 | unknown | REAL | -999 | covariance for Sersic fit | ||
| sersicCovar55 | unknown | REAL | -999 | covariance for Sersic fit | ||
| sersicCovar56 | unknown | REAL | -999 | covariance for Sersic fit | ||
| sersicCovar57 | unknown | REAL | -999 | covariance for Sersic fit | ||
| sersicCovar58 | unknown | REAL | -999 | covariance for Sersic fit | ||
| sersicCovar66 | unknown | REAL | -999 | covariance for Sersic fit | ||
| sersicCovar67 | unknown | REAL | -999 | covariance for Sersic fit | ||
| sersicCovar68 | unknown | REAL | -999 | covariance for Sersic fit | ||
| sersicCovar77 | unknown | REAL | -999 | covariance for Sersic fit | ||
| sersicCovar78 | unknown | REAL | -999 | covariance for Sersic fit | ||
| sersicCovar88 | unknown | REAL | -999 | covariance for Sersic fit | ||
| activeFlag | unknown | TINYINT | -999 | indicates whether this detection/orphan is still a detection/orphan | ||
| dataRelease | unknown | TINYINT | 0 | Data release when this detection was taken | ||
| StackToImage | ||||||
| ODM attribute | units | Data type | Default | Description | IPP source | IPP variable/notes |
| stackMetaID | unknown | BIGINT | 0 | stack identifier | GPC1 database | Same as StackMeta. See above. |
| imageID | unknown | BIGINT | 0 | hashed exposure-ccdID identifier | ||
| SkinnyObject | ||||||
| ODM attribute | units | Data type | Default | Description | IPP source | IPP variable/notes |
| objID | unknown | BIGINT | 0 | ODM object identifier index | DVO | same as StackDetection - see above |
| ippObjID | unknown | BIGINT | 0 | IPP object number | DVO | same as StackDetection - see above |
| projectionCellID | unknown | INT | -999 | projection cell identifier at discovery time | ||
| dataRelease | unknown | TINYINT | 0 | Data release to propagate to the object | ||
| surveyID | unknown | 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 | unknown | BIGINT | 0 | ODM object identifier | DVO | same as StackDetection - see above |
| ippObjID | unknown | BIGINT | 0 | ipp object identifier | DVO | same as StackDetection - see above |
| filterID | unknown | TINYINT | 0 | filter identifier | cmf primary header | Same as StackMeta. See above. |
| calColor | mag | REAL | 0 | color adopted for magnitude calculation | ||
| calColorErr | mag | REAL | 0 | error in calibrating color | ||
| calibModNum | unknown | SMALLINT | 0 | calibration modification number | ||
| dataRelease | unknown | TINYINT | 0 | Data release when this color calibration was established | ||
Running
Note:
See TracWiki
for help on using the wiki.
