Changeset 37216
- Timestamp:
- Aug 11, 2014, 7:10:15 AM (12 years ago)
- Location:
- branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables
- Files:
-
- 3 edited
-
Detection.txt (modified) (1 diff)
-
MeanObject.txt (modified) (1 diff)
-
ObjectThin.txt (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/Detection.txt
r37209 r37216 7 7 imageID - ipptopsps : expID x y (*** is this right???) (smf:IMAGEID / gpc1.chipRun.chip_image_id)_ 8 8 randomDetID + ipptopsps : RANDOM from sql 9 dvoRegionID - dvo / catID [EAM: add to dvopsps]9 dvoRegionID - dvo:average.catID 10 10 obsTime - smf:MJD-OBS + 0.5 EXPTIME / 84600 11 11 xPos + smf:X_PSF -
branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/MeanObject.txt
r37000 r37216 1 1 2 *** I've checked that these are plausible, not exact 2 3 4 objID + dvo / addstar 5 gQfPerfect - dvo / relphot / secfilt. [XXX Not calculated] 6 gMeanPSFMag + dvo / relphot / secfilt.M 7 gMeanPSFMagErr + dvo / relphot / secfilt.dM 8 gMeanPSFMagNpt + dvo / relphot / secfilt.Nused [XXX : ensure .Nused matches .M] 9 gMeanPSFMagStd + dvo / relphot / secfilt.Mstdev 10 gMeanPSFMagMin + dvo / relphot / secfilt.Min [XXX: replace M_20, M_80 with Min, Max] 11 gMeanPSFMagMax + dvo / relphot / secfilt.Max [XXX: replace M_20, M_80 with Min, Max] 3 12 13 gMeanKronMag + dvo / relphot / secfilt.Mkron 14 gMeanKronMagErr + dvo / relphot / secfilt.dMkron 15 gMeanKronMagNpt + dvo / relphot / secfilt.nMkron [XXX : not calculated] 16 gMeanKronMagStd - dvo / relphot / secfilt.MstdevKron [XXX : not calculated] 4 17 5 objID = dvo / addstar 6 gcObjID = dvo / addstar 7 gQfPerfect = dvo / relphot / secfilt. [XXX Not calculated] 8 gMeanPSFMag = dvo / relphot / secfilt.M 9 gMeanPSFMagErr = dvo / relphot / secfilt.dM 10 gnIncPSFMag = dvo / relphot / secfilt.Nused [XXX : ensure .Nused matches .M] 11 gMeanPSFMagStd = dvo / relphot / secfilt.Mstdev 12 gMinPSFMag = dvo / relphot / secfilt.Min [XXX: replace M_20, M_80 with Min, Max] 13 gMaxPSFMag = dvo / relphot / secfilt.Max [XXX: replace M_20, M_80 with Min, Max] 14 = 15 gMeanKronMag = dvo / relphot / secfilt.Mkron 16 gMeanKronMagErr = dvo / relphot / secfilt.dMkron 17 gnIncKronMag = dvo / relphot / secfilt.nMkron [XXX : not calculated] 18 gMeanKronMagStd = dvo / relphot / secfilt.MstdevKron [XXX : not calculated] 19 = 20 gMeanApMag = dvo / relphot / secfilt.Map 21 gMeanApMagErr = dvo / relphot / secfilt.? [XXX : not calculated] 22 gnIncApMag = dvo / relphot / secfilt.? [XXX : not calculated] 23 gMeanApMagStd = dvo / relphot / secfilt.? [XXX : not calculated] 18 gMeanApMag + dvo / relphot / secfilt.Map 19 gMeanApMagErr + dvo / relphot / secfilt.? [XXX : not calculated] 20 gMeanApMagNpt + dvo / relphot / secfilt.? [XXX : not calculated] 21 gMeanApMagStd + dvo / relphot / secfilt.? [XXX : not calculated] 24 22 25 gFlags =dvo / relphot / secfilt.flags23 gFlags + dvo / relphot / secfilt.flags -
branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ObjectThin.txt
r37127 r37216 1 1 2 objName = ipptopsps 3 objID = dvo / addstar 4 gcobjID = dvo / addstar 5 ippObjID = dvo / addstar 6 surveyID = ipptopsps 7 skyCellID = smf header 8 htmID = PSPS 9 zoneID = PSPS 10 randomID = ipptopsps 11 batchID = ipptopsps 12 dvoRegionID = dvo / catID 13 dataRelease = ipptopsps 14 objInfoFlag = dvo / relastro,relphot [define] 15 qualityFlag = dvo / relastro,relphot [define] 16 consistencyFlag = ipptopsps? 17 raStack = dvo / allow recalibration? [ADD to average.d] 18 decStack = dvo / allow recalibration? 19 raStackErr = dvo / allow recalibration? 20 decStackErr = dvo / allow recalibration? 21 raMean = dvo / relastro 22 decMean = dvo / relastro 23 raMeanErr = dvo / relastro 24 decMeanErr = dvo / relastro 25 raMeanStd = dvo / relastro [XXX does not exist: chisq values instead?] 26 decMeanStd = dvo / relastro 27 ----------------- = 28 -- = 29 -- = 30 -- = 31 -- = 32 -- = 33 cx = PSPS 34 cy = PSPS 35 cz = PSPS 36 lambda = PSPS 37 beta = PSPS 38 l = PSPS 39 b = PSPS 40 ----------------- = 41 nStackObjectRows = dvo [ADD to average.d] 42 -- = 43 nStackDetections = dvo / relphot [Sum of not-forced stack detections] 44 nDetections = dvo / relphot [Sum of ng+nr, etc?] 45 ng = dvo / relphot [Sum of GPC1.g.XY?? measure.d] 46 nr = dvo / relphot [ditto] 47 ni = dvo / relphot 48 nz = dvo / relphot 49 ny = dvo / relphot 2 objName - ipptopsps : move to dvopsps? 3 objID + dvo:average.extID 4 ippObjID + dvo:(average.objID | average.catID << 32) 5 surveyID + ipptopsps : internal, from survey name 6 htmID - PSPS 7 zoneID - PSPS 8 randomID + ipptopsps : RANDOM from sql 9 batchID + ipptopsps : internal 10 dvoRegionID ? dvo:average.catID 11 dataRelease + ipptopsps : user input (skychunk.dataRelease) 12 objInfoFlag + dvo:average.flags 13 qualityFlag - (dvo:average.flags >> 24) & 0xFF *** correct?? 14 consistencyFlag - *** hard-wired in ipptopsps to 0 15 raStack - dvo:average.Rstk *** not calculated? 16 decStack - dvo:average.Dstk *** not calculated? 17 raStackErr - dvo:average.dRstk *** not calculated? 18 decStackErr - dvo:average.dDstk *** not calculated? 19 raMean + dvo:average.R 20 decMean + dvo:average.D 21 raMeanErr - dvo:average.dR 22 decMeanErr - dvo:average.dD 23 posMeanChisq - dvo:average.ChiSqAve 24 ----------------- 25 -- 26 -- 27 -- 28 -- 29 -- 30 cx - PSPS 31 cy - PSPS 32 cz - PSPS 33 lambda - PSPS 34 beta - PSPS 35 l - PSPS 36 b - PSPS 37 ----------------- 38 nStackObjectRows - *** set to 0 *** 39 -- 40 nStackDetections - not set? 41 nDetections - ipptopsps:Sum of ng+nr in sql 42 ng - dvo:secfilt.ncode ** check that this is right 43 nr - dvo:secfilt.ncode ** check that this is right 44 ni - dvo:secfilt.ncode ** check that this is right 45 nz - dvo:secfilt.ncode ** check that this is right 46 ny - dvo:secfilt.ncode ** check that this is right
Note:
See TracChangeset
for help on using the changeset viewer.
