| | 3 | |
| | 4 | |
| | 5 | |
| | 6 | |
| | 7 | == Unresolved fields for camera stage == |
| | 8 | |
| | 9 | '''{{{FrameMeta}}}''' |
| | 10 | |
| | 11 | || '''PSPS field''' || '''PSPS type''' || '''PSPS Description''' || '''IPP source''' || '''Comments''' || |
| | 12 | || surveyID || TINYINT || survey flag identifier || || || |
| | 13 | || filterID || TINYINT || filter identifier || || IPP uses string (g.00000). Need enum. || |
| | 14 | || cameraID || SMALLINT || camera identifier || || set to 1? || |
| | 15 | || cameraConfigID|| SMALLINT || camera configuration identifier || || set to 0? || |
| | 16 | || telescopeID || SMALLINT || telescope identifier || || set to 1? || |
| | 17 | || analysisVer || SMALLINT || version number of analysis || || || |
| | 18 | || p1Recip || SMALLINT || IPP phase 1 recipe ID || || || |
| | 19 | || p2Recip || SMALLINT || IPP phase 2 recipe ID || || || |
| | 20 | || p3Recip || SMALLINT || IPP phase 3 recipe ID || || || |
| | 21 | || nP2Images || SMALLINT || number of OTA/CCD images in this P2 exposure || || always 60? || |
| | 22 | || astroScat || REAL || global astrometric scatter || || have values per chip, but global? || |
| | 23 | || photoScat || REAL || global photometric scatter || || || |
| | 24 | || nAstRef || INT || number of astrometric reference sources || || have values per chip, but global? || |
| | 25 | || nPhoRef || INT || number of photometric reference sources || || have values per chip, but global? || |
| | 26 | || polyOrder || TINYINT || polynomial order of astrometry fit || smf.phu.NPLYTERM? || || |
| | 27 | || calibModNum|| SMALLINT || calibration modification number || || || |
| | 28 | |
| | 29 | |
| | 30 | '''{{{ImageMeta}}}''' |
| | 31 | |
| | 32 | || '''PSPS field''' || '''PSPS type''' || '''PSPS Description''' || '''IPP source''' || '''Comments''' || |
| | 33 | || filterID || TINYINT || filter ID || || IPP uses string (g.00000). Need enum. || |
| | 34 | || bias || REAL || detector bias level || || missing from smf || |
| | 35 | || biasScat || REAL || scatter in bias level || || missing from smf|| |
| | 36 | || photoScat || REAL || photometric scatter for chip || smf.phu.ZPT_OBS? || || |
| | 37 | || nPhoRef || INT || number of photometric reference sources || smf.chip.NPSFSTAR? smf.chip.NSTARS? || || |
| | 38 | || psfFwhm || REAL || PSF full width at half maximum || smf.chip.FWHM_MAJ? || || |
| | 39 | || psfModelID || INT || PSF model identifier|| || missing from smf || |
| | 40 | || psfExtra1 || REAL || PSF parameters || || missing from smf || |
| | 41 | || psfExtra2 || REAL || PSF parameters || || missing from smf || |
| | 42 | || detectorID || SMALLINT || identifier for actual CCD chip || || IPP uses string (CCID58-1-02a2). Need enum.|| |
| | 43 | || qaFlags || INT || Q/A flags || || PSPS needs two flag fields || |
| | 44 | || detrend1 || BIGINT || identifier of detrend image 1 || || IPP uses strings, PSPS wants INTs || |
| | 45 | || detrend2 || BIGINT || identifier of detrend image 2 || || IPP uses strings, PSPS wants INTs|| |
| | 46 | || detrend3 || BIGINT || identifier of detrend image 3 || ||IPP uses strings, PSPS wants INTs || |
| | 47 | || detrend4 || BIGINT || identifier of detrend image 4 || ||IPP uses strings, PSPS wants INTs || |
| | 48 | || detrend5 || BIGINT || identifier of detrend image 5 || ||IPP uses strings, PSPS wants INTs || |
| | 49 | || detrend6 || BIGINT || identifier of detrend image 6 || ||IPP uses strings, PSPS wants INTs || |
| | 50 | || detrend7 || BIGINT || identifier of detrend image 7 || || IPP uses strings, PSPS wants INTs|| |
| | 51 | || detrend8 || BIGINT || identifier of detrend image 8 || ||IPP uses strings, PSPS wants INTs || |
| | 52 | || photoZero || REAL || local derived photometric zero point || || smf.phu.ZPT_OBS? || |
| | 53 | || polyOrder || TINYINT || polynomial order of astrometry fit || smf.chip.NPLYTERM? || || |
| | 54 | || calibModNum || SMALLINT || calibration modification number || || set to 0? || |
| | 55 | |
| | 56 | |
| | 57 | |
| | 58 | '''{{{Detection}}}''' |
| | 59 | |
| | 60 | || '''PSPS field''' || '''PSPS type''' || '''PSPS Description''' || '''IPP source''' || '''Comments''' || |
| | 61 | ||filterID|| TINYINT || filter ID: g=1, r=2, i=3, z=4, y=5, w=6, ... || || IPP uses string (g.00000). Need enum. || |
| | 62 | ||surveyID|| TINYINT || survey flag identifier || || || |
| | 63 | || psfLikelihood || REAL || PSF likelihood || smf.psf.PSF_QF? || || |
| | 64 | || psfCf|| REAL || PSF coverage factor || smf.psf.PSF_QF? || || |
| | 65 | || infoFlag|| INT || bitmask indicating provenance information || || || |
| | 66 | || activeFlag|| TINYINT || indicates whether this detection/orphan is still a detection/orphan || || || |
| | 67 | || historyModNum || SMALLINT || modification number in the O-D association history || || set to 0? || |
| | 68 | |
| | 69 | == Unresolved fields for diff stage == |
| | 70 | |
| | 71 | '''{{{StackMeta}}}''' |
| | 72 | |
| | 73 | || '''PSPS field''' || '''PSPS type''' || '''PSPS Description''' || '''IPP source''' || '''Comments''' || |
| | 74 | ||stackMetaID||BIGINT||stack identifier|| || || |
| | 75 | ||skycellID||INT||skycell region identifier || || missing from cmf files || |
| | 76 | ||surveyID||TINYINT||survey flag identifier || || || |
| | 77 | ||photoCalID||INT||photometry code numerical id || || || |
| | 78 | ||filterID||TINYINT||filter identifier || ||IPP uses string (g.00000). Need enum. || |
| | 79 | ||stackTypeID||TINYINT||stack type identifier || || || |
| | 80 | ||refImageID||BIGINT||identifier of image used as reference for analysis || || || |
| | 81 | ||subtrImageID||BIGINT||identifier of image subtracted to generate difference image || || || |
| | 82 | ||analVer||SMALLINT||analysis version index || || || |
| | 83 | ||nP2Images||SMALLINT||number of P2 images contributing to this cell || || || |
| | 84 | ||astroScat||FLOAT||0.astrometric scatter for chip || || || |
| | 85 | ||photoScat||FLOAT||0.photometric scatter for chip || || || |
| | 86 | ||nAstroRef||INT||number of astrometric reference sources || || || |
| | 87 | ||nPhoRef||INT||number of photometric reference sources || || || |
| | 88 | ||psfFwhm||FLOAT||PSF full width at half maximum || || || |
| | 89 | ||psfmodelID||SMALLINT||PSF model identifier || || || |
| | 90 | ||psfExtra1||FLOAT||PSF parameters || || || |
| | 91 | ||psfExtra2||FLOAT||PSF parameters || || || |
| | 92 | ||photoZero||FLOAT||local derived photometric zero point || || || |
| | 93 | ||photoColor||FLOAT||local derived photometric color term || || || |
| | 94 | ||polyOrder||TINYINT||polynomial order of astrometry fit || || || |
| | 95 | ||pca1x3y0||FLOAT||polynomial coefficients for the astrometric fit || || not available || |
| | 96 | ||pca1x2y1||FLOAT||polynomial coefficients for the astrometric fit || || not available || |
| | 97 | ||pca1x1y2||FLOAT||polynomial coefficients for the astrometric fit || || not available || |
| | 98 | ||pca1x0y3||FLOAT||polynomial coefficients for the astrometric fit || || not available || |
| | 99 | ||pca1x2y0||FLOAT||polynomial coefficients for the astrometric fit || || not available || |
| | 100 | ||pca1x1y1||FLOAT||polynomial coefficients for the astrometric fit || || not available || |
| | 101 | ||pca1x0y2||FLOAT||polynomial coefficients for the astrometric fit || || not available || |
| | 102 | ||pca2x3y0||FLOAT||polynomial coefficients for the astrometric fit || || not available || |
| | 103 | ||pca2x2y1||FLOAT||polynomial coefficients for the astrometric fit || || not available || |
| | 104 | ||pca2x1y2||FLOAT||polynomial coefficients for the astrometric fit || || not available || |
| | 105 | ||pca2x0y3||FLOAT||polynomial coefficients for the astrometric fit || || not available || |
| | 106 | ||pca2x2y0||FLOAT||polynomial coefficients for the astrometric fit || || not available || |
| | 107 | ||pca2x1y1||FLOAT||polynomial coefficients for the astrometric fit || || not available || |
| | 108 | ||pca2x0y2||FLOAT||polynomial coefficients for the astrometric fit || || not available || |
| | 109 | ||calibModNum||SMALLINT||calibration modification number || || || |
| | 110 | ||dataRelease||TINYINT||Data release || || || |
| | 111 | |
| | 112 | '''{{{StackToImage}}}''' |
| | 113 | |
| | 114 | || '''PSPS field''' || '''PSPS type''' || '''PSPS Description''' || '''IPP source''' || '''Comments''' || |
| | 115 | ||stackMetaID||BIGINT||stack identifier || || || |
| | 116 | ||imageID||BIGINT||hashed exposure-ccdID identifier || || || |
| | 117 | |
| | 118 | '''{{{StackLowSigDelta/StackHighSigDelta}}}''' |
| | 119 | |
| | 120 | || '''PSPS field''' || '''PSPS type''' || '''PSPS Description''' || '''IPP source''' || '''Comments''' || |
| | 121 | ||partitionKey||BIGINT||partition key || || || |
| | 122 | ||stackDiffID||BIGINT||ODM detection identifier || || || |
| | 123 | ||ippDetectID||BIGINT||detection id generated by IPP || || || |
| | 124 | ||filterID||TINYINT||filter ID: g=1, r=2, i=3, z=4, y=5, w=6,.. || || || |
| | 125 | ||psfLikelihood||FLOAT||PSF likelihood || || || |
| | 126 | ||infoFlag||INT||indicator of strange propeties || || || |
| | 127 | ||nFrames||INT||number of frames contributing to source || || || |
| | 128 | ||htmID||BIGINT||HTM index for the detection || || || |
| | 129 | ||zoneID||INT||Zone index || || || |
| | 130 | ||raErr||FLOAT||estimated error in ra || || || |
| | 131 | ||decErr||FLOAT||estimated error in dec || || || |
| | 132 | ||cx||FLOAT||cartesian x || || || |
| | 133 | ||cy||FLOAT||cartesian y || || || |
| | 134 | ||cz||FLOAT||cartesian z || || || |
| | 135 | ||calMag||FLOAT||calibrated magnitude || || || |
| | 136 | ||calMagErr||FLOAT||estimated error in calMag || || || |
| | 137 | ||dataRelease||TINYINT||Data release when this detection was taken || || || |
| | 138 | |
| | 139 | |